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!

How to pass a parameter (major code) to a shared LOV

Thaer Alomour39 hours ago — edited 39 hours ago

I have one lookup table that stores multiple lists (countries, nationalities, currencies…) using a major/minor setup (major = list id, minor > 0 = values).

Example SQL:

SELECT CASE 
	WHEN :APP_LANG = 'en' THEN list_display_en
	WHEN :APP_LANG = 'ar' THEN list_display_ar
       END AS D
     , list_minor AS R
  FROM app_lookup_master
 WHERE list_major = 10
   AND list_minor <> 0 ;

I want to reuse one shared LOV and just pass the list_major value (e.g. 10 for countries, 20 for nationalities) instead of hard-coding it.

Question:
How can I pass a parameter (page item or application item) into a shared LOV so it filters by the right major value? Is there a clean way to do this?

This post has been answered by Steve Muench-Oracle on Oct 1 2025
Jump to Answer
Comments
Post Details
Added 39 hours ago
8 comments
172 views