View: OKL_K_FEE_LINES_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for fee lines
Implementation/DBA Data:	APPS.OKL_K_FEE_LINES_UV

View Text

SELECT KLEB.FEE_TYPE FEE_TYPE
, FNDV.MEANING
, KLEB.FEE_PURPOSE_CODE FEE_PURPOSE_CODE
, CLEB.ID LINE_ID
, CLEB.CLE_ID LINE_CLE_ID
, CLEB.STS_CODE LINE_STS_CODE
, CLEB.CURRENCY_CODE LINE_CURRENCY_CODE
, CLEB.LINE_NUMBER LINE_LINE_NUMBER
, CLEB.DISPLAY_SEQUENCE LINE_DISPLAY_SEQUENCE
, CLEB.LSE_ID LINE_LSE_ID
, CLEB.START_DATE LINE_START_DATE
, CLEB.END_DATE LINE_END_DATE
, KLEB.AMOUNT LINE_AMOUNT
, KLEB.CAPITAL_AMOUNT LINE_CAPITAL_AMOUNT
, CLEB.DNZ_CHR_ID LINE_DNZ_CHR_ID
, CLEB.CHR_ID LINE_CHR_ID
, ITEM.ID ITEM_ID
, ITEM.CLE_ID ITEM_CLE_ID
, ITEM.OBJECT1_ID1 ITEM_OBJECT1_ID1
, ITEM.OBJECT1_ID2 ITEM_OBJECT1_ID2
, ITEM.JTOT_OBJECT1_CODE ITEM_JTOT_OBJECT1_CODE
, ITEM.CHR_ID ITEM_CHR_ID
, ITEM.DNZ_CHR_ID ITEM_DNZ_CHR_ID
, ITEM.UOM_CODE ITEM_UOM_CODE
, ITEM.EXCEPTION_YN ITEM_EXCEPTION_YN
, ITEM.NUMBER_OF_ITEMS ITEM_NUMBER_OF_ITEMS
, LSEB.LTY_CODE LS_LTY_CODE
, LSEB.ID LS_ID
, CPLB.ID PARTY_ID
, CPLB.RLE_CODE PARTY_RLE_CODE
, CPLB.CLE_ID PARTY_CLE_ID
, CPLB.OBJECT1_ID1 PARTY_OBJECT1_ID1
, CPLB.OBJECT1_ID2 PARTY_OBJECT1_ID2
, CPLB.JTOT_OBJECT1_CODE PARTY_JTOT_OBJECT1_CODE
, CPLB.DNZ_CHR_ID PARTY_DNZ_CHR_ID
, CHRB.CUST_ACCT_ID CUST_ACCT_ID
, KLEB.QTE_ID QTE_ID
, TO_NUMBER(NULL) ROLLOVER_QUOTE
, TO_CHAR(NULL) CONTRACT_NUMBER
, KHRB.KHR_ID KHR_ID
, KLEB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, KLEB.ATTRIBUTE1 ATTRIBUTE1
, KLEB.ATTRIBUTE2 ATTRIBUTE2
, KLEB.ATTRIBUTE3 ATTRIBUTE3
, KLEB.ATTRIBUTE4 ATTRIBUTE4
, KLEB.ATTRIBUTE5 ATTRIBUTE5
, KLEB.ATTRIBUTE6 ATTRIBUTE6
, KLEB.ATTRIBUTE7 ATTRIBUTE7
, KLEB.ATTRIBUTE8 ATTRIBUTE8
, KLEB.ATTRIBUTE9 ATTRIBUTE9
, KLEB.ATTRIBUTE10 ATTRIBUTE10
, KLEB.ATTRIBUTE11 ATTRIBUTE11
, KLEB.ATTRIBUTE12 ATTRIBUTE12
, KLEB.ATTRIBUTE13 ATTRIBUTE13
, KLEB.ATTRIBUTE14 ATTRIBUTE14
, KLEB.ATTRIBUTE15 ATTRIBUTE15
FROM OKC_K_LINES_B CLEB
, OKL_K_LINES KLEB
, OKC_LINE_STYLES_B LSEB
, OKC_K_ITEMS ITEM
, OKC_K_PARTY_ROLES_B CPLB
, FND_LOOKUPS FNDV
, OKC_K_HEADERS_B CHRB
, OKL_K_HEADERS KHRB
WHERE CHRB.ID = KHRB.ID
AND CHRB.ID = CLEB.DNZ_CHR_ID
AND KLEB.ID = CLEB.ID
AND CLEB.LSE_ID = LSEB.ID
AND LSEB.LTY_CODE = 'FEE'
AND ITEM.CLE_ID = CLEB.ID
AND CLEB.ID = CPLB.CLE_ID(+)
AND CLEB.DNZ_CHR_ID = CPLB.DNZ_CHR_ID(+)
AND ITEM.DNZ_CHR_ID = CLEB.DNZ_CHR_ID
AND FNDV.LOOKUP_TYPE = 'OKL_FEE_TYPES'
AND FNDV.LOOKUP_CODE = KLEB.FEE_TYPE

Columns