Talking about Schema browser/Describe window.
For packages there is “Deps (Uses)” and “Deps (Used By)”, but for objects there is only “Dependencies” which only shows the references to the current object.
Would it be possible to implement the other direction too? dba_dependencies should contain the necessary information.
In the following example, referenced_type shows that referencing_type depends on it, but referencing_type does not display this information.
CREATE TYPE referenced_type AS OBJECT (
CREATE TYPE referencing_type AS OBJECT (