Multiple Values select by Popup LOV

 

Step:1
=====
Check (Yes) Multiple Values.
Separator- :

Step:2
=====

Sql Query Where Condition:

AND (instr(':'||nvl(:P489_BUYER_ID, P.BUYER_BUYER_ID)|| ':',':' ||P.BUYER_BUYER_ID||':') > 0 OR :P489_BUYER_ID IS NULL)