IN_PO_WO_LS_VW

(SQL View)
 Index Back

Supply Date after Demand Date

11/04/04 SR/ISC: Created

SELECT PH.BUSINESS_UNIT %Concat X.PEG_KEY_SEPARATOR %Concat PH.PO_ID , %NumtoChar(PH.LINE_NBR) %Concat X.PEG_KEY_SEPARATOR %Concat %NumtoChar(PH.SCHED_NBR) %Concat X.PEG_KEY_SEPARATOR %Concat %NumtoChar(PH.DISTRIB_LINE_NUM) , IP.SUP_DTTM , IDH.BUSINESS_UNIT %Concat X.PEG_KEY_SEPARATOR %Concat IDH.WO_ID , %NumtoChar(WO_TASK_ID) %Concat X.PEG_KEY_SEPARATOR %Concat %NumtoChar(RES_LN_NBR) ,IP.QTY_PEGGED , IP.DMD_DTTM , MST.UNIT_MEASURE_STD , PLD.BUSINESS_UNIT_IN , IP.DMD_ORDER_TYPE , IP.SUP_ORDER_TYPE FROM PS_IN_PEGGING IP , PS_PO_HASH PH , PS_WM_WO_MAT_HASH IDH , PS_PO_LINE_DISTRIB PLD , PS_INSTALLATION_IN X , PS_MASTER_ITEM_TBL MST , PS_BU_ITEMS_INV A , PS_SET_CNTRL_REC C , PS_PO_LINE PL WHERE IP.SUPPLY_HASH = PH.HASH_KEY AND IP.SUP_ORDER_TYPE = '010' AND IP.DEMAND_HASH = IDH.HASH_KEY AND IP.DMD_ORDER_TYPE = '110' AND IP.PEG_STATUS = '10' AND IP.SUP_DTTM > IP.DMD_DTTM AND PH.PO_ID = PLD.PO_ID AND PH.BUSINESS_UNIT = PLD.BUSINESS_UNIT AND PH.LINE_NBR = PLD.LINE_NBR AND PH.SCHED_NBR = PLD.SCHED_NBR AND PH.DISTRIB_LINE_NUM = PLD.DISTRIB_LINE_NUM 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 PLD.BUSINESS_UNIT_IN = C.SETCNTRLVALUE AND PL.PO_ID = PLD.PO_ID AND PL.BUSINESS_UNIT = PLD.BUSINESS_UNIT AND PL.LINE_NBR = PLD.LINE_NBR AND PL.INV_ITEM_ID = MST.INV_ITEM_ID

# 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 DUE_DTTM DateTime(26) TIMESTAMP Due Datetime
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 QTY_PEGGED Signed Number(17,4) DECIMAL(15,4) NOT NULL 06/16/04 EGS: Created.
7 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
8 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
9 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
10 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
11 SUP_ORDER_TYPE Character(4) VARCHAR2(4) NOT NULL Used by Pegging Maintenance/Inquiry
010=Purchase
020=Production
035=Transfer Supply
100=Requisition