RECV_DIST_AP_VW

(SQL View)
 Index Back

Receipt - RTV View


SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , A.DISTRIB_LINE_NUM , A.QTY_DS_ACCPT_SUOM + SUM(D.QTY_AM_RETRN_SUOM) , A.QTY_DS_ACCPT_VUOM + SUM(D.QTY_AM_RETRN_VUOM) FROM PS_RECV_LN_DISTRIB A , PS_BUS_UNIT_TBL_PM B , PS_RTV_LN C , PS_RTV_LN_DISTRIB D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.RTV_ADJ_SOURCE = 'Y' AND A.BUSINESS_UNIT = D.BUSINESS_UNIT_RECV AND A.RECEIVER_ID = D.RECEIVER_ID AND A.RECV_LN_NBR = D.RECV_LN_NBR AND A.RECV_SHIP_SEQ_NBR = D.RECV_SHIP_SEQ_NBR AND A.DISTRIB_LINE_NUM = D.DISTRIB_LINE_NUM AND D.RTV_DIST_STATUS <> 'X' AND D.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.RTV_ID = C.RTV_ID AND D.RTV_LN_NBR = C.RTV_LN_NBR AND C.RTV_LN_STATUS <> 'X' AND C.RETURN_ACTION = 'R' GROUP BY A.BUSINESS_UNIT, A.RECEIVER_ID, A.RECV_LN_NBR, A.RECV_SHIP_SEQ_NBR, A.DISTRIB_LINE_NUM, A.QTY_DS_ACCPT_SUOM, A.QTY_DS_ACCPT_VUOM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
4 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
5 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
6 QTY_DS_ACCPT_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Distributed Quantity
7 QTY_DS_ACCPT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Distributed Qty in Supp UOM