VIEW: QPR.QPR_TIME#

Source

View Text - Preformatted

select TIME_ID TIME_ID, INSTANCE_ID INSTANCE_ID, CALENDAR_TYPE CALENDAR_TYPE, CALENDAR_CODE CALENDAR_CODE, YEAR YEAR, YEAR_DESCRIPTION YEAR_DESCRIPTION, YEAR_START_DATE YEAR_START_DATE, YEAR_END_DATE YEAR_END_DATE, QUARTER QUARTER, QUARTER_DESCRIPTION QUARTER_DESCRIPTION, QUARTER_START_DATE QUARTER_START_DATE, QUARTER_END_DATE QUARTER_END_DATE, MONTH MONTH, MONTH_DESCRIPTION MONTH_DESCRIPTION, MONTH_START_DATE MONTH_START_DATE, MONTH_END_DATE MONTH_END_DATE, WEEK WEEK, WEEK_DESCRIPTION WEEK_DESCRIPTION, WEEK_START_DATE WEEK_START_DATE, WEEK_END_DATE WEEK_END_DATE, DAY DAY, DAY_DESCRIPTION DAY_DESCRIPTION, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID from "QPR"."QPR_TIME"

View Text - HTML Formatted

SELECT TIME_ID TIME_ID
, INSTANCE_ID INSTANCE_ID
, CALENDAR_TYPE CALENDAR_TYPE
, CALENDAR_CODE CALENDAR_CODE
, YEAR YEAR
, YEAR_DESCRIPTION YEAR_DESCRIPTION
, YEAR_START_DATE YEAR_START_DATE
, YEAR_END_DATE YEAR_END_DATE
, QUARTER QUARTER
, QUARTER_DESCRIPTION QUARTER_DESCRIPTION
, QUARTER_START_DATE QUARTER_START_DATE
, QUARTER_END_DATE QUARTER_END_DATE
, MONTH MONTH
, MONTH_DESCRIPTION MONTH_DESCRIPTION
, MONTH_START_DATE MONTH_START_DATE
, MONTH_END_DATE MONTH_END_DATE
, WEEK WEEK
, WEEK_DESCRIPTION WEEK_DESCRIPTION
, WEEK_START_DATE WEEK_START_DATE
, WEEK_END_DATE WEEK_END_DATE
, DAY DAY
, DAY_DESCRIPTION DAY_DESCRIPTION
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
FROM "QPR"."QPR_TIME"