Oracle PL/SQL/System Tables Views/dba dependencies

Query dba_dependencies

 
SQL>
SQL> set linesize 132
SQL>  column referenced_object format a35
SQL>  clear breaks
breaks cleared
SQL>  break on name on type
SQL>
SQL>  select name,type,referenced_owner ||"."|| referenced_name referenced_object
  2   from dba_dependencies
  3   where owner = "HR"
  4   /
NAME                           TYPE              REFERENCED_OBJECT
------------------------------ ----------------- -----------------------------------
UPDATE_JOB_HISTORY             TRIGGER           SYS.STANDARD
ADD_JOB_HISTORY                PROCEDURE         SYS.STANDARD
SECURE_DML                     PROCEDURE         SYS.STANDARD
                                                 SYS.DBMS_STANDARD
ADD_JOB_HISTORY                PROCEDURE         SYS.SYS_STUB_FOR_PURITY_ANALYSIS
SECURE_DML                     PROCEDURE         SYS.SYS_STUB_FOR_PURITY_ANALYSIS
EMP_DETAILS_VIEW               VIEW              HR.REGIONS
                                                 HR.COUNTRIES
                                                 HR.LOCATIONS
                                                 HR.DEPARTMENTS
                                                 HR.JOBS
UPDATE_JOB_HISTORY             TRIGGER           HR.EMPLOYEES
SECURE_EMPLOYEES               TRIGGER           HR.EMPLOYEES
EMP_DETAILS_VIEW               VIEW              HR.EMPLOYEES
ADD_JOB_HISTORY                PROCEDURE         HR.JOB_HISTORY
SECURE_EMPLOYEES               TRIGGER           HR.SECURE_DML
UPDATE_JOB_HISTORY             TRIGGER           HR.ADD_JOB_HISTORY
17 rows selected.
SQL> --

Query dba_dependencies by owner and referenced_name

 
SQL>
SQL>
SQL> select owner || "." || name name, type, dependency_type
  2  from dba_dependencies
  3  where referenced_owner = "HR" and referenced_name = "EMPLOYEES"
  4  /
NAME                           TYPE              DEPE
------------------------------ ----------------- ----
HR.EMP_DETAILS_VIEW            VIEW              HARD
HR.SECURE_EMPLOYEES            TRIGGER           HARD
HR.UPDATE_JOB_HISTORY          TRIGGER           HARD
3 rows selected.
SQL>
SQL> --