depend.sql

select substr(name,1,27) "NAME",'~',substr(type,1,9) "TYPE",'~',
       substr(referenced_owner,1,5) "OWNER",'~',
       substr(referenced_name,1,27) "REF_NAME",'~',
       substr(referenced_type,1,9) "REF_TYPE"
 from all_dependencies where owner='ACME' 
 order by owner, name
/