View: OKL_CURE_CONTRACT_UV

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

View Text

SELECT CRUV.CONTRACT_NUMBER
, HZP.PARTY_NAME
, CRUV.VENDOR_ID
, CRUV.VENDOR_PROGRAM_NAME
, CRUV.RULE_INFORMATION5
, 0
, CAM.CURE_AMOUNT_ID
, CAM.CHR_ID
, CAM.CURE_AMOUNT
, CAM.REPURCHASE_AMOUNT
, CRF.REFUND_AMOUNT_DUE
, NCUV.CURES_IN_POSSESSION
, 0
, NULL
, CAM.CURE_AMOUNT
, CAM.ELIGIBLE_CURE_AMOUNT
, CAM.PAYMENTS_REMAINING
, CAM.PAST_DUE_AMOUNT
, CAM.OUTSTANDING_AMOUNT
, CAM.TIMES_CURED
, CHR.CURRENCY_CODE
FROM OKL_CURE_AMOUNTS_ALL CAM
, OKL_CURE_RULE_UV CRUV
, OKC_K_PARTY_ROLES_B CPR
, HZ_PARTIES HZP
, OKL_NO_OF_CURES_UV NCUV
, OKC_K_HEADERS_V CHR
, OKL_CURE_REFUNDS_DTLS_UV CRF
WHERE CRUV.CONTRACT_ID = CAM.CHR_ID
AND CHR.ID = CRUV.CONTRACT_ID
AND CHR.ID = CAM.CHR_ID
AND CHR.ID = CPR.CHR_ID
AND CRUV.CONTRACT_ID = CPR.CHR_ID
AND CPR.OBJECT1_ID1 = HZP.PARTY_ID
AND CPR.RLE_CODE = 'LESSEE'
AND CRUV.CONTRACT_ID = CRF.CONTRACT_ID (+)
AND CRUV.CONTRACT_ID = NCUV.CHR_ID (+)

Columns