IN_XRS_WO_MM_VW

(SQL View)
 Index Back

Mismatched Inventory Units

11/08/04 SR/ISC: Created

SELECT PH.BUSINESS_UNIT %Concat X.PEG_KEY_SEPARATOR %Concat PH.ORDER_NO , PH.DEMAND_SOURCE %Concat X.PEG_KEY_SEPARATOR %Concat %NUMTOCHAR(PH.ORDER_INT_LINE_NO) %Concat X.PEG_KEY_SEPARATOR %Concat %NUMTOCHAR(PH.SCHED_LINE_NBR) %Concat X.PEG_KEY_SEPARATOR %Concat %NUMTOCHAR(PH.DEMAND_LINE_NO) , PLD.DESTIN_BU , ID.BUSINESS_UNIT %Concat X.PEG_KEY_SEPARATOR %Concat ID.WO_ID , %NUMTOCHAR(ID.WO_TASK_ID) %Concat X.PEG_KEY_SEPARATOR %Concat %NUMTOCHAR(ID.RES_LN_NBR) , ID.BUSINESS_UNIT_IN , IP.QTY_PEGGED , ID.UNIT_MEASURE_STD ,IP.DMD_ORDER_TYPE ,IP.SUP_ORDER_TYPE FROM PS_IN_PEGGING IP , PS_IN_DEMAND_HASH PH , PS_IN_DEMAND PLD , PS_WM_WO_MAT_HASH IDH , PS_WM_WO_SCHED_MAT ID , PS_INSTALLATION_IN X WHERE IP.SUPPLY_HASH = PH.HASH_KEY AND IP.SUP_ORDER_TYPE = '035' AND IP.DEMAND_HASH = IDH.HASH_KEY AND IP.DMD_ORDER_TYPE = '110' AND IP.PEG_STATUS = '10' AND PH.BUSINESS_UNIT = PLD.BUSINESS_UNIT AND PH.DEMAND_SOURCE = PLD.DEMAND_SOURCE AND PH.SOURCE_BUS_UNIT = PLD.SOURCE_BUS_UNIT AND PH.ORDER_NO = PLD.ORDER_NO AND PH.ORDER_INT_LINE_NO = PLD.ORDER_INT_LINE_NO AND PH.SCHED_LINE_NBR = PLD.SCHED_LINE_NBR AND PH.INV_ITEM_ID = PLD.INV_ITEM_ID AND PH.DEMAND_LINE_NO = PLD.DEMAND_LINE_NO AND IDH.BUSINESS_UNIT = ID.BUSINESS_UNIT AND IDH.WO_ID = ID.WO_ID AND IDH.WO_TASK_ID = ID.WO_TASK_ID AND IDH.RES_LN_NBR = ID.RES_LN_NBR AND PLD.DESTIN_BU <> ID.BUSINESS_UNIT_IN

# 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 BUSINESS_UNIT_SUP Character(5) VARCHAR2(5) NOT NULL 07/29/04 EGS: Created
4 DMD_ORDER_KEY Character(25) VARCHAR2(25) NOT NULL Used to store the various Order Number formats in 1 field
5 DMD_LINE_KEY Character(25) VARCHAR2(25) NOT NULL Used to Store the concatenation of Line, Demand, Sched, Kit, etc in 1 field.
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 QTY_PEGGED Signed Number(17,4) DECIMAL(15,4) NOT NULL 06/16/04 EGS: Created.
8 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
9 DMD_ORDER_TYPE Character(4) VARCHAR2(4) NOT NULL Used by Pegging Maintenance/Inquiry
030=Transfer Demand
070=Stock Request
090=Sales Order
110=Work Order Inventory
115=WO Non-Inventory
900=Work Order
10 SUP_ORDER_TYPE Character(4) VARCHAR2(4) NOT NULL Used by Pegging Maintenance/Inquiry
010=Purchase
020=Production
035=Transfer Supply
100=Requisition