VIEW: APPS.QPR_ADJ_ALLHIER_L_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 AG1_DESC, level3_value as AG1_SR_LEVEL_PK, level3_attribute1 as AG1_ATTRIBUTE1, level3_attribute2 as AG1_ATTRIBUTE2, level3_attribute3 as AG1_ATTRIBUTE3, level3_attribute4 as AG1_ATTRIBUTE4, level3_attribute5 as AG1_ATTRIBUTE5, level2_desc as AT_DESC, level2_value as AT_SR_LEVEL_PK, level2_attribute1 as AT_ATTRIBUTE1, level2_attribute2 as AT_ATTRIBUTE2, level2_attribute3 as AT_ATTRIBUTE3, level2_attribute4 as AT_ATTRIBUTE4, level2_attribute5 as AT_ATTRIBUTE5, level1_desc as ADJ_DESC, level1_value as ADJ_SR_LEVEL_PK, level1_attribute1 as ADJ_ATTRIBUTE1, level1_attribute2 as ADJ_ATTRIBUTE2, level1_attribute3 as ADJ_ATTRIBUTE3, level1_attribute4 as ADJ_ATTRIBUTE4, level1_attribute5 as ADJ_ATTRIBUTE5, instance_id as INSTANCE_ID from qpr_dimension_values WHERE dim_code='ADJ' and hierarchy_code = 'ADJUSTMENT' and instance_id=qpr_maintain_aw.get_instance and level1_attribute1 <> 'FREIGHT_CHARGE' and (qpr_maintain_aw.get_adj is null or level1_value in ( select qpm0.attribute_1 from qpr_plan_measures qpm0 where qpm0.price_plan_id=qpr_maintain_aw.get_price_plan_id and qpm0.price_plan_meas_grp_id=0 and qpm0.run_number=qpr_maintain_aw.get_run_number))

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 AG1_DESC
, LEVEL3_VALUE AS AG1_SR_LEVEL_PK
, LEVEL3_ATTRIBUTE1 AS AG1_ATTRIBUTE1
, LEVEL3_ATTRIBUTE2 AS AG1_ATTRIBUTE2
, LEVEL3_ATTRIBUTE3 AS AG1_ATTRIBUTE3
, LEVEL3_ATTRIBUTE4 AS AG1_ATTRIBUTE4
, LEVEL3_ATTRIBUTE5 AS AG1_ATTRIBUTE5
, LEVEL2_DESC AS AT_DESC
, LEVEL2_VALUE AS AT_SR_LEVEL_PK
, LEVEL2_ATTRIBUTE1 AS AT_ATTRIBUTE1
, LEVEL2_ATTRIBUTE2 AS AT_ATTRIBUTE2
, LEVEL2_ATTRIBUTE3 AS AT_ATTRIBUTE3
, LEVEL2_ATTRIBUTE4 AS AT_ATTRIBUTE4
, LEVEL2_ATTRIBUTE5 AS AT_ATTRIBUTE5
, LEVEL1_DESC AS ADJ_DESC
, LEVEL1_VALUE AS ADJ_SR_LEVEL_PK
, LEVEL1_ATTRIBUTE1 AS ADJ_ATTRIBUTE1
, LEVEL1_ATTRIBUTE2 AS ADJ_ATTRIBUTE2
, LEVEL1_ATTRIBUTE3 AS ADJ_ATTRIBUTE3
, LEVEL1_ATTRIBUTE4 AS ADJ_ATTRIBUTE4
, LEVEL1_ATTRIBUTE5 AS ADJ_ATTRIBUTE5
, INSTANCE_ID AS INSTANCE_ID
FROM QPR_DIMENSION_VALUES
WHERE DIM_CODE='ADJ'
AND HIERARCHY_CODE = 'ADJUSTMENT'
AND INSTANCE_ID=QPR_MAINTAIN_AW.GET_INSTANCE
AND LEVEL1_ATTRIBUTE1 <> 'FREIGHT_CHARGE'
AND (QPR_MAINTAIN_AW.GET_ADJ IS NULL OR LEVEL1_VALUE IN ( SELECT QPM0.ATTRIBUTE_1
FROM QPR_PLAN_MEASURES QPM0
WHERE QPM0.PRICE_PLAN_ID=QPR_MAINTAIN_AW.GET_PRICE_PLAN_ID
AND QPM0.PRICE_PLAN_MEAS_GRP_ID=0
AND QPM0.RUN_NUMBER=QPR_MAINTAIN_AW.GET_RUN_NUMBER))