APPS.BSC_BSC_ADAPTER dependencies on BSC_DB_TABLES_RELS

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