MSC_AP_CALENDAR_DATES_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
CALENDAR_CODE CALENDAR_DATE SEQ_NUM NEXT_SEQ_NUM PRIOR_SEQ_NUM NEXT_DATE PRIOR_DATE CALENDAR_START_DATE CALENDAR_END_DATE ROW_ID

Query

SQL_Statement

select zsad.SCHEDULE_ID CALENDAR_CODE, zsad.CALENDAR_DATE, zsad.SEQ_NUM, zsad.NEXT_SEQ_NUM, zsad.PRIOR_SEQ_NUM, zsad.NEXT_DATE, zsad.PRIOR_DATE, cal.calendar_start_date, cal.calendar_end_date, zsad.rowid row_id FROM ZMM_SR_AVAILABLE_DATES zsad, MSC_AP_SCHEDULES_V cal where zsad.SCHEDULE_ID = cal.CALENDAR_CODE AND calendar_code NOT IN ( SELECT calendar_code FROM MSC_AP_CALENDAR_SHIFTS_TIME_V WHERE to_time > 86400000 )