DBA Data[Home] [Help]

APPS.BSC_DIMENSION_EDIT dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 134: UPDATE bsc_kpi_analysis_measures_b k

130: UPPER(D.TABLE_RELATION) = UPPER(l_dim_table))) AND
131: PROTOTYPE_FLAG in (0, 6, 7);
132:
133: -- Color By KPI: Mark KPIs for color re-calculation
134: UPDATE bsc_kpi_analysis_measures_b k
135: SET prototype_flag = 7
136: WHERE indicator IN (SELECT D.INDICATOR
137: FROM BSC_KPI_DIM_LEVELS_B D
138: WHERE K.INDICATOR = D.INDICATOR AND