APPS.EDW_OWB_COLLECTION_UTIL dependencies on ALL_MVIEWS

Line 11209: ALL_MVIEWS mv,

11205: --
11206: cursor c1(p_object varchar2,p_owner varchar2) is
11207: select 1
11208: from
11209: ALL_MVIEWS mv,
11210: ALL_MVIEW_DETAIL_RELATIONS rel
11211: where
11212: rel.mview_name=mv.mview_name
11213: and mv.owner=rel.owner

Line 11224: write_to_log_file('select 1 from ALL_MVIEWS mv, ALL_MVIEW_DETAIL_RELATIONS rel '||

11220: --
11221: Begin
11222: if g_debug then
11223: write_to_log_file_n('In is_source_for_fast_refresh_mv');
11224: write_to_log_file('select 1 from ALL_MVIEWS mv, ALL_MVIEW_DETAIL_RELATIONS rel '||
11225: ' where rel.mview_name=mv.mview_name and mv.owner=rel.owner and mv.fast_refreshable<>''NO'''||
11226: ' and rel.detailobj_name='||p_object||' and rel.detailobj_owner='||p_owner);
11227: end if;
11228: open c1(p_object,p_owner);