SF_TRC_PRDN_VW2

(SQL View)
 Index Back

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 Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SF_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL 01/31/03 MDS CN#MG880-Genealogy: Needed this clone of inv_item_id for the serial id prompt table in td completions because tools always finds a blank inv_item_id (because it's on multiple records in this component).
3 SF_PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL 01/31/03 MDS CN#MG880-Genealogy: Needed this clone of production_id for the serial id prompt table in td completions because tools always finds a blank production_id (because it's on multiple records in this component).
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