View: OKL_ASSET_DFF_EXTRACT_LINE_V

Product:	OKL - Lease and Finance Management
Description:	Line extract object for Asset related DFF
Implementation/DBA Data:	APPS.OKL_ASSET_DFF_EXTRACT_LINE_V

View Text

SELECT TCL.ID TCL_ID
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, TCL.ATTRIBUTE_CATEGORY
, NULL) TCL_ASSET_ATTRIBUTE_CATEGORY
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, TCL.ATTRIBUTE1
, NULL) TCL_ASSET_ATTRIBUTE1
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, TCL.ATTRIBUTE2
, NULL) TCL_ASSET_ATTRIBUTE2
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, TCL.ATTRIBUTE3
, NULL) TCL_ASSET_ATTRIBUTE3
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, TCL.ATTRIBUTE4
, NULL) TCL_ASSET_ATTRIBUTE4
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, TCL.ATTRIBUTE5
, NULL) TCL_ASSET_ATTRIBUTE5
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, TCL.ATTRIBUTE6
, NULL) TCL_ASSET_ATTRIBUTE6
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, TCL.ATTRIBUTE7
, NULL) TCL_ASSET_ATTRIBUTE7
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, TCL.ATTRIBUTE8
, NULL) TCL_ASSET_ATTRIBUTE8
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, TCL.ATTRIBUTE9
, NULL) TCL_ASSET_ATTRIBUTE9
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, TCL.ATTRIBUTE10
, NULL) TCL_ASSET_ATTRIBUTE10
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, TCL.ATTRIBUTE11
, NULL) TCL_ASSET_ATTRIBUTE11
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, TCL.ATTRIBUTE12
, NULL) TCL_ASSET_ATTRIBUTE12
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, TCL.ATTRIBUTE13
, NULL) TCL_ASSET_ATTRIBUTE13
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, TCL.ATTRIBUTE14
, NULL) TCL_ASSET_ATTRIBUTE14
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, TCL.ATTRIBUTE15
, NULL) TCL_ASSET_ATTRIBUTE15
FROM OKL_TXL_CNTRCT_LNS_ALL TCL
, OKL_TXL_EXTENSION_B TEL
WHERE TCL.ID = TEL.SOURCE_ID(+)
AND TEL.SOURCE_TABLE(+) = 'OKL_TXL_CNTRCT_LNS'

Columns