DBA Data[Home] [Help]

APPS.AD_ZD_MVIEW dependencies on AD_OBSOLETE_OBJECTS

Line 1876: , ad_obsolete_objects aoo

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

Line 1901: , ad_obsolete_objects aoo

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