VIEW: APPS.OKL_CS_FEES_UV

Source

View Text - Preformatted

SELECT CLE.ID FEE_LINE_ID, CLE.DNZ_CHR_ID CONTRACT_ID, CLE.STS_CODE STATUS_CODE, KLE.AMOUNT FEE_AMOUNT, KLE.FEE_TYPE FEE_TYPE_CODE, FNDV.MEANING FEE_TYPE, STTL.NAME FEE_CODE, STTL.DESCRIPTION DESCRIPTION, LSTL.MEANING STATUS, CLE.START_DATE EFFECTIVE_FROM, CLE.END_DATE EFFECTIVE_TO, CLE.CURRENCY_CODE CURRENCY_CODE, LSE.LTY_CODE LTY_CODE FROM okc_k_lines_b cle, okc_line_styles_b lse, okl_k_lines kle, okc_k_items cit, okc_k_party_roles_b cpl, OKL_STRM_TYPE_TL STTL, okc_statuses_b ls, okc_statuses_tl lstl, FND_LOOKUPS FNDV WHERE lse.id = cle.lse_id and lse.lty_code = 'FEE' and kle.id = cle.id and cle.sts_code not in ('ABANDONED') and cit.cle_id = cle.id and cit.dnz_chr_id = cle.dnz_chr_id and cpl.cle_id(+) = cle.id and cpl.rle_code(+) = 'OKL_VENDOR' and cpl.dnz_chr_id(+) = cle.dnz_chr_id and to_char(STTL.ID) = cit.object1_id1 and ls.code = cle.sts_code and lstl.code = cle.sts_code and lstl.code = ls.code AND STTL.LANGUAGE = USERENV('LANG') and FNDV.LOOKUP_TYPE = 'OKL_FEE_TYPES' and FNDV.LOOKUP_CODE = KLE.FEE_TYPE and lstl.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT CLE.ID FEE_LINE_ID
, CLE.DNZ_CHR_ID CONTRACT_ID
, CLE.STS_CODE STATUS_CODE
, KLE.AMOUNT FEE_AMOUNT
, KLE.FEE_TYPE FEE_TYPE_CODE
, FNDV.MEANING FEE_TYPE
, STTL.NAME FEE_CODE
, STTL.DESCRIPTION DESCRIPTION
, LSTL.MEANING STATUS
, CLE.START_DATE EFFECTIVE_FROM
, CLE.END_DATE EFFECTIVE_TO
, CLE.CURRENCY_CODE CURRENCY_CODE
, LSE.LTY_CODE LTY_CODE
FROM OKC_K_LINES_B CLE
, OKC_LINE_STYLES_B LSE
, OKL_K_LINES KLE
, OKC_K_ITEMS CIT
, OKC_K_PARTY_ROLES_B CPL
, OKL_STRM_TYPE_TL STTL
, OKC_STATUSES_B LS
, OKC_STATUSES_TL LSTL
, FND_LOOKUPS FNDV
WHERE LSE.ID = CLE.LSE_ID
AND LSE.LTY_CODE = 'FEE'
AND KLE.ID = CLE.ID
AND CLE.STS_CODE NOT IN ('ABANDONED')
AND CIT.CLE_ID = CLE.ID
AND CIT.DNZ_CHR_ID = CLE.DNZ_CHR_ID
AND CPL.CLE_ID(+) = CLE.ID
AND CPL.RLE_CODE(+) = 'OKL_VENDOR'
AND CPL.DNZ_CHR_ID(+) = CLE.DNZ_CHR_ID
AND TO_CHAR(STTL.ID) = CIT.OBJECT1_ID1
AND LS.CODE = CLE.STS_CODE
AND LSTL.CODE = CLE.STS_CODE
AND LSTL.CODE = LS.CODE
AND STTL.LANGUAGE = USERENV('LANG')
AND FNDV.LOOKUP_TYPE = 'OKL_FEE_TYPES'
AND FNDV.LOOKUP_CODE = KLE.FEE_TYPE
AND LSTL.LANGUAGE = USERENV('LANG')