Try to set two POPUPKEY_FROM_LOVs beside each other with the column ids: 2,3
When you run the page then APEX automatically creates a hidden field for the return value of the "popup lov".
The output looks like that:
column "application": Return column id = 2, Display column id = 3
column "system": Return column id = 3, Display column id = 4
If you set a value for column "system" it saves the "return value" in the "display value"-field of column "application".
Workaround: Use at least two numbers in between to avoid this behavior:
select
APEX_ITEM.CHECKBOX (1,ac.ac_id) as ac_id,
APEX_ITEM.POPUPKEY_FROM_LOV(2,ac.application_key,'lov_apps',50) as application,
APEX_ITEM.POPUPKEY_FROM_LOV(3,ac.system_key,'lov_systems',50) as system
from app_conf ac;
When you run the page then APEX automatically creates a hidden field for the return value of the "popup lov".
The output looks like that:
column "application": Return column id = 2, Display column id = 3
column "system": Return column id = 3, Display column id = 4
If you set a value for column "system" it saves the "return value" in the "display value"-field of column "application".
Workaround: Use at least two numbers in between to avoid this behavior:
select
APEX_ITEM.CHECKBOX (1,ac.ac_id) as ac_id,
APEX_ITEM.POPUPKEY_FROM_LOV(2,ac.application_key,'lov_apps',50) as application,
APEX_ITEM.POPUPKEY_FROM_LOV(4,ac.system_key,'lov_systems',50) as system
from app_conf ac;
