WM_QTY_PREAL_VW

(SQL View)
 Index Back

WM Qty Pre-Allocated View

Used to get Qty Pre-Allocated for corresponding WO Task Sched Inv lines. (Note: Qty Pre-Allocated returned by this view is in base UOM units, must be subsequently converted in PeopleCode to demand units; i.e., if demand UOM <> standard UOM)

SELECT A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , A.RES_LN_NBR , A.INV_ITEM_ID , SUM(B.QTY_BASE) FROM PS_WM_WO_SCHED_MAT A , PS_DEMAND_PHYS_INV B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT_IN AND B.DEMAND_SOURCE = 'WM' AND B.SOURCE_BUS_UNIT = A.BUSINESS_UNIT AND B.ORDER_NO = A.WO_ID AND B.ORDER_INT_LINE_NO = A.WO_TASK_ID AND B.SCHED_LINE_NBR = A.RES_LN_NBR AND B.INV_ITEM_ID = A.INV_ITEM_ID AND B.DEMAND_LINE_NO = 1 AND B.DEMAND_SOURCE = 'WM' AND B.ALLOCATE_SOURCE = 'PR' AND B.PICK_BATCH_ID = 0 GROUP BY A.BUSINESS_UNIT, A.WO_ID, A.WO_TASK_ID, A.RES_LN_NBR, A.INV_ITEM_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
3 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
4 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
6 QTY_PRE_ALLOC_BASE Number(16,4) DECIMAL(15,4) NOT NULL Quantity Open Standard UOM