SL_BUSINESS_UNITTO_BUSINESS_UNITSL_SOURCE_BUS_UNITSL_ORDER_NOIN_DMD_WOH_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT m.business_unit_in , m.business_unit_in , m.business_unit , m.wo_id FROM ps_wm_wo_sched_mat m , PS_WM_WO_TSK t WHERE %Join(common_keys, wm_wo_sched_mat m, wm_wo_tsk t) AND t.internal_status NOT IN ('05', '06', '07') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SL_BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit selection field |
| 2 | TO_BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit selection field |
| 3 | SL_SOURCE_BUS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Source Business Unit selection |
| 4 | SL_ORDER_NO |
Character(10) | VARCHAR2(10) NOT NULL | Order Number selection |