DBA Data[Home] [Help]

APPS.AD_ZD_MVIEW dependencies on DBA_SYNONYMS

Line 725: from dba_synonyms

721: if (upper(l_owner) <> l_appsname) then
722:
723: -- test if synonym exists
724: select count(1) INTO l_syn_exist
725: from dba_synonyms
726: where synonym_name=p_mview_name
727: and owner=l_appsname
728: and table_owner=upper(l_owner)
729: and table_name=synonym_name;