DBA Dependencies (uses)

Description
Categories: Enginatics
Repository: Github
Hierarchical report showing all dependent database objects used by a specified object
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
Object Name
 
LOV
Object Type
 
LOV
Owner
 
LOV