Find Object Dependencies

Submitted by code_admin on Fri, 07/20/2018 - 12:55

Find what object reference a particular package

  1. select *
  2. from ALL_DEPENDENCIES
  3. where referenced_name = 'IC_DISCO_GMS_PKG'
  4. and referenced_owner = 'APPS'
  5. order by owner
  6. ;

Tags

RJM Article Type
Quick Reference