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