APPS.AD_ZD_MVIEW dependencies on FND_ORACLE_USERID

Line 1759: ( select oracle_username from system.fnd_oracle_userid

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 '%#'
1762: and lvv.editioning_view = 'N'
1763: and eusr.edition_name = sys_context('userenv', 'current_edition_name')

Line 1866: ( select oracle_username from fnd_oracle_userid

1862: select m.owner owner,
1863: m.mview_name name
1864: from dba_mviews m
1865: where m.owner in
1866: ( select oracle_username from fnd_oracle_userid
1867: where read_only_flag in ('A', 'E', 'U', 'B') )
1868: and not exists
1869: ( select 'X' from dba_views v
1870: where v.owner = m.owner

Line 1874: from fnd_oracle_userid fou

1870: where v.owner = m.owner
1871: and v.view_name = ad_zd_mview.get_mvq_name(m.mview_name) )
1872: and not exists
1873: ( select 'X'
1874: from fnd_oracle_userid fou
1875: , fnd_product_installations fpi
1876: , ad_obsolete_objects aoo
1877: where fpi.application_id = aoo.application_id
1878: and fou.oracle_id = fpi.oracle_id

Line 1889: ( select oracle_username from fnd_oracle_userid

1885: from dba_views v
1886: where v.view_name like '%'||'#'
1887: and v.editioning_view = 'N'
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

Line 1899: from fnd_oracle_userid fou

1895: and m.object_type = 'MATERIALIZED VIEW'
1896: and m.status = 'VALID' )
1897: and not exists
1898: ( select 'X'
1899: from fnd_oracle_userid fou
1900: , fnd_product_installations fpi
1901: , ad_obsolete_objects aoo
1902: where fpi.application_id = aoo.application_id
1903: and fou.oracle_id = fpi.oracle_id