WM_WO_POHASH_VW

(SQL View)
 Index Back

Work Order PO Hash View

Purchase orders pegged to a work order view

SELECT A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , A.RES_LN_NBR , A.RSRC_TYPE , A.INV_ITEM_ID , A.DESCR254_MIXED , A.QTY_REQUIRED , A.UNIT_OF_MEASURE , A.DUE_DT , A.WO_DELIVERY_INST , A.EST_UNIT_COST , A.SCHED_COST_PO , A.CURRENCY_CD , C.BUSINESS_UNIT , C.PO_ID , C.LINE_NBR , C.SCHED_NBR , C.DISTRIB_LINE_NUM , %NumToChar(C.LINE_NBR) %Concat X.PEG_KEY_SEPARATOR %Concat %NumToChar(C.SCHED_NBR) %Concat X.PEG_KEY_SEPARATOR %Concat %NumToChar(C.DISTRIB_LINE_NUM) , C.QTY_PO_STD_EXP , BB.QTY_PEGGED , BB.QTY_COMPLETE , C.QTY_PO_STD_EXP , S.DUE_DT , S.DUE_TIME , BB.PEG_STATUS FROM PS_WM_WO_SCHED_PO A , PS_WM_WO_PO_HASH B , PS_IN_PEGGING BB , PS_PO_LINE_DISTRIB C , PS_PO_LINE_SHIP S , PS_PO_HASH D , PS_INSTALLATION_IN X WHERE B.BUSINESS_UNIT = 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 BB.DMD_ORDER_TYPE = '115' AND BB.DEMAND_HASH = B.HASH_KEY AND BB.SUP_ORDER_TYPE = '010' AND BB.SUPPLY_HASH = D.HASH_KEY AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.PO_ID = D.PO_ID AND C.LINE_NBR = D.LINE_NBR AND C.SCHED_NBR = D.SCHED_NBR AND C.DISTRIB_LINE_NUM = D.DISTRIB_LINE_NUM AND C.DST_ACCT_TYPE = 'DST' AND S.BUSINESS_UNIT = C.BUSINESS_UNIT AND S.PO_ID = C.PO_ID AND S.LINE_NBR = C.LINE_NBR AND S.SCHED_NBR = C.SCHED_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 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE3

7 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
8 QTY_REQUIRED Signed Number(17,4) DECIMAL(15,4) NOT NULL Work Order quantity required
9 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Default Value: MASTER_ITEM_TBL.UNIT_MEASURE_STD

Prompt Table: %EDIT_UOM

10 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
11 WO_DELIVERY_INST Character(254) VARCHAR2(254) NOT NULL Delivery instructions for work order parts list
12 EST_UNIT_COST Number(21,5) DECIMAL(20,5) NOT NULL Estimated unit cost
13 SCHED_COST_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL This field will be used to store the Scheduled cost of Procurement
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: BUS_UNIT_TBL_WM.BASE_CURRENCY

15 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
16 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
17 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
18 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
19 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distrib
20 PEG_LINE_KEY Character(30) VARCHAR2(30) NOT NULL Used to Store the concatenation of Line, Demand, Sched, Kit, etc in 1 field.
21 QTY_AVAILABLE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Available
22 QTY_PEGGED Signed Number(17,4) DECIMAL(15,4) NOT NULL 06/16/04 EGS: Created.
23 QTY_COMPLETE Number(16,4) DECIMAL(15,4) NOT NULL Quantity Complete
24 QTY_ORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL 06/21/04 EGS: Created
25 SCHED_DATE Date(10) DATE Schedule Date
26 SCHED_TIME Time(15) TIMESTAMP Schedule Time
27 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged