During the course of writing the HTMLDB (oracle applications express-APEX- a.k.a TAKFAH) tutorial, I was confronted to the case of the POST-CHANGE trigger (Forms-like) in APEX.

The question was already asked by a user on OTN and I went through an implementation using an idea borrowed from Carl Backstrom.

Here is the problem: you create a report based on one table. However, in one of the region, you want to retrieve the details based on one of the items from another table.

Here is the link: http://forums.oracle.com/forums/thread.jspa?messageID=1234011&#1234011