[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 |