VIEW: APPS.QPR_SC_ALLHIER_L_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' and instance_id = qpr_maintain_aw.get_instance and (qpr_maintain_aw.get_chn is null or level1_value in (select qpm7.attribute_1 from qpr_plan_measures qpm7 where qpm7.price_plan_id=qpr_maintain_aw.get_price_plan_id and qpm7.price_plan_meas_grp_id=7 and qpm7.run_number=qpr_maintain_aw.get_run_number))

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'
AND INSTANCE_ID = QPR_MAINTAIN_AW.GET_INSTANCE
AND (QPR_MAINTAIN_AW.GET_CHN IS NULL OR LEVEL1_VALUE IN (SELECT QPM7.ATTRIBUTE_1
FROM QPR_PLAN_MEASURES QPM7
WHERE QPM7.PRICE_PLAN_ID=QPR_MAINTAIN_AW.GET_PRICE_PLAN_ID
AND QPM7.PRICE_PLAN_MEAS_GRP_ID=7
AND QPM7.RUN_NUMBER=QPR_MAINTAIN_AW.GET_RUN_NUMBER))