View: OKL_AM_ASSET_LINES_ALL_UV

Product:	OKL - Leasing and Finance Management
Description:	View for showing Asset Lines.Join between B and TL tables.
Implementation/DBA Data:	APPS.OKL_AM_ASSET_LINES_ALL_UV

View Text

SELECT CLEB.ID ID
, CLET.NAME NAME
, OKHFV.CONTRACT_NUMBER CONTRACT_NUMBER
, CLET.ITEM_DESCRIPTION DESCRIPTION
, CLEB.CHR_ID CHR_ID
, KLE.OEC OEC
, OTQV.ID QTE_ID
, OTQV.QUOTE_NUMBER QUOTE_NUMBER
, TQL.ASSET_VALUE
, TQL.RESIDUAL_VALUE
, TQL.UNBILLED_RECEIVABLES
, TQL.ASSET_QUANTITY
, TQL.QUOTE_QUANTITY
, TQL.SPLIT_KLE_ID
, TQL.SPLIT_KLE_NAME
, OTQV.ASSET_VALUE
, OTQV.RESIDUAL_VALUE
, OTQV.UNBILLED_RECEIVABLES
, OTQV.GAIN_LOSS
, OTQV.QST_CODE
, OTQV.QTP_CODE
, TQL.ID TQL_ID
FROM OKL_K_LINES KLE
, OKC_K_LINES_TL CLET
, OKC_K_LINES_B CLEB
, OKC_K_HEADERS_ALL_B OKHFV
, OKL_TRX_QUOTES_ALL_B OTQV
, OKL_TXL_QTE_LINES_ALL_B TQL
WHERE CLEB.ID = CLET.ID
AND CLET.LANGUAGE = USERENV('LANG')
AND CLEB.ID = KLE.ID
AND OKHFV.ID = OTQV.KHR_ID
AND TQL.KLE_ID = KLE.ID
AND OTQV.ID = TQL.QTE_ID
AND TQL.QLT_CODE = 'AMCFIA'

Columns