APPS.MSC_PS_SNO_TAB_ANLYZ SQL Statements

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

Line: 15

    V_QUERY_STR1 := 'SELECT DISTINCT A.TABLE_NAME TABLE_NAME ' ||
		    'FROM DBA_TABLES A, MSC_INT_MODEL_NAVIGATION B '||
		    'WHERE A.TABLE_NAME   = TRIM(UPPER(B.TABLE_NAME)) '||
		      'AND A.OWNER        = MSC_UTIL.GET_SCHEMA_NAME(724) '||
                      'AND UPPER(B.MODEL) = :V_MODEL ';

Line: 21

    SELECT TRIM(UPPER(TABLE_NAME)) INTO T_NAME
      FROM DBA_TABLES
     WHERE TABLE_NAME = 'MSC_INT_MODEL_NAVIGATION'
       AND OWNER      = MSC_UTIL.GET_SCHEMA_NAME(724);

Line: 32

            EXECUTE IMMEDIATE 'ANALYZE TABLE '||MSC_UTIL.GET_SCHEMA_NAME(724)||'.'||LV_TAB||' DELETE STATISTICS';