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

Line 4028: FROM BSC_KPI_ANALYSIS_MEASURES_VL

4024: l_count NUMBER := 0;
4025:
4026: CURSOR c_SeriesCount IS
4027: SELECT COUNT(SERIES_ID)
4028: FROM BSC_KPI_ANALYSIS_MEASURES_VL
4029: WHERE INDICATOR = p_indicator
4030: AND ANALYSIS_OPTION0 = p_a0
4031: AND ANALYSIS_OPTION1 = p_a1
4032: AND ANALYSIS_OPTION2 = p_a2;

Line 4069: , p_measure_name IN VARCHAR2 --BSC_KPI_ANALYSIS_MEASURES_VL.name

4065: , p_measure_short_name IN VARCHAR2
4066: , p_dim_obj_short_names IN VARCHAR2 --comma seperated dimension objects needed for PMF Measures
4067: , p_default_short_names IN VARCHAR2 := NULL
4068: , p_view_by_name IN VARCHAR2 := NULL
4069: , p_measure_name IN VARCHAR2 --BSC_KPI_ANALYSIS_MEASURES_VL.name
4070: , p_measure_help IN VARCHAR2 --BSC_KPI_ANALYSIS_MEASURES_VL.help
4071: , p_default_value IN NUMBER
4072: , p_time_stamp IN VARCHAR2 := NULL
4073: , p_update_ana_opt IN BOOLEAN := FALSE

Line 4070: , p_measure_help IN VARCHAR2 --BSC_KPI_ANALYSIS_MEASURES_VL.help

4066: , p_dim_obj_short_names IN VARCHAR2 --comma seperated dimension objects needed for PMF Measures
4067: , p_default_short_names IN VARCHAR2 := NULL
4068: , p_view_by_name IN VARCHAR2 := NULL
4069: , p_measure_name IN VARCHAR2 --BSC_KPI_ANALYSIS_MEASURES_VL.name
4070: , p_measure_help IN VARCHAR2 --BSC_KPI_ANALYSIS_MEASURES_VL.help
4071: , p_default_value IN NUMBER
4072: , p_time_stamp IN VARCHAR2 := NULL
4073: , p_update_ana_opt IN BOOLEAN := FALSE
4074: , x_return_status OUT NOCOPY VARCHAR2

Line 5777: l_def_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_VL.kpi_measure_id%TYPE;

5773: l_Old_Anal_Num_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;
5774:
5775: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
5776: l_color_rollup_type BSC_KPIS_B.color_rollup_type%TYPE;
5777: l_def_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_VL.kpi_measure_id%TYPE;
5778: l_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_VL.kpi_measure_id%TYPE;
5779:
5780:
5781: CURSOR c_kpi_ids IS

Line 5778: l_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_VL.kpi_measure_id%TYPE;

5774:
5775: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
5776: l_color_rollup_type BSC_KPIS_B.color_rollup_type%TYPE;
5777: l_def_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_VL.kpi_measure_id%TYPE;
5778: l_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_VL.kpi_measure_id%TYPE;
5779:
5780:
5781: CURSOR c_kpi_ids IS
5782: SELECT indicator

Line 5922: FROM bsc_kpi_analysis_measures_vl

5918: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
5919:
5920: SELECT kpi_measure_id
5921: INTO l_kpi_measure_id
5922: FROM bsc_kpi_analysis_measures_vl
5923: WHERE analysis_option0 = p_Anal_opt0
5924: AND analysis_option1 = p_Anal_opt1
5925: AND analysis_option2 = p_Anal_opt2
5926: AND series_id = p_Anal_Series

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

5927: AND indicator = p_kpi_id;
5928:
5929: SELECT bk.color_rollup_type, km.kpi_measure_id, bk.prototype_flag
5930: INTO l_color_rollup_type, l_def_kpi_measure_id, l_obj_prototype_flag
5931: FROM bsc_db_color_ao_defaults_v dd, bsc_kpi_analysis_measures_vl km, bsc_kpis_b bk
5932: WHERE km.indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id AND
5933: bk.indicator = km.indicator AND
5934: km.indicator = dd.indicator AND
5935: dd.a0_default = km.analysis_option0 AND