SYS.DBA_DEPENDENCIES

DBA_DEPENDENCIES describes all dependencies between objects in the database. This view does not display the SCHEMAID column. See "SYS.ALL_DEPENDENCIES" for column descriptions.