Query to find all APIs of Oracle Apps modules
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) Desc...3 posts
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) Desc...--Tax rate and account query
SELECT rb.tax_regime_code,
rb.tax,
rb.rate_type_code,
rb.percentage_rate,
rb.last_update_date,
za.last_update_date,
...--Customer Account Tax Registration Details
SELECT party_name,
account_number,
ps.party_site_number,
(SELECT LISTAGG (al.meaning, ', ') WITHIN GROUP (ORDER BY al.meaning)
...