Idea Summary
Create APIs to handle Shared Component or Inline LOV's in SQL or PL/SQL.
Use Case
Easily get LOV display value for a LOV return value (or the other way around) for a given Shared Component LOV or Inline page item LOV.
Right now, for static values, you have to code it yourself, e.g.:
select display_value
from apex_application_lov_entries
where application_id = :app_id
and list_of_values_name = 'COUNTRIES'
and return_value = 'USA'
For Dynamic LOVs it is practically impossible to use the stored SQL query in your own code.
Preferred Solution (Optional)
Expose useful functions in wwv_flow_lov (like get_shared_lov_id and get_lov_display_value) as public APIs.