BUSINESS_UNITSOURCE_BUS_UNITWO_IDIN_WO_ID_VW(SQL View) |
Index Back |
|---|---|
Work Order IDs in wm_wo_tsk |
| SELECT DISTINCT b.business_unit_in , a.business_unit , a.wo_id , %Substring(h.descr254,1,60) , h.shop_id FROM PS_WM_WO_TSK a , ps_bus_unit_tbl_wm b , ps_wm_wo_hdr h WHERE a.internal_status NOT IN ('05','06','07') AND b.business_unit = a.business_unit AND h.business_unit = a.business_unit AND h.wo_id = a.wo_id |
| # | 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 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 5 | SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shop Identification |