MSC_CALENDARSRC

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
CALENDAR_CODE DESCRIPTION DAYS_ON DAYS_OFF CALENDAR_START_DATE CALENDAR_END_DATE QUARTERLY_CALENDAR_TYPE PATTERN_STRING SR_INSTANCE_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OVERWRITE_FLAG WEEK_START_DAY FIRST_WORKING_DATE LAST_WORKING_DATE REFRESH_NUMBER DELETED_FLAG

Name

CALENDAR_CODE

DESCRIPTION

DAYS_ON

DAYS_OFF

CALENDAR_START_DATE

CALENDAR_END_DATE

QUARTERLY_CALENDAR_TYPE

PATTERN_STRING

SR_INSTANCE_ID

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

OVERWRITE_FLAG

WEEK_START_DAY

FIRST_WORKING_DATE

LAST_WORKING_DATE

REFRESH_NUMBER

DELETED_FLAG

Query

SQL_Statement
select "CALENDAR_CODE","DESCRIPTION","DAYS_ON","DAYS_OFF","CALENDAR_START_DATE","CALENDAR_END_DATE","QUARTERLY_CALENDAR_TYPE","PATTERN_STRING","SR_INSTANCE_ID","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","OVERWRITE_FLAG","WEEK_START_DAY","FIRST_WORKING_DATE","LAST_WORKING_DATE","REFRESH_NUMBER","DELETED_FLAG" from msc_calendars as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))

SQL_Statement

select "CALENDAR_CODE","DESCRIPTION","DAYS_ON","DAYS_OFF","CALENDAR_START_DATE","CALENDAR_END_DATE","QUARTERLY_CALENDAR_TYPE","PATTERN_STRING","SR_INSTANCE_ID","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","OVERWRITE_FLAG","WEEK_START_DAY","FIRST_WORKING_DATE","LAST_WORKING_DATE","REFRESH_NUMBER","DELETED_FLAG" from msc_calendars as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))