Pass a selected Value of a Value set into another Value set

Summary:

Pass a selected Value of a Value set into another Value set

Content (please ensure you mask any confidential information):

We are looking to pass dynamic values that are in one value set and use them in the 'WHERE' statement in another Value set.

Current setup: Item Descriptive Flexfield (EGP_SYSTEM_ITEMS_DFF) for BPA Number:

Associated Value Set (PIM_BPA_Number) for the above Flexfield:

We have another Flexfield for the BPA Price as follows:

In the Value set for this Flexfield (BPA Price) we would like to be able to take the value populated in the Value set 'PIM_BPA_Number' (above) and use it in the below WHERE clause, so that logically we are Selecting UNIT_PRICE from PO_LINES_ALL WHERE SEGMENT1 = {