VIEW: APPS.OKL_ASSET_DFF_EXTRACT_LINE_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'