To Determine an Object's Dependencies

I am looking at the schema 'DM' please edit for your schema.

set pages500 lines110
col objdep format a40 hea "Object Name (Type)"
col refr format a35 hea "Object Reference (Type)"

variable usn varchar2(20);
exec :usn := 'DM';

break on objdep

select owner||'.'||name||' ('||decode(type,'MATERIALIZED VIEW', 'MV', 'DIMENSION', 'DIM','EVALUATION CONTXT', 'EVALCTXT', 'PACKAGE BODY', 'PKGBDY','CUBE.DIMENSION','CUBE.DIM', type)||')' objdep,
referenced_name||' ('||decode(referenced_type,'EVALUATION CONTXT', 'EVALCTXT', 'NON-EXISTENT CONTXT','NO-EXIST',
'PACKAGE BODY','PKGBDY', 'CUBE.DIMENSION','CUBE.DIM', referenced_type)||')' refr
from dba_dependencies where owner=:usn order by objdep;