WIE_OVERRIDE_CALENDAR_SHIFTS_V
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: VIEW
Columns
Name |
---|
ORGANIZATION_ID SCHEDULE_ID SHIFT_ID SCHEDULE_DETAIL_ID START_DATE_TIME END_DATE_TIME |
Query
SQL_Statement |
---|
SELECT wc.organization_id organization_id, sd.schedule_id schedule_id, sd.shift_id shift_id, sd.schedule_detail_id schedule_detail_id, sd.start_date_time start_date_time, sd.end_date_time end_date_time FROM zmm_sr_schedule_dtls sd, wis_wc_prod_calendars pd, wis_work_centers_b wc WHERE pd.mfg_calendar_id = sd.schedule_id AND wc.work_center_id = pd.work_center_id AND shift_id IS NOT NULL ORDER BY wc.organization_id, sd.schedule_id, sd.shift_id, sd.schedule_detail_id |