IN_NWO_PQOH_VW

(SQL View)
 Index Back

Pegs and Qty on hand

11/05/04 SR/ISC: Created

SELECT BII.BUSINESS_UNIT , BII.INV_ITEM_ID , BII.QTY_AVAILABLE , 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) , %DatePart(IP.DMD_DTTM) , SUM(IP.QTY_PEGGED) , MST.UNIT_MEASURE_STD , MST.DESCR , IP.DMD_ORDER_TYPE FROM PS_IN_PEGGING IP , PS_WM_WO_PO_HASH IDH , PS_WM_WO_SCHED_PO ID , PS_BU_ITEMS_INV BII , PS_INSTALLATION_IN X , PS_MASTER_ITEM_TBL MST , PS_SET_CNTRL_REC C WHERE IP.DEMAND_HASH = IDH.HASH_KEY AND IP.DMD_ORDER_TYPE = '115' 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 BII.BUSINESS_UNIT = ID.BUSINESS_UNIT AND BII.INV_ITEM_ID = ID.INV_ITEM_ID AND BII.QTY_AVAILABLE > 0 AND BII.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'MASTER_ITEM_TBL' AND MST.SETID = C.SETID AND BII.INV_ITEM_ID = MST.INV_ITEM_ID AND ID.INV_ITEM_ID = MST.INV_ITEM_ID GROUP BY BII.BUSINESS_UNIT, BII.INV_ITEM_ID, IDH.WO_TASK_ID, IDH.BUSINESS_UNIT , IDH.RES_LN_NBR, IP.DMD_DTTM, BII.QTY_AVAILABLE, X.PEG_KEY_SEPARATOR , MST.UNIT_MEASURE_STD , MST.DESCR , IDH.WO_ID, IP.DMD_ORDER_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 QTY_AVAILABLE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Available
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_DATE Date(10) DATE Schedule Date
7 QTY_PEGGED Signed Number(17,4) DECIMAL(15,4) NOT NULL 06/16/04 EGS: Created.
8 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
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