IN_WO_CP_VW

(SQL View)
 Index Back

Cancelled Orders with Pegs

10/05/04 SR/ISC: Created

SELECT DISTINCT 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.DMD_ORDER_TYPE FROM PS_IN_PEGGING IP , PS_WM_WO_MAT_HASH IDH , PS_WM_WO_SCHED_MAT ID , PS_INSTALLATION_IN X , PS_WM_WO_TSK TSK WHERE IP.DEMAND_HASH = IDH.HASH_KEY AND IP.DMD_ORDER_TYPE = '110' AND IP.PEG_STATUS = '10' 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 ID.BUSINESS_UNIT = TSK.BUSINESS_UNIT AND ID.WO_ID = TSK.WO_ID AND ID.WO_TASK_ID = TSK.WO_TASK_ID AND TSK.INTERNAL_STATUS = '07'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DMD_ORDER_KEY Character(25) VARCHAR2(25) NOT NULL Used to store the various Order Number formats in 1 field
2 DMD_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 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