CM_AVGQTY_VW

(SQL View)
Index Back

CM Perpertual Average Qty view


SELECT A.BUSINESS_UNIT , A.BUSINESS_UNIT_RECV , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , A.DISTRIB_LINE_NUM , SUM(B.QTY_BASE) FROM PS_CM_AVGADJ_COST A , PS_TRANSACTION_INV B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.DT_TIMESTAMP = B.DT_TIMESTAMP AND A.SEQ_NBR = B.SEQ_NBR GROUP BY A.BUSINESS_UNIT, A.INV_ITEM_ID, A.DT_TIMESTAMP, A.SEQ_NBR, A.BUSINESS_UNIT_RECV, A.RECEIVER_ID, A.RECV_LN_NBR, A.RECV_SHIP_SEQ_NBR, A.DISTRIB_LINE_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
3 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
4 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
5 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
6 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
7 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity