MSC_XTR_HIERARCHY_MAP_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
DIMENSION_ID HIERARCHY_ID BASE_LEVEL_ID LEVEL_2_ID LEVEL_3_ID LEVEL_4_ID LEVEL_5_ID LEVEL_6_ID LEVEL_7_ID LEVEL_8_ID LEVEL_9_ID LEVEL_10_ID DIMENSION_CODE DIMENSION_NAME HIERARCHY_NAME BASE_LEVEL_NAME LEVEL_2_NAME LEVEL_3_NAME LEVEL_4_NAME LEVEL_5_NAME LEVEL_6_NAME LEVEL_7_NAME LEVEL_8_NAME LEVEL_9_NAME LEVEL_10_NAME CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

select hm.dimension_id, hm.hierarchy_id, hm.base_level_id, hm.level_2_id, hm.level_3_id, hm.level_4_id, hm.level_5_id, hm.level_6_id, hm.level_7_id, hm.level_8_id, hm.level_9_id, hm.level_10_id, d0.dimension_code, dt.name dimension_name, ht.name hierarchy_name, (select name from msc_levels_tl where level_id = hm.base_level_id and language = userenv('LANG')) base_level_name, (select name from msc_levels_tl where level_id = hm.level_2_id and language = userenv('LANG')) level_2_name, (select name from msc_levels_tl where level_id = hm.level_3_id and language = userenv('LANG')) level_3_name, (select name from msc_levels_tl where level_id = hm.level_4_id and language = userenv('LANG')) level_4_name, (select name from msc_levels_tl where level_id = hm.level_5_id and language = userenv('LANG')) level_5_name, (select name from msc_levels_tl where level_id = hm.level_6_id and language = userenv('LANG')) level_6_name, (select name from msc_levels_tl where level_id = hm.level_7_id and language = userenv('LANG')) level_7_name, (select name from msc_levels_tl where level_id = hm.level_8_id and language = userenv('LANG')) level_8_name, (select name from msc_levels_tl where level_id = hm.level_9_id and language = userenv('LANG')) level_9_name, (select name from msc_levels_tl where level_id = hm.level_10_id and language = userenv('LANG')) level_10_name, hm.created_by, hm.creation_date, hm.last_updated_by, hm.last_update_date, hm.last_update_login from msc_xtr_hierarchy_map hm, msc_dimensions_b d0, msc_dimensions_tl dt, msc_hierarchies_tl ht where hm.dimension_id = d0.dimension_id and d0.dimension_id = dt.dimension_id and dt.language = userenv('LANG') and hm.hierarchy_id = ht.hierarchy_id and ht.language = userenv('LANG')