DBA Data[Home] [Help]

APPS.BIS_MV_REFRESH dependencies on USER_SYNONYMS

Line 113: FROM all_mviews mvs, user_synonyms s

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: