[Home] [Help]
View: OKL_RECONCILE_CURES_UV
View Text
SELECT CHR_ID
, SUM(NVL(AMOUNT
, 0)) AMOUNT
, NVL(NULL
, 0)
, NULL
FROM OKL_CURE_PAYMENT_LINES
WHERE STATUS = 'CURES_IN_POSSESSION' GROUP BY CHR_ID
Columns
| Name |
| CHR_ID |
| CURES_IN_POSSESSION |
| AMOUNT_RECEIVED |
| CURED_FLAG |