MSC_WTM_CALENDARS_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
CALENDAR_CODE CALENDAR_NAME CALENDAR_TYPE ID SRC_CALENDAR_TYPE SR_INSTANCE_ID CALENDAR_START_DATE CALENDAR_END_DATE REFRESH_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT TO_CHAR(HIERARCHY_ID) CALENDAR_CODE, HIERARCHY_NAME CALENDAR_NAME, TO_CHAR(DECODE(CALENDAR_TYPE, 1, 7, 3, 9, 5, 11)) CALENDAR_TYPE, ID, CALENDAR_TYPE SRC_CALENDAR_TYPE, SR_INSTANCE_ID, CALENDAR_START_DATE, CALENDAR_END_DATE, REFRESH_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM MSC_WTM_CALENDAR_HEADER