Skip to Content
0
Jun 03, 2020 at 06:14 PM

How to define Case statement in IDT for Oracle database.

79 Views Last edit Jun 03, 2020 at 06:17 PM 5 rev

Query 1:

(CASE INV.PAYMENT_STATUS_FLAG WHEN 'N' THEN 'No' WHEN 'Y' THEN 'Yes' WHEN 'P' THEN 'Partial' ELSE INV.PAYMENT_STATUS_FLAG END )

Query 2:

NVL(IDSTR.BASE_AMOUNT, CASE INV.INVOICE_CURRENCY_CODE WHEN LDG.CURRENCY_CODE THEN NVL(IDSTR.AMOUNT,0) ELSE NULL END)