DFF value based on receiver entity on Intercompany Transaction

Hi All,

We have a requirement to derive the user list a specific entity on the DFF (Attribute1) on the batch/transaction level. The list should be based on the selection of the receiver organization. We are trying to achieve it using the SQL/table validated value set attached to this DFF. The ask is how can we make this SQL dynamic to read the receiver organization and populate the user list (lov).

Thank you in Advance.