IN_PO_CP_VW

(SQL View)
 Index Back

Canceled Orders with Pegs

10/05/04 SR/ISC: Created

SELECT DISTINCT PSH.BUSINESS_UNIT %Concat X.PEG_KEY_SEPARATOR %Concat PSH.PO_ID , %NUMTOCHAR(PSH.LINE_NBR) %Concat X.PEG_KEY_SEPARATOR %Concat %NUMTOCHAR(PSH.SCHED_NBR) %Concat X.PEG_KEY_SEPARATOR %Concat %NUMTOCHAR(PSH.DISTRIB_LINE_NUM) , PLD.BUSINESS_UNIT_IN , IP.SUP_ORDER_TYPE FROM PS_IN_PEGGING IP , PS_PO_HASH PSH , PS_PO_LINE_SHIP PLS , PS_PO_LINE PL , PS_PO_LINE_DISTRIB PLD , PS_INSTALLATION_IN X WHERE IP.SUPPLY_HASH = PSH.HASH_KEY AND IP.SUP_ORDER_TYPE = '010' AND IP.PEG_STATUS = '10' AND PSH.BUSINESS_UNIT = PLS.BUSINESS_UNIT AND PSH.PO_ID = PLS.PO_ID AND PSH.LINE_NBR = PLS.LINE_NBR AND PSH.SCHED_NBR = PLS.SCHED_NBR AND PSH.BUSINESS_UNIT = PL.BUSINESS_UNIT AND PSH.PO_ID = PL.PO_ID AND PSH.LINE_NBR = PL.LINE_NBR AND PSH.BUSINESS_UNIT = PLD.BUSINESS_UNIT AND PSH.PO_ID = PLD.PO_ID AND PSH.LINE_NBR = PLD.LINE_NBR AND PSH.SCHED_NBR = PLD.SCHED_NBR AND PSH.DISTRIB_LINE_NUM = PLD.DISTRIB_LINE_NUM AND (PL.CANCEL_STATUS = 'X' OR PLS.CANCEL_STATUS = 'X' OR PLD.DISTRIB_LN_STATUS = 'X')

# 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