Idea Summary
I have numerous cases where a dynamic LOV on one page is almost identical to another on a different page, the only difference being that it uses :PXX_ITEM from one page but a different page item on the other; otherwise the SQL is identical.
Use Case
To reduce code duplication and centralise the LOV definition in the shared components.
Preferred Solution (Optional)
Allow for the dynamic LOV in the shared components to have bind variable placeholders in the SQL and either APEX can detect these and list them in the page using it. Provide a new input field for items that allow a shared LOV to be its source where the bind variables in the SQL will be replaced by a comma or colon separated list of page items.