IN_PRO_OP_VW

(SQL View)
 Index Back

Overpegged Orders

10/05/04 SR/ISC: Created

SELECT ID.BUSINESS_UNIT %Concat X.PEG_KEY_SEPARATOR %Concat ID.PRODUCTION_ID , ID.MG_OUTPUT_ITEM , %DatePart(IP.SUP_DTTM) , ID.MG_OUTPUT_SCHD_QTY , SUM(IP.QTY_PEGGED) , ID.BUSINESS_UNIT , MST.UNIT_MEASURE_STD , IP.SUP_ORDER_TYPE FROM PS_IN_PEGGING IP , PS_SF_OUTPUT_HASH IPH , PS_SF_OUTPUT_LIST ID , PS_INSTALLATION_IN X , PS_MASTER_ITEM_TBL MST , PS_BU_ITEMS_INV A , PS_SET_CNTRL_REC C WHERE IP.SUPPLY_HASH = IPH.HASH_KEY AND IP.SUP_ORDER_TYPE = '020' AND IP.PEG_STATUS = '10' AND IPH.BUSINESS_UNIT = ID.BUSINESS_UNIT AND IPH.PRODUCTION_ID = ID.PRODUCTION_ID AND IPH.MG_OUTPUT_TYPE = ID.MG_OUTPUT_TYPE AND IPH.MG_OUTPUT_ITEM = ID.MG_OUTPUT_ITEM AND IPH.OP_SEQUENCE = ID.OP_SEQUENCE AND IPH.MG_OUTPUT_QTY_CODE = ID.MG_OUTPUT_QTY_CODE AND A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'MASTER_ITEM_TBL' AND MST.SETID = C.SETID AND A.INV_ITEM_ID = MST.INV_ITEM_ID AND ID.BUSINESS_UNIT = C.SETCNTRLVALUE AND ID.MG_OUTPUT_ITEM = A.INV_ITEM_ID GROUP BY ID.BUSINESS_UNIT, ID.PRODUCTION_ID, ID.MG_OUTPUT_ITEM, IP.SUP_DTTM, ID.MG_OUTPUT_SCHD_QTY, X.PEG_KEY_SEPARATOR, IP.SUP_ORDER_TYPE, ID.BUSINESS_UNIT, MST.UNIT_MEASURE_STD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SUP_ORDER_KEY Character(25) VARCHAR2(25) NOT NULL Used to store the various Order Number formats in 1 field
2 SUP_LINE_KEY Character(25) VARCHAR2(25) NOT NULL Used to Store the concatenation of Line, Demand, Sched, Kit, etc in 1 field.
3 SCHED_DATE Date(10) DATE Schedule Date
4 QTY_OPEN Number(16,4) DECIMAL(15,4) NOT NULL Open Quantity
5 QTY_PEGGED Signed Number(17,4) DECIMAL(15,4) NOT NULL 06/16/04 EGS: Created.
6 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
7 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
8 SUP_ORDER_TYPE Character(4) VARCHAR2(4) NOT NULL Used by Pegging Maintenance/Inquiry
010=Purchase
020=Production
035=Transfer Supply
100=Requisition