VIEW: QPR.QPR_DIMENSION_VALUES#

Source

View Text - Preformatted

select DIM_VALUE_ID DIM_VALUE_ID, INSTANCE_ID INSTANCE_ID, DIM_CODE DIM_CODE, HIERARCHY_CODE HIERARCHY_CODE, LEVEL1_VALUE LEVEL1_VALUE, LEVEL1_DESC LEVEL1_DESC, LEVEL1_ATTRIBUTE1 LEVEL1_ATTRIBUTE1, LEVEL1_ATTRIBUTE2 LEVEL1_ATTRIBUTE2, LEVEL1_ATTRIBUTE3 LEVEL1_ATTRIBUTE3, LEVEL1_ATTRIBUTE4 LEVEL1_ATTRIBUTE4, LEVEL1_ATTRIBUTE5 LEVEL1_ATTRIBUTE5, LEVEL2_VALUE LEVEL2_VALUE, LEVEL2_DESC LEVEL2_DESC, LEVEL2_ATTRIBUTE1 LEVEL2_ATTRIBUTE1, LEVEL2_ATTRIBUTE2 LEVEL2_ATTRIBUTE2, LEVEL2_ATTRIBUTE3 LEVEL2_ATTRIBUTE3, LEVEL2_ATTRIBUTE4 LEVEL2_ATTRIBUTE4, LEVEL2_ATTRIBUTE5 LEVEL2_ATTRIBUTE5, LEVEL3_VALUE LEVEL3_VALUE, LEVEL3_DESC LEVEL3_DESC, LEVEL3_ATTRIBUTE1 LEVEL3_ATTRIBUTE1, LEVEL3_ATTRIBUTE2 LEVEL3_ATTRIBUTE2, LEVEL3_ATTRIBUTE3 LEVEL3_ATTRIBUTE3, LEVEL3_ATTRIBUTE4 LEVEL3_ATTRIBUTE4, LEVEL3_ATTRIBUTE5 LEVEL3_ATTRIBUTE5, LEVEL4_VALUE LEVEL4_VALUE, LEVEL4_DESC LEVEL4_DESC, LEVEL4_ATTRIBUTE1 LEVEL4_ATTRIBUTE1, LEVEL4_ATTRIBUTE2 LEVEL4_ATTRIBUTE2, LEVEL4_ATTRIBUTE3 LEVEL4_ATTRIBUTE3, LEVEL4_ATTRIBUTE4 LEVEL4_ATTRIBUTE4, LEVEL4_ATTRIBUTE5 LEVEL4_ATTRIBUTE5, LEVEL5_VALUE LEVEL5_VALUE, LEVEL5_DESC LEVEL5_DESC, LEVEL5_ATTRIBUTE1 LEVEL5_ATTRIBUTE1, LEVEL5_ATTRIBUTE2 LEVEL5_ATTRIBUTE2, LEVEL5_ATTRIBUTE3 LEVEL5_ATTRIBUTE3, LEVEL5_ATTRIBUTE4 LEVEL5_ATTRIBUTE4, LEVEL5_ATTRIBUTE5 LEVEL5_ATTRIBUTE5, LEVEL6_VALUE LEVEL6_VALUE, LEVEL6_DESC LEVEL6_DESC, LEVEL6_ATTRIBUTE1 LEVEL6_ATTRIBUTE1, LEVEL6_ATTRIBUTE2 LEVEL6_ATTRIBUTE2, LEVEL6_ATTRIBUTE3 LEVEL6_ATTRIBUTE3, LEVEL6_ATTRIBUTE4 LEVEL6_ATTRIBUTE4, LEVEL6_ATTRIBUTE5 LEVEL6_ATTRIBUTE5, LEVEL7_VALUE LEVEL7_VALUE, LEVEL7_DESC LEVEL7_DESC, LEVEL7_ATTRIBUTE1 LEVEL7_ATTRIBUTE1, LEVEL7_ATTRIBUTE2 LEVEL7_ATTRIBUTE2, LEVEL7_ATTRIBUTE3 LEVEL7_ATTRIBUTE3, LEVEL7_ATTRIBUTE4 LEVEL7_ATTRIBUTE4, LEVEL7_ATTRIBUTE5 LEVEL7_ATTRIBUTE5, LEVEL8_VALUE LEVEL8_VALUE, LEVEL8_DESC LEVEL8_DESC, LEVEL8_ATTRIBUTE1 LEVEL8_ATTRIBUTE1, LEVEL8_ATTRIBUTE2 LEVEL8_ATTRIBUTE2, LEVEL8_ATTRIBUTE3 LEVEL8_ATTRIBUTE3, LEVEL8_ATTRIBUTE4 LEVEL8_ATTRIBUTE4, LEVEL8_ATTRIBUTE5 LEVEL8_ATTRIBUTE5, CHECK_DATE CHECK_DATE, 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_DIMENSION_VALUES"

View Text - HTML Formatted

SELECT DIM_VALUE_ID DIM_VALUE_ID
, INSTANCE_ID INSTANCE_ID
, DIM_CODE DIM_CODE
, HIERARCHY_CODE HIERARCHY_CODE
, LEVEL1_VALUE LEVEL1_VALUE
, LEVEL1_DESC LEVEL1_DESC
, LEVEL1_ATTRIBUTE1 LEVEL1_ATTRIBUTE1
, LEVEL1_ATTRIBUTE2 LEVEL1_ATTRIBUTE2
, LEVEL1_ATTRIBUTE3 LEVEL1_ATTRIBUTE3
, LEVEL1_ATTRIBUTE4 LEVEL1_ATTRIBUTE4
, LEVEL1_ATTRIBUTE5 LEVEL1_ATTRIBUTE5
, LEVEL2_VALUE LEVEL2_VALUE
, LEVEL2_DESC LEVEL2_DESC
, LEVEL2_ATTRIBUTE1 LEVEL2_ATTRIBUTE1
, LEVEL2_ATTRIBUTE2 LEVEL2_ATTRIBUTE2
, LEVEL2_ATTRIBUTE3 LEVEL2_ATTRIBUTE3
, LEVEL2_ATTRIBUTE4 LEVEL2_ATTRIBUTE4
, LEVEL2_ATTRIBUTE5 LEVEL2_ATTRIBUTE5
, LEVEL3_VALUE LEVEL3_VALUE
, LEVEL3_DESC LEVEL3_DESC
, LEVEL3_ATTRIBUTE1 LEVEL3_ATTRIBUTE1
, LEVEL3_ATTRIBUTE2 LEVEL3_ATTRIBUTE2
, LEVEL3_ATTRIBUTE3 LEVEL3_ATTRIBUTE3
, LEVEL3_ATTRIBUTE4 LEVEL3_ATTRIBUTE4
, LEVEL3_ATTRIBUTE5 LEVEL3_ATTRIBUTE5
, LEVEL4_VALUE LEVEL4_VALUE
, LEVEL4_DESC LEVEL4_DESC
, LEVEL4_ATTRIBUTE1 LEVEL4_ATTRIBUTE1
, LEVEL4_ATTRIBUTE2 LEVEL4_ATTRIBUTE2
, LEVEL4_ATTRIBUTE3 LEVEL4_ATTRIBUTE3
, LEVEL4_ATTRIBUTE4 LEVEL4_ATTRIBUTE4
, LEVEL4_ATTRIBUTE5 LEVEL4_ATTRIBUTE5
, LEVEL5_VALUE LEVEL5_VALUE
, LEVEL5_DESC LEVEL5_DESC
, LEVEL5_ATTRIBUTE1 LEVEL5_ATTRIBUTE1
, LEVEL5_ATTRIBUTE2 LEVEL5_ATTRIBUTE2
, LEVEL5_ATTRIBUTE3 LEVEL5_ATTRIBUTE3
, LEVEL5_ATTRIBUTE4 LEVEL5_ATTRIBUTE4
, LEVEL5_ATTRIBUTE5 LEVEL5_ATTRIBUTE5
, LEVEL6_VALUE LEVEL6_VALUE
, LEVEL6_DESC LEVEL6_DESC
, LEVEL6_ATTRIBUTE1 LEVEL6_ATTRIBUTE1
, LEVEL6_ATTRIBUTE2 LEVEL6_ATTRIBUTE2
, LEVEL6_ATTRIBUTE3 LEVEL6_ATTRIBUTE3
, LEVEL6_ATTRIBUTE4 LEVEL6_ATTRIBUTE4
, LEVEL6_ATTRIBUTE5 LEVEL6_ATTRIBUTE5
, LEVEL7_VALUE LEVEL7_VALUE
, LEVEL7_DESC LEVEL7_DESC
, LEVEL7_ATTRIBUTE1 LEVEL7_ATTRIBUTE1
, LEVEL7_ATTRIBUTE2 LEVEL7_ATTRIBUTE2
, LEVEL7_ATTRIBUTE3 LEVEL7_ATTRIBUTE3
, LEVEL7_ATTRIBUTE4 LEVEL7_ATTRIBUTE4
, LEVEL7_ATTRIBUTE5 LEVEL7_ATTRIBUTE5
, LEVEL8_VALUE LEVEL8_VALUE
, LEVEL8_DESC LEVEL8_DESC
, LEVEL8_ATTRIBUTE1 LEVEL8_ATTRIBUTE1
, LEVEL8_ATTRIBUTE2 LEVEL8_ATTRIBUTE2
, LEVEL8_ATTRIBUTE3 LEVEL8_ATTRIBUTE3
, LEVEL8_ATTRIBUTE4 LEVEL8_ATTRIBUTE4
, LEVEL8_ATTRIBUTE5 LEVEL8_ATTRIBUTE5
, CHECK_DATE CHECK_DATE
, 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_DIMENSION_VALUES"