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

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';

Line 2547: ' FROM bsc_db_tables'||

2543: h_sql VARCHAR2(32000);
2544:
2545: BEGIN
2546: /* h_sql := 'SELECT source_data_type, source_file_name'||
2547: ' FROM bsc_db_tables'||
2548: ' WHERE table_name = :1';
2549: OPEN h_cursor FOR h_sql USING x_input_table;
2550: FETCH h_cursor INTO x_source_type, x_source_name;
2551: CLOSE h_cursor; */

Line 2554: FROM bsc_db_tables

2550: FETCH h_cursor INTO x_source_type, x_source_name;
2551: CLOSE h_cursor; */
2552: SELECT source_data_type, TRIM(source_file_name)
2553: INTO x_source_type, x_source_name
2554: FROM bsc_db_tables
2555: WHERE table_name = x_input_table ;
2556:
2557: RETURN TRUE;
2558:

Line 3048: ' FROM bsc_db_tables'||

3044: BEGIN
3045: h_edw_flag := 0;
3046:
3047: /* h_sql := 'SELECT NVL(edw_flag, 0)'||
3048: ' FROM bsc_db_tables'||
3049: ' WHERE table_name = :1';
3050: OPEN h_cursor FOR h_sql USING x_table_name;
3051: FETCH h_cursor INTO h_edw_flag;
3052: CLOSE h_cursor; */

Line 3056: FROM bsc_db_tables

3052: CLOSE h_cursor; */
3053: begin
3054: SELECT NVL(edw_flag, 0)
3055: INTO h_edw_flag
3056: FROM bsc_db_tables
3057: WHERE table_name = x_table_name;
3058: exception
3059: when no_data_found then h_edw_flag := null;
3060: end;

Line 3074: h_table_generation_type bsc_db_tables.generation_type%TYPE;

3070: FUNCTION Get_Table_Generation_Type(
3071: x_table_name IN VARCHAR2
3072: ) RETURN NUMBER IS
3073:
3074: h_table_generation_type bsc_db_tables.generation_type%TYPE;
3075:
3076: BEGIN
3077: h_table_generation_type := NULL;
3078:

Line 3081: FROM bsc_db_tables

3077: h_table_generation_type := NULL;
3078:
3079: SELECT generation_type
3080: INTO h_table_generation_type
3081: FROM bsc_db_tables
3082: WHERE table_name = x_table_name;
3083:
3084: RETURN h_table_generation_type;
3085:

Line 3102: h_table_type bsc_db_tables.table_type%TYPE;

3098: FUNCTION Get_Table_Type(
3099: x_table_name IN VARCHAR2
3100: ) RETURN NUMBER IS
3101:
3102: h_table_type bsc_db_tables.table_type%TYPE;
3103:
3104: BEGIN
3105: h_table_type := NULL;
3106:

Line 3109: FROM bsc_db_tables

3105: h_table_type := NULL;
3106:
3107: SELECT table_type
3108: INTO h_table_type
3109: FROM bsc_db_tables
3110: WHERE table_name = x_table_name;
3111:
3112: RETURN h_table_type;
3113:

Line 3135: ' FROM bsc_db_tables'||

3131:
3132: /*
3133: c_table_periodicity t_cursor; -- x_table_name
3134: c_table_periodicity_sql VARCHAR2(2000) := 'SELECT periodicity_id'||
3135: ' FROM bsc_db_tables'||
3136: ' WHERE table_name = :1';
3137: */
3138:
3139: h_table_periodicity bsc_db_tables.periodicity_id%TYPE;

Line 3139: h_table_periodicity bsc_db_tables.periodicity_id%TYPE;

3135: ' FROM bsc_db_tables'||
3136: ' WHERE table_name = :1';
3137: */
3138:
3139: h_table_periodicity bsc_db_tables.periodicity_id%TYPE;
3140:
3141: BEGIN
3142: h_table_periodicity := NULL;
3143:

Line 3155: FROM bsc_db_tables

3151: */
3152: BEGIN
3153: SELECT periodicity_id
3154: INTO h_table_periodicity
3155: FROM bsc_db_tables
3156: WHERE table_name = x_table_name;
3157: EXCEPTION
3158: WHEN NO_DATA_FOUND THEN
3159: h_table_periodicity := NULL;

Line 3186: FROM bsc_db_tables

3182: BEGIN
3183: BEGIN
3184: SELECT num_of_years, previous_years
3185: INTO x_num_of_years, x_previous_years
3186: FROM bsc_db_tables
3187: WHERE table_name = x_table_name;
3188: EXCEPTION
3189: WHEN NO_DATA_FOUND THEN
3190: x_num_of_years := 2;

Line 3223: FROM bsc_kpi_data_tables t, bsc_db_tables_rels r, bsc_kpis_b k

3219: ) RETURN NUMBER IS
3220:
3221: CURSOR c_kpis IS
3222: SELECT DISTINCT k.indicator, k.prototype_flag
3223: FROM bsc_kpi_data_tables t, bsc_db_tables_rels r, bsc_kpis_b k
3224: WHERE t.table_name = r.table_name AND
3225: t.indicator = k.indicator AND
3226: (t.table_name = x_table_name OR
3227: (r.source_table_name = x_table_name AND r.relation_type = 1));

Line 3321: ' FROM bsc_db_tables'||

3317: h_target_flag := 0;
3318:
3319: /*
3320: h_sql := 'SELECT NVL(target_flag, 0)'||
3321: ' FROM bsc_db_tables'||
3322: ' WHERE table_name = :1';
3323: OPEN h_cursor FOR h_sql USING x_table_name;
3324: FETCH h_cursor INTO h_target_flag;
3325: CLOSE h_cursor;

Line 3329: FROM bsc_db_tables

3325: CLOSE h_cursor;
3326: */
3327: SELECT NVL(target_flag, 0)
3328: INTO h_target_flag
3329: FROM bsc_db_tables
3330: WHERE table_name = x_table_name;
3331:
3332: RETURN h_target_flag;
3333:

Line 3594: FROM bsc_db_tables t, bsc_db_tables_rels r

3590: ) RETURN BOOLEAN IS
3591:
3592: CURSOR c_table_type IS
3593: SELECT t.table_type
3594: FROM bsc_db_tables t, bsc_db_tables_rels r
3595: WHERE t.table_name = r.source_table_name and
3596: r.table_name = x_table_name;
3597:
3598: h_table_type NUMBER;

Line 4107: ' FROM bsc_db_tables'||

4103: /*
4104: get_range_yr t_cursor; -- 2, 0, x_calendar_id
4105: get_range_yr_sql VARCHAR2(2000) := 'SELECT nvl(max(num_of_years - previous_years), 1),'||
4106: ' nvl(max(previous_years), 1)'||
4107: ' FROM bsc_db_tables'||
4108: ' WHERE table_type <> :1 AND nvl(num_of_years, 0) > :2 AND'||
4109: ' periodicity_id IN (SELECT periodicity_id'||
4110: ' FROM bsc_sys_periodicities'||
4111: ' WHERE calendar_id = :3)';

Line 4115: FROM bsc_db_tables

4111: ' WHERE calendar_id = :3)';
4112: */
4113: CURSOR get_range_yr (p_table_type NUMBER, p_num_of_years NUMBER, p_calendar_id NUMBER) IS
4114: SELECT nvl(max(num_of_years - previous_years), 1), nvl(max(previous_years), 1)
4115: FROM bsc_db_tables
4116: WHERE table_type <> p_table_type AND nvl(num_of_years, 0) > p_num_of_years AND
4117: periodicity_id IN (
4118: SELECT periodicity_id
4119: FROM bsc_sys_periodicities

Line 6095: from bsc_db_tables_rels

6091: select count(table_name)
6092: into h_count
6093: from (
6094: select distinct table_name
6095: from bsc_db_tables_rels
6096: start with table_name in (
6097: select distinct kd.table_name
6098: from bsc_kpi_data_tables kd, bsc_kpi_properties k
6099: where k.indicator = kd.indicator and