VIEW: APPS.OKL_OUTSTANDING_CURE_UV

Source

View Text - Preformatted

SELECT kvp.vendor_id vendor_id ,kvp.contract_id contract_id ,SUM(cra.claimed_cure_amount) outstanding_cure_value FROM OKL_K_VENDOR_PROGRAMS_UV KVP,OKL_CURE_AMOUNTS CAM,OKL_CURE_REPORT_AMTS_ALL CRA WHERE kvp.contract_id = cam.chr_id AND cra.cure_amount_id = cam.cure_amount_id AND cra.cure_report_id IN (SELECT crt1.cure_report_id FROM okl_cure_reports_all crt1 WHERE crt1.report_date = ( SELECT MAX(crt2.report_date) FROM okl_cure_reports_all crt2 WHERE crt2.vendor_id = crt1.vendor_id)) GROUP BY kvp.vendor_id ,kvp.contract_id

View Text - HTML Formatted

SELECT KVP.VENDOR_ID VENDOR_ID
, KVP.CONTRACT_ID CONTRACT_ID
, SUM(CRA.CLAIMED_CURE_AMOUNT) OUTSTANDING_CURE_VALUE
FROM OKL_K_VENDOR_PROGRAMS_UV KVP
, OKL_CURE_AMOUNTS CAM
, OKL_CURE_REPORT_AMTS_ALL CRA
WHERE KVP.CONTRACT_ID = CAM.CHR_ID
AND CRA.CURE_AMOUNT_ID = CAM.CURE_AMOUNT_ID
AND CRA.CURE_REPORT_ID IN (SELECT CRT1.CURE_REPORT_ID
FROM OKL_CURE_REPORTS_ALL CRT1
WHERE CRT1.REPORT_DATE = ( SELECT MAX(CRT2.REPORT_DATE)
FROM OKL_CURE_REPORTS_ALL CRT2
WHERE CRT2.VENDOR_ID = CRT1.VENDOR_ID)) GROUP BY KVP.VENDOR_ID
, KVP.CONTRACT_ID