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 |