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 |