SF_TRC_PD_S_VW2

(SQL View)
 Index Back

Prdn Trace Sum View for PIDS

10/02/02 PWF Added new view to be put into page

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.PRODUCTION_ID , A.SF_TRC_PRDN_STATUS , SUM(B.NEW_PRDN_QTY) FROM PS_SF_TRC_PRDN A , PS_SF_TRC_OUT B WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.INV_ITEM_ID=B.INV_ITEM_ID AND A.SERIAL_ID=B.SERIAL_ID GROUP BY A.BUSINESS_UNIT, A.INV_ITEM_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 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
4 SF_TRC_PRDN_STATUS Character(1) VARCHAR2(1) NOT NULL Production Trace Status
1=Associated
2=Disassoc
3=Torndown
4=Split
5=Rework
5 NEW_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production Start Qty