09/28/04 EGS: Created.

IN_WSM_DPI_VW

(SQL View)
 Index Back

SELECT WWSM.BUSINESS_UNIT , WWSM.WO_ID , WWSM.WO_TASK_ID , WWSM.RES_LN_NBR , SUM(DPI.QTY_PICKED) FROM PS_WM_WO_SCHED_MAT WWSM , PS_DEMAND_PHYS_INV DPI WHERE DPI.BUSINESS_UNIT = WWSM.BUSINESS_UNIT_IN AND DPI.DEMAND_SOURCE = 'WM' AND DPI.SOURCE_BUS_UNIT = WWSM.BUSINESS_UNIT AND DPI.ORDER_NO = WWSM.WO_ID AND DPI.ORDER_INT_LINE_NO = WWSM.WO_TASK_ID AND DPI.SCHED_LINE_NBR = WWSM.RES_LN_NBR AND DPI.INV_ITEM_ID = WWSM.INV_ITEM_ID AND DPI.DEMAND_LINE_NO = 1 GROUP BY WWSM.BUSINESS_UNIT, WWSM.WO_ID, WWSM.WO_TASK_ID, WWSM.RES_LN_NBR

# 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 QTY_PICKED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked