SL_BUSINESS_UNITTO_BUSINESS_UNITSL_SOURCE_BUS_UNITSL_ORDER_NOTO_ORDER_NOSL_ORDER_INT_LINESL_SCHED_LINE_NBRIN_DMD_WOS_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT m.business_unit_in , m.business_unit_in , m.business_unit , m.wo_id , m.wo_id , m.wo_task_id , m.res_ln_nbr 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 |
| 5 | TO_ORDER_NO |
Character(10) | VARCHAR2(10) NOT NULL | Order Number selection |
| 6 | SL_ORDER_INT_LINE |
Number(5,0) | INTEGER NOT NULL | Order Line selection |
| 7 | SL_SCHED_LINE_NBR |
Number(6,0) | INTEGER NOT NULL | 05/07/04 PWF Added field for new 8.9 data model changes |