eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_MO_INDICATOR_PKG dependencies on BSC_SYS_DIM_LEVELS_B

Line 194: bsc_sys_dim_levels_b levels,

190: cursor cJoin (p_indicator NUMBER, p_dimset NUMBER, p_level_name VARCHAR2) IS
191: select distinct levels.level_table_name child_level, parent_levels.level_table_name parent_level,
192: relation_col parent_fk, level
193: from bsc_sys_dim_level_rels rels,
194: bsc_sys_dim_levels_b levels,
195: bsc_sys_dim_levels_b parent_levels,
196: bsc_kpi_dim_levels_b kpi_levels
197: where rels.dim_level_id = levels.dim_level_id
198: and levels.level_table_name = kpi_levels.level_table_name

Line 195: bsc_sys_dim_levels_b parent_levels,

191: select distinct levels.level_table_name child_level, parent_levels.level_table_name parent_level,
192: relation_col parent_fk, level
193: from bsc_sys_dim_level_rels rels,
194: bsc_sys_dim_levels_b levels,
195: bsc_sys_dim_levels_b parent_levels,
196: bsc_kpi_dim_levels_b kpi_levels
197: where rels.dim_level_id = levels.dim_level_id
198: and levels.level_table_name = kpi_levels.level_table_name
199: and rels.parent_dim_level_id = parent_levels.dim_level_id

Line 203: start with parent_dim_level_id = (select dim_level_id from bsc_sys_dim_levels_b where level_table_name = p_level_name)

199: and rels.parent_dim_level_id = parent_levels.dim_level_id
200: and kpi_levels.indicator = p_indicator
201: and kpi_levels.dim_set_id = p_dimset
202: connect by prior rels.dim_level_id||rels.relation_type = rels.parent_dim_level_id||1 -- relation_type=1
203: start with parent_dim_level_id = (select dim_level_id from bsc_sys_dim_levels_b where level_table_name = p_level_name)
204: order by level;
205:
206: l_dim VARCHAR2(100);
207: l_parent VARCHAR2(100);

Line 323: FROM BSC_SYS_DIM_LEVEL_RELS RELS, BSC_SYS_DIM_LEVELS_B LVLA, BSC_SYS_DIM_LEVELS_B LVLB

319: l_dimension_levels BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;
320:
321: CURSOR cParentFK(p_lower_dim_table IN VARCHAR2, p_higher_dim_table IN VARCHAR2) IS
322: SELECT RELATION_COL
323: FROM BSC_SYS_DIM_LEVEL_RELS RELS, BSC_SYS_DIM_LEVELS_B LVLA, BSC_SYS_DIM_LEVELS_B LVLB
324: WHERE LVLA.level_table_name = p_lower_dim_table
325: AND LVLB.level_table_name = p_higher_dim_table
326: AND LVLA.dim_level_id = rels.dim_level_id
327: AND LVLB.dim_level_id = rels.parent_dim_level_id;

Line 942: FROM BSC_KPI_DIM_LEVELS_B K, BSC_SYS_DIM_LEVELS_B S

938: cv CurTyp;
939:
940: CURSOR cFilter(pIndicator IN NUMBER, pConfig IN NUMBER) IS
941: SELECT count(1)
942: FROM BSC_KPI_DIM_LEVELS_B K, BSC_SYS_DIM_LEVELS_B S
943: WHERE UPPER(K.LEVEL_TABLE_NAME) = UPPER(S.LEVEL_TABLE_NAME)
944: AND K.INDICATOR = pIndicator
945: AND K.DIM_SET_ID = pConfig
946: AND UPPER(S.LEVEL_VIEW_NAME) <> UPPER(K.LEVEL_VIEW_NAME)

Line 1069: FROM BSC_SYS_DIM_LEVELS_B S, BSC_KPI_DIM_LEVELS_B K

1065: Function GetSourceDimensionSet(Indic IN NUMBER, DimSet IN NUMBER) return VARCHAR2 IS
1066:
1067: CURSOR cSourceDimSet IS
1068: SELECT NVL(SOURCE, 'BSC') DSSOURCE
1069: FROM BSC_SYS_DIM_LEVELS_B S, BSC_KPI_DIM_LEVELS_B K
1070: WHERE S.LEVEL_TABLE_NAME = K.LEVEL_TABLE_NAME
1071: AND K.INDICATOR = Indic AND K.DIM_SET_ID = DimSet AND K.STATUS = 2;
1072: l_ret VARCHAR2(100);
1073: cv CurTyp;

Line 2747: select level_table_name from bsc_sys_dim_levels_b

2743: END IF;
2744: l_stmt := 'select 1 from bsc_kpi_dim_levels_b where indicator =:1
2745: and level_pk_col = :2
2746: and level_table_name in (
2747: select level_table_name from bsc_sys_dim_levels_b
2748: where short_name in ('|| gRecDims||')
2749: or dim_level_id in
2750: (select dim_level_id from bsc_sys_dim_level_rels
2751: where dim_level_id = parent_dim_level_id))