EIP_CTL_IDBUSINESS_UNIT_POPO_IDLINE_NBRPO_SSPOA_LN_VW2(SQL View) |
Index Back |
|---|---|
Po Lines , no vouchewr |
| SELECT A.EIP_CTL_ID , A. BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , SUM(B.QTY_PO) , SUM(B.MERCHANDISE_AMT) FROM PS_PO_LINE_EC A , PS_PO_LINE_SHIP_EC B WHERE A.EIP_CTL_ID = B.EIP_CTL_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND A.LINE_NBR = B.LINE_NBR AND NOT EXISTS ( SELECT 'X' FROM PS_PO_LINE_SHIP C WHERE B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PO_ID = C.PO_ID AND B.LINE_NBR = C.LINE_NBR AND B.SCHED_NBR = C.SCHED_NBR AND C.CANCEL_STATUS = 'X' ) GROUP BY A.EIP_CTL_ID, A.BUSINESS_UNIT, A.PO_ID, A.LINE_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EIP_CTL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 2 | BUSINESS_UNIT_PO |
Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 3 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 4 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 5 | QTY_PO | Number(16,4) | DECIMAL(15,4) NOT NULL | Purchase Order Quantity |
| 6 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |