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_KPI_COLOR_PROPERTIES_PUB dependencies on BSC_KPI_ANALYSIS_MEASURES_VL

Line 313: FROM bsc_db_color_ao_defaults_v dd, bsc_kpi_analysis_measures_vl km, bsc_kpis_b bk

309: WHERE indicator = p_objective_id;*/
310:
311: SELECT bk.color_rollup_type, bk.prototype_flag
312: INTO l_color_rollup_type, l_obj_prototype_flag
313: FROM bsc_db_color_ao_defaults_v dd, bsc_kpi_analysis_measures_vl km, bsc_kpis_b bk
314: WHERE km.indicator = p_objective_id AND
315: bk.indicator = km.indicator AND
316: km.indicator = dd.indicator AND
317: dd.a0_default = km.analysis_option0 AND

Line 560: l_def_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_VL.kpi_measure_id%TYPE;

556: )
557: IS
558: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
559: l_color_rollup_type BSC_KPIS_B.color_rollup_type%TYPE;
560: l_def_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_VL.kpi_measure_id%TYPE;
561: BEGIN
562:
563: FND_MSG_PUB.Initialize;
564: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 583: FROM bsc_db_color_ao_defaults_v dd, bsc_kpi_analysis_measures_vl km, bsc_kpis_b bk

579: WHERE indicator = p_objective_id;*/
580:
581: SELECT bk.color_rollup_type, km.kpi_measure_id, bk.prototype_flag
582: INTO l_color_rollup_type, l_def_kpi_measure_id, l_obj_prototype_flag
583: FROM bsc_db_color_ao_defaults_v dd, bsc_kpi_analysis_measures_vl km, bsc_kpis_b bk
584: WHERE km.indicator = p_objective_id AND
585: bk.indicator = km.indicator AND
586: km.indicator = dd.indicator AND
587: dd.a0_default = km.analysis_option0 AND