APPS.BSC_MV_ADAPTER SQL Statements

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

Line: 371

          if l_line_type(j)='SELECT' then
            if j=1 then
              l_mv_stmt:=l_mv_stmt||l_line(j);

Line: 377

          elsif l_line_type(j)='SELECT INC' then
            if l_fast_refresh_mv then
              l_mv_stmt:=l_mv_stmt||l_line(j);

Line: 530

      'DEMAND AS SELECT '||p_b_tables(i)||'.*,'||p_b_tables(i)||'.rowid row_id from '||
      g_bsc_owner||'.'||p_b_tables(i)||' '||p_b_tables(i)||
      ' where 1=2';

Line: 567

select count(1) from all_objects where
owner=p_owner and object_name=p_zmv_name
and object_type = 'MATERIALIZED VIEW';

Line: 610

select count(1) from user_indexes where index_name=p_index_name
and table_name = p_mv_name and table_owner=p_mv_owner;

Line: 786

    l_zero_code_cols.delete;

Line: 787

    l_nonzero_code_cols.delete;

Line: 933

select relation_col
 from bsc_sys_dim_level_rels rels ,bsc_sys_dim_levels_b levels
 where levels.level_table_name=p_object
 and rels.dim_level_id=levels.dim_level_id;

Line: 985

  select count(1) into l_dim from bsc_sys_dim_levels_b where level_table_name=p_object;