VIEW: APPS.QPR_CUS_ALLHIER_V

Source

View Text - Preformatted

SELECT a.level1_desc as TP_DESC, a.level1_value as TP_SR_LEVEL_PK, a.level1_attribute1 as TP_ATTRIBUTE1, a.level1_attribute2 as TP_ATTRIBUTE2, a.level1_attribute3 as TP_ATTRIBUTE3, a.level1_attribute4 as TP_ATTRIBUTE4, a.level1_attribute5 as TP_ATTRIBUTE5, b.level2_desc as CG_DESC, b.level2_value as CG_SR_LEVEL_PK, b.level2_attribute1 as CG_ATTRIBUTE1, b.level2_attribute2 as CG_ATTRIBUTE2, b.level2_attribute3 as CG_ATTRIBUTE3, b.level2_attribute4 as CG_ATTRIBUTE4, b.level2_attribute5 as CG_ATTRIBUTE5, a.level2_desc as TP_CLASS_DESC, a.level2_value as TP_CLASS_SR_LEVEL_PK, a.level2_attribute1 as TP_CLASS_ATTRIBUTE1, a.level2_attribute2 as TP_CLASS_ATTRIBUTE2, a.level2_attribute3 as TP_CLASS_ATTRIBUTE3, a.level2_attribute4 as TP_CLASS_ATTRIBUTE4, a.level2_attribute5 as TP_CLASS_ATTRIBUTE5, a.level3_desc as ALL_CUS_DESC, a.level3_value as ALL_CUS_SR_LEVEL_PK, a.level3_attribute1 as ALL_CUS_ATTRIBUTE1, a.level3_attribute2 as ALL_CUS_ATTRIBUTE2, a.level3_attribute3 as ALL_CUS_ATTRIBUTE3, a.level3_attribute4 as ALL_CUS_ATTRIBUTE4, a.level3_attribute5 as ALL_CUS_ATTRIBUTE5, a.instance_id as INSTANCE_ID from qpr_dimension_values a, qpr_dimension_values b WHERE a.level1_value = b.level1_value and a.dim_code='CUS' and a.hierarchy_code = 'TRADINGPARTNERCLASS' and b.dim_code='CUS' and b.hierarchy_code = 'CUSTOMERGROUP' and a.instance_id=b.instance_id

View Text - HTML Formatted

SELECT A.LEVEL1_DESC AS TP_DESC
, A.LEVEL1_VALUE AS TP_SR_LEVEL_PK
, A.LEVEL1_ATTRIBUTE1 AS TP_ATTRIBUTE1
, A.LEVEL1_ATTRIBUTE2 AS TP_ATTRIBUTE2
, A.LEVEL1_ATTRIBUTE3 AS TP_ATTRIBUTE3
, A.LEVEL1_ATTRIBUTE4 AS TP_ATTRIBUTE4
, A.LEVEL1_ATTRIBUTE5 AS TP_ATTRIBUTE5
, B.LEVEL2_DESC AS CG_DESC
, B.LEVEL2_VALUE AS CG_SR_LEVEL_PK
, B.LEVEL2_ATTRIBUTE1 AS CG_ATTRIBUTE1
, B.LEVEL2_ATTRIBUTE2 AS CG_ATTRIBUTE2
, B.LEVEL2_ATTRIBUTE3 AS CG_ATTRIBUTE3
, B.LEVEL2_ATTRIBUTE4 AS CG_ATTRIBUTE4
, B.LEVEL2_ATTRIBUTE5 AS CG_ATTRIBUTE5
, A.LEVEL2_DESC AS TP_CLASS_DESC
, A.LEVEL2_VALUE AS TP_CLASS_SR_LEVEL_PK
, A.LEVEL2_ATTRIBUTE1 AS TP_CLASS_ATTRIBUTE1
, A.LEVEL2_ATTRIBUTE2 AS TP_CLASS_ATTRIBUTE2
, A.LEVEL2_ATTRIBUTE3 AS TP_CLASS_ATTRIBUTE3
, A.LEVEL2_ATTRIBUTE4 AS TP_CLASS_ATTRIBUTE4
, A.LEVEL2_ATTRIBUTE5 AS TP_CLASS_ATTRIBUTE5
, A.LEVEL3_DESC AS ALL_CUS_DESC
, A.LEVEL3_VALUE AS ALL_CUS_SR_LEVEL_PK
, A.LEVEL3_ATTRIBUTE1 AS ALL_CUS_ATTRIBUTE1
, A.LEVEL3_ATTRIBUTE2 AS ALL_CUS_ATTRIBUTE2
, A.LEVEL3_ATTRIBUTE3 AS ALL_CUS_ATTRIBUTE3
, A.LEVEL3_ATTRIBUTE4 AS ALL_CUS_ATTRIBUTE4
, A.LEVEL3_ATTRIBUTE5 AS ALL_CUS_ATTRIBUTE5
, A.INSTANCE_ID AS INSTANCE_ID
FROM QPR_DIMENSION_VALUES A
, QPR_DIMENSION_VALUES B
WHERE A.LEVEL1_VALUE = B.LEVEL1_VALUE
AND A.DIM_CODE='CUS'
AND A.HIERARCHY_CODE = 'TRADINGPARTNERCLASS'
AND B.DIM_CODE='CUS'
AND B.HIERARCHY_CODE = 'CUSTOMERGROUP'
AND A.INSTANCE_ID=B.INSTANCE_ID