WIE_HALF_YEAR_OVR_CAL_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 organization_id, schedule_id, shift_id, schedule_detail_id, start_date_time, end_date_time FROM wie_override_calendar_shifts_v WHERE start_date_time BETWEEN sysdate - 90 AND sysdate + 90