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_DOC_PKG dependencies on BSC_KPI_DIM_LEVELS_B

Line 1068: FROM BSC_KPI_DIM_LEVELS_B

1064: Function GetLevelPKCol(Indicator IN NUMBER, Configuration IN NUMBER, DimLevelIndex IN NUMBER) return VARCHAR2 IS
1065: res VARCHAR2(100) := null;
1066: CURSOR c1 (p1 NUMBER, p2 NUMBER, p3 NUMBER) IS
1067: SELECT LEVEL_PK_COL
1068: FROM BSC_KPI_DIM_LEVELS_B
1069: WHERE INDICATOR = p1
1070: AND DIM_SET_ID = p2
1071: AND DIM_LEVEL_INDEX = p3;
1072: l_level_pk_col VARCHAR2(100);

Line 1151: (select 1 from bsc_kpi_dim_levels_b master, bsc_kpi_dim_levels_b child

1147: select kpis.indicator
1148: from main_indics ind, bsc_kpis_vl kpis
1149: where ind.indicator = kpis.source_indicator
1150: and not exists
1151: (select 1 from bsc_kpi_dim_levels_b master, bsc_kpi_dim_levels_b child
1152: where master.indicator=kpis.source_indicator
1153: and child.indicator= ind.indicator
1154: and master.level_table_name = child.level_table_name
1155: and master.dim_level_index = child.dim_level_index