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

Line 1830: from BSC_KPI_ANALYSIS_MEASURES_VL

1826: ,x_Anal_Opt_Rec.Bsc_Measure_Prototype_Flag
1827: ,x_Anal_Opt_Rec.Bsc_Measure_Long_Name
1828: ,x_Anal_Opt_Rec.Bsc_Measure_Help
1829: ,x_Anal_Opt_Rec.Bsc_Kpi_Measure_Id
1830: from BSC_KPI_ANALYSIS_MEASURES_VL
1831: where indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
1832: and analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
1833: and analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
1834: and analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2;

Line 1861: from BSC_KPI_ANALYSIS_MEASURES_VL

1857: ,x_Anal_Opt_Rec.Bsc_Dataset_Bm_Color
1858: ,x_Anal_Opt_Rec.Bsc_Measure_Prototype_Flag
1859: ,x_Anal_Opt_Rec.Bsc_Measure_Long_Name
1860: ,x_Anal_Opt_Rec.Bsc_Measure_Help
1861: from BSC_KPI_ANALYSIS_MEASURES_VL
1862: where indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
1863: and analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
1864: and analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
1865: and analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2

Line 3319: l_kpi_name BSC_KPI_ANALYSIS_MEASURES_VL.NAME%TYPE;

3315: l_mess_count NUMBER;
3316: l_dep_obj_message varchar2(1000);
3317: l_message varchar2(1000);
3318: l_AnaOpt_Name BSC_OAF_ANALYSYS_OPT_COMB_V.FULL_NAME%TYPE;
3319: l_kpi_name BSC_KPI_ANALYSIS_MEASURES_VL.NAME%TYPE;
3320: l_objective_name BSC_KPIS_VL.NAME%TYPE;
3321: l_objective BSC_KPIS_VL.NAME%TYPE;
3322:
3323: CURSOR c_Measure_ak IS

Line 3347: CURSOR c_KpiMeasure(p_dataset_id BSC_KPI_ANALYSIS_MEASURES_VL.dataset_id%TYPE) IS

3343: AND a.parent_option_id = p_option1
3344: AND a.grandparent_option_id = p_option2
3345: AND a.indicator = b.indicator;
3346:
3347: CURSOR c_KpiMeasure(p_dataset_id BSC_KPI_ANALYSIS_MEASURES_VL.dataset_id%TYPE) IS
3348: SELECT a.name KPI_NAME, b.name OBJECTVIE_NAME
3349: FROM BSC_KPI_ANALYSIS_MEASURES_VL a
3350: ,BSC_KPIS_VL b
3351: WHERE a.indicator = b.indicator

Line 3349: FROM BSC_KPI_ANALYSIS_MEASURES_VL a

3345: AND a.indicator = b.indicator;
3346:
3347: CURSOR c_KpiMeasure(p_dataset_id BSC_KPI_ANALYSIS_MEASURES_VL.dataset_id%TYPE) IS
3348: SELECT a.name KPI_NAME, b.name OBJECTVIE_NAME
3349: FROM BSC_KPI_ANALYSIS_MEASURES_VL a
3350: ,BSC_KPIS_VL b
3351: WHERE a.indicator = b.indicator
3352: AND a.dataset_id = p_dataset_id
3353: AND a.Indicator <> p_kpi_id