SF_PRDN_SER_VW

(SQL View)
 Index Back

Production Serial ID View

Production Serial ID View for use by Receiving and RTV processing in purchasing.

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.PRODUCTION_ID , A.SERIAL_ID , B.COMPLETED_FLG FROM PS_SF_TRC_PRDN A , PS_SF_TRC_OUT B WHERE A.SETID_INV_ITEM =B.SETID_INV_ITEM AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INV_ITEM_ID =B.INV_ITEM_ID AND A.SERIAL_ID =B.SERIAL_ID AND A.INV_LOT_ID = B.INV_LOT_ID AND A.TRANSACTION_NBR = B.TRANSACTION_NBR AND A.SF_TRC_PRDN_STATUS = '1' AND B.COMPLETED_FLG = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
2 INV_ITEM_ID_RECV Character(18) VARCHAR2(18) NOT NULL Item Number
3 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
4 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
5 COMPLETED_FLG Character(1) VARCHAR2(1) NOT NULL Completed
N=Not Completed
Y=Complete