APPS.AD_ZD_MVIEW dependencies on DBA_OBJECTS

Line 1757: , dba_objects mvo

1753: (select * from sys.user$ where type# = 2) xusr
1754: , (select * from sys.obj$ where owner# = 0 and type# = 57) ed
1755: where xusr.spare2 = ed.obj# ) eusr
1756: , dba_views lvv
1757: , dba_objects mvo
1758: where lvv.owner in
1759: ( select oracle_username from system.fnd_oracle_userid
1760: where read_only_flag in ('A', 'E', 'U', 'B') )
1761: and lvv.view_name like '%#'

Line 1892: ( select 'X' from dba_objects m

1888: and v.owner in
1889: ( select oracle_username from fnd_oracle_userid
1890: where read_only_flag in ('A', 'E', 'U', 'B') )
1891: and not exists
1892: ( select 'X' from dba_objects m
1893: where m.owner = v.owner
1894: and m.object_name = ad_zd_mview.get_mv_name(v.view_name)
1895: and m.object_type = 'MATERIALIZED VIEW'
1896: and m.status = 'VALID' )