We all know about the apex views but hardly use them. Today, I answered two questions in the oracle Forum where the solution was related to the apex views. The first question was on how to create a report with all the csv links for all the reports in an application:
http://forums.oracle.com/forums/thread.jspa?threadID=952151
The second question was on how to provide a generic solution for a page help functionality:
http://forums.oracle.com/forums/thread.jspa?threadID=952469
Basically, the usage of apex views provides a simple two-step solution which doesn't require any maintanance.
In my demo application, you will find the corresponding examples:
Report on all csv links
Help page
Try it out.