VIEW: APPS.OKL_OR_PAYMENT_HEADER_UV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'