CM_NP_PID_VW(SQL View) |
Index Back |
---|---|
PID's completed but not putawapids where completed qty <> the sum of 021 qty's in trans_inv |
SELECT A.BUSINESS_UNIT , D.CM_BOOK , A.PRODUCTION_ID , A.MG_OUTPUT_ITEM , (A.COMPLETED_QTY - B.COMPLETED_QTY) , %Substring(C.MESSAGE_TEXT, 1, 50) FROM PS_CE_OUTPUT2_VW A , PS_CE_PID_CMP_VW B , PSMSGCATDEFN C , PS_CM_BU_BOOK_TBL D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PRODUCTION_ID = B.PRODUCTION_ID AND A.MG_OUTPUT_ITEM = B.INV_ITEM_ID AND (B.COMPLETED_QTY - A.COMPLETED_QTY) <> 0 AND C.MESSAGE_SET_NBR = 15500 AND C.MESSAGE_NBR = 177 AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND D.CM_BOOK_STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | CM_BOOK | Character(10) | VARCHAR2(10) NOT NULL | Cost Book |
3 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
4 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
5 | COMPLETED_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Completed Qty |
6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |