BUSINESS_UNITSHOP_IDIN_WO_SHOP_VW(SQL View) |
Index Back |
|---|---|
Work Order Shop View |
| SELECT DISTINCT b.business_unit_in , a.business_unit , a.shop_id FROM ps_wm_wo_hdr a , PS_WM_WO_TSK t , ps_bus_unit_tbl_wm b WHERE t.business_unit = a.business_unit AND b.business_unit = a.business_unit AND t.wo_id = a.wo_id AND t.internal_status NOT IN ('05','06','07') |
| # | 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 | SHOP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Shop Identification |