BUSINESS_UNITSOURCE_BUS_UNITWO_IDWO_TASK_IDIN_WO_TSKPIK_VW(SQL View) |
Index Back |
|---|---|
Work Order Tasks in Task Rec |
| SELECT DISTINCT b.business_unit_in , a.business_unit , a.wo_id , a.wo_task_id 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 |