View: OKL_CURE_OFFSET_CONTRACTS_UV

Product:	OKL - Lease and Finance Management
Description:	Vendor Cure view
Implementation/DBA Data:	APPS.OKL_CURE_OFFSET_CONTRACTS_UV

View Text

SELECT CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, CAM.CHR_ID CHR_ID
, CHR.CURRENCY_CODE CURRENCY_CODE
, PTY.OBJECT1_ID1 VENDOR_ID
, SUM(CAM.NEGOTIATED_AMOUNT - NVL(CAM.RECEIVED_AMOUNT
, 0)) CURE_AMOUNT_DUE
FROM OKL_K_HEADERS KHR
, OKC_K_HEADERS_B PROG
, OKL_CURE_AMOUNTS_ALL CAM
, OKC_K_PARTY_ROLES_B PTY
, OKX_VENDORS_V VND
, OKC_K_HEADERS_B CHR
WHERE CHR.ID = CAM.CHR_ID
AND KHR.ID = CHR.ID
AND KHR.KHR_ID = PROG.ID
AND PROG.SCS_CODE = 'PROGRAM'
AND CHR.SCS_CODE IN ('LEASE'
, 'LOAN')
AND PROG.ID = PTY.CHR_ID
AND PTY.RLE_CODE = 'OKL_VENDOR'
AND PTY.OBJECT1_ID1 = TO_CHAR(VND.ID1)
AND PTY.OBJECT1_ID2 = TO_CHAR(VND.ID2)
AND CAM.STATUS = 'CURESINPROGRESS'
AND NVL(CAM.NEGOTIATED_AMOUNT
, 0) > 0 GROUP BY CAM.CHR_ID
, CHR.CONTRACT_NUMBER
, PTY.OBJECT1_ID1
, CHR.CURRENCY_CODE HAVING SUM(CAM.NEGOTIATED_AMOUNT - NVL(CAM.RECEIVED_AMOUNT
, 0)) >0

Columns