VIEW: APPS.QPR_MGB_ALLHIER_V

Source

View Text - Preformatted

SELECT level1_desc as MGB_DESC, level1_value as MGB_SR_LEVEL_PK, level1_value as MGB_LEVEL_VALUE, level1_attribute1 as MGB_ATTRIBUTE1, level1_attribute2 as MGB_ATTRIBUTE2, level1_attribute3 as MGB_ATTRIBUTE3, level1_attribute4 as MGB_ATTRIBUTE4, level1_attribute5 as MGB_ATTRIBUTE5, instance_id as INSTANCE_ID from qpr_dimension_values WHERE dim_code='MGB' and hierarchy_code = 'MRGBAND'

View Text - HTML Formatted

SELECT LEVEL1_DESC AS MGB_DESC
, LEVEL1_VALUE AS MGB_SR_LEVEL_PK
, LEVEL1_VALUE AS MGB_LEVEL_VALUE
, LEVEL1_ATTRIBUTE1 AS MGB_ATTRIBUTE1
, LEVEL1_ATTRIBUTE2 AS MGB_ATTRIBUTE2
, LEVEL1_ATTRIBUTE3 AS MGB_ATTRIBUTE3
, LEVEL1_ATTRIBUTE4 AS MGB_ATTRIBUTE4
, LEVEL1_ATTRIBUTE5 AS MGB_ATTRIBUTE5
, INSTANCE_ID AS INSTANCE_ID
FROM QPR_DIMENSION_VALUES
WHERE DIM_CODE='MGB'
AND HIERARCHY_CODE = 'MRGBAND'