APPS.BSC_IM_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

select substr(p_Stable,  instr(p_Stable, '_',1, 2)+1,
   instr(p_Stable, '_', 1, 3)- (instr(p_Stable, '_',1, 2)+1))
from dual;

Line: 35

select count(1)from bsc_db_calculations calc
where calc.calculation_type = 4
and calc.table_name =
  (select table_name
   from bsc_kpi_data_tables data
   where
   data.indicator = p_kpi
   and data.mv_name = p_mv_name
   and rownum=1)
and calc.parameter1 = p_fk;

Line: 71

select table_name from bsc_db_tables_rels
where table_name like 'BSC_S%'
connect by source_table_name = prior table_name
start with source_table_name = p_b_pt_table_name;

Line: 77

select projection_data from bsc_kpi_data_tables
where indicator = p_kpi
and projection_data = p_b_pt_table_name;

Line: 82

select count(1) from bsc_db_calculations calc
where calc.calculation_type = 4
and calc.table_name = p_sTable
and calc.parameter1 = p_fk;

Line: 335

  g_stmt:='select '||p_column||' from '||p_object||' where rownum=1';

Line: 560

  g_stmt:='select '||p_seq||'.nextval from dual';

Line: 1178

  l_stmt:= 'SELECT 1 FROM USER_SOURCE WHERE NAME=:1 AND TYPE=:2 ';

Line: 1199

cursor c1(p_table varchar2) is select table_owner from user_synonyms where synonym_name=p_table;

Line: 1235

cursor c1(p_table varchar2) is select table_owner from user_synonyms where synonym_name=p_table;

Line: 1289

    l_stmt:='select object_type from all_objects where object_name=:1 and owner=:2';

Line: 1333

  g_stmt:='select constraint_name,constraint_type,status,validated,index_name from all_constraints '||
  'where table_name=:a and owner=:b';

Line: 1610

  g_stmt:='select 1 from all_snapshot_logs where MASTER=:a and log_owner=:b';

Line: 1642

  g_stmt:='select log_table from all_snapshot_logs where MASTER=:a and log_owner=:b';

Line: 1684

  g_stmt:='select refresh_mode,refresh_method,build_mode,last_refresh_type,last_refresh_date, '||
  'staleness from all_mviews where mview_name=:a and owner=:b';

Line: 1732

  g_stmt:='select 1 from all_mviews where mview_name=:a and owner=:b';

Line: 1761

    g_stmt:='select 1 from user_views where view_name=:a';

Line: 1765

    g_stmt:='select 1 from all_views where view_name=:a and owner=:b';

Line: 2154

  g_stmt:='select '||
  'column_name, '||
  'decode(data_type,:1, data_type||''(''||data_length||'')'',data_type) date_type '||
  'from all_tab_columns '||
  'where table_name=:a '||
  'and owner=:b ';

Line: 2485

  l_stmt:='select tablespace_name,initial_extent,next_extent,pct_free,pct_used,pct_increase,max_extents,'||
  'avg_row_len from '||
  'all_tables where table_name=:a and owner=:b';

Line: 2524

  l_stmt:='select index_name,uniqueness,tablespace_name,initial_extent,next_extent,max_extents,pct_increase '||
  'from all_indexes where table_name=:1 and table_owner=:2';

Line: 2598

  l_stmt:='select index_name,column_name from all_ind_columns where index_name=:1 and index_owner=:2 '||
  'order by column_position';

Line: 2635

  g_stmt:='select TABLE_NAME,TABLE_OWNER from user_synonyms where synonym_name=:1';

Line: 2883

  g_stmt:='select 1 from all_mviews where mview_name=:1 and owner=:2';

Line: 2916

    l_stmt:='select 1 from '||p_table||' where rownum=1';

Line: 2918

    l_stmt:='select 1 from '||p_table||' where '||p_where||' and rownum=1';

Line: 2946

  l_stmt:='select 1 from '||p_table||' where '||p_where||' and rownum=1';

Line: 3017

    SELECT WORD FROM BSC_DB_RESERVED_WORDS WHERE WORD IS NOT NULL AND TYPE = 1;

Line: 3019

    SELECT WORD FROM BSC_DB_RESERVED_WORDS WHERE WORD IS NOT NULL AND TYPE = 2;

Line: 3201

cursor c1(p_view varchar2) is select 1 from user_views where view_name like p_view;

Line: 3205

    write_to_log_file_n('select 1 from user_views where view_name like '||p_view_like);

Line: 3238

is select mview_name from all_mview_detail_relations where detailobj_name=p_mv and owner=p_owner;

Line: 3275

is select detailobj_name from all_mview_detail_relations where mview_name=p_mv and owner=p_owner;

Line: 3312

select distinct substr(rels.table_name, 1, instr(rels.table_name, '_', -1))||'MV' from
bsc_db_Tables_rels rels
where rels.source_table_name like p_lower_level
and rels.table_name  not like p_lower_level
and rels.table_name  like 'BSC_S%';

Line: 3319

select 1 from user_objects where object_name = p_higher_level and object_type='VIEW';