APPS.EDW_CLEAN_OBJECT SQL Statements

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

Line: 70

  l_stmt:='select syn.table_owner '||
          ' from user_synonyms syn, edw_dimensions_md_v dim, edw_levels_md_v lvl'||
  	  ' where dim.dim_name=:a and lvl.dim_id=dim.dim_id and syn.table_name=lvl.level_name||:b'; ----bug#4905343

Line: 78

  l_stmt:='select ltc.name,lstg.name,snplog.log_table from edw_tables_md_v ltc, edw_dimensions_md_v dim, '||
   'edw_levels_md_v lvl, edw_tables_md_v lstg,all_snapshot_logs snplog,edw_pvt_map_properties_md_v map, '||
   'user_synonyms syn '||
   'where dim.dim_name=:a '||
   'and lvl.dim_id=dim.dim_id and ltc.name=lvl.level_name||:b '|| --bug#4905343
   'and map.primary_target(+)=ltc.elementid and map.primary_source=lstg.elementid(+) '||
   'and snplog.master=ltc.name and snplog.log_owner=:c';

Line: 138

        l_stmt:='update '||g_lstg_tables(i)||' set collection_status=''READY'' where collection_status<>''READY'' '||
        ' and rownum<=100000';

Line: 209

  l_stmt:='select 1 from edw_dimensions_md_v where dim_name=:a';

Line: 233

  l_stmt:='select rel.name from edw_tables_md_v rel,edw_pvt_map_properties_md_v map,edw_facts_md_v tgt '||
  'where tgt.fact_name=:a and map.primary_target=tgt.fact_id '||
  'and rel.elementid=map.primary_source ';

Line: 241

  g_fact_dlog:=EDW_OWB_COLLECTION_UTIL.get_log_for_table(p_fact,'Delete Log');

Line: 249

  l_stmt:='select distinct cube_src.fact_id||''_''||cube.fact_id from edw_facts_md_v cube,edw_facts_md_v cube_src, '||
   'edw_pvt_map_properties_md_v map where map.primary_target=cube.fact_id and map.primary_source=cube_src.fact_id  '||
   'and cube_src.fact_name=:a';

Line: 266

  l_stmt:='select distinct cube_src.fact_id||''_''||cube.fact_id from edw_facts_md_v cube,edw_facts_md_v '||
  'cube_src, edw_pvt_map_properties_md_v map where map.primary_source=cube.fact_id and '||
  'map.primary_target=cube_src.fact_id  '||
  'and cube_src.fact_name=:a';

Line: 352

      l_stmt:='update '||g_fstg_table||' set collection_status=''READY'' where collection_status<>''READY'' '||
      ' and rownum<=100000';

Line: 395

  l_stmt:='select relation_name from edw_relations_md_v where relation_long_name=:a';