Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 24 2014
Added on Feb 17 2014
6 comments
2,465 views