View: OKL_CS_FEE_PAYMENTS_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CS_FEE_PAYMENTS_UV

View Text

SELECT RGP.CLE_ID LINE_ID
, RUL.RULE_INFORMATION1 SEQ_NUMBER
, RUL.RULE_INFORMATION7 STUB_DAYS
, TO_NUMBER(RUL.RULE_INFORMATION8) STUB_AMOUNT
, RUL.RULE_INFORMATION3 PERIOD_IN_MONTHS
, TO_NUMBER(RUL.RULE_INFORMATION6) AMOUNT
, FND_DATE.CANONICAL_TO_DATE(RUL.RULE_INFORMATION2) START_DATE
, OKL_LA_PAYMENTS_PVT.GET_DISPLAY_END_DATE(RUL.RULE_INFORMATION2
, RUL.RULE_INFORMATION7
, RUL.OBJECT1_ID1
, RUL.RULE_INFORMATION3) END_DATE
, CHR.ID CONTRACT_ID
, CHR.CURRENCY_CODE
FROM OKC_RULES_B RUL
, OKC_RULE_GROUPS_B RGP
, OKC_K_HEADERS_B CHR
WHERE RUL.RGP_ID = RGP.ID
AND RUL.RULE_INFORMATION_CATEGORY = 'LASLL'
AND RGP.RGD_CODE = 'LALEVL'
AND RUL.DNZ_CHR_ID = CHR.ID

Columns