WM_WO_POINQ2_VW

(SQL View)
 Index Back

WO Procure Inquiry Detail View

Work Order Procurement Inquiry Detail View - join of requisitions, purchase orders pegged/referenced to work order quantity-based and amount-only procurement items

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 , 'N' , A.BUSINESS_UNIT_PO , A.PEG_ORDER_TYPE , A.ORDER_NO , A.LINE_NBR , A.SCHED_NBR , A.DISTRIB_LINE_NUM , A.PEG_LINE_KEY , A.QTY_AVAILABLE , A.QTY_PEGGED , A.QTY_COMPLETE , A.QTY_ORDER , A.SCHED_DATE , A.SCHED_TIME , A.PEG_STATUS FROM PS_WM_WO_PEGITM_VW A UNION SELECT B.BUSINESS_UNIT , B.WO_ID , B.WO_TASK_ID , B.RES_LN_NBR , B.RSRC_TYPE , B.INV_ITEM_ID , B.DESCR254_MIXED , B.QTY_REQUIRED , B.UNIT_OF_MEASURE , B.DUE_DT , B.WO_DELIVERY_INST , B.EST_UNIT_COST , B.SCHED_COST_PO , B.CURRENCY_CD , 'Y' , B.BUSINESS_UNIT_PO , B.PEG_ORDER_TYPE , B.ORDER_NO , B.LINE_NBR , B.SCHED_NBR , B.DISTRIB_LINE_NUM , B.PEG_LINE_KEY , B.QTY_AVAILABLE , 0 , 0 , B.QTY_ORDER , B.SCHED_DATE , B.SCHED_TIME , ' ' FROM PS_WM_WO_AMOITM_VW B

# 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

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
15 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
N=No
Y=Yes

Y/N Table Edit

16 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
17 PEG_ORDER_TYPE Character(4) VARCHAR2(4) NOT NULL Used by Pegging Maintenance/Inquiry
010=Purchase
020=Production
030=Transfer Demand
035=Transfer Supply
070=Stock Request
090=Sales Order
100=Requisition
110=WO Inventory
115=WO Non-Inventory
18 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
19 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
20 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
21 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distrib
22 PEG_LINE_KEY Character(30) VARCHAR2(30) NOT NULL Used to Store the concatenation of Line, Demand, Sched, Kit, etc in 1 field.
23 QTY_AVAILABLE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Available
24 QTY_PEGGED Signed Number(17,4) DECIMAL(15,4) NOT NULL 06/16/04 EGS: Created.
25 QTY_COMPLETE Number(16,4) DECIMAL(15,4) NOT NULL Quantity Complete
26 QTY_ORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL 06/21/04 EGS: Created
27 SCHED_DATE Date(10) DATE Schedule Date
28 SCHED_TIME Time(15) TIMESTAMP Schedule Time
29 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged