APEX

Hello,

I have an LOV component that uses this select:

select LOC_ABBR display_value, LOC_ID return_value
from LOCS
order by 1

On a screen, I have an item that uses this LOV as a "Select List (Named LOV)". I want to default the value of the lov with the value from this select:

select LOC_ABBR display_value, LOC_ID return_value
from locs where loc_abbr = '000'

I selected Default Type "(PLSQL Expression or Function)", and tried entering the select statement into Default property. This does not work.

How can I set a default value for the LOV? Ideally, I would like to assign the default for any existing records that do not have a value for this item, as well as setting a default for new records when "Add Row" is pressed.

Thank you,