PV_RTV_P_DST_VW

(SQL View)
 Index Back

RTV PO Distribution View

SCC 8/15/06 ICE1551980000 - remove unused fields

SELECT A.BUSINESS_UNIT_PO , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.PO_DIST_LINE_NUM , A.QTY_PO , A.INV_ITEM_ID , A.DESCR254_MIXED , SUM(DIS.QTY_AM_RETRN_VUOM) FROM PS_PV_RTV_P_DST_V2 A , PS_RTV_LN_DISTRIB DIS WHERE DIS.BUSINESS_UNIT_PO = A.BUSINESS_UNIT_PO(+) AND DIS.PO_ID = A.PO_ID(+) AND DIS.LINE_NBR = A.LINE_NBR(+) AND DIS.SCHED_NBR = A.SCHED_NBR(+) AND DIS.PO_DIST_LINE_NUM = A.PO_DIST_LINE_NUM(+) GROUP BY A.BUSINESS_UNIT_PO , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.PO_DIST_LINE_NUM ,A.QTY_PO ,A.INV_ITEM_ID , A.DESCR254_MIXED

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO 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 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
6 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
9 QTY_SH_RTN Number(16,4) DECIMAL(15,4) NOT NULL Qty Returned in Receipt UOM