VIEW: MSC.MSC_ST_CALENDARS#

Source

View Text - Preformatted

select CALENDAR_CODE CALENDAR_CODE, DESCRIPTION DESCRIPTION, DAYS_ON DAYS_ON, DAYS_OFF DAYS_OFF, CALENDAR_START_DATE CALENDAR_START_DATE, CALENDAR_END_DATE CALENDAR_END_DATE, QUARTERLY_CALENDAR_TYPE QUARTERLY_CALENDAR_TYPE, SR_INSTANCE_CODE SR_INSTANCE_CODE, SR_INSTANCE_ID SR_INSTANCE_ID, DELETED_FLAG DELETED_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REFRESH_ID REFRESH_ID, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, ERROR_TEXT ERROR_TEXT, OVERWRITE_FLAG OVERWRITE_FLAG, WEEK_START_DAY WEEK_START_DAY, COMPANY_NAME COMPANY_NAME, COMPANY_ID COMPANY_ID from "MSC"."MSC_ST_CALENDARS"

View Text - HTML Formatted

SELECT CALENDAR_CODE CALENDAR_CODE
, DESCRIPTION DESCRIPTION
, DAYS_ON DAYS_ON
, DAYS_OFF DAYS_OFF
, CALENDAR_START_DATE CALENDAR_START_DATE
, CALENDAR_END_DATE CALENDAR_END_DATE
, QUARTERLY_CALENDAR_TYPE QUARTERLY_CALENDAR_TYPE
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, SR_INSTANCE_ID SR_INSTANCE_ID
, DELETED_FLAG DELETED_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REFRESH_ID REFRESH_ID
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, ERROR_TEXT ERROR_TEXT
, OVERWRITE_FLAG OVERWRITE_FLAG
, WEEK_START_DAY WEEK_START_DAY
, COMPANY_NAME COMPANY_NAME
, COMPANY_ID COMPANY_ID
FROM "MSC"."MSC_ST_CALENDARS"