View: OKL_FEE_SERVICE_DFF_LINE_V

Product:	OKL - Lease and Finance Management
Description:	Line extract object with fee and service DFF
Implementation/DBA Data:	APPS.OKL_FEE_SERVICE_DFF_LINE_V

View Text

SELECT TCL.ID TCL_ID
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FEE'
, TCL.ATTRIBUTE_CATEGORY
, NULL) TCL_FEE_ATTRIBUTE_CATEGORY
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FEE'
, TCL.ATTRIBUTE1
, NULL) TCL_FEE_ATTRIBUTE1
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FEE'
, TCL.ATTRIBUTE2
, NULL) TCL_FEE_ATTRIBUTE2
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FEE'
, TCL.ATTRIBUTE3
, NULL) TCL_FEE_ATTRIBUTE3
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FEE'
, TCL.ATTRIBUTE4
, NULL) TCL_FEE_ATTRIBUTE4
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FEE'
, TCL.ATTRIBUTE5
, NULL) TCL_FEE_ATTRIBUTE5
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FEE'
, TCL.ATTRIBUTE6
, NULL) TCL_FEE_ATTRIBUTE6
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FEE'
, TCL.ATTRIBUTE7
, NULL) TCL_FEE_ATTRIBUTE7
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FEE'
, TCL.ATTRIBUTE8
, NULL) TCL_FEE_ATTRIBUTE8
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FEE'
, TCL.ATTRIBUTE9
, NULL) TCL_FEE_ATTRIBUTE9
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FEE'
, TCL.ATTRIBUTE10
, NULL) TCL_FEE_ATTRIBUTE10
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FEE'
, TCL.ATTRIBUTE11
, NULL) TCL_FEE_ATTRIBUTE11
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FEE'
, TCL.ATTRIBUTE12
, NULL) TCL_FEE_ATTRIBUTE12
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FEE'
, TCL.ATTRIBUTE13
, NULL) TCL_FEE_ATTRIBUTE13
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FEE'
, TCL.ATTRIBUTE14
, NULL) TCL_FEE_ATTRIBUTE14
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'FEE'
, TCL.ATTRIBUTE15
, NULL) TCL_FEE_ATTRIBUTE15
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'SERVICE'
, TCL.ATTRIBUTE_CATEGORY
, NULL) TCL_SERVICE_ATTRIBUTE_CATEGORY
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'SERVICE'
, TCL.ATTRIBUTE1
, NULL) TCL_SERVICE_ATTRIBUTE1
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'SERVICE'
, TCL.ATTRIBUTE2
, NULL) TCL_SERVICE_ATTRIBUTE2
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'SERVICE'
, TCL.ATTRIBUTE3
, NULL) TCL_SERVICE_ATTRIBUTE3
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'SERVICE'
, TCL.ATTRIBUTE4
, NULL) TCL_SERVICE_ATTRIBUTE4
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'SERVICE'
, TCL.ATTRIBUTE5
, NULL) TCL_SERVICE_ATTRIBUTE5
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'SERVICE'
, TCL.ATTRIBUTE6
, NULL) TCL_SERVICE_ATTRIBUTE6
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'SERVICE'
, TCL.ATTRIBUTE7
, NULL) TCL_SERVICE_ATTRIBUTE7
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'SERVICE'
, TCL.ATTRIBUTE8
, NULL) TCL_SERVICE_ATTRIBUTE8
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'SERVICE'
, TCL.ATTRIBUTE9
, NULL) TCL_SERVICE_ATTRIBUTE9
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'SERVICE'
, TCL.ATTRIBUTE10
, NULL) TCL_SERVICE_ATTRIBUTE10
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'SERVICE'
, TCL.ATTRIBUTE11
, NULL) TCL_SERVICE_ATTRIBUTE11
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'SERVICE'
, TCL.ATTRIBUTE12
, NULL) TCL_SERVICE_ATTRIBUTE12
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'SERVICE'
, TCL.ATTRIBUTE13
, NULL) TCL_SERVICE_ATTRIBUTE13
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'SERVICE'
, TCL.ATTRIBUTE14
, NULL) TCL_SERVICE_ATTRIBUTE14
, DECODE( TEL.CONTRACT_LINE_TYPE
, 'SERVICE'
, TCL.ATTRIBUTE15
, NULL) TCL_SERVICE_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