IN_WO_TASK_VW

(SQL View)
Index Back

Work Order Tasks in Task Rec

10/19/05 MEG CN#IN900: Added WO_INV_COMMIT_RULE.

SELECT DISTINCT b.business_unit_in , a.business_unit , a.wo_id , a.wo_task_id , %Substring(a.descr254,1,30) , a.asset_id , a.location , a.currency_cd , a.sched_start_dt , a.sched_start_time , a.wo_inv_commit_rule , a.wo_reserve_rule , a.priority_nbr FROM PS_WM_WO_TSK a , ps_bus_unit_tbl_wm b WHERE a.internal_status NOT IN ('05','06','07') AND b.business_unit = a.business_unit

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 SCHED_START_DT Date(10) DATE Scheduled Start Date
10 SCHED_START_TIME Time(15) TIMESTAMP Schedule Start Time
11 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
12 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
13 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority