109: where mview_name = p_mvname
110: AND owner = p_apps_schema_name
111: UNION ALL
112: SELECT NVL(compile_state, 'NA') 113: FROM all_mviews mvs, user_synonyms s 114: WHERE mvs.owner = s.table_owner
115: AND mvs.mview_name = s.table_name
116: AND mview_name = p_mvname;
117: