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_BSC_ADAPTER dependencies on BSC_SYS_DIM_LEVELS_B

Line 19: BSC_SYS_DIM_LEVELS_B WHERE level_table_name in

15: l_count number := 1;
16: cursor cLevelInfo is
17: SELECT LEVEL_TABLE_NAME,SHORT_NAME, upper(level_pk_col) level_pk_col
18: FROM
19: BSC_SYS_DIM_LEVELS_B WHERE level_table_name in
20: (select level_table_name
21: from bsc_kpi_dim_levels_b kpi,
22: bsc_tmp_opt_ui_kpis gdb
23: where gdb.indicator=kpi.indicator

Line 2894: SELECT level_view_name FROM bsc_sys_dim_levels_b s WHERE d.level_pk_col = s.level_pk_col)

2890: --------------------------
2891: cursor c1(p_indicator number,p_dim_set_id number,p_status number,p_table_name varchar2,p_column_type varchar2) is
2892: SELECT d.level_pk_col, d.level_view_name FROM bsc_kpi_dim_levels_b d, bsc_db_tables_cols c
2893: WHERE d.indicator = p_indicator AND d.dim_set_id = p_dim_set_id AND d.status = p_status AND d.level_view_name <> (
2894: SELECT level_view_name FROM bsc_sys_dim_levels_b s WHERE d.level_pk_col = s.level_pk_col)
2895: AND c.table_name = p_table_name AND c.column_name = d.level_pk_col AND
2896: c.column_type = p_column_type;
2897:
2898: cursor c2(p_indicator number,p_set_id number) is

Line 2925: 'SELECT level_view_name FROM bsc_sys_dim_levels_b s WHERE d.level_pk_col = s.level_pk_col) '||

2921: if l_indicator_id is not null and l_dim_set_id is not null then
2922: if g_debug then
2923: l_stmt:='SELECT d.level_pk_col, d.level_view_name FROM bsc_kpi_dim_levels_b d, bsc_db_tables_cols c '||
2924: 'WHERE d.indicator = :1 AND d.dim_set_id = :2 AND d.status = :3 AND d.level_view_name <> ( '||
2925: 'SELECT level_view_name FROM bsc_sys_dim_levels_b s WHERE d.level_pk_col = s.level_pk_col) '||
2926: 'AND c.table_name = :4 AND c.column_name = d.level_pk_col AND '||
2927: 'c.column_type = :5';
2928: write_to_log_file_n(l_stmt||' '||l_indicator_id||' '||l_dim_set_id||' 2 '||p_table||' P');
2929: end if;

Line 3169: bsc_sys_dim_levels_b lvl,

3165: select
3166: par_lvl.level_table_name,
3167: rel.relation_col
3168: from
3169: bsc_sys_dim_levels_b lvl,
3170: bsc_sys_dim_levels_b par_lvl,
3171: bsc_sys_dim_level_rels rel
3172: where
3173: lvl.level_table_name=p_level

Line 3170: bsc_sys_dim_levels_b par_lvl,

3166: par_lvl.level_table_name,
3167: rel.relation_col
3168: from
3169: bsc_sys_dim_levels_b lvl,
3170: bsc_sys_dim_levels_b par_lvl,
3171: bsc_sys_dim_level_rels rel
3172: where
3173: lvl.level_table_name=p_level
3174: and lvl.dim_level_id=rel.dim_level_id

Line 3180: write_to_log_file_n('select par_lvl.level_table_name,rel.relation_col from bsc_sys_dim_levels_b lvl,'||

3176: and par_lvl.dim_level_id=rel.parent_dim_level_id;
3177: -------------
3178: Begin
3179: if g_debug then
3180: write_to_log_file_n('select par_lvl.level_table_name,rel.relation_col from bsc_sys_dim_levels_b lvl,'||
3181: 'bsc_sys_dim_levels_b par_lvl,bsc_sys_dim_level_rels rel where lvl.level_table_name='''||p_child_level||''''||
3182: 'and lvl.dim_level_id=rel.dim_level_id and rel.relation_type=1 and par_lvl.dim_level_id=rel.parent_dim_level_id');
3183: end if;
3184: p_num_parent_levels:=1;

Line 3181: 'bsc_sys_dim_levels_b par_lvl,bsc_sys_dim_level_rels rel where lvl.level_table_name='''||p_child_level||''''||

3177: -------------
3178: Begin
3179: if g_debug then
3180: write_to_log_file_n('select par_lvl.level_table_name,rel.relation_col from bsc_sys_dim_levels_b lvl,'||
3181: 'bsc_sys_dim_levels_b par_lvl,bsc_sys_dim_level_rels rel where lvl.level_table_name='''||p_child_level||''''||
3182: 'and lvl.dim_level_id=rel.dim_level_id and rel.relation_type=1 and par_lvl.dim_level_id=rel.parent_dim_level_id');
3183: end if;
3184: p_num_parent_levels:=1;
3185: open c1(p_child_level);

Line 3239: select short_name from bsc_sys_dim_levels_b

3235: and table_name=p_dim_level
3236: and column_name = p_level_pk;
3237:
3238: cursor c_short_name is
3239: select short_name from bsc_sys_dim_levels_b
3240: where level_table_name=p_dim_level;
3241: l_short_name varchar2(300);
3242:
3243: begin

Line 3286: write_to_log_file('PK Column '||p_level_pk||' specified in bsc_sys_dim_levels_b does not exist in '||p_dim_level);

3282: BSC_IM_UTILS.g_status_message:=sqlerrm;
3283: g_status_message:=sqlerrm;
3284: write_to_log_file_n('Exception in create_denorm_table: p_dim_level='||p_dim_level||', pk='||p_level_pk||', stmt='||l_stmt||', error='||sqlerrm);
3285: if (l_data_type is null) then
3286: write_to_log_file('PK Column '||p_level_pk||' specified in bsc_sys_dim_levels_b does not exist in '||p_dim_level);
3287: end if;
3288: raise;
3289: end;
3290:

Line 3301: cursor c1(p_col varchar2) is select level_table_name,short_name from bsc_sys_dim_levels_b where upper(level_pk_col)=upper(p_col);

3297: p_rec_dim_key out nocopy varchar2
3298: )return boolean is
3299: l_stmt varchar2(5000);
3300: --------------------------------------------
3301: cursor c1(p_col varchar2) is select level_table_name,short_name from bsc_sys_dim_levels_b where upper(level_pk_col)=upper(p_col);
3302: --------------------------------------------
3303: l_name varchar2(200);
3304: l_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;
3305:

Line 3313: l_stmt:='select level_table_name,short_name from bsc_sys_dim_levels_b where level_pk_col=:1';

3309: g_level_info_cached := true;
3310: end if;
3311: if g_debug then
3312: write_to_log_file_n('In get_level_for_pk'||' '||get_time);
3313: l_stmt:='select level_table_name,short_name from bsc_sys_dim_levels_b where level_pk_col=:1';
3314: write_to_log_file_n(l_stmt||' '||p_level_pk);
3315: end if;
3316:
3317: if g_level_info.exists(upper(p_level_pk)) then

Line 6189: from bsc_sys_dim_level_cols ,bsc_sys_dim_levels_b

6185: l_stmt varchar2(5000);
6186: ---------------------------------------------
6187: cursor c1 (p_level_table_name varchar2)
6188: is select column_name,column_type
6189: from bsc_sys_dim_level_cols ,bsc_sys_dim_levels_b
6190: where level_table_name=p_level_table_name
6191: and bsc_sys_dim_level_cols.dim_level_id=bsc_sys_dim_levels_b.dim_level_id;
6192: ---------------------------------------------
6193: Begin

Line 6191: and bsc_sys_dim_level_cols.dim_level_id=bsc_sys_dim_levels_b.dim_level_id;

6187: cursor c1 (p_level_table_name varchar2)
6188: is select column_name,column_type
6189: from bsc_sys_dim_level_cols ,bsc_sys_dim_levels_b
6190: where level_table_name=p_level_table_name
6191: and bsc_sys_dim_level_cols.dim_level_id=bsc_sys_dim_levels_b.dim_level_id;
6192: ---------------------------------------------
6193: Begin
6194: if g_debug then
6195: l_stmt:='select column_name,column_type '||

Line 6196: 'from bsc_sys_dim_level_cols ,bsc_sys_dim_levels_b '||

6192: ---------------------------------------------
6193: Begin
6194: if g_debug then
6195: l_stmt:='select column_name,column_type '||
6196: 'from bsc_sys_dim_level_cols ,bsc_sys_dim_levels_b '||
6197: 'where level_table_name=:1 '||
6198: 'and bsc_sys_dim_level_cols.dim_level_id=bsc_sys_dim_levels_b.dim_level_id ';
6199: write_to_log_file_n(l_stmt||' '||p_level);
6200: end if;

Line 6198: 'and bsc_sys_dim_level_cols.dim_level_id=bsc_sys_dim_levels_b.dim_level_id ';

6194: if g_debug then
6195: l_stmt:='select column_name,column_type '||
6196: 'from bsc_sys_dim_level_cols ,bsc_sys_dim_levels_b '||
6197: 'where level_table_name=:1 '||
6198: 'and bsc_sys_dim_level_cols.dim_level_id=bsc_sys_dim_levels_b.dim_level_id ';
6199: write_to_log_file_n(l_stmt||' '||p_level);
6200: end if;
6201: p_number_columns:=1;
6202: open c1(p_level);

Line 6296: cursor c1(p_table varchar2) is select short_name from bsc_sys_dim_levels_b where level_table_name=p_table;

6292:
6293: --given the table name, get the short name of the level
6294: function get_level_short_name(p_table_name varchar2) return varchar2 is
6295: --
6296: cursor c1(p_table varchar2) is select short_name from bsc_sys_dim_levels_b where level_table_name=p_table;
6297: --
6298: l_name varchar2(200);
6299: Begin
6300: if g_debug then

Line 6301: write_to_log_file_n('In get_level_short_name->select short_name from bsc_sys_dim_levels_b where level_table_name='||

6297: --
6298: l_name varchar2(200);
6299: Begin
6300: if g_debug then
6301: write_to_log_file_n('In get_level_short_name->select short_name from bsc_sys_dim_levels_b where level_table_name='||
6302: p_table_name);
6303: end if;
6304: open c1(p_table_name);
6305: fetch c1 into l_name;