DBA Data[Home] [Help]

APPS.BSC_DIMENSION_EDIT dependencies on BSC_KPI_DIM_LEVELS_B

Line 127: FROM BSC_KPI_DIM_LEVELS_B D

123: SET PROTOTYPE_FLAG = 6,
124: LAST_UPDATED_BY = BSC_APPS.fnd_global_user_id,
125: LAST_UPDATE_DATE = SYSDATE
126: WHERE INDICATOR IN (SELECT D.INDICATOR
127: FROM BSC_KPI_DIM_LEVELS_B D
128: WHERE K.INDICATOR = D.INDICATOR AND
129: (UPPER(D.LEVEL_TABLE_NAME) = UPPER(l_dim_table) OR
130: UPPER(D.TABLE_RELATION) = UPPER(l_dim_table))) AND
131: PROTOTYPE_FLAG in (0, 6, 7);

Line 137: FROM BSC_KPI_DIM_LEVELS_B D

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
139: (UPPER(D.LEVEL_TABLE_NAME) = UPPER(l_dim_table) OR
140: UPPER(D.TABLE_RELATION) = UPPER(l_dim_table)));
141: commit;