WIE_HALF_YEAR_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_PLANT_CALENDAR_SHIFTS_V where start_date_time between sysdate-90 and sysdate+90