SYS.ALL_DEPENDENCIES

The ALL_DEPENDENCIES view describes dependencies between procedures, packages, functions, and package bodies accessible to the current user.

Related views

• SYS.DBA_DEPENDENCIES describes all dependencies between objects in the database.

• SYS.USER_DEPENDENCIES describes dependencies between objects that are owned by the current user.

Columns

Column name	Type	Description
OWNER	VARCHAR2(30) INLINE	Object owner
NAME	VARCHAR2(30) INLINE	Object name
TYPE	VARCHAR2(17) INLINE NOT NULL	Object type
REFERENCED_OWNER	VARCHAR2(30) INLINE	Owner of the referenced object
REFERENCED_NAME	VARCHAR2(30) INLINE	Name of the referenced object
REFERENCED_TYPE	VARCHAR2(17) INLINE NOT NULL	Type of the referenced object
REFERENCED_LINK_NAME	VARCHAR2(128) INLINE	Unused (Column unused by TimesTen. Ignore value.)
DEPENDENCY_TYPE	VARCHAR2(4) INLINE NOT NULL	REF for REF dependency HARD otherwise