VIEW: APPS.QPR_ADJ_ALLHIER_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 level1_attribute1 <> 'FREIGHT_CHARGE'

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 LEVEL1_ATTRIBUTE1 <> 'FREIGHT_CHARGE'