View: OKL_OR_PAYMENT_DETAILS_UV

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

View Text

SELECT RUL_LASLL.ID RUL_LASLL_ID
, TO_NUMBER(RUL_LASLL.RULE_INFORMATION3) PERIODS
, TO_NUMBER(RUL_LASLL.RULE_INFORMATION6) PERIODIC_AMOUNT
, TO_NUMBER(RUL_LASLL.RULE_INFORMATION7) STUB_DAYS
, TO_NUMBER(RUL_LASLL.RULE_INFORMATION8) STUB_AMOUNT
, FND_DATE.CANONICAL_TO_DATE(RUL_LASLL.RULE_INFORMATION2) START_DATE
, DECODE( RUL_LASLL.RULE_INFORMATION7
, NULL
, ( ADD_MONTHS( FND_DATE.CANONICAL_TO_DATE(RUL_LASLL.RULE_INFORMATION2)
, NVL(TO_NUMBER(RUL_LASLL.RULE_INFORMATION3)
, 1) * DECODE(RUL_LASLL.OBJECT1_ID1
, 'M'
, 1
, 'Q'
, 3
, 'S'
, 6
, 'A'
, 12) ) - 1)
, FND_DATE.CANONICAL_TO_DATE(RUL_LASLL.RULE_INFORMATION2) + TO_NUMBER(RUL_LASLL.RULE_INFORMATION7) - 1) END_DATE
, RUL_LASLL.RGP_ID
, RUL_LASLL.DNZ_CHR_ID
, RUL_LASLL.OBJECT2_ID1
, RUL_LASLL.OBJECT2_ID2
, RUL_LASLL.JTOT_OBJECT2_CODE
FROM OKC_RULES_B RUL_LASLL
WHERE RUL_LASLL.RULE_INFORMATION_CATEGORY = 'LASLL'
AND NVL(RUL_LASLL.OBJECT2_ID2
, '#') = '#'
AND RUL_LASLL.JTOT_OBJECT2_CODE = 'OKL_STRMHDR' ORDER BY START_DATE

Columns