VIEW: APPS.QPR_VLB_ALLHIER_V

Source

View Text - Preformatted

SELECT level1_desc as VLB_DESC, level1_value as VLB_SR_LEVEL_PK, level1_value as VLB_LEVEL_VALUE, level1_attribute1 as VLB_ATTRIBUTE1, level1_attribute2 as VLB_ATTRIBUTE2, level1_attribute3 as VLB_ATTRIBUTE3, level1_attribute4 as VLB_ATTRIBUTE4, level1_attribute5 as VLB_ATTRIBUTE5, instance_id as INSTANCE_ID from qpr_dimension_values WHERE dim_code='VLB' and hierarchy_code = 'VOL_BAND'

View Text - HTML Formatted

SELECT LEVEL1_DESC AS VLB_DESC
, LEVEL1_VALUE AS VLB_SR_LEVEL_PK
, LEVEL1_VALUE AS VLB_LEVEL_VALUE
, LEVEL1_ATTRIBUTE1 AS VLB_ATTRIBUTE1
, LEVEL1_ATTRIBUTE2 AS VLB_ATTRIBUTE2
, LEVEL1_ATTRIBUTE3 AS VLB_ATTRIBUTE3
, LEVEL1_ATTRIBUTE4 AS VLB_ATTRIBUTE4
, LEVEL1_ATTRIBUTE5 AS VLB_ATTRIBUTE5
, INSTANCE_ID AS INSTANCE_ID
FROM QPR_DIMENSION_VALUES
WHERE DIM_CODE='VLB'
AND HIERARCHY_CODE = 'VOL_BAND'