IN_WM_ALL_VW

(SQL View)
 Index Back

Join of all WM tables for Rsv

Reservations needs a join with all three WM tables.

SELECT H.BUSINESS_UNIT , M.BUSINESS_UNIT_IN , H.WO_ID , T.WO_TASK_ID , M.RES_LN_NBR , M.INV_ITEM_ID , H.SHOP_ID , H.WO_TYPE , H.PROJECT_ID , H.SRVC_GRP_ID , H.LOCATION , M.WO_COMMIT_FLAG , T.WO_INV_COMMIT_RULE , T.INTERNAL_STAT_COMM , T.WO_RESERVE_RULE , T.INTERNAL_STAT_RSRV , T.INTERNAL_STATUS , M.WO_MAT_NEED_DT FROM PS_WM_WO_HDR H , PS_WM_WO_TSK T , PS_WM_WO_SCHED_MAT M WHERE %Join(COMMON_KEYS, WM_WO_HDR H, WM_WO_TSK T) AND %Join(COMMON_KEYS, WM_WO_TSK T, WM_WO_SCHED_MAT M)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
3 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
4 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
5 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
7 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
8 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type
9 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
10 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group
11 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
12 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
13 WO_INV_COMMIT_RULE Character(1) VARCHAR2(1) NOT NULL Inventory commit rule, when to commit inventory for Work Management
1=Parts List Creation
2=Pick Plan Creation
3=Work Order Status Change
4=Commit at Reserve
14 INTERNAL_STAT_COMM Character(2) VARCHAR2(2) NOT NULL Work Order commit rule internal status.
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
15 WO_RESERVE_RULE Character(1) VARCHAR2(1) NOT NULL Work Order Reservation rule
1=Parts List Creation
2=Pick Plan Creation
3=Work Order Status Change
4=Batch Reserve Only
16 INTERNAL_STAT_RSRV Character(2) VARCHAR2(2) NOT NULL Work Order Reservation rule internal status.
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
17 INTERNAL_STATUS Character(2) VARCHAR2(2) NOT NULL Internal Status
01=Open
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
05=Complete
06=Closed
07=Canceled
08=On Hold
09=Work Order Created
18 WO_MAT_NEED_DT Date(10) DATE Work Management Material needed date. This field is used when committing inventory and the needed date