APPS.BSC_UPDATE_UTIL dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 3287: FROM bsc_kpi_analysis_measures_b

3283:
3284: BEGIN
3285: SELECT COUNT(indicator)
3286: INTO h_num_rows
3287: FROM bsc_kpi_analysis_measures_b
3288: WHERE kpi_measure_id = p_kpi_measure_id
3289: AND prototype_flag = 7;
3290:
3291: IF h_num_rows > 0 THEN

Line 6266: bsc_kpi_analysis_measures_b anal_meas,

6262: DECODE(ds.measure_id2,
6263: NULL, NULL,
6264: m2.operation || '(' || NVL(BSC_APPS.Get_Property_Value(m2.s_color_formula, 'pFormulaSource'), m2.measure_col) || ')' ) measure_formula
6265: FROM bsc_tab_indicators tab_ind,
6266: bsc_kpi_analysis_measures_b anal_meas,
6267: bsc_sys_datasets_b ds,
6268: bsc_sys_measures m1,
6269: bsc_sys_measures m2,
6270: bsc_kpis_b obj

Line 6317: bsc_kpi_analysis_measures_b am

6313: SELECT ind.measure_type source,
6314: dts.dataset_id
6315: FROM bsc_sys_datasets_b dts,
6316: bis_indicators ind,
6317: bsc_kpi_analysis_measures_b am
6318: WHERE dts.dataset_id = am.dataset_id
6319: AND dts.dataset_id = ind.dataset_id
6320: AND am.indicator = p_indicator
6321: AND am.kpi_measure_id = p_kpi_measure;