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.

[Home] [Help]

SYS.AD_ZD_SYS dependencies on DBA_OBJECTS

Line 106: dba_objects_ae oe,

102: -- old editions that can be used
103: cursor C_OLD_EDITIONS is
104: select oe.object_name edition_name
105: from
106: dba_objects_ae oe,
107: dba_objects_ae re,
108: database_properties RUN
109: where run.property_name = 'DEFAULT_EDITION'
110: /* run edition */

Line 107: dba_objects_ae re,

103: cursor C_OLD_EDITIONS is
104: select oe.object_name edition_name
105: from
106: dba_objects_ae oe,
107: dba_objects_ae re,
108: database_properties RUN
109: where run.property_name = 'DEFAULT_EDITION'
110: /* run edition */
111: and re.owner = 'SYS'

Line 350: , dba_objects_ae oe /* old edition */

346: where ed.name = 'ORA$BASE' ) eusr
347: where obj.owner# = eusr.user#
348: and obj.type# not in (10, 0)
349: and obj.remoteowner is null ) co
350: , dba_objects_ae oe /* old edition */
351: , dba_objects_ae re /* run edition */
352: , database_properties run /* run edition name */
353: where run.property_name = 'DEFAULT_EDITION'
354: /* run edition */

Line 351: , dba_objects_ae re /* run edition */

347: where obj.owner# = eusr.user#
348: and obj.type# not in (10, 0)
349: and obj.remoteowner is null ) co
350: , dba_objects_ae oe /* old edition */
351: , dba_objects_ae re /* run edition */
352: , database_properties run /* run edition name */
353: where run.property_name = 'DEFAULT_EDITION'
354: /* run edition */
355: and re.owner = 'SYS'

Line 369: from dba_objects_ae ro /* replacement object */

365: ('SYNONYM', 'VIEW',
366: 'PACKAGE', 'PACKAGE BODY', 'TYPE', 'TYPE BODY',
367: 'PROCEDURE', 'FUNCTION', 'TRIGGER') /* editioned type */
368: and exists ( select null
369: from dba_objects_ae ro /* replacement object */
370: , dba_objects_ae ne /* newer edition */
371: where ro.owner = co.owner
372: and ro.object_type in (co.object_type, 'NON-EXISTENT')
373: and ro.object_name = co.object_name

Line 370: , dba_objects_ae ne /* newer edition */

366: 'PACKAGE', 'PACKAGE BODY', 'TYPE', 'TYPE BODY',
367: 'PROCEDURE', 'FUNCTION', 'TRIGGER') /* editioned type */
368: and exists ( select null
369: from dba_objects_ae ro /* replacement object */
370: , dba_objects_ae ne /* newer edition */
371: where ro.owner = co.owner
372: and ro.object_type in (co.object_type, 'NON-EXISTENT')
373: and ro.object_name = co.object_name
374: and ro.namespace = co.namespace

Line 507: from dba_objects_ae

503: l_patch_edition := NULL;
504: end;
505:
506: select count(*) into l_count
507: from dba_objects_ae
508: where owner = x_owner
509: and object_name = x_object_name
510: and object_type = x_object_type
511: and edition_name = l_patch_edition;

Line 547: ** Make 2 passes of dba_objects. During the first pass, select objects with no dependencies

543: ** Bug 12938985
544: ** Execute immediate mode actualizes all the objects in a single iteration
545: **
546: ** Parallel workers mode uses the foll. approach
547: ** Make 2 passes of dba_objects. During the first pass, select objects with no dependencies
548: ** (i.e LIST1) and in the second pass do the rest (i.e LIST2). This is done for performance
549: ** optimization and to minimize the locking contention while running in parallel workers mode.
550: **
551: ** LIST1 - contains all the objects with no dependencies. Used during parallel workers mode

Line 586: dba_objects o

582: o.owner
583: , o.object_name
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,

Line 603: from dba_objects o1

599:
600: cursor C_INHERITED_OBJECTS_LIST1(x_edition varchar2) is
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

Line 615: from dba_objects o2

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
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

Line 637: from dba_objects o1

633:
634: cursor C_INHERITED_OBJECTS_LIST2(x_edition varchar2) is
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

Line 642: from dba_objects o2

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
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

Line 654: from dba_objects o3

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
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

Line 680: from dba_objects

676:
677:
678: cursor C_EDITION(x_owner varchar2 ,x_object_name varchar2 ,x_object_type varchar2) is
679: select edition_name
680: from dba_objects
681: where owner = x_owner
682: and object_name = x_object_name
683: and object_type = x_object_type;
684:

Line 815: dba_objects o

811: o.owner
812: , o.object_name
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')