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_UTIL dependencies on BSC_DB_TABLES_COLS

Line 2348: -- configured in BSC_DB_TABLES_COLS but it does not exists in BSC_DB_MEASURES_COLS_VL

2344: x_num_data_columns IN OUT NOCOPY NUMBER) RETURN BOOLEAN IS
2345:
2346: -- BSC-BIS-DIMENSIONS Note: From thsi implemetation we can run loader when
2347: -- there are indicators in prototype. This open a case where a measure is
2348: -- configured in BSC_DB_TABLES_COLS but it does not exists in BSC_DB_MEASURES_COLS_VL
2349: -- because the user could delete the measure. I am changing the query to return
2350: -- default values in case the measure does not exists in BSC_DB_MEASURES_COLS_VL
2351:
2352: -- SUPPORT_BSC_BIS_MEASURES: Only BSC measures exists in bsc_db_measure_cols_vl.

Line 2359: FROM bsc_db_tables_cols c, bsc_db_measure_cols_vl m

2355: CURSOR c_data_columns (p_table_name VARCHAR2, p_column_type VARCHAR2) IS
2356: SELECT c.column_name, c.source_formula,
2357: DECODE(NVL(c.source,'BSC'),'BSC',NVL(m.projection_id, 0),0),
2358: DECODE(NVL(c.source,'BSC'),'BSC',NVL(m.measure_type, 1),1)
2359: FROM bsc_db_tables_cols c, bsc_db_measure_cols_vl m
2360: WHERE c.column_name = m.measure_col (+) AND
2361: c.table_name = p_table_name AND c.column_type = p_column_type;
2362:
2363: h_column_type_a VARCHAR2(1);

Line 2365: h_column_name bsc_db_tables_cols.column_name%TYPE;

2361: c.table_name = p_table_name AND c.column_type = p_column_type;
2362:
2363: h_column_type_a VARCHAR2(1);
2364:
2365: h_column_name bsc_db_tables_cols.column_name%TYPE;
2366: h_source_formula bsc_db_tables_cols.source_formula%TYPE;
2367: h_projection_id bsc_db_tables_cols.projection_id%TYPE;
2368: h_measure_type bsc_db_measure_cols_vl.measure_type%TYPE;
2369:

Line 2366: h_source_formula bsc_db_tables_cols.source_formula%TYPE;

2362:
2363: h_column_type_a VARCHAR2(1);
2364:
2365: h_column_name bsc_db_tables_cols.column_name%TYPE;
2366: h_source_formula bsc_db_tables_cols.source_formula%TYPE;
2367: h_projection_id bsc_db_tables_cols.projection_id%TYPE;
2368: h_measure_type bsc_db_measure_cols_vl.measure_type%TYPE;
2369:
2370: BEGIN

Line 2367: h_projection_id bsc_db_tables_cols.projection_id%TYPE;

2363: h_column_type_a VARCHAR2(1);
2364:
2365: h_column_name bsc_db_tables_cols.column_name%TYPE;
2366: h_source_formula bsc_db_tables_cols.source_formula%TYPE;
2367: h_projection_id bsc_db_tables_cols.projection_id%TYPE;
2368: h_measure_type bsc_db_measure_cols_vl.measure_type%TYPE;
2369:
2370: BEGIN
2371: h_column_type_a := 'A';

Line 2424: ' FROM bsc_db_tables_cols t, bsc_sys_dim_levels_b d, bsc_sys_dim_levels_b d1'||

2420:
2421: /*
2422: c_key_columns t_cursor; -- x_table, h_column_type_p
2423: c_key_columns_sql VARCHAR2(2000) := 'SELECT t.column_name, d.level_view_name, t.source_column, d1.level_view_name'||
2424: ' FROM bsc_db_tables_cols t, bsc_sys_dim_levels_b d, bsc_sys_dim_levels_b d1'||
2425: ' WHERE t.table_name = :1 AND t.column_type = :2 AND'||
2426: ' t.column_name = d.level_pk_col AND'||
2427: ' t.source_column = d1.level_pk_col';
2428: */

Line 2431: FROM bsc_db_tables_cols t, bsc_sys_dim_levels_b d, bsc_sys_dim_levels_b d1

2427: ' t.source_column = d1.level_pk_col';
2428: */
2429: CURSOR c_key_columns (p_table_name VARCHAR2, p_column_type VARCHAR2) IS
2430: SELECT t.column_name, d.level_view_name, t.source_column, d1.level_view_name
2431: FROM bsc_db_tables_cols t, bsc_sys_dim_levels_b d, bsc_sys_dim_levels_b d1
2432: WHERE t.table_name = p_table_name AND t.column_type = p_column_type AND
2433: t.column_name = d.level_pk_col AND
2434: t.source_column = d1.level_pk_col
2435: ORDER BY d.dim_level_id;

Line 2439: h_key_column bsc_db_tables_cols.column_name%TYPE;

2435: ORDER BY d.dim_level_id;
2436:
2437: h_column_type_p VARCHAR2(1);
2438:
2439: h_key_column bsc_db_tables_cols.column_name%TYPE;
2440: h_key_dim_table bsc_sys_dim_levels_b.level_view_name%TYPE;
2441: h_source_column bsc_db_tables_cols.source_column%TYPE;
2442: h_source_dim_table bsc_sys_dim_levels_b.level_view_name%TYPE;
2443:

Line 2441: h_source_column bsc_db_tables_cols.source_column%TYPE;

2437: h_column_type_p VARCHAR2(1);
2438:
2439: h_key_column bsc_db_tables_cols.column_name%TYPE;
2440: h_key_dim_table bsc_sys_dim_levels_b.level_view_name%TYPE;
2441: h_source_column bsc_db_tables_cols.source_column%TYPE;
2442: h_source_dim_table bsc_sys_dim_levels_b.level_view_name%TYPE;
2443:
2444: BEGIN
2445: h_column_type_p := 'P';