[Home] [Help]
View: OKL_PYMTS_FEE_INSTS_UV
Product: | OKL - Lease and Finance Management |
Description: | User Interface view for Fee Line instance LOV on Payments Page |
Implementation/DBA Data: |
APPS.OKL_PYMTS_FEE_INSTS_UV
|
View Text
SELECT CLEB.ID LINE_ID
, CLEB.DNZ_CHR_ID KHR_ID
, CLEB.LSE_ID LSE_ID
, STYV.NAME SERV_INST_NAME
, STYV.DESCRIPTION SERV_INST_DESC
, FNDV.MEANING FEE_TYPE_MEANING
, FNDV.LOOKUP_CODE FEE_TYPE_CODE
FROM OKL_STRMTYP_SOURCE_V STYV
, OKC_K_ITEMS CIM
, OKC_LINE_STYLES_B LSEB
, OKC_K_LINES_B CLEB
, OKC_STATUSES_B STSB
, OKL_K_LINES KLE
, FND_LOOKUPS FNDV
WHERE STYV.ID1 = CIM.OBJECT1_ID1
AND TO_CHAR(STYV.ID2) = TO_CHAR(CIM.OBJECT1_ID2)
AND LSEB.ID = CLEB.LSE_ID
AND LSEB.LTY_CODE = 'FEE'
AND CIM.JTOT_OBJECT1_CODE = 'OKL_STRMTYP'
AND CIM.CLE_ID = CLEB.ID
AND CIM.DNZ_CHR_ID =CLEB.DNZ_CHR_ID
AND STSB.CODE = CLEB.STS_CODE
AND STSB.STE_CODE NOT IN ('HOLD'
, 'EXPIRED'
, 'TERMINATED'
, 'CANCELLED')
AND CLEB.ID = KLE.ID
AND FNDV.LOOKUP_TYPE = 'OKL_FEE_TYPES'
AND FNDV.LOOKUP_CODE = KLE.FEE_TYPE
AND FNDV.LOOKUP_CODE IN ('MISCELLANEOUS'
, 'PASSTHROUGH'
, 'SECDEPOSIT'
, 'INCOME'
, 'FINANCED'
, 'ROLLOVER')
Columns
Name |
LINE_ID |
KHR_ID |
LSE_ID |
SERVICE_INST_NAME |
SERVICE_INST_DESC |
FEE_TYPE_MEANING |
FEE_TYPE_CODE |