IN_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 |