Sunday, October 19, 2014

Script To get Oracle API’s for any module

Here is the script used to get the API’s for any module

select a.owner,, a.type,
          u.status Status, u.last_ddl_time,
          substr(text, 1, 80) Description
   from dba_source a, dba_objects u
 where u.object_name =
    and a.text like '%Header%'
    and a.type = u.object_type
    and like 'AR_%API%' -- you can changed module wise
  order by a.owner,;

1 comment:

  1. Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check