Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_OR_PAYMENT_HEADER_UV |
SELECT CHRB.START_DATE
, KHR.TERM_DURATION
, RGP_LALEVL.ID RGP_LALEVL_ID
, RGP_LALEVL.RGD_CODE RGP_LALEVL_RGD_CODE
, RGP_LALEVL.DNZ_CHR_ID
, RGP_LALEVL.CLE_ID
, TO_CHAR(NULL) SERVICE_FEE_CLE_ID
, TO_CHAR(NULL) SERVICE_FEE_NAME
, TO_CHAR(NULL) ASSET_CLE_ID
, TO_CHAR(NULL) ASSET_NUMBER
, TO_CHAR(NULL) ASSET_DESCRIPTION
, RUL_LASLH.ID RUL_LASLH_ID
, RUL_LASLH.RULE_INFORMATION_CATEGORY RUL_LASLH_RULE_INFO_CAT
, RUL_LASLH.OBJECT1_ID1 RUL_LASLH_OBJECT1_ID1
, RUL_LASLH.OBJECT1_ID2 RUL_LASLH_OBJECT1_ID2
, RUL_LASLH.JTOT_OBJECT1_CODE RUL_LASLH_JTOT_OBJECT1_CODE
, STYT.NAME STY_NAME
, RUL_LASLL.RULE_INFORMATION5 STRUCTURE_CODE
, OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_LA_PAYMENT_STRUCTURE'
, RUL_LASLL.RULE_INFORMATION5) STRUCTURE_NAME
, RUL_LASLL.OBJECT1_ID1 FREQUENCY_CODE
, OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_FREQUENCY'
, RUL_LASLL.OBJECT1_ID1) FREQUENCY_NAME
, NVL(RUL_LASLL.RULE_INFORMATION10
, 'N') ARREARS_YN
, OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO'
, NVL(RUL_LASLL.RULE_INFORMATION10
, 'N')) ARREARS_YN_NAME
FROM OKC_RULE_GROUPS_B RGP_LALEVL
, OKC_RULES_B RUL_LASLH
, OKL_STRM_TYPE_TL STYT
, OKC_RULES_B RUL_LASLL
, OKC_K_HEADERS_B CHRB
, OKL_K_HEADERS KHR
WHERE RGP_LALEVL.RGD_CODE = 'LALEVL'
AND RGP_LALEVL.DNZ_CHR_ID = CHRB.ID
AND KHR.ID = CHRB.ID
AND RUL_LASLH.RGP_ID = RGP_LALEVL.ID
AND RUL_LASLH.RULE_INFORMATION_CATEGORY = 'LASLH'
AND RUL_LASLH.DNZ_CHR_ID = RGP_LALEVL.DNZ_CHR_ID
AND STYT.ID = RUL_LASLH.OBJECT1_ID1
AND STYT.LANGUAGE = USERENV('LANG')
AND RUL_LASLL.RULE_INFORMATION_CATEGORY = 'LASLL'
AND RUL_LASLL.RGP_ID = RUL_LASLH.RGP_ID
AND RUL_LASLL.DNZ_CHR_ID = RUL_LASLH.DNZ_CHR_ID
AND RUL_LASLL.OBJECT2_ID1 = RUL_LASLH.ID
AND NVL(RUL_LASLL.OBJECT2_ID2
, '#') = '#'
AND RUL_LASLL.JTOT_OBJECT2_CODE = 'OKL_STRMHDR'