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
1879: and fou.oracle_username = m.owner
1880: and aoo.object_name = m.mview_name
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
1904: and fou.oracle_username = v.owner
1905: and aoo.object_name = v.view_name