CM_NP_PID2_VW(SQL View) |
Index Back |
|---|---|
PID's completed but not putawaPIDS with completed qty > 0 and not in transaction_inv (not putaway) |
| SELECT A.BUSINESS_UNIT , B.CM_BOOK , A.PRODUCTION_ID , A.MG_OUTPUT_ITEM , A.COMPLETED_QTY , %Substring(C.MESSAGE_TEXT, 1, 50) FROM PS_CE_OUTPUT2_VW A , PS_CM_BU_BOOK_TBL B , PSMSGCATDEFN C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.CM_BOOK_STATUS = 'A' AND A.COMPLETED_QTY > 0 AND C.MESSAGE_SET_NBR = 15500 AND C.MESSAGE_NBR = 177 AND NOT EXISTS ( SELECT 'X' FROM PS_CE_PID_CMP_VW BB WHERE A.BUSINESS_UNIT = BB.BUSINESS_UNIT AND A.PRODUCTION_ID = BB.PRODUCTION_ID AND A.MG_OUTPUT_ITEM = BB.INV_ITEM_ID ) |
| # | 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 |