BUSINESS_UNITWO_IDIN_WO_ID_VW3(SQL View) |
Index Back |
|---|---|
Work Order IDs in wm_wo_tsk |
| SELECT DISTINCT b.business_unit_in , t.business_unit , t.wo_id FROM PS_WM_WO_TSK t , ps_bus_unit_tbl_wm b , ps_wm_wo_sched_mat a WHERE t.internal_status NOT IN ('05','06','07') AND b.business_unit = t.business_unit AND a.business_unit = t.business_unit AND a.wo_id = t.wo_id AND a.wo_task_id = t.wo_task_id AND a.qty_scheduled > 0 AND a.floor_stock_flag <> 'Y' |
| # | 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 |