Is it possible to derive PO Header DFF value based on PO Legal Entity

Summary:

Need to know if there is a way to derive value in PO DFF value based on Legal Entity used on PO

Content (required):

Our Customer has a requirement to default a value in PO Header DFF based on the PO Legal entity. We tried writing a query by utilizing :parameter. SoldtoLegalEntityId in the where condition but the same doesn't works & gives a null value in the DFF. However, if we hardcode the Legal entity ID then the query does defaults the value returned by the sql.

Legal Entity ID is available in the list of parameters while creating PO DFF