1. Tables and Views for SCM
  2. MSC_AP_CALENDAR_EXCEPTIONS_V

MSC_AP_CALENDAR_EXCEPTIONS_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

CALENDAR_CODE

AVL_EXCEPTION_ID

EXCEPTION_START_DATE

EXCEPTION_END_DATE

AVAILABILITY_CODE

WHOLE_DAY_FLAG

Query

SQL_Statement

Select

''||zssae.SCHEDULE_ID CALENDAR_CODE,

zssae.AVL_EXCEPTION_ID,

zsaev.START_DATE_TIME Exception_start_date ,

zsaev.END_DATE_TIME Exception_end_date,

zsaev.AVAILABILITY_CODE,

zsaev.WHOLE_DAY_FLAG

From

ZMM_SR_SCHED_AVL_EXCPS zssae,

ZMM_SR_AVL_EXCEPTIONS_vl zsaev,

MSC_AP_SCHEDULES_V cal

Where zsaev.AVL_EXCEPTION_ID(+) = zssae.AVL_EXCEPTION_ID and

''||zssae.SCHEDULE_ID = cal.calendar_code