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.

SYSTEM.AD_INST dependencies on DBA_OBJECTS

Line 24: select object_name, object_type from dba_objects

20: PRAGMA EXCEPTION_INIT(success_with_comp_error, -24344);
21: -- compile packages first, then views, then bodies
22: -- this is because a view could reference a package header
23: cursor c1 is
24: select object_name, object_type from dba_objects
25: where owner = upper(compile_schema.in_schema)
26: and status = 'INVALID'
27: and object_type = 'PACKAGE';
28: cursor c2 is

Line 29: select object_name, object_type from dba_objects

25: where owner = upper(compile_schema.in_schema)
26: and status = 'INVALID'
27: and object_type = 'PACKAGE';
28: cursor c2 is
29: select object_name, object_type from dba_objects
30: where owner = upper(compile_schema.in_schema)
31: and status = 'INVALID'
32: and object_type = 'VIEW';
33: cursor c3 is

Line 34: select object_name, object_type from dba_objects

30: where owner = upper(compile_schema.in_schema)
31: and status = 'INVALID'
32: and object_type = 'VIEW';
33: cursor c3 is
34: select object_name, object_type from dba_objects
35: where owner = upper(compile_schema.in_schema)
36: and status = 'INVALID'
37: order by decode(object_type,'PACKAGE',1,'VIEW',2,'PACKAGE BODY',4,3);
38: