DBA Dependencies (uses)

➜ Back to Library
Description
Categories: Enginatics, Kcapps
Repository: Github
Hierarchical report showing all dependent database objects that a specified object, e.g. a view or package name uses or depends on (top to bottom)
Run DBA Dependencies (uses) and other Oracle EBS reports with Blitz Report™ on our demo environment
select
'0' level_,
lower(do.owner||'.'||do.object_name) object,
do.owner,
do.object_name,
do.object_type,
lower(do.owner||'.'||do.object_name) path
from
dba_objects do
where
do.owner=:owner and
do.object_name=:object_name and
do.object_type=:object_type and
1=1
union all
select
lpad(' ',2*(level))||level level_,
lower(lpad(' ',2*(level))||dd.referenced_owner||'.'||dd.referenced_name) object,
dd.referenced_owner owner,
dd.referenced_name object_name,
dd.referenced_type object_type,
lower(:owner||'.'||:object_name||sys_connect_by_path(dd.referenced_owner||'.'||dd.referenced_name,' > ')) path
from
dba_dependencies dd
where
dd.owner not in ('SYS','SYSTEM','PUBLIC') and
dd.referenced_owner not in ('SYS','SYSTEM','PUBLIC') and
dd.referenced_type<>'NON-EXISTENT'
connect by nocycle
prior dd.referenced_owner=dd.owner and
prior dd.referenced_name=dd.name and
prior dd.referenced_type=dd.type
start with
dd.owner=:owner and
dd.name=:object_name and
dd.type=:object_type
Parameter Name SQL text Validation
Owner 
 
 LOV
Object Type 
 
 LOV
Object Name 
 
 LOV
Download
Related Blitz Reports
RWB Database Objects used by Report Views DBA Dependencies (used by) DBA Result Cache Objects and Invalidations DBA Blocking Sessions DIS End User Layers DBA AWR Blocking Session Summary DBA AWR Active Session History DBA SGA Buffer Cache Object Usage DBA SGA Active Session History
Blitz Report™

Blitz Report™ provides multiple benefits: