eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AD_OBSOLETE_PRODUCTS dependencies on DBA_SYNONYMS

Line 144: TYPE ds_obj_name IS TABLE OF dba_synonyms.synonym_name%TYPE;

140:
141:
142: procedure drop_synonym_all (x_appl_id in number,
143: x_app_short_name in varchar2) is
144: TYPE ds_obj_name IS TABLE OF dba_synonyms.synonym_name%TYPE;
145: TYPE obs_obj_type IS TABLE OF AD_OBSOLETE_OBJECTS.object_type%TYPE;
146: TYPE obs_obj_name IS TABLE OF AD_OBSOLETE_OBJECTS.object_name%TYPE;
147:
148: ds_object_name ds_obj_name;

Line 188: from dba_synonyms

184: -- get the list of all
185:
186: select synonym_name
187: bulk collect into ds_object_name
188: from dba_synonyms
189: where TABLE_OWNER = l_schema_name
190: and synonym_name not in
191: (select object_name
192: from AD_OBSOLETE_OBJECTS