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