PI_SCAN_DUP_SER (SQL View)	Index Back
PI Scan Duplicate Serials

PI_SCAN_DUP_SER

(SQL View)

PI Scan Duplicate Serials

SELECT A.PI_ID , A.SERIAL_ID , A.PI_LINE_NUM FROM PS_PI_SCAN A WHERE A.SERIAL_ID <> ' ' AND 1 <> ( SELECT COUNT(*) FROM PS_PI_SCAN B WHERE A.PI_ID = B.PI_ID AND A.SERIAL_ID = B.SERIAL_ID )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PI_ID Character(10) VARCHAR2(10) NOT NULL Physical Inventory ID
Prompt Table: PI_CNTL

2 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

3 PI_LINE_NUM Number(8,0) INTEGER NOT NULL PI Line Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PI_ID	Character(10)	VARCHAR2(10) NOT NULL	Physical Inventory ID Prompt Table: PI_CNTL
2	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
3	PI_LINE_NUM	Number(8,0)	INTEGER NOT NULL	PI Line Number