APPS.BSC_OLAP_MAIN SQL Statements

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

Line: 58

   l_stmt := ' insert into '||g_col_type_table_name||'(level_table_name, data_type)
              select distinct dim.level_table_name,col.data_type
              from
              bsc_kpi_dim_levels_b dim,
              all_tab_columns col
              where
              dim.level_table_name=col.table_name
              and col.column_name=:1
              and col.owner=:2
              union all
              select distinct dim.level_table_name,col.data_type
              from
              all_tab_columns col,
              bsc_kpi_dim_levels_b dim
              where
              dim.level_table_name=col.table_name
              and col.column_name=:3
              and col.owner =:4';

Line: 88

    l_stmt := 'insert into '||g_col_type_table_name||'(level_table_name, data_type)
            select distinct dim.level_table_name,col.data_type
              from
              all_tab_columns col,
			  bsc_kpi_dim_levels_b dim,
              bsc_kpis_vl kpi
              where
                  (kpi.prototype_flag not in (1,2,3,4) OR '||
              l_cur_run_kpis||
              ') and kpi.indicator=dim.indicator
              and dim.level_table_name=col.table_name
              and col.column_name=:1
              and col.owner =:2
	      union all
	      select distinct dim.level_table_name,col.data_type
              from
              all_tab_columns col,
              bsc_kpi_dim_levels_b dim,
              bsc_kpis_vl kpi
              where
                  (kpi.prototype_flag not in (1,2,3,4) OR '||
              l_cur_run_kpis||
              ')and kpi.indicator=dim.indicator
              and dim.level_table_name=col.table_name
              and col.column_name=:3
              and col.owner =:4';