[Home] [Help]
View: OKL_CS_FEES_UV
Product: | OKL - Lease and Finance Management |
Description: | |
Implementation/DBA Data: |
APPS.OKL_CS_FEES_UV
|
View Text
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')
Columns
Name |
FEE_LINE_ID |
CONTRACT_ID |
STATUS_CODE |
FEE_AMOUNT |
FEE_TYPE_CODE |
FEE_TYPE |
FEE_CODE |
DESCRIPTION |
STATUS |
EFFECTIVE_FROM |
EFFECTIVE_TO |
CURRENCY_CODE |
LTY_CODE |