SF_TRC_PD_S_VW

(SQL View)
 Index Back

Prdn Trace Sum View for PIDS

10/02/02 PWF Added new view to be put into page 08/25/03 PWF Added Completed Qty and Scrapped Qty

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.SERIAL_ID , A.INV_LOT_ID , A.PRODUCTION_ID , A.SF_TRC_PRDN_STATUS , SUM(B.NEW_PRDN_QTY) , SUM(b.compl_qty) , SUM (b.scrapped_qty) 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 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