VIEW: APPS.QPR_OAD_ALLHIER_V

Source

View Text - Preformatted

SELECT level5_desc AS all_desc, level5_value AS all_sr_level_pk, level5_attribute1 AS all_attribute1, level5_attribute2 AS all_attribute2, level5_attribute3 AS all_attribute3, level5_attribute4 AS all_attribute4, level5_attribute5 AS all_attribute5, level4_desc AS ogr_desc, level4_value AS ogr_sr_level_pk, level4_attribute1 AS ogr_attribute1, level4_attribute2 AS ogr_attribute2, level4_attribute3 AS ogr_attribute3, level4_attribute4 AS ogr_attribute4, level4_attribute5 AS ogr_attribute5, level3_desc AS otp_desc, level3_value AS otp_sr_level_pk, level3_attribute1 AS otp_attribute1, level3_attribute2 AS otp_attribute2, level3_attribute3 AS otp_attribute3, level3_attribute4 AS otp_attribute4, level3_attribute5 AS otp_attribute5, level2_desc AS otr_desc, level2_value AS otr_sr_level_pk, level2_attribute1 AS otr_attribute1, level2_attribute2 AS otr_attribute2, level2_attribute3 AS otr_attribute3, level2_attribute4 AS otr_attribute4, level2_attribute5 AS otr_attribute5, level1_desc AS oad_desc, level1_value AS oad_sr_level_pk, level1_attribute1 AS oad_attribute1, level1_attribute2 AS oad_attribute2, level1_attribute3 AS oad_attribute3, level1_attribute4 AS oad_attribute4, level1_attribute5 AS oad_attribute5, instance_id AS instance_id FROM qpr_dimension_values WHERE dim_code='OAD' and hierarchy_code = 'OFFINVADJ'

View Text - HTML Formatted

SELECT LEVEL5_DESC AS ALL_DESC
, LEVEL5_VALUE AS ALL_SR_LEVEL_PK
, LEVEL5_ATTRIBUTE1 AS ALL_ATTRIBUTE1
, LEVEL5_ATTRIBUTE2 AS ALL_ATTRIBUTE2
, LEVEL5_ATTRIBUTE3 AS ALL_ATTRIBUTE3
, LEVEL5_ATTRIBUTE4 AS ALL_ATTRIBUTE4
, LEVEL5_ATTRIBUTE5 AS ALL_ATTRIBUTE5
, LEVEL4_DESC AS OGR_DESC
, LEVEL4_VALUE AS OGR_SR_LEVEL_PK
, LEVEL4_ATTRIBUTE1 AS OGR_ATTRIBUTE1
, LEVEL4_ATTRIBUTE2 AS OGR_ATTRIBUTE2
, LEVEL4_ATTRIBUTE3 AS OGR_ATTRIBUTE3
, LEVEL4_ATTRIBUTE4 AS OGR_ATTRIBUTE4
, LEVEL4_ATTRIBUTE5 AS OGR_ATTRIBUTE5
, LEVEL3_DESC AS OTP_DESC
, LEVEL3_VALUE AS OTP_SR_LEVEL_PK
, LEVEL3_ATTRIBUTE1 AS OTP_ATTRIBUTE1
, LEVEL3_ATTRIBUTE2 AS OTP_ATTRIBUTE2
, LEVEL3_ATTRIBUTE3 AS OTP_ATTRIBUTE3
, LEVEL3_ATTRIBUTE4 AS OTP_ATTRIBUTE4
, LEVEL3_ATTRIBUTE5 AS OTP_ATTRIBUTE5
, LEVEL2_DESC AS OTR_DESC
, LEVEL2_VALUE AS OTR_SR_LEVEL_PK
, LEVEL2_ATTRIBUTE1 AS OTR_ATTRIBUTE1
, LEVEL2_ATTRIBUTE2 AS OTR_ATTRIBUTE2
, LEVEL2_ATTRIBUTE3 AS OTR_ATTRIBUTE3
, LEVEL2_ATTRIBUTE4 AS OTR_ATTRIBUTE4
, LEVEL2_ATTRIBUTE5 AS OTR_ATTRIBUTE5
, LEVEL1_DESC AS OAD_DESC
, LEVEL1_VALUE AS OAD_SR_LEVEL_PK
, LEVEL1_ATTRIBUTE1 AS OAD_ATTRIBUTE1
, LEVEL1_ATTRIBUTE2 AS OAD_ATTRIBUTE2
, LEVEL1_ATTRIBUTE3 AS OAD_ATTRIBUTE3
, LEVEL1_ATTRIBUTE4 AS OAD_ATTRIBUTE4
, LEVEL1_ATTRIBUTE5 AS OAD_ATTRIBUTE5
, INSTANCE_ID AS INSTANCE_ID
FROM QPR_DIMENSION_VALUES
WHERE DIM_CODE='OAD'
AND HIERARCHY_CODE = 'OFFINVADJ'