APEX Application Reports

The APEX Application Reports module includes numerous pre-defined reports that include vast information on all the development aspects of the application, and is divided into four major categories: Shared Components, Page Components, Activity and Cross Application. It can be accessed from the Tasks window on the application home page, or by clicking on the page sheet icon which is the third icon from the right on the Page Definition Action Bar.

I want to draw your attention to the Database Object Dependencies report, as part of the Application section of the Shared Component category. This can be seen in the following screenshot:

This report, which for large APEX applications can be quite "heavy", lists all the database objects that our APEX application depends on, how many times these objects are referenced within the application, and where (drill down to the Reference Count column in the following screenshot):

Besides a great documentation value, this report...