Query to find all APIs of Oracle Apps modules

1SELECT SUBSTR (a.OWNER, 1, 20),
2         SUBSTR (a.NAME, 1, 30),
3         SUBSTR (a.TYPE, 1, 20),
4         SUBSTR (u.status, 1, 10) Stat,
5         u.last_ddl_time,
6         SUBSTR (text, 1, 80)   Description
7    FROM dba_source a, dba_objects u
8   WHERE     u.object_name = a.name
9         AND a.text LIKE '%Header%'
10         AND a.TYPE = u.object_type
11         AND a.name LIKE 'AR_%API%'               -- Check for AR Related APIs
12ORDER BY a.owner, a.name;