DBA Data[Home] [Help]

APPS.BSC_MO_INDICATOR_PKG dependencies on BSC_KPIS_VL

Line 975: BSC_KPIS_VL kpi

971: PROCEDURE init_measure_counts(l_list IN DBMS_SQL.number_table) IS
972: l_dummy varchar2(1000);
973: l_stmt varchar2(4000) := 'SELECT kpi.indicator||''_''|| i.dim_set_id hash_index, COUNT(M.MEASURE_COL) NUM_DATA_COLUMNS
974: FROM BSC_SYS_MEASURES M, '||BSC_METADATA_OPTIMIZER_PKG.g_dbmeasure_tmp_table||' I,
975: BSC_KPIS_VL kpi
976: WHERE I.MEASURE_ID = M.MEASURE_ID
977: AND kpi.indicator = i.indicator
978: AND M.TYPE = 0
979: AND NVL(M.SOURCE, ''BSC'') IN (''BSC'', ''PMF'')

Line 1041: SELECT short_name INTO l_short_name FROM bsc_kpis_vl where indicator = Indic;

1037:
1038: IF (g_objective_measures.exists(Indic||'_'||DimSet)) THEN
1039: return g_objective_measures(Indic||'_'||DimSet).value;
1040: END IF;
1041: SELECT short_name INTO l_short_name FROM bsc_kpis_vl where indicator = Indic;
1042:
1043: --BSC-PMF Integration: Even though a PMF measure cannot be present in a BSC
1044: --dimension set, I am going to do the validation to filter out PMF measures
1045: -- Bug 4301819

Line 3497: select short_name into l_source from bsc_kpis_vl

3493: cv CurTyp;
3494:
3495: BEGIN
3496: bsc_mo_helper_pkg.writeTmp( 'Inside GetDataFields, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, false);
3497: select short_name into l_source from bsc_kpis_vl
3498: where indicator=Indic;
3499: -- Bug 4301819
3500: -- Dont include PMF measures if this is created by objective definer
3501: IF (l_source is null) THEN -- created by objective definer