View: OKL_LA_FEE_LINES_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_LA_FEE_LINES_UV

View Text

SELECT TO_CHAR(CLEB_FEE.ID) CLEB_FEE_ID
, TO_CHAR(CLEB_FEE.DNZ_CHR_ID) DNZ_CHR_ID
, TO_CHAR(CLEB_FEE.ORIG_SYSTEM_ID1) ORIG_SYSTEM_ID1
, KLE_FEE.FEE_TYPE FEE_TYPE
, LKP_FEE_TYPE.MEANING FEE_TYPE_NAME
, TO_CHAR(CIM_FEE.ID) CIM_FEE_ID
, STYT.NAME CIM_FEE_STY_NAME
, TO_CHAR(CIM_FEE.OBJECT1_ID1) CIM_FEE_OBJECT1_ID1
, TO_CHAR(CIM_FEE.OBJECT1_ID2) CIM_FEE_OBJECT1_ID2
, CIM_FEE.JTOT_OBJECT1_CODE CIM_FEE_OBJECT1_CODE
, TO_CHAR(CPLB_FEE.ID) CPLB_FEE_ID
, POV.VENDOR_NAME CPLB_FEE_VENDOR_NAME
, TO_CHAR(CPLB_FEE.OBJECT1_ID1) CPLB_FEE_OBJECT1_ID1
, TO_CHAR(CPLB_FEE.OBJECT1_ID2) CPLB_FEE_OBJECT1_ID2
, CPLB_FEE.JTOT_OBJECT1_CODE CPLB_FEE_OBJECT1_CODE
, CPLB_FEE.RLE_CODE CPLB_FEE_RLE_CODE
, CLEB_FEE.START_DATE START_DATE
, CLEB_FEE.END_DATE END_DATE
, KLE_FEE.AMOUNT AMOUNT
, KLE_FEE.INITIAL_DIRECT_COST INITIAL_DIRECT_COST
, TO_CHAR(NULL) ROLLOVER_TERM_QUOTE_NUMBER
, TO_CHAR(NULL) ROLLOVER_CONTRACT_NUMBER
, TO_CHAR(KLE_FEE.QTE_ID) QTE_ID
, KLE_FEE.FUNDING_DATE FUNDING_DATE
, KLE_FEE.FEE_PURPOSE_CODE FEE_PURPOSE_CODE
, TO_CHAR(NULL) SALES_TAX_FEE_YN
, KLE_FEE.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, KLE_FEE.ATTRIBUTE1 ATTRIBUTE1
, KLE_FEE.ATTRIBUTE2 ATTRIBUTE2
, KLE_FEE.ATTRIBUTE3 ATTRIBUTE3
, KLE_FEE.ATTRIBUTE4 ATTRIBUTE4
, KLE_FEE.ATTRIBUTE5 ATTRIBUTE5
, KLE_FEE.ATTRIBUTE6 ATTRIBUTE6
, KLE_FEE.ATTRIBUTE7 ATTRIBUTE7
, KLE_FEE.ATTRIBUTE8 ATTRIBUTE8
, KLE_FEE.ATTRIBUTE9 ATTRIBUTE9
, KLE_FEE.ATTRIBUTE10 ATTRIBUTE10
, KLE_FEE.ATTRIBUTE11 ATTRIBUTE11
, KLE_FEE.ATTRIBUTE12 ATTRIBUTE12
, KLE_FEE.ATTRIBUTE13 ATTRIBUTE13
, KLE_FEE.ATTRIBUTE14 ATTRIBUTE14
, KLE_FEE.ATTRIBUTE15 ATTRIBUTE15
, TO_CHAR(RGP_LAFEXP.ID) RGP_LAFEXP_ID
, TO_CHAR(RUL_LAFREQ.ID) RUL_LAFREQ_ID
, TO_CHAR(RUL_LAFREQ.OBJECT1_ID1) RUL_LAFREQ_OBJECT1_ID1
, TO_CHAR(RUL_LAFREQ.OBJECT1_ID2) RUL_LAFREQ_OBJECT1_ID2
, RUL_LAFREQ.JTOT_OBJECT1_CODE RUL_LAFREQ_OBJECT1_CODE
, TUOM.NAME FREQUENCY_NAME
, TO_CHAR(RUL_LAFEXP.ID) RUL_LAFEXP_ID
, RUL_LAFEXP.RULE_INFORMATION1 RULE_INFORMATION1
, RUL_LAFEXP.RULE_INFORMATION2 RULE_INFORMATION2
FROM OKC_K_LINES_B CLEB_FEE
, OKL_K_LINES KLE_FEE
, OKC_K_ITEMS CIM_FEE
, OKL_STRM_TYPE_TL STYT
, OKC_K_PARTY_ROLES_B CPLB_FEE
, PO_VENDORS POV
, FND_LOOKUPS LKP_FEE_TYPE
, OKC_RULE_GROUPS_B RGP_LAFEXP
, OKC_RULES_B RUL_LAFREQ
, OKC_RULES_B RUL_LAFEXP
, OKL_TIME_UNITS_V TUOM
WHERE CLEB_FEE.ID = KLE_FEE.ID
AND CIM_FEE.CLE_ID = CLEB_FEE.ID
AND CIM_FEE.DNZ_CHR_ID = CLEB_FEE.DNZ_CHR_ID
AND CIM_FEE.JTOT_OBJECT1_CODE = 'OKL_STRMTYP'
AND STYT.ID = CIM_FEE.OBJECT1_ID1
AND STYT.LANGUAGE = USERENV('LANG')
AND CPLB_FEE.CLE_ID (+) = CLEB_FEE.ID
AND CPLB_FEE.DNZ_CHR_ID (+) = CLEB_FEE.DNZ_CHR_ID
AND CPLB_FEE.RLE_CODE (+) = 'OKL_VENDOR'
AND POV.VENDOR_ID (+) = CPLB_FEE.OBJECT1_ID1
AND LKP_FEE_TYPE.LOOKUP_CODE = KLE_FEE.FEE_TYPE
AND LKP_FEE_TYPE.LOOKUP_TYPE = 'OKL_FEE_TYPES'
AND RGP_LAFEXP.DNZ_CHR_ID (+) = CLEB_FEE.DNZ_CHR_ID
AND RGP_LAFEXP.CLE_ID (+) = CLEB_FEE.ID
AND RGP_LAFEXP.RGD_CODE (+) = 'LAFEXP'
AND RUL_LAFREQ.RGP_ID (+) = RGP_LAFEXP.ID
AND RUL_LAFREQ.RULE_INFORMATION_CATEGORY (+) = 'LAFREQ'
AND RUL_LAFEXP.RGP_ID (+) = RGP_LAFEXP.ID
AND RUL_LAFEXP.RULE_INFORMATION_CATEGORY (+) = 'LAFEXP'
AND TUOM.ID1 (+) = RUL_LAFREQ.OBJECT1_ID1

Columns