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_DB_TABLES

Line 95: cursor c1 is select column_name from bsc_db_tables_cols where table_name = p_table_name;

91: p_table_name varchar2,
92: p_measures BSC_IM_UTILS.varchar_tabletype,
93: p_number_measures number
94: ) return varchar2 is
95: cursor c1 is select column_name from bsc_db_tables_cols where table_name = p_table_name;
96: l_column_name VARCHAR2(100);
97: l_ordered_columns varchar2(32000);
98: begin
99: if p_number_measures= 0 then

Line 125: cursor c1 is select column_name from bsc_db_tables_cols where table_name=p_b_table_name

121: return l_ordered_columns;
122: end;
123:
124: function get_prj_union_clause(p_b_table_name varchar2, p_add_alias boolean default true) return varchar2 is
125: cursor c1 is select column_name from bsc_db_tables_cols where table_name=p_b_table_name
126: order by column_type desc;
127: l_stmt varchar2(32000);
128: l_prj_table varchar2(100);
129: begin

Line 2892: SELECT d.level_pk_col, d.level_view_name FROM bsc_kpi_dim_levels_b d, bsc_db_tables_cols c

2888: l_number_pk_col number;
2889: l_view_owner varchar2(200);
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;

Line 2923: l_stmt:='SELECT d.level_pk_col, d.level_view_name FROM bsc_kpi_dim_levels_b d, bsc_db_tables_cols c '||

2919: write_to_log_file('Result '||l_indicator_id||' '||l_dim_set_id);
2920: end if;
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';

Line 3417: from bsc_db_tables_cols where table_name=p_table

3413: l_stmt varchar2(5000);
3414: ---------------------------------------------
3415: cursor c1(p_table varchar2) is
3416: select table_name,upper(column_name),column_type,source_formula,source_column
3417: from bsc_db_tables_cols where table_name=p_table
3418: order by column_name;
3419: ---------------------------------------------
3420: l_table_name varchar2(100);
3421: Begin

Line 3429: 'from bsc_db_tables_cols where table_name=:1';

3425: l_table_name := p_table_name;
3426: end if;
3427: if g_debug then
3428: l_stmt:='select table_name,upper(column_name),column_type,source_formula,upper(source_column) '||
3429: 'from bsc_db_tables_cols where table_name=:1';
3430: write_to_log_file_n(l_stmt||' '||l_table_name);
3431: end if;
3432: if p_number_cols is null then
3433: p_number_cols:=1;

Line 3466: is select periodicity_id from bsc_db_tables where table_name=p_table;

3462: l_stmt varchar2(5000);
3463: l_id number;
3464: ---------------------------------------
3465: cursor c1 (p_table varchar2)
3466: is select periodicity_id from bsc_db_tables where table_name=p_table;
3467: ---------------------------------------
3468: l_table_name varchar2(100);
3469: Begin
3470: if (p_table_name like 'BSC_B%PRJ%') then

Line 3476: l_stmt:='select periodicity_id from bsc_db_tables where table_name=:1';

3472: else
3473: l_table_name := p_table_name;
3474: end if;
3475: if g_debug then
3476: l_stmt:='select periodicity_id from bsc_db_tables where table_name=:1';
3477: write_to_log_file_n(l_stmt||' '||l_table_name);
3478: end if;
3479: open c1(l_table_name);
3480: fetch c1 into l_id;

Line 3616: is select distinct bsc_db_tables_cols.column_name,bsc_kpi_dim_levels_b.dim_level_index from

3612: l_stmt varchar2(5000);
3613: --------------------------------------------------
3614: --for S tables
3615: cursor c0 (p_table varchar2)
3616: is select distinct bsc_db_tables_cols.column_name,bsc_kpi_dim_levels_b.dim_level_index from
3617: bsc_kpi_data_tables,
3618: bsc_db_tables_cols,
3619: bsc_kpi_dim_levels_b
3620: where

Line 3618: bsc_db_tables_cols,

3614: --for S tables
3615: cursor c0 (p_table varchar2)
3616: is select distinct bsc_db_tables_cols.column_name,bsc_kpi_dim_levels_b.dim_level_index from
3617: bsc_kpi_data_tables,
3618: bsc_db_tables_cols,
3619: bsc_kpi_dim_levels_b
3620: where
3621: bsc_kpi_data_tables.table_name=bsc_db_tables_cols.table_name
3622: and bsc_db_tables_cols.table_name =p_table

Line 3621: bsc_kpi_data_tables.table_name=bsc_db_tables_cols.table_name

3617: bsc_kpi_data_tables,
3618: bsc_db_tables_cols,
3619: bsc_kpi_dim_levels_b
3620: where
3621: bsc_kpi_data_tables.table_name=bsc_db_tables_cols.table_name
3622: and bsc_db_tables_cols.table_name =p_table
3623: and bsc_db_tables_cols.column_type='P'
3624: and bsc_kpi_data_tables.indicator=bsc_kpi_dim_levels_b.indicator
3625: and bsc_db_tables_cols.column_name=bsc_kpi_dim_levels_b.level_pk_col

Line 3622: and bsc_db_tables_cols.table_name =p_table

3618: bsc_db_tables_cols,
3619: bsc_kpi_dim_levels_b
3620: where
3621: bsc_kpi_data_tables.table_name=bsc_db_tables_cols.table_name
3622: and bsc_db_tables_cols.table_name =p_table
3623: and bsc_db_tables_cols.column_type='P'
3624: and bsc_kpi_data_tables.indicator=bsc_kpi_dim_levels_b.indicator
3625: and bsc_db_tables_cols.column_name=bsc_kpi_dim_levels_b.level_pk_col
3626: and bsc_kpi_data_tables.dim_set_id=bsc_kpi_dim_levels_b.dim_set_id

Line 3623: and bsc_db_tables_cols.column_type='P'

3619: bsc_kpi_dim_levels_b
3620: where
3621: bsc_kpi_data_tables.table_name=bsc_db_tables_cols.table_name
3622: and bsc_db_tables_cols.table_name =p_table
3623: and bsc_db_tables_cols.column_type='P'
3624: and bsc_kpi_data_tables.indicator=bsc_kpi_dim_levels_b.indicator
3625: and bsc_db_tables_cols.column_name=bsc_kpi_dim_levels_b.level_pk_col
3626: and bsc_kpi_data_tables.dim_set_id=bsc_kpi_dim_levels_b.dim_set_id
3627: order by bsc_kpi_dim_levels_b.dim_level_index;

Line 3625: and bsc_db_tables_cols.column_name=bsc_kpi_dim_levels_b.level_pk_col

3621: bsc_kpi_data_tables.table_name=bsc_db_tables_cols.table_name
3622: and bsc_db_tables_cols.table_name =p_table
3623: and bsc_db_tables_cols.column_type='P'
3624: and bsc_kpi_data_tables.indicator=bsc_kpi_dim_levels_b.indicator
3625: and bsc_db_tables_cols.column_name=bsc_kpi_dim_levels_b.level_pk_col
3626: and bsc_kpi_data_tables.dim_set_id=bsc_kpi_dim_levels_b.dim_set_id
3627: order by bsc_kpi_dim_levels_b.dim_level_index;
3628: --
3629: --for the B tables

Line 3631: is select distinct bsc_db_tables_cols.column_name,all_tab_columns.column_id

3627: order by bsc_kpi_dim_levels_b.dim_level_index;
3628: --
3629: --for the B tables
3630: cursor c1 (p_table varchar2,p_owner varchar2)
3631: is select distinct bsc_db_tables_cols.column_name,all_tab_columns.column_id
3632: from
3633: bsc_db_tables_cols ,
3634: all_tab_columns
3635: where bsc_db_tables_cols.table_name =p_table

Line 3633: bsc_db_tables_cols ,

3629: --for the B tables
3630: cursor c1 (p_table varchar2,p_owner varchar2)
3631: is select distinct bsc_db_tables_cols.column_name,all_tab_columns.column_id
3632: from
3633: bsc_db_tables_cols ,
3634: all_tab_columns
3635: where bsc_db_tables_cols.table_name =p_table
3636: and bsc_db_tables_cols.column_type='P'
3637: and all_tab_columns.table_name(+)=p_table

Line 3635: where bsc_db_tables_cols.table_name =p_table

3631: is select distinct bsc_db_tables_cols.column_name,all_tab_columns.column_id
3632: from
3633: bsc_db_tables_cols ,
3634: all_tab_columns
3635: where bsc_db_tables_cols.table_name =p_table
3636: and bsc_db_tables_cols.column_type='P'
3637: and all_tab_columns.table_name(+)=p_table
3638: and all_tab_columns.column_name(+)=bsc_db_tables_cols.column_name
3639: and all_tab_columns.owner(+)=p_owner

Line 3636: and bsc_db_tables_cols.column_type='P'

3632: from
3633: bsc_db_tables_cols ,
3634: all_tab_columns
3635: where bsc_db_tables_cols.table_name =p_table
3636: and bsc_db_tables_cols.column_type='P'
3637: and all_tab_columns.table_name(+)=p_table
3638: and all_tab_columns.column_name(+)=bsc_db_tables_cols.column_name
3639: and all_tab_columns.owner(+)=p_owner
3640: order by all_tab_columns.column_id;

Line 3638: and all_tab_columns.column_name(+)=bsc_db_tables_cols.column_name

3634: all_tab_columns
3635: where bsc_db_tables_cols.table_name =p_table
3636: and bsc_db_tables_cols.column_type='P'
3637: and all_tab_columns.table_name(+)=p_table
3638: and all_tab_columns.column_name(+)=bsc_db_tables_cols.column_name
3639: and all_tab_columns.owner(+)=p_owner
3640: order by all_tab_columns.column_id;
3641: ----
3642: l_owner varchar2(200);

Line 3649: write_to_log_file_n('distinct bsc_db_tables_cols.column_name,bsc_kpi_dim_levels_b.dim_level_index fr...');

3645: l_table_name varchar2(100);
3646: Begin
3647: p_number_fk:=1;
3648: if g_debug then
3649: write_to_log_file_n('distinct bsc_db_tables_cols.column_name,bsc_kpi_dim_levels_b.dim_level_index fr...');
3650: end if;
3651: if (p_table like 'BSC_B_%PRJ%') then
3652: l_table_name := get_b_table_name_for_prj(p_table);
3653: else

Line 3669: write_to_log_file_n('is select distinct bsc_db_tables_cols.column_name,all_tab_columns.column_id...');

3665: --
3666: if p_number_fk=0 then
3667: --either there are no fk or this could be a table without entries in bsc_kpi_data_tables...like B tables
3668: if g_debug then
3669: write_to_log_file_n('is select distinct bsc_db_tables_cols.column_name,all_tab_columns.column_id...');
3670: end if;
3671: l_owner:=bsc_im_utils.get_table_owner(l_table_name);
3672: p_number_fk:=p_number_fk+1;
3673: open c1(l_table_name,l_owner);

Line 3752: is select distinct column_name from bsc_db_tables_cols where table_name =p_table_name and

3748: ) return boolean is
3749: l_stmt varchar2(5000);
3750: -----------------------------------------
3751: cursor c1 (p_table_name varchar2)
3752: is select distinct column_name from bsc_db_tables_cols where table_name =p_table_name and
3753: column_type='A' order by column_name;
3754: -----------------------------------------
3755: l_table_name varchar2(100);
3756: Begin

Line 3763: l_stmt:='select distinct column_name from bsc_db_tables_cols where table_name =:1 and '||

3759: else
3760: l_table_name := p_table;
3761: end if;
3762: if g_debug then
3763: l_stmt:='select distinct column_name from bsc_db_tables_cols where table_name =:1 and '||
3764: 'column_type=''A''';
3765: write_to_log_file_n(l_stmt||' '||p_table);
3766: end if;
3767: p_number_measures:=1;

Line 3846: select distinct upper(table_name), substr(table_name, instr(table_name, '_', -1, 1)+1) periodicity_id from bsc_db_tables_rels

3842: --is select distinct upper(table_name),periodicity_id from bsc_kpi_data_tables where indicator=p_indicator
3843: --and table_name is not null;
3844:
3845: cursor c1 (p_indicator number)is
3846: select distinct upper(table_name), substr(table_name, instr(table_name, '_', -1, 1)+1) periodicity_id from bsc_db_tables_rels
3847: where instr(table_name, 'BSC_S_'||p_indicator||'_') =1 or instr(table_name, 'BSC_SB_'||p_indicator||'_') =1;
3848:
3849: /*
3850: 5009697

Line 3854: from bsc_db_tables_rels rel, bsc_db_tables tab

3850: 5009697
3851: c2 will add duplicate data to c1
3852: cursor c2 (p_indicator number)
3853: is select distinct rel.source_table_name, tab.periodicity_id
3854: from bsc_db_tables_rels rel, bsc_db_tables tab
3855: where rel.table_name in
3856: (select distinct upper(table_name) from bsc_kpi_data_tables where indicator=p_indicator)
3857: and rel.source_table_name like 'BSC_SB_%'
3858: and rel.source_table_name=tab.table_name ;

Line 3879: 'from bsc_db_tables_rels rel, bsc_db_tables tab '||

3875: /*
3876: 5009697
3877: if g_debug then
3878: l_stmt:='select distinct rel.source_table_name, tab.periodicity_id '||
3879: 'from bsc_db_tables_rels rel, bsc_db_tables tab '||
3880: 'where rel.table_name in '||
3881: '(select distinct upper(table_name) from bsc_kpi_data_tables where indicator=:1) '||
3882: 'and rel.source_table_name like ''BSC_SB_%'' '||
3883: 'and rel.source_table_name=tab.table_name ';

Line 4101: is select table_name,source_table_name,relation_type from bsc_db_tables_rels where

4097: ) return boolean is
4098: l_stmt varchar2(32000);
4099: ------------------------------------------------
4100: cursor c1 (p_table_name varchar2)
4101: is select table_name,source_table_name,relation_type from bsc_db_tables_rels where
4102: table_name=p_table_name;
4103: ------------------------------------------------
4104: l_table_name varchar2(100);
4105: Begin

Line 4120: l_stmt:='select table_name,source_table_name,relation_type from bsc_db_tables_rels where '||

4116: else
4117: p_number_tables:=p_number_tables+1;
4118: end if;
4119: if g_debug then
4120: l_stmt:='select table_name,source_table_name,relation_type from bsc_db_tables_rels where '||
4121: 'table_name=:1';
4122: write_to_log_file_n(l_stmt||' '||l_table_name);
4123: end if;
4124: open c1(l_table_name);

Line 6237: is select distinct table_name from bsc_db_tables_rels

6233: --Fix bug#3899842: use distinct
6234: --cursor c1 (p_mv_name varchar2)
6235: --is select distinct table_name from bsc_kpi_data_tables where mv_name=p_mv_name;
6236: cursor c1 (p_mv_name_pattern varchar2)
6237: is select distinct table_name from bsc_db_tables_rels
6238: where substr(table_name, 1, length(p_mv_name_pattern))= p_mv_name_pattern;
6239: -----------------------------------
6240: l_pattern varchar2(100);
6241: Begin

Line 6265: l_stmt:='select table_name from bsc_db_tables where table_name like substr(:1,1,

6261: end loop;
6262: end if;
6263: if p_number_s_tables=0 then
6264: p_number_s_tables:=1;
6265: l_stmt:='select table_name from bsc_db_tables where table_name like substr(:1,1,
6266: length(:2)-3)||''%''';
6267: if g_debug then
6268: write_to_log_file_n(l_stmt||' using '||p_mv||','||p_mv);
6269: end if;