WM_WO_SCHMAT_NC

(SQL View)
 Index Back

Inventory scheduled resources


SELECT A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , B.BUSINESS_UNIT_IN , B.ITM_SETID , B.INV_ITEM_ID , B.RES_LN_NBR , B.WO_MAT_NEED_DT , B.QTY_SCHEDULED_BASE , B.PEG_STATUS , B.WO_COMMIT_FLAG , B.DESCR254_MIXED FROM PS_WM_WO_TSK A , PS_WM_WO_SCHED_MAT B WHERE A.INTERNAL_STATUS NOT IN ('05', '06', '07') AND B.FLOOR_STOCK_FLAG <> 'Y' AND %Join(COMMON_KEYS, WM_WO_TSK A, WM_WO_SCHED_MAT B)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order

Prompt Table: SP_BU_WM_NONVW

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 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
5 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
7 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.
8 WO_MAT_NEED_DT Date(10) DATE Work Management Material needed date. This field is used when committing inventory and the needed date
9 QTY_SCHEDULED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Scheduled base
10 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged

Default Value: 40

11 WO_COMMIT_FLAG Character(1) VARCHAR2(1) NOT NULL Work Order Management Commit Flag. This flag handles WO commitments against PS Inventory
1=Not Committed
2=In Process
3=Committed

Default Value: 1

12 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description