VIEW: APPS.QPR_ORG_ALLHIER_V

Source

View Text - Preformatted

SELECT level4_desc as ALL_DESC, level4_value as ALL_SR_LEVEL_PK, level4_attribute1 as ALL_ATTRIBUTE1, level4_attribute2 as ALL_ATTRIBUTE2, level4_attribute3 as ALL_ATTRIBUTE3, level4_attribute4 as ALL_ATTRIBUTE4, level4_attribute5 as ALL_ATTRIBUTE5, level3_desc as BG_DESC, level3_value as BG_SR_LEVEL_PK, level3_attribute1 as BG_ATTRIBUTE1, level3_attribute2 as BG_ATTRIBUTE2, level3_attribute3 as BG_ATTRIBUTE3, level3_attribute4 as BG_ATTRIBUTE4, level3_attribute5 as BG_ATTRIBUTE5, level2_desc as LE_DESC, level2_value as LE_SR_LEVEL_PK, level2_attribute1 as LE_ATTRIBUTE1, level2_attribute2 as LE_ATTRIBUTE2, level2_attribute3 as LE_ATTRIBUTE3, level2_attribute4 as LE_ATTRIBUTE4, level2_attribute5 as LE_ATTRIBUTE5, level1_desc as OU_DESC, level1_value as OU_SR_LEVEL_PK, level1_attribute1 as OU_ATTRIBUTE1, level1_attribute2 as OU_ATTRIBUTE2, level1_attribute3 as OU_ATTRIBUTE3, level1_attribute4 as OU_ATTRIBUTE4, level1_attribute5 as OU_ATTRIBUTE5, instance_id as INSTANCE_ID from qpr_dimension_values WHERE dim_code='ORG' and hierarchy_code = 'ORGANIZATION'

View Text - HTML Formatted

SELECT LEVEL4_DESC AS ALL_DESC
, LEVEL4_VALUE AS ALL_SR_LEVEL_PK
, LEVEL4_ATTRIBUTE1 AS ALL_ATTRIBUTE1
, LEVEL4_ATTRIBUTE2 AS ALL_ATTRIBUTE2
, LEVEL4_ATTRIBUTE3 AS ALL_ATTRIBUTE3
, LEVEL4_ATTRIBUTE4 AS ALL_ATTRIBUTE4
, LEVEL4_ATTRIBUTE5 AS ALL_ATTRIBUTE5
, LEVEL3_DESC AS BG_DESC
, LEVEL3_VALUE AS BG_SR_LEVEL_PK
, LEVEL3_ATTRIBUTE1 AS BG_ATTRIBUTE1
, LEVEL3_ATTRIBUTE2 AS BG_ATTRIBUTE2
, LEVEL3_ATTRIBUTE3 AS BG_ATTRIBUTE3
, LEVEL3_ATTRIBUTE4 AS BG_ATTRIBUTE4
, LEVEL3_ATTRIBUTE5 AS BG_ATTRIBUTE5
, LEVEL2_DESC AS LE_DESC
, LEVEL2_VALUE AS LE_SR_LEVEL_PK
, LEVEL2_ATTRIBUTE1 AS LE_ATTRIBUTE1
, LEVEL2_ATTRIBUTE2 AS LE_ATTRIBUTE2
, LEVEL2_ATTRIBUTE3 AS LE_ATTRIBUTE3
, LEVEL2_ATTRIBUTE4 AS LE_ATTRIBUTE4
, LEVEL2_ATTRIBUTE5 AS LE_ATTRIBUTE5
, LEVEL1_DESC AS OU_DESC
, LEVEL1_VALUE AS OU_SR_LEVEL_PK
, LEVEL1_ATTRIBUTE1 AS OU_ATTRIBUTE1
, LEVEL1_ATTRIBUTE2 AS OU_ATTRIBUTE2
, LEVEL1_ATTRIBUTE3 AS OU_ATTRIBUTE3
, LEVEL1_ATTRIBUTE4 AS OU_ATTRIBUTE4
, LEVEL1_ATTRIBUTE5 AS OU_ATTRIBUTE5
, INSTANCE_ID AS INSTANCE_ID
FROM QPR_DIMENSION_VALUES
WHERE DIM_CODE='ORG'
AND HIERARCHY_CODE = 'ORGANIZATION'