VIEW: APPS.OKL_NO_OF_CURES_UV

Source

View Text - Preformatted

SELECT chr_id ,COUNT(chr_id) FROM OKL_CURE_AMOUNTS CAM WHERE status = 'CURESINPROGRESS' and negotiated_amount is not null and received_amount is not null GROUP BY chr_id

View Text - HTML Formatted

SELECT CHR_ID
, COUNT(CHR_ID)
FROM OKL_CURE_AMOUNTS CAM
WHERE STATUS = 'CURESINPROGRESS'
AND NEGOTIATED_AMOUNT IS NOT NULL
AND RECEIVED_AMOUNT IS NOT NULL GROUP BY CHR_ID