How to dispaly custom DFF values in contracts based on contract business unit

Summary:

Hi,

We have created custom DFF (AR memolines ) in contract lines. Currently all memolines of all BU's are populating.

We want to restrict the LOV of Ar memolines DFF we created to populate only the contract BU specific related ones.

Could you please suggest.

I have created below query and its working when run in BI publisher. but when mention in valueset in the output getting error as missing in or out parameter.

SELECT MEM.NAME
FROM FUSION.AR_MEMO_LINES_ALL_VL MEM
WHERE NVL(MEM.EFFECTIVE_END_DATE, SYSDATE + 1) >= SYSDATE
AND EXISTS (
SELECT 1
FROM FUSION.AR_REF_ACCOUNTS_ALL REF,