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_UPDATE_COLOR dependencies on BSC_SYS_COLORS_B

Line 368: ' FROM bsc_tmp_colors tem_c, bsc_sys_colors_b col_b ' ||

364: l_color_method := get_color_method(p_objective_id, p_kpi_measure_id);
365:
366: l_sql_mcc := 'SELECT ' || l_lst_keys_insert || ', period, col_b.color_id FROM ( ' ||
367: ' SELECT ' || l_lst_keys_insert || ', period , MAX(col_b.perf_sequence) mcc ' ||
368: ' FROM bsc_tmp_colors tem_c, bsc_sys_colors_b col_b ' ||
369: ' WHERE tem_c.color = col_b.color_id ' ||
370: ' GROUP BY ' || l_lst_keys_insert || ' , period ' ||
371: ' ) bsc_tmp_colors_mcc, bsc_sys_colors_b col_b ' ||
372: ' WHERE bsc_tmp_colors_mcc.mcc = col_b.perf_sequence ';

Line 371: ' ) bsc_tmp_colors_mcc, bsc_sys_colors_b col_b ' ||

367: ' SELECT ' || l_lst_keys_insert || ', period , MAX(col_b.perf_sequence) mcc ' ||
368: ' FROM bsc_tmp_colors tem_c, bsc_sys_colors_b col_b ' ||
369: ' WHERE tem_c.color = col_b.color_id ' ||
370: ' GROUP BY ' || l_lst_keys_insert || ' , period ' ||
371: ' ) bsc_tmp_colors_mcc, bsc_sys_colors_b col_b ' ||
372: ' WHERE bsc_tmp_colors_mcc.mcc = col_b.perf_sequence ';
373:
374: OPEN l_mcc_cursor FOR l_sql_mcc;
375: FETCH l_mcc_cursor INTO l_lst_keys_array(1), l_lst_keys_array(2), l_lst_keys_array(3), l_lst_keys_array(4), l_lst_keys_array(5), l_lst_keys_array(6), l_lst_keys_array(7), l_lst_keys_array(8) , l_period, l_mcc_color;

Line 573: ' FROM ('||p_sql_mcc||') BSC_TMP_COLORS_MCC, BSC_SYS_COLORS_B COL_B'||

569: RETURN;
570: END IF;
571: h_color_method := Get_Color_Method(p_indic_code,p_kpi_measure_id);
572: h_sql_trend := ' SELECT '||p_lst_keys_insert||'PERIOD, COL_B.COLOR_ID '||
573: ' FROM ('||p_sql_mcc||') BSC_TMP_COLORS_MCC, BSC_SYS_COLORS_B COL_B'||
574: ' WHERE BSC_TMP_COLORS_MCC.MCC = COL_B.PERF_SEQUENCE '||
575: ' ORDER BY PERIOD ';
576: OPEN h_trend_cursor FOR h_sql_trend;
577: FETCH h_trend_cursor INTO h_key1,h_key2,h_key3,h_key4,h_key5,h_key6,h_key7,h_key8,h_trend_period, h_trend_color;

Line 1315: ' FROM BSC_TMP_COLORS TEM_C, BSC_SYS_COLORS_B COL_B'||

1311: END IF;
1312:
1313: h_sql_mcc := 'SELECT '||h_lst_select||'PERIOD, '||
1314: ' MAX(COL_B.PERF_SEQUENCE) MCC'||
1315: ' FROM BSC_TMP_COLORS TEM_C, BSC_SYS_COLORS_B COL_B'||
1316: ' WHERE TEM_C.COLOR = COL_B.COLOR_ID'||
1317: ' GROUP BY '||h_lst_select||'PERIOD';
1318:
1319: -- We are ready to insert the colors directly in BSC_SYS_KPI_COLORS

Line 1324: ' FROM ('||h_sql_mcc||') BSC_TMP_COLORS_MCC, BSC_SYS_COLORS_B COL_B'||

1320: h_sql := 'INSERT INTO BSC_SYS_KPI_COLORS (TAB_ID, INDICATOR, KPI_MEASURE_ID, DIM_LEVEL1, DIM_LEVEL2,'||
1321: ' DIM_LEVEL3, DIM_LEVEL4, DIM_LEVEL5, DIM_LEVEL6, DIM_LEVEL7, DIM_LEVEL8,'||
1322: ' PERIOD_ID, KPI_COLOR, USER_COLOR)'||
1323: ' SELECT :1, :2, :3, '||h_lst_keys_insert||'PERIOD,'|| ' COL_B.COLOR_ID, COL_B.COLOR_ID ' ||
1324: ' FROM ('||h_sql_mcc||') BSC_TMP_COLORS_MCC, BSC_SYS_COLORS_B COL_B'||
1325: ' WHERE BSC_TMP_COLORS_MCC.MCC = COL_B.PERF_SEQUENCE';
1326:
1327: h_bind_vars_values_n.delete;
1328: h_bind_vars_values_n(1) := x_tab_id;

Line 1494: min_perf BSC_SYS_COLORS_B.PERF_SEQUENCE%TYPE;

1490: x_color_level4 NUMBER;
1491:
1492: threshold_Prop_Table BSC_COLOR_CALC_UTIL.Threshold_Prop_Table;
1493:
1494: min_perf BSC_SYS_COLORS_B.PERF_SEQUENCE%TYPE;
1495: max_perf BSC_SYS_COLORS_B.PERF_SEQUENCE%TYPE;
1496: min_perf_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;
1497: max_perf_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;
1498: nodata_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;

Line 1495: max_perf BSC_SYS_COLORS_B.PERF_SEQUENCE%TYPE;

1491:
1492: threshold_Prop_Table BSC_COLOR_CALC_UTIL.Threshold_Prop_Table;
1493:
1494: min_perf BSC_SYS_COLORS_B.PERF_SEQUENCE%TYPE;
1495: max_perf BSC_SYS_COLORS_B.PERF_SEQUENCE%TYPE;
1496: min_perf_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;
1497: max_perf_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;
1498: nodata_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;
1499:

Line 1496: min_perf_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;

1492: threshold_Prop_Table BSC_COLOR_CALC_UTIL.Threshold_Prop_Table;
1493:
1494: min_perf BSC_SYS_COLORS_B.PERF_SEQUENCE%TYPE;
1495: max_perf BSC_SYS_COLORS_B.PERF_SEQUENCE%TYPE;
1496: min_perf_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;
1497: max_perf_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;
1498: nodata_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;
1499:
1500: h_sql_else VARCHAR2(500);

Line 1497: max_perf_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;

1493:
1494: min_perf BSC_SYS_COLORS_B.PERF_SEQUENCE%TYPE;
1495: max_perf BSC_SYS_COLORS_B.PERF_SEQUENCE%TYPE;
1496: min_perf_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;
1497: max_perf_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;
1498: nodata_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;
1499:
1500: h_sql_else VARCHAR2(500);
1501: l_comp_op VARCHAR2(2); --> different operator for color_method

Line 1498: nodata_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;

1494: min_perf BSC_SYS_COLORS_B.PERF_SEQUENCE%TYPE;
1495: max_perf BSC_SYS_COLORS_B.PERF_SEQUENCE%TYPE;
1496: min_perf_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;
1497: max_perf_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;
1498: nodata_color_id BSC_SYS_COLORS_B.COLOR_ID%TYPE;
1499:
1500: h_sql_else VARCHAR2(500);
1501: l_comp_op VARCHAR2(2); --> different operator for color_method
1502: --1. <=, 2. <, 3 < any other case <=

Line 1509: FROM bsc_sys_colors_b;

1505:
1506:
1507: CURSOR c_sys_colors IS
1508: SELECT COLOR_ID, PERF_SEQUENCE, COLOR
1509: FROM bsc_sys_colors_b;
1510:
1511: BEGIN
1512:
1513: -- ppandey -> Get the system color properties Enh #4012218