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?