IN_WO_TASK_VW3(SQL View) |
Index Back |
---|---|
Work Order Tasks in Task Rec |
SELECT DISTINCT b.business_unit_in , a.business_unit , 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 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
2 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
3 | Number(5,0) | INTEGER NOT NULL | Task Number |