VIEW: APPS.OKL_CURE_RECEIVED_UV

Source

View Text - Preformatted

SELECT chr_id, SUM(received_amount) FROM OKL_CURE_AMOUNTS CAM WHERE 1=1 GROUP BY chr_id

View Text - HTML Formatted

SELECT CHR_ID
, SUM(RECEIVED_AMOUNT)
FROM OKL_CURE_AMOUNTS CAM
WHERE 1=1 GROUP BY CHR_ID