VIEW: APPS.QPR_COS_ALLHIER_L_V

Source

View Text - Preformatted

SELECT level3_desc as ALL_DESC, level3_value as ALL_SR_LEVEL_PK, level3_attribute1 as ALL_ATTRIBUTE1, level3_attribute2 as ALL_ATTRIBUTE2, level3_attribute3 as ALL_ATTRIBUTE3, level3_attribute4 as ALL_ATTRIBUTE4, level3_attribute5 as ALL_ATTRIBUTE5, level2_desc as CTP_DESC, level2_value as CTP_SR_LEVEL_PK, level2_attribute1 as CTP_ATTRIBUTE1, level2_attribute2 as CTP_ATTRIBUTE2, level2_attribute3 as CTP_ATTRIBUTE3, level2_attribute4 as CTP_ATTRIBUTE4, level2_attribute5 as CTP_ATTRIBUTE5, level1_desc as COS_DESC, level1_value as COS_SR_LEVEL_PK, level1_attribute1 as COS_ATTRIBUTE1, level1_attribute2 as COS_ATTRIBUTE2, level1_attribute3 as COS_ATTRIBUTE3, level1_attribute4 as COS_ATTRIBUTE4, level1_attribute5 as COS_ATTRIBUTE5, instance_id as INSTANCE_ID from qpr_dimension_values WHERE dim_code='COS' and hierarchy_code = 'COSTING' and instance_id=qpr_maintain_aw.get_instance

View Text - HTML Formatted

SELECT LEVEL3_DESC AS ALL_DESC
, LEVEL3_VALUE AS ALL_SR_LEVEL_PK
, LEVEL3_ATTRIBUTE1 AS ALL_ATTRIBUTE1
, LEVEL3_ATTRIBUTE2 AS ALL_ATTRIBUTE2
, LEVEL3_ATTRIBUTE3 AS ALL_ATTRIBUTE3
, LEVEL3_ATTRIBUTE4 AS ALL_ATTRIBUTE4
, LEVEL3_ATTRIBUTE5 AS ALL_ATTRIBUTE5
, LEVEL2_DESC AS CTP_DESC
, LEVEL2_VALUE AS CTP_SR_LEVEL_PK
, LEVEL2_ATTRIBUTE1 AS CTP_ATTRIBUTE1
, LEVEL2_ATTRIBUTE2 AS CTP_ATTRIBUTE2
, LEVEL2_ATTRIBUTE3 AS CTP_ATTRIBUTE3
, LEVEL2_ATTRIBUTE4 AS CTP_ATTRIBUTE4
, LEVEL2_ATTRIBUTE5 AS CTP_ATTRIBUTE5
, LEVEL1_DESC AS COS_DESC
, LEVEL1_VALUE AS COS_SR_LEVEL_PK
, LEVEL1_ATTRIBUTE1 AS COS_ATTRIBUTE1
, LEVEL1_ATTRIBUTE2 AS COS_ATTRIBUTE2
, LEVEL1_ATTRIBUTE3 AS COS_ATTRIBUTE3
, LEVEL1_ATTRIBUTE4 AS COS_ATTRIBUTE4
, LEVEL1_ATTRIBUTE5 AS COS_ATTRIBUTE5
, INSTANCE_ID AS INSTANCE_ID
FROM QPR_DIMENSION_VALUES
WHERE DIM_CODE='COS'
AND HIERARCHY_CODE = 'COSTING'
AND INSTANCE_ID=QPR_MAINTAIN_AW.GET_INSTANCE