View: RHX_DP_HIER_LVLS_PUB_V

View Text

SELECT HL.HIERARCHY_ID
, H.HIERARCHY_NAME
, HL.LEVEL_ID
, L.LEVEL_NAME
, HL.PARENT_LEVEL_ID
, L1.LEVEL_NAME
, H.DIMENSION_CODE
, FCL.MEANING
, H.DEMAND_PLAN_ID
, DP.DEMAND_PLAN_NAME
, HL.ATTRIBUTE_CATEGORY
, HL.ATTRIBUTE1
, HL.ATTRIBUTE2
, HL.ATTRIBUTE3
, HL.ATTRIBUTE4
, HL.ATTRIBUTE5
, HL.ATTRIBUTE6
, HL.ATTRIBUTE7
, HL.ATTRIBUTE8
, HL.ATTRIBUTE9
, HL.ATTRIBUTE10
, HL.ATTRIBUTE11
, HL.ATTRIBUTE12
, HL.ATTRIBUTE13
, HL.ATTRIBUTE14
, HL.ATTRIBUTE15
FROM RHX_DP_DEMAND_PLANS DP
, FND_COMMON_LOOKUPS FCL
, RHX_DP_LEVELS L1
, RHX_DP_LEVELS L
, RHX_DP_HIERARCHIES H
, RHX_DP_HIERARCHY_LEVELS HL
WHERE HL.HIERARCHY_ID = H.HIERARCHY_ID
AND H.VALID_FLAG = 1
AND HL.LEVEL_ID = L.LEVEL_ID
AND HL.PARENT_LEVEL_ID = L1.LEVEL_ID
AND FCL.LOOKUP_CODE = H.DIMENSION_CODE
AND FCL.LOOKUP_TYPE = 'DEMAND_PLANNER_DIMENSIONS'
AND DP.DEMAND_PLAN_ID = H.DEMAND_PLAN_ID UNION ALL SELECT H.HIERARCHY_ID
, H.HIERARCHY_NAME
, L.LEVEL_ID
, L.LEVEL_NAME
, DECODE (L.LEVEL_ID
, -999
, 0
, NULL)
, DECODE (L.LEVEL_NAME
, '$&*'
, 'BLAH'
, NULL)
, H.DIMENSION_CODE
, FCL.MEANING
, H.DEMAND_PLAN_ID
, DP.DEMAND_PLAN_NAME
, H.ATTRIBUTE_CATEGORY
, H.ATTRIBUTE1
, H.ATTRIBUTE2
, H.ATTRIBUTE3
, H.ATTRIBUTE4
, H.ATTRIBUTE5
, H.ATTRIBUTE6
, H.ATTRIBUTE7
, H.ATTRIBUTE8
, H.ATTRIBUTE9
, H.ATTRIBUTE10
, H.ATTRIBUTE11
, H.ATTRIBUTE12
, H.ATTRIBUTE13
, H.ATTRIBUTE14
, H.ATTRIBUTE15
FROM RHX_DP_DEMAND_PLANS DP
, FND_COMMON_LOOKUPS FCL
, RHX_DP_LEVELS L
, RHX_DP_HIERARCHIES H
WHERE L.LEVEL_TYPE_CODE = 1
AND H.VALID_FLAG = 1
AND L.DEMAND_PLAN_ID = H.DEMAND_PLAN_ID
AND L.DIMENSION_CODE = H.DIMENSION_CODE
AND FCL.LOOKUP_CODE = H.DIMENSION_CODE
AND FCL.LOOKUP_TYPE = 'DEMAND_PLANNER_DIMENSIONS'
AND DP.DEMAND_PLAN_ID = H.DEMAND_PLAN_ID

Columns