VIEW: APPS.OKL_CS_VAR_INT_RATE_ASSET_UV

Source

View Text - Preformatted

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, VAR.KLE_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

View Text - HTML Formatted

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
, VAR.KLE_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