Oracle Apex Reports

In Oracle Apex 3 (possibly 4) there are a number of views that allow you to query the tables that form the apex pages, this includes vies of forms, items, buttons etc.

I've found this particularly useful when looking for particular bits of SQL and PL/SQL code where it is not practical to look through all of the pages.

To list the apex tables run this query on the system schema:

select * from ALL_VIEWS

where VIEW_NAME LIKE 'APEX_%'

and the views that I've found most useful are the APEX_APPLICATION_PAGE_* tables.