IN_PO_PTWY_VW

(SQL View)
 Index Back

SELECT D.BUSINESS_UNIT , D.PO_ID , D.LINE_NBR , D.SCHED_NBR , D.DISTRIB_LINE_NUM , TI.QTY_BASE FROM PS_PO_LINE_DISTRIB D , PS_RECV_LN_DISTRIB R , PS_TRANSACTION_INV TI WHERE R.BUSINESS_UNIT_PO = D.BUSINESS_UNIT AND R.PO_ID = D.PO_ID AND R.LINE_NBR = D.LINE_NBR AND R.SCHED_NBR = D.SCHED_NBR AND R.PO_DIST_LINE_NUM = D.DISTRIB_LINE_NUM AND R.RECV_DS_STATUS <> 'X' AND TI.SOURCE_BUS_UNIT = R.BUSINESS_UNIT AND TI.RECEIVER_ID = R.RECEIVER_ID AND TI.RECV_LN_NBR = R.RECV_LN_NBR AND TI.RECV_SHIP_SEQ_NBR = R.RECV_SHIP_SEQ_NBR AND TI.DISTRIB_LINE_NUM = R.DISTRIB_LINE_NUM AND (TI.TRANSACTION_GROUP = '020' OR TI.TRANSACTION_GROUP = '010')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
5 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
6 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity