I created a LoV for the a page item with following PL/SQL Code:
SELECT r.REASON AS displayed, r.CODE
FROM REFUSAL_REASONS r
WHERE CODE='R';
I have set the following properties in the column mapping: Return Value:SHORTCODE, Display: DIISPLAYED, Default Sort: DISPLAYED
The problem is all reasons are displayed. However, no matter what I select, the same reason is always selected.