APPS.AD_MV SQL Statements

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

Line: 58

      SELECT oracle_username
      INTO   l_appsuser
      FROM   fnd_oracle_userid
      WHERE  read_only_flag='U';

Line: 64

      SELECT editions_enabled
      INTO   l_enabled
      FROM   dba_users
      WHERE  username=l_appsuser;

Line: 90

      ga_stmt.DELETE;

Line: 123

       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: 149

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

Line: 166

            ga_stmt.DELETE;

Line: 244

         ga_stmt.DELETE;

Line: 251

            ga_stmt.DELETE;

Line: 392

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