VIEW: APPS.QPR_SC_ALLHIER_V

Source

View Text - Preformatted

SELECT level2_desc as ALL_DESC, level2_value as ALL_SR_LEVEL_PK, level2_attribute1 as ALL_ATTRIBUTE1, level2_attribute2 as ALL_ATTRIBUTE2, level2_attribute3 as ALL_ATTRIBUTE3, level2_attribute4 as ALL_ATTRIBUTE4, level2_attribute5 as ALL_ATTRIBUTE5, level1_desc as CHN_DESC, level1_value as CHN_SR_LEVEL_PK, level1_attribute1 as CHN_ATTRIBUTE1, level1_attribute2 as CHN_ATTRIBUTE2, level1_attribute3 as CHN_ATTRIBUTE3, level1_attribute4 as CHN_ATTRIBUTE4, level1_attribute5 as CHN_ATTRIBUTE5, instance_id as INSTANCE_ID from qpr_dimension_values WHERE dim_code='CHN' and hierarchy_code = 'SALESCHANNEL'

View Text - HTML Formatted

SELECT LEVEL2_DESC AS ALL_DESC
, LEVEL2_VALUE AS ALL_SR_LEVEL_PK
, LEVEL2_ATTRIBUTE1 AS ALL_ATTRIBUTE1
, LEVEL2_ATTRIBUTE2 AS ALL_ATTRIBUTE2
, LEVEL2_ATTRIBUTE3 AS ALL_ATTRIBUTE3
, LEVEL2_ATTRIBUTE4 AS ALL_ATTRIBUTE4
, LEVEL2_ATTRIBUTE5 AS ALL_ATTRIBUTE5
, LEVEL1_DESC AS CHN_DESC
, LEVEL1_VALUE AS CHN_SR_LEVEL_PK
, LEVEL1_ATTRIBUTE1 AS CHN_ATTRIBUTE1
, LEVEL1_ATTRIBUTE2 AS CHN_ATTRIBUTE2
, LEVEL1_ATTRIBUTE3 AS CHN_ATTRIBUTE3
, LEVEL1_ATTRIBUTE4 AS CHN_ATTRIBUTE4
, LEVEL1_ATTRIBUTE5 AS CHN_ATTRIBUTE5
, INSTANCE_ID AS INSTANCE_ID
FROM QPR_DIMENSION_VALUES
WHERE DIM_CODE='CHN'
AND HIERARCHY_CODE = 'SALESCHANNEL'