VIEW: APPS.OKL_PYMTS_FEE_INSTS_UV

Source

View Text - Preformatted

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', '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')

View Text - HTML Formatted

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'
, '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')