VIEW: QPR.QPR_DIM_SOURCES#

Source

View Text - Preformatted

select DIM_SOURCE_ID DIM_SOURCE_ID, INSTANCE_ID INSTANCE_ID, INSTANCE_TYPE INSTANCE_TYPE, DIM_CODE DIM_CODE, HIER_CODE HIER_CODE, SEEDED_FLAG SEEDED_FLAG, VIEW_NAME VIEW_NAME, LEVEL_NUMBER LEVEL_NUMBER, DESC_COLUMN DESC_COLUMN, VALUE_COLUMN VALUE_COLUMN, ATTR_NUMBER ATTR_NUMBER, ATTR_COLUMN ATTR_COLUMN, USER_VIEW_NAME USER_VIEW_NAME, USER_LEVEL_NUMBER USER_LEVEL_NUMBER, USER_DESC_COLUMN USER_DESC_COLUMN, USER_VALUE_COLUMN USER_VALUE_COLUMN, USER_ATTR_NUMBER USER_ATTR_NUMBER, USER_ATTR_COLUMN USER_ATTR_COLUMN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, 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_DIM_SOURCES"

View Text - HTML Formatted

SELECT DIM_SOURCE_ID DIM_SOURCE_ID
, INSTANCE_ID INSTANCE_ID
, INSTANCE_TYPE INSTANCE_TYPE
, DIM_CODE DIM_CODE
, HIER_CODE HIER_CODE
, SEEDED_FLAG SEEDED_FLAG
, VIEW_NAME VIEW_NAME
, LEVEL_NUMBER LEVEL_NUMBER
, DESC_COLUMN DESC_COLUMN
, VALUE_COLUMN VALUE_COLUMN
, ATTR_NUMBER ATTR_NUMBER
, ATTR_COLUMN ATTR_COLUMN
, USER_VIEW_NAME USER_VIEW_NAME
, USER_LEVEL_NUMBER USER_LEVEL_NUMBER
, USER_DESC_COLUMN USER_DESC_COLUMN
, USER_VALUE_COLUMN USER_VALUE_COLUMN
, USER_ATTR_NUMBER USER_ATTR_NUMBER
, USER_ATTR_COLUMN USER_ATTR_COLUMN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, 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_DIM_SOURCES"