APPS.EDW_ANALYZE_OBJECT SQL Statements

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

Line: 79

    l_stmt:='select dim_name,dim_long_name from edw_dimensions_md_v';

Line: 91

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

Line: 122

    l_stmt:='select ltc.name,ltc.long_name '||
    'from '||
    'edw_tables_md_v ltc, '||
    'edw_dimensions_md_v dim, '||
    'edw_levels_md_v lvl '||
    'where dim.dim_name=:a '||
    'and lvl.dim_id=dim.dim_id '||
    'and ltc.name=lvl.level_name||''_LTC''';

Line: 165

    l_stmt:='select lstg.name,lstg.long_name '||
    'from '||
    'edw_tables_md_v ltc, '||
    'edw_tables_md_v lstg, '||
    'edw_pvt_map_properties_md_v map, '||
    'edw_dimensions_md_v dim, '||
    'edw_levels_md_v lvl '||
    'where dim.dim_name=:a '||
    'and lvl.dim_id=dim.dim_id '||
    'and ltc.name=lvl.level_name||''_LTC'' '||
    'and map.primary_target=ltc.elementid '||
    'and lstg.elementid=map.primary_source ';

Line: 232

    l_stmt:='select fact_name,fact_longname from edw_facts_md_v';

Line: 244

    l_stmt:='select fact_name from edw_facts_md_v where fact_longname=:a';

Line: 286

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