VIEW: APPS.OKL_CURE_POSSESSED_UV

Source

View Text - Preformatted

SELECT chr_id ,SUM(amount) FROM OKL_CURE_PAYMENT_LINES WHERE STATUS = 'CURES_IN_POSSESSION' GROUP BY chr_id

View Text - HTML Formatted

SELECT CHR_ID
, SUM(AMOUNT)
FROM OKL_CURE_PAYMENT_LINES
WHERE STATUS = 'CURES_IN_POSSESSION' GROUP BY CHR_ID