View: OKL_CS_VARIABLE_INT_RATE_UV

Product:	OKL - Lease and Finance Management
Description:	Variable Interest Rate Information
Implementation/DBA Data:	APPS.OKL_CS_VARIABLE_INT_RATE_UV

View Text

SELECT VAR.INTEREST_CALC_START_DATE DATE_FROM
, VAR.INTEREST_CALC_END_DATE DATE_TO
, DECODE(VAR.CALC_METHOD_CODE
, 'REAMORT'
, 'Y'
, 'N') COMPOSITE
, LKP.MEANING INTEREST_CALCULATION_METHOD
, VAR.CALC_METHOD_CODE INTEREST_CALC_MTHD_CODE
, VAR.INTEREST_RATE
, VAR.INTEREST_AMT INTEREST_AMOUNT
, VAR.KHR_ID KHR_ID
FROM OKL_VAR_INT_PARAMS VAR
, OKL_TRX_AR_INVOICES_B HDR
, FND_LOOKUPS LKP
WHERE VAR.SOURCE_ID = HDR.ID(+)
AND LKP.LOOKUP_TYPE = 'OKL_BPD_VAR_RATE_CALC_CODE'
AND LKP.LOOKUP_CODE = VAR.CALC_METHOD_CODE

Columns