Notes on Oracle’s solution to find object dependencies, DEPTREE. Written in 1991, and still included on installation.
Script to find all generations Of an object’s children. Children. Grandchildren. Great-Grandchildren. Great-Great-Grandchildren. Etc.
What if some of your objects require parent objects 10 layers deep first? ie: type, table, function, view, synonym, package, procedure, etc. All_Dependencies only goes one layer deep.
Here is a very complex script to find all the successive parents of an object.