View: OKL_OUTSTANDING_CURE_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_OUTSTANDING_CURE_UV

View Text

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

Columns