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.

SYS.AD_ZD_SYS dependencies on DBA_USERS

Line 588: and o.owner in ( select username from dba_users where editions_enabled = 'Y')

584: , o.object_type
585: from
586: dba_objects o
587: where o.edition_name <> x_edition
588: and o.owner in ( select username from dba_users where editions_enabled = 'Y')
589: order by o.owner,
590: decode(o.object_type,
591: 'TYPE', 1, /* most types depend on native or other types */
592: 'SYNONYM', 2, /* synonyms point to tables and types */

Line 605: and o1.owner in ( select username from dba_users where editions_enabled = 'Y')

601: select * from
602: (select owner,object_name,object_type
603: from dba_objects o1
604: where o1.edition_name <> x_edition
605: and o1.owner in ( select username from dba_users where editions_enabled = 'Y')
606: and not exists ( select null from dba_dependencies d
607: where d.owner = o1.owner
608: and d.name = o1.object_name
609: and d.type = o1.object_type

Line 610: and d.referenced_owner IN (select username from dba_users where editions_enabled = 'Y')

606: and not exists ( select null from dba_dependencies d
607: where d.owner = o1.owner
608: and d.name = o1.object_name
609: and d.type = o1.object_type
610: and d.referenced_owner IN (select username from dba_users where editions_enabled = 'Y')
611: and d.referenced_type IN ('TYPE','SYNONYM','PACKAGE','VIEW','TYPE BODY','PACKAGE BODY','FUNCTION','PROCEDURE','TRIGGER')
612: )
613: union
614: select owner,object_name,object_type

Line 617: and o2.owner in (select username from dba_users where editions_enabled = 'Y')

613: union
614: select owner,object_name,object_type
615: from dba_objects o2
616: where o2.edition_name <> x_edition
617: and o2.owner in (select username from dba_users where editions_enabled = 'Y')
618: AND o2.object_type = 'PACKAGE BODY'
619: AND NOT EXISTS ( SELECT NULL
620: FROM dba_dependencies c
621: WHERE c.owner = o2.owner

Line 624: AND c.referenced_owner IN (select username from dba_users where editions_enabled = 'Y')

620: FROM dba_dependencies c
621: WHERE c.owner = o2.owner
622: AND c.name = o2.object_name
623: AND c.TYPE = 'PACKAGE BODY'
624: AND c.referenced_owner IN (select username from dba_users where editions_enabled = 'Y')
625: AND c.referenced_type IN ('TYPE','SYNONYM','PACKAGE','VIEW','TYPE BODY','PACKAGE BODY','FUNCTION','PROCEDURE','TRIGGER')
626: AND ( (c.referenced_name <> c.name) or (c.referenced_owner <> c.owner) OR (c.referenced_type <> 'PACKAGE'))
627: )
628: )

Line 639: and o1.owner in ( select username from dba_users where editions_enabled = 'Y')

635: select * from
636: (select owner,object_name,object_type
637: from dba_objects o1
638: where o1.edition_name <> x_edition
639: and o1.owner in ( select username from dba_users where editions_enabled = 'Y')
640: minus
641: select owner,object_name,object_type
642: from dba_objects o2
643: where o2.edition_name <> x_edition

Line 644: and o2.owner in ( select username from dba_users where editions_enabled = 'Y')

640: minus
641: select owner,object_name,object_type
642: from dba_objects o2
643: where o2.edition_name <> x_edition
644: and o2.owner in ( select username from dba_users where editions_enabled = 'Y')
645: and not exists ( select null from dba_dependencies d
646: where d.owner = o2.owner
647: and d.name = o2.object_name
648: and d.type = o2.object_type

Line 649: and d.referenced_owner IN (select username from dba_users where editions_enabled = 'Y')

645: and not exists ( select null from dba_dependencies d
646: where d.owner = o2.owner
647: and d.name = o2.object_name
648: and d.type = o2.object_type
649: and d.referenced_owner IN (select username from dba_users where editions_enabled = 'Y')
650: and d.referenced_type IN ('TYPE','SYNONYM','PACKAGE','VIEW','TYPE BODY','PACKAGE BODY','FUNCTION','PROCEDURE','TRIGGER')
651: )
652: minus
653: select owner,object_name,object_type

Line 656: and o3.owner in ( select username from dba_users where editions_enabled = 'Y')

652: minus
653: select owner,object_name,object_type
654: from dba_objects o3
655: where o3.edition_name <> x_edition
656: and o3.owner in ( select username from dba_users where editions_enabled = 'Y')
657: AND o3.object_type = 'PACKAGE BODY'
658: AND NOT EXISTS ( SELECT NULL
659: FROM dba_dependencies c
660: WHERE c.owner = o3.owner

Line 663: AND c.referenced_owner IN (select username from dba_users where editions_enabled = 'Y')

659: FROM dba_dependencies c
660: WHERE c.owner = o3.owner
661: AND c.name = o3.object_name
662: AND c.TYPE = 'PACKAGE BODY'
663: AND c.referenced_owner IN (select username from dba_users where editions_enabled = 'Y')
664: AND c.referenced_type IN ('TYPE','SYNONYM','PACKAGE','VIEW','TYPE BODY','PACKAGE BODY','FUNCTION','PROCEDURE','TRIGGER')
665: AND ( (c.referenced_name <> c.name) or (c.referenced_owner <> c.owner) OR (c.referenced_type <> 'PACKAGE'))
666: )
667: )

Line 817: and o.owner in ( select username from dba_users where editions_enabled = 'Y')

813: , o.object_type
814: from
815: dba_objects o
816: where o.edition_name <> x_edition
817: and o.owner in ( select username from dba_users where editions_enabled = 'Y')
818: and o.object_name like 'AD_ZD%'
819: and o.object_type in ('PACKAGE','PACKAGE BODY')
820: order by o.owner,
821: decode(o.object_type,