Reverse engineering object DDL on oracle comes out to be a great solution many times. It helps not only to determine the dependencies but also to move the database objects from one location to another. The link below provides valuable information how reverse engineering comes out to be helpful.
Reverse engineering object DDL and finding object dependencies | Oracle FAQ.
