Select multiple value from parameters with substr and REGEXP_SUBSTR function in BI Publisher report

Hello All,

I have create one LOV  values with two columns Account id and Account Name by using the concatenate function. example

ACCOUNT_NUMBER || '-' || ACCOUNT_NAME as 123456-TestAccunt

My data model have the have the column name as Account number.

I am trying to pass the multiple account number from Lov in where clause by using the sub string function. example.

ACCOUNT_NUMBER in  (:(substr(REGEXP_SUBSTR(AccountNameid, '[^-]+'),1-1)).

My requirement to only match the account no to LOV number values. It is give the error

Thanks,

Nadeem