How to map this where clause in Oracle Warehouse Builder

[freeka]

Hi all

I have a where clause which I am struggling to map in Oracle Warehouse Builder. Problem is that I don't know what mapping will cover the CASE clause I have.

I know I could use Expression operator but where do I put it in reference to my mapping?

Many thanks in advance.


WHERE xd.cii_owner_account_id = hca.cust_account_id
AND incidentb.incident_status_id = incident_status.incident_status_id
AND incident_number = xd.sr_number

--
-- this is where the confusion begins
--

AND ( (CASE
WHEN buyout_immediate_flag <> 'Immediate'
THEN '-'
END) = '-'
OR (CASE
WHEN buyout_immediate_flag = 'Immediate'
THEN incident_status.NAME
END
) LIKE '%Authorised%'
OR (CASE
WHEN buyout_immediate_flag = 'Immediate'
THEN incident_status.NAME
END
) LIKE '%IT Appro%'
)