APPS.MSC_REFRESH_MV SQL Statements

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

Line: 17

    SELECT a.oracle_username
    FROM   FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b
    WHERE  a.oracle_id = b.oracle_id
    AND    b.application_id= p_schema_id;

Line: 23

    SELECT 1
    FROM   all_objects
    WHERE  object_name = p_mv_trim_name
    AND    owner = p_schema_name;

Line: 32

      select nvl(ltrim(rtrim(upper(p_mv_name))), '@@@') into l_mv_name from dual;