VIEW: APPS.QPR_PSG_ALLHIER_V

Source

View Text - Preformatted

SELECT level1_desc AS psg_desc, level1_value AS psg_sr_level_pk, level1_attribute1 AS psg_attribute1, level1_attribute2 AS psg_attribute2, level1_attribute3 AS psg_attribute3, level1_attribute4 AS psg_attribute4, level1_attribute5 AS psg_attribute5, level2_desc, level2_value, level2_attribute1 , level2_attribute2 , level2_attribute3, level2_attribute4 , level2_attribute5 , instance_id AS instance_id FROM qpr_dimension_values WHERE dim_code = 'PSG' AND hierarchy_code = 'PR_SEGMENT' union all SELECT qpr_sr_util.get_null_desc AS psg_desc, to_char(qpr_sr_util.get_null_pk) AS psg_sr_level_pk, null AS psg_attribute1, null AS psg_attribute2, null AS psg_attribute3, null AS psg_attribute4, null AS psg_attribute5, qpr_sr_util.get_all_psg_desc level2_desc, to_char(qpr_sr_util.get_all_psg_pk) level2_value, null , null , null, null , null , null FROM dual

View Text - HTML Formatted

SELECT LEVEL1_DESC AS PSG_DESC
, LEVEL1_VALUE AS PSG_SR_LEVEL_PK
, LEVEL1_ATTRIBUTE1 AS PSG_ATTRIBUTE1
, LEVEL1_ATTRIBUTE2 AS PSG_ATTRIBUTE2
, LEVEL1_ATTRIBUTE3 AS PSG_ATTRIBUTE3
, LEVEL1_ATTRIBUTE4 AS PSG_ATTRIBUTE4
, LEVEL1_ATTRIBUTE5 AS PSG_ATTRIBUTE5
, LEVEL2_DESC
, LEVEL2_VALUE
, LEVEL2_ATTRIBUTE1
, LEVEL2_ATTRIBUTE2
, LEVEL2_ATTRIBUTE3
, LEVEL2_ATTRIBUTE4
, LEVEL2_ATTRIBUTE5
, INSTANCE_ID AS INSTANCE_ID
FROM QPR_DIMENSION_VALUES
WHERE DIM_CODE = 'PSG'
AND HIERARCHY_CODE = 'PR_SEGMENT' UNION ALL SELECT QPR_SR_UTIL.GET_NULL_DESC AS PSG_DESC
, TO_CHAR(QPR_SR_UTIL.GET_NULL_PK) AS PSG_SR_LEVEL_PK
, NULL AS PSG_ATTRIBUTE1
, NULL AS PSG_ATTRIBUTE2
, NULL AS PSG_ATTRIBUTE3
, NULL AS PSG_ATTRIBUTE4
, NULL AS PSG_ATTRIBUTE5
, QPR_SR_UTIL.GET_ALL_PSG_DESC LEVEL2_DESC
, TO_CHAR(QPR_SR_UTIL.GET_ALL_PSG_PK) LEVEL2_VALUE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM DUAL