We have a company standard with Lists of Values. There is a single table called LOVS that has multiple lists.
Table structure is
LOV_TYPE varchar2 -- STATE_LOV, GENDER_LOV, STATUS_LOV
LOV_VALUE varchar2 -- the actual value such as AZ, CA,TX, M, F
LOV_DESCR
All our tables follow the standard of {LOV_TYPE}_LOV
So our customer table has
STATE_LOV
GENDER_LOV
STATUS_LOV
When we generate the form we have fields named
R05_STATE_LOV
R05_GENDER_LOV
R05_STATUS_LOV
I want to create a single Shared Component -> List of values that is something like
select lov_description as display_value, LOV_KEY as return_value
from LOVS where LOV_TYPE_LOV = substr({field_name},5)
order by 1
How can I get {field_name}?