IN_REQ_NWO_LSVW

(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.REQ_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(IDH.WO_TASK_ID) %Concat X.PEG_KEY_SEPARATOR %Concat %NUMTOCHAR(IDH.RES_LN_NBR) ,IP.DMD_DTTM , IP.DMD_ORDER_TYPE , IP.SUP_ORDER_TYPE , IDH.BUSINESS_UNIT FROM PS_IN_PEGGING IP , PS_REQ_HASH PH , PS_WM_WO_PO_HASH IDH , PS_INSTALLATION_IN X , PS_WM_WO_SCHED_PO ID WHERE IP.SUPPLY_HASH = PH.HASH_KEY AND IP.SUP_ORDER_TYPE = '100' AND IP.DEMAND_HASH = IDH.HASH_KEY AND IP.DMD_ORDER_TYPE ='115' AND IP.PEG_STATUS = '10' AND IP.SUP_DTTM > IP.DMD_DTTM 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 IDH.RSRC_TYPE = ID.RSRC_TYPE

# 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 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
7 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
8 SUP_ORDER_TYPE Character(4) VARCHAR2(4) NOT NULL Used by Pegging Maintenance/Inquiry
010=Purchase
020=Production
035=Transfer Supply
100=Requisition
9 BUSINESS_UNIT_DMD Character(5) VARCHAR2(5) NOT NULL 08/12/04 EGS: Created.