IN_XRS_CP_VW

(SQL View)
 Index Back

Canceled Orders with Pegs

10/05/04 SR/ISC: Created

SELECT DISTINCT IDH.BUSINESS_UNIT %Concat X.PEG_KEY_SEPARATOR %Concat IDH.ORDER_NO , IDH.DEMAND_SOURCE %Concat X.PEG_KEY_SEPARATOR %Concat %NUMTOCHAR(IDH.ORDER_INT_LINE_NO) %Concat X.PEG_KEY_SEPARATOR %Concat %NUMTOCHAR(IDH.SCHED_LINE_NBR) %Concat X.PEG_KEY_SEPARATOR %Concat %NUMTOCHAR(IDH.DEMAND_LINE_NO) , ID.DESTIN_BU , IP.SUP_ORDER_TYPE FROM PS_IN_PEGGING IP , PS_IN_DEMAND_HASH IDH , PS_IN_DEMAND ID , PS_INSTALLATION_IN X WHERE IP.SUPPLY_HASH = IDH.HASH_KEY AND IP.SUP_ORDER_TYPE = '035' AND IP.PEG_STATUS = '10' AND IDH.BUSINESS_UNIT = ID.BUSINESS_UNIT AND IDH.ORDER_NO = ID.ORDER_NO AND IDH.ORDER_INT_LINE_NO = ID.ORDER_INT_LINE_NO AND IDH.SCHED_LINE_NBR = ID.SCHED_LINE_NBR AND ID.IN_FULFILL_STATE = '90'

# 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_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
4 SUP_ORDER_TYPE Character(4) VARCHAR2(4) NOT NULL Used by Pegging Maintenance/Inquiry
010=Purchase
020=Production
035=Transfer Supply
100=Requisition