CM_NP_PID_VW

(SQL View)
Index Back

PID's completed but not putawa

pids 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