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_ZD_TABLE dependencies on DBA_OBJECTS

Line 657: -- dba_objects. At present there is a huge performance

653:
654: -- Bug 13597311. Adding valid state to decide
655: -- whether to force recompile a trigger or not.
656: -- This can be also done in CURSOR c_trg by joining
657: -- dba_objects. At present there is a huge performance
658: -- drop in the resultant query. Taking suggestion from
659: -- perf team.
660: -- TODO: If perf team can suggest a single query, it would
661: -- help optimize further.

Line 665: from dba_objects

661: -- help optimize further.
662:
663: select status
664: into l_valid_status
665: from dba_objects
666: where owner = trg_rec.owner
667: and object_name = trg_rec.trigger_name
668: and object_type = 'TRIGGER';
669: