Need to pass AR Business Unit as parameter in where clause of a Table based value set

Summary:

We have a requirement to dynamically pass the Business Unit ID associated to the AR transaction number in the where clause of the Table based value set which we have created for the purpose.

Content (please ensure you mask any confidential information):

Please let us know how we can pass the Business Unit ID associated to the AR transaction number dynamically in the below query to achieve the requirement. Screenshot attached for further reference.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Below is the query we are using in the where clause: