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_UI_PKG dependencies on BSC_KPI_DIM_LEVELS_VL

Line 719: ( SELECT TARGET_LEVEL FROM bsc_kpi_dim_levels_vl DIM

715:
716:
717: PROCEDURE updateTargets(pIndicator IN NUMBER) IS
718: l_stmt VARCHAR2(1000) := 'UPDATE BSC_TMP_OPT_UI_LEVELS UI SET TARGET_LEVEL =
719: ( SELECT TARGET_LEVEL FROM bsc_kpi_dim_levels_vl DIM
720: WHERE UI.DIM_SET_ID = DIM.DIM_SET_ID
721: AND UI.INDICATOR = DIM.INDICATOR
722: AND UI.INDICATOR = : 1
723: AND UI.LEVEL_TABLE_NAME= DIM.LEVEL_TABLE_NAME)

Line 811: select count(1) INTO l_count FROM bsc_kpi_dim_levels_vl

807: insert_dimension_set(/*l_return_array, */pIndicator, colConfigurations(l_config_index), l_levels);
808: EXIT WHEN l_config_index = colConfigurations.last;
809: l_config_index := colConfigurations.next(l_config_index);
810: END LOOP;
811: select count(1) INTO l_count FROM bsc_kpi_dim_levels_vl
812: where indicator = pIndicator
813: and target_level = 0;
814: IF (l_count > 0) THEN
815: -- update table for target levels