I'm working with Oracle APEX 23.1. I want to create a list of value (LOV_item1) based on value of an application item (APP_item1). APP_item1 has a corresponding application computation which is calculated before header. Apparently, SQL query in LOV_item1 cannot read value of APP_item1, hence no value is shown when I use LOV_item1 in page 1.
Do I miss something when implementing APP_item1?