VIEW: APPS.QPR_PSG_ALLHIER_L_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' AND instance_id = qpr_maintain_aw.get_instance AND(qpr_maintain_aw.get_psg IS NULL OR level1_value IN (SELECT qpm2.attribute_1 FROM qpr_plan_measures qpm2 WHERE qpm2.price_plan_id = qpr_maintain_aw.get_price_plan_id AND qpm2.price_plan_meas_grp_id = 8 AND qpm2.run_number = qpr_maintain_aw.get_run_number)) 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 , qpr_maintain_aw.get_instance AS instance_id 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'
AND INSTANCE_ID = QPR_MAINTAIN_AW.GET_INSTANCE AND(QPR_MAINTAIN_AW.GET_PSG IS NULL OR LEVEL1_VALUE IN (SELECT QPM2.ATTRIBUTE_1
FROM QPR_PLAN_MEASURES QPM2
WHERE QPM2.PRICE_PLAN_ID = QPR_MAINTAIN_AW.GET_PRICE_PLAN_ID
AND QPM2.PRICE_PLAN_MEAS_GRP_ID = 8
AND QPM2.RUN_NUMBER = QPR_MAINTAIN_AW.GET_RUN_NUMBER)) 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
, QPR_MAINTAIN_AW.GET_INSTANCE AS INSTANCE_ID
FROM DUAL