DBA Data[Home] [Help]

APPS.AD_ZD_MVIEW dependencies on FND_PRODUCT_INSTALLATIONS

Line 1875: , fnd_product_installations fpi

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
1879: and fou.oracle_username = m.owner

Line 1900: , fnd_product_installations fpi

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
1904: and fou.oracle_username = v.owner