1. Tables and Views for SCM
  2. MSC_CALENDAR_EXCEPTIONSRC_V

MSC_CALENDAR_EXCEPTIONSRC_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

CALENDAR_CODE

AVL_EXCEPTION_ID

EXCEPTION_START_DATE

EXCEPTION_END_DATE

EXCEPTION_TYPE

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

REFRESH_NUMBER

Query

SQL_Statement

select "CALENDAR_CODE","AVL_EXCEPTION_ID","EXCEPTION_START_DATE","EXCEPTION_END_DATE","EXCEPTION_TYPE","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","REFRESH_NUMBER" from msc_calendar_exceptions as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))