Skip to Main Content

How to get field item name?

dandaman184Feb 17 2014 — edited Feb 24 2014

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}?

Comments
Post Details
Added on Feb 17 2014
6 comments
2,169 views