Query para localizar Oracle API para qualquer módulo

select substr(a.OWNER,1,20)

, substr(a.NAME,1,30)

, substr(a.TYPE,1,20) 

, substr(u.status,1,10) Stat

, u.last_ddl_time

, substr(text,1,80) Description 

from dba_source a, dba_objects u 

WHERE 2=2 

and u.object_name = a.name 

and a.text like ‘%Header%’ 

and a.type = u.object_type 

and a.name like ‘PA_%API%’  — Trocar PA pelo sigla do módulo desejado. Exemplo: AP, GL, PO, INV

order by 

a.owner, a.name;