VIEW: APPS.OKL_CS_FEE_PAYMENTS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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