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_COLOR_CALC_UTIL dependencies on BSC_SYS_KPI_COLORS

Line 290: FROM bsc_sys_kpi_colors

286: SELECT DISTINCT
287: dim_level1 || dim_level2 || dim_level3 || dim_level4 || dim_level5 || dim_level6 || dim_level7 || dim_level8 || period_id dim_comb,
288: dim_level1, dim_level2, dim_level3, dim_level4, dim_level5, dim_level6, dim_level7, dim_level8,
289: period_id
290: FROM bsc_sys_kpi_colors
291: WHERE indicator = p_indicator
292: AND tab_id = p_tab_id;
293: l_dim_comb c_dim_comb%ROWTYPE;
294:

Line 297: FROM bsc_sys_kpi_colors

293: l_dim_comb c_dim_comb%ROWTYPE;
294:
295: CURSOR c_kpi_colors(p_indicator NUMBER, p_tab_id NUMBER, p_dim_comb VARCHAR2) IS
296: SELECT kpi_measure_id, kpi_color
297: FROM bsc_sys_kpi_colors
298: WHERE dim_level1 || dim_level2 || dim_level3 || dim_level4 || dim_level5 || dim_level6 || dim_level7 || dim_level8 || period_id = p_dim_comb
299: AND indicator = p_indicator
300: AND tab_id = p_tab_id
301: UNION -- bsc_sys_kpi_colors may not contain a color entry for 'color enabled' KPIs for which data has not been loaded

Line 301: UNION -- bsc_sys_kpi_colors may not contain a color entry for 'color enabled' KPIs for which data has not been loaded

297: FROM bsc_sys_kpi_colors
298: WHERE dim_level1 || dim_level2 || dim_level3 || dim_level4 || dim_level5 || dim_level6 || dim_level7 || dim_level8 || period_id = p_dim_comb
299: AND indicator = p_indicator
300: AND tab_id = p_tab_id
301: UNION -- bsc_sys_kpi_colors may not contain a color entry for 'color enabled' KPIs for which data has not been loaded
302: SELECT kpi_measure_id, BSC_COLOR_REPOSITORY.NO_COLOR kpi_color
303: FROM bsc_kpi_measure_props
304: WHERE indicator = p_indicator
305: AND disable_color = 'F'

Line 307: ( SELECT kpi_measure_id FROM bsc_sys_kpi_colors

303: FROM bsc_kpi_measure_props
304: WHERE indicator = p_indicator
305: AND disable_color = 'F'
306: AND kpi_measure_id NOT IN
307: ( SELECT kpi_measure_id FROM bsc_sys_kpi_colors
308: WHERE indicator = p_indicator
309: AND tab_id = p_tab_id
310: );
311: l_kpi_colors c_kpi_colors%ROWTYPE;

Line 544: FROM bsc_sys_kpi_colors

540: SELECT DISTINCT
541: dim_level1 || dim_level2 || dim_level3 || dim_level4 || dim_level5 || dim_level6 || dim_level7 || dim_level8 || period_id dim_comb,
542: dim_level1, dim_level2, dim_level3, dim_level4, dim_level5, dim_level6, dim_level7, dim_level8,
543: period_id
544: FROM bsc_sys_kpi_colors
545: WHERE indicator = p_indicator
546: AND tab_id = p_tab_id;
547: l_dim_comb c_dim_comb%ROWTYPE;
548:

Line 551: FROM bsc_sys_kpi_colors

547: l_dim_comb c_dim_comb%ROWTYPE;
548:
549: CURSOR c_kpi_colors(p_indicator NUMBER, p_tab_id NUMBER, p_dim_comb VARCHAR2) IS
550: SELECT kpi_color, kpi_measure_id
551: FROM bsc_sys_kpi_colors
552: WHERE dim_level1 || dim_level2 || dim_level3 || dim_level4 || dim_level5 || dim_level6 || dim_level7 || dim_level8 || period_id = p_dim_comb
553: AND indicator = p_indicator
554: AND tab_id = p_tab_id
555: UNION -- bsc_sys_kpi_colors may not contain a color entry for 'color enabled' KPIs for which data has not been loaded

Line 555: UNION -- bsc_sys_kpi_colors may not contain a color entry for 'color enabled' KPIs for which data has not been loaded

551: FROM bsc_sys_kpi_colors
552: WHERE dim_level1 || dim_level2 || dim_level3 || dim_level4 || dim_level5 || dim_level6 || dim_level7 || dim_level8 || period_id = p_dim_comb
553: AND indicator = p_indicator
554: AND tab_id = p_tab_id
555: UNION -- bsc_sys_kpi_colors may not contain a color entry for 'color enabled' KPIs for which data has not been loaded
556: SELECT BSC_COLOR_REPOSITORY.NO_COLOR kpi_color, kpi_measure_id
557: FROM bsc_kpi_measure_props
558: WHERE indicator = p_indicator
559: AND disable_color = 'F'

Line 561: ( SELECT kpi_measure_id FROM bsc_sys_kpi_colors

557: FROM bsc_kpi_measure_props
558: WHERE indicator = p_indicator
559: AND disable_color = 'F'
560: AND kpi_measure_id NOT IN
561: ( SELECT kpi_measure_id FROM bsc_sys_kpi_colors
562: WHERE indicator = p_indicator
563: AND tab_id = p_tab_id
564: );
565: l_kpi_colors c_kpi_colors%ROWTYPE;

Line 999: FROM bsc_sys_kpi_colors

995: INSERT /*+ append */
996: INTO bsc_sys_objective_colors
997: (tab_id, indicator, dim_level1, dim_level2, dim_level3, dim_level4, dim_level5, dim_level6, dim_level7, dim_level8, period_id, obj_color, driving_kpi_measure_id)
998: SELECT tab_id, indicator, dim_level1, dim_level2, dim_level3, dim_level4, dim_level5, dim_level6, dim_level7, dim_level8, period_id, kpi_color, kpi_measure_id
999: FROM bsc_sys_kpi_colors
1000: WHERE kpi_measure_id = l_default_kpi_measure_id
1001: AND tab_id = p_objective_color_rec.tab_id
1002: AND indicator = p_objective_color_rec.objective_id;
1003: