VIEW: APPS.OKL_RECONCILE_CURES_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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