APPS.AD_MV SQL Statements

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

Line: 76

       SELECT 'x'
         INTO ls_dummy
         FROM user_tables
            , user_mviews
        WHERE table_name = mview_name
          AND mview_name = create_mv.as_mview_name_i
          AND NOT EXISTS (
                SELECT null
                  FROM user_objects
                 WHERE object_type = 'MATERIALIZED VIEW'
                   AND object_name = table_name
                   AND object_name = create_mv.as_mview_name_i
              )
       ;

Line: 100

         l_statement := 'select version from v$instance';

Line: 121

         ga_stmt.DELETE;

Line: 130

            ga_stmt.DELETE;

Line: 212

         ga_stmt.DELETE;

Line: 220

            ga_stmt.DELETE;

Line: 329

    EXECUTE IMMEDIATE 'ALTER SESSION SET "_mv_refresh_selections"=TRUE';