SF_TRC_TD_S_VW

(SQL View)
 Index Back

Prdn Trace Sum View for TD PID

09/03/03 PWF CN#MG880-SERIAL Created this record to determine the status of components to be torndown in a teardown PID

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.SERIAL_ID , A.INV_LOT_ID , A.PRODUCTION_ID , A.SF_TRC_PRDN_STATUS , 0 , 0 , 0 FROM PS_SF_TRC_PRDN A , PS_SF_TRC_USAG 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 GROUP BY A.BUSINESS_UNIT, A.INV_ITEM_ID, A.INV_LOT_ID, A.SERIAL_ID, A.PRODUCTION_ID,A.SF_TRC_PRDN_STATUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
4 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
5 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
6 SF_TRC_PRDN_STATUS Character(1) VARCHAR2(1) NOT NULL Production Trace Status
1=Associated
2=Disassoc
3=Torndown
4=Split
5=Rework
7 NEW_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production Start Qty
8 COMPL_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Completed Qty
9 SCRAPPED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Scrapped Qty