RECV_LN_DIST_VW(SQL View) |
Index Back |
|---|---|
Sum of rcv sched qty for line |
| SELECT D.BUSINESS_UNIT_PO , D.PO_ID , D.LINE_NBR , D.SCHED_NBR , D.PO_DIST_LINE_NUM , SUM(D.QTY_DS_ACCPT_SUOM) , SUM(D.QTY_DS_ACCPT_VUOM) FROM PS_RECV_LN_SHIP S , PS_RECV_LN_DISTRIB D WHERE S.RECV_SHIP_STATUS <> 'X' AND D.RECV_DS_STATUS <> 'X' AND D.BUSINESS_UNIT = S.BUSINESS_UNIT AND D.RECEIVER_ID = S.RECEIVER_ID AND D.RECV_LN_NBR = S.RECV_LN_NBR AND D.RECV_SHIP_SEQ_NBR = S.RECV_SHIP_SEQ_NBR GROUP BY D.BUSINESS_UNIT_PO, D.PO_ID, D.LINE_NBR, D.SCHED_NBR, D.PO_DIST_LINE_NUM |
| # | 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 | 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 |