NOTE: 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;

Object Name (Type).......................Object Reference (Type)
---------------------------------------- -----------------------------------
DM.CB$CHANNEL_SALES_CHANNEL (MV) ........CHANNELS (TABLE)
.........................................CB$CHANNEL_SALES_CHANNEL (TABLE)
DM.CB$CUSTOMER_REGIONAL (MV) ............CUSTOMERS (TABLE)
.........................................COUNTRIES (TABLE)
.........................................CB$CUSTOMER_REGIONAL (TABLE)
DM.CB$PRODUCT_STANDARD (MV) .............CB$PRODUCT_STANDARD (TABLE)
.........................................PRODUCTS (TABLE)
DM.CB$SALES_CUBE (MV) ...................CUSTOMERS (TABLE)
.........................................COUNTRIES (TABLE)
.........................................CHANNELS (TABLE)
.........................................CB$SALES_CUBE (TABLE)
.........................................SALES (TABLE)
.........................................PRODUCTS (TABLE)
.........................................TIMES (TABLE)
DM.CB$TIME_CALENDAR (MV).. ..............TIMES (TABLE)
.........................................CB$TIME_CALENDAR (TABLE)
DM.CB$TIME_FISCAL (MV) ..................TIMES (TABLE)
.........................................CB$TIME_FISCAL (TABLE)
DM.CHANNEL (CUBE.DIM) ... ...............AW$DM (TABLE)
DM.CHANNELS_DIM (DIM)....................CHANNELS (TABLE)
DM.CHANNEL_SALES_CHANNEL_VIEW (VIEW).....CUBE_TABLE (SYNONYM)
.........................................OLAPIMPL_T (TYPE.BODY)
.........................................CHANNEL (CUBE.DIM)
DM.CHANNEL_VIEW (VIEW)...................CHANNEL (CUBE.DIM)
.........................................CUBE_TABLE (SYNONYM)
.........................................OLAPIMPL_T (TYPE.BODY)
DM.CUSTOMER (CUBE.DIM) ......... ........AW$DM (TABLE)
DM.CUSTOMERS_DIM (DIM)...................COUNTRIES (TABLE)
.........................................CUSTOMERS (TABLE)
DM.CUSTOMER_REGIONAL_VIEW (VIEW).........CUSTOMER (CUBE.DIM)
.........................................CUBE_TABLE (SYNONYM)
.........................................OLAPIMPL_T (TYPE.BODY)
DM.CUSTOMER_VIEW (VIEW)..................OLAPIMPL_T (TYPE.BODY)
.........................................CUSTOMER (CUBE.DIM)
.........................................CUBE_TABLE (SYNONYM)
DM.FORECAST (CUBE).......................AW$DM (TABLE)
DM.FORECAST_VIEW (VIEW)..................FORECAST (CUBE)
.........................................OLAPIMPL_T (TYPE.BODY)
.........................................CUBE_TABLE (SYNONYM)
DM.PRODUCT (CUBE.DIM) ...... ............AW$DM (TABLE)
DM.PRODUCTS_DIM (DIM)....................PRODUCTS (TABLE)
DM.PRODUCT_STANDARD_VIEW (VIEW)..........OLAPIMPL_T (TYPE.BODY)
.........................................CUBE_TABLE (SYNONYM)
.........................................PRODUCT (CUBE.DIM)
DM.PRODUCT_VIEW (VIEW)...................OLAPIMPL_T (TYPE.BODY)
.........................................PRODUCT (CUBE.DIM)
.........................................CUBE_TABLE (SYNONYM)
DM.SALES_CUBE (CUBE).....................AW$DM (TABLE)
DM.SALES_CUBE_JOINED (VIEW)..............CUBE_TABLE (SYNONYM)
.........................................TIME (CUBE.DIMENSION)
.........................................PRODUCT (CUBE.DIM)
.........................................CUSTOMER_REGIONAL_VIEW (VIEW)
.........................................CUSTOMER (CUBE.DIM)
.........................................TIME_CALENDAR_VIEW (VIEW)
.........................................CHANNEL (CUBE.DIM)
.........................................SALES_CUBE_VIEW (VIEW)
.........................................OLAPIMPL_T (TYPE.BODY)
.........................................SALES_CUBE (CUBE)
.........................................PRODUCT_STANDARD_VIEW (VIEW)
.........................................CHANNEL_SALES_CHANNEL_VIEW (VIEW)
DM.SALES_CUBE_VIEW (VIEW)................SALES_CUBE (CUBE)
.........................................OLAPIMPL_T (TYPE.BODY)
.........................................CUBE_TABLE (SYNONYM)
...