IN_WO_RETURN_VW

(SQL View)
 Index Back

SELECT WWPH.BUSINESS_UNIT , WWPH.WO_ID , WWPH.WO_TASK_ID , WWPH.RES_LN_NBR , SUM(RL.QTY_LN_RETRN_SUOM) FROM PS_IN_PEGGING IP , PS_WM_WO_PO_HASH WWPH , PS_PO_HASH PH , PS_PO_LINE_SHIP PLS , PS_RTV_LN RL WHERE WWPH.HASH_KEY = IP.DEMAND_HASH AND IP.PEG_STATUS IN ('10', '20') AND IP.SUP_ORDER_TYPE = '010' AND IP.DMD_ORDER_TYPE = '115' AND PH.HASH_KEY = IP.SUPPLY_HASH AND PLS.BUSINESS_UNIT = PH.BUSINESS_UNIT AND PLS.PO_ID = PH.PO_ID AND PLS.LINE_NBR = PH.LINE_NBR AND PLS.SCHED_NBR = PH.SCHED_NBR AND RL.BUSINESS_UNIT = PLS.BUSINESS_UNIT AND RL.PO_ID = PLS.PO_ID AND RL.LINE_NBR = PLS.LINE_NBR AND RL.SCHED_NBR = PLS.SCHED_NBR AND RL.RETURN_ACTION IN ('C', 'E') AND RL.RECEIVER_ID <> ' ' AND RL.RTV_LN_STATUS <> 'X' GROUP BY WWPH.BUSINESS_UNIT, WWPH.WO_ID, WWPH.WO_TASK_ID, WWPH.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_LN_RETRN_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Std Returned Qty