AP_PO_WO_VW

(SQL View)
 Index Back

PO Distrib Work Order Data


SELECT A.BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.DISTRIB_LINE_NUM , C.BUSINESS_UNIT , C.WO_ID , C.WO_TASK_ID , C.RSRC_TYPE , C.RES_LN_NBR FROM PS_PO_HASH A , PS_IN_PEGGING B , PS_WM_WO_PO_HASH C WHERE B.DMD_ORDER_TYPE = '115' AND B.SUP_ORDER_TYPE = '010' AND B.PEG_STATUS IN ('10', '20') AND B.SUPPLY_HASH = A.HASH_KEY AND B.DEMAND_HASH = C.HASH_KEY UNION SELECT C.BUSINESS_UNIT , C.PO_ID , C.LINE_NBR , C.SCHED_NBR , C.DISTRIB_LINE_NUM , A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , A.RSRC_TYPE , A.RES_LN_NBR FROM PS_WM_WO_SCHED_PO A , PS_POREQ_WO_XREF B , PS_PO_LINE_DISTRIB C WHERE B.PO_DOCUMENT_TYPE = 'PO' AND B.BUSINESS_UNIT_WO = A.BUSINESS_UNIT AND B.WO_ID = A.WO_ID AND B.WO_TASK_ID = A.WO_TASK_ID AND B.RES_LN_NBR = A.RES_LN_NBR AND B.RSRC_TYPE = A.RSRC_TYPE AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.PO_ID = B.DOC_ID AND C.LINE_NBR = B.LINE_NBR AND C.SCHED_NBR = B.SCHED_NBR AND C.DST_ACCT_TYPE = 'DST'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
5 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
6 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
7 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
8 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
9 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material
10 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.