View: OKL_ST_MAP_LOAN_LINES_V

Product:	OKL - Lease and Finance Management
Description:	View on OKL_SIF_LINES, OKL_STREAM_INTERFACES & OKL_SIF_FEES.
Implementation/DBA Data:	APPS.OKL_ST_MAP_LOAN_LINES_V

View Text

SELECT SILB.ID ID
, SILB.SIF_ID SIF_ID
, SILB.KLE_ID KLE_ID
, SILB.INDEX_NUMBER INDEX_NUMBER
, SILB.DESCRIPTION DESCRIPTION
, SILB.DATE_LENDING DATE_LENDING
, SILB.DATE_START DATE_START
, SFEB.STRUCTURE STRUCTURE
, SILB.STREAM_INTERFACE_ATTRIBUTE01 STREAM_INTERFACE_ATTRIBUTE01
, SILB.STREAM_INTERFACE_ATTRIBUTE02 STREAM_INTERFACE_ATTRIBUTE02
, SILB.STREAM_INTERFACE_ATTRIBUTE03 STREAM_INTERFACE_ATTRIBUTE03
, SILB.STREAM_INTERFACE_ATTRIBUTE04 STREAM_INTERFACE_ATTRIBUTE04
, SILB.STREAM_INTERFACE_ATTRIBUTE05 STREAM_INTERFACE_ATTRIBUTE05
, SILB.STREAM_INTERFACE_ATTRIBUTE06 STREAM_INTERFACE_ATTRIBUTE06
, SILB.STREAM_INTERFACE_ATTRIBUTE07 STREAM_INTERFACE_ATTRIBUTE07
, SILB.STREAM_INTERFACE_ATTRIBUTE08 STREAM_INTERFACE_ATTRIBUTE08
, SILB.STREAM_INTERFACE_ATTRIBUTE09 STREAM_INTERFACE_ATTRIBUTE09
, SILB.STREAM_INTERFACE_ATTRIBUTE10 STREAM_INTERFACE_ATTRIBUTE10
, SILB.STREAM_INTERFACE_ATTRIBUTE11 STREAM_INTERFACE_ATTRIBUTE11
, SILB.STREAM_INTERFACE_ATTRIBUTE12 STREAM_INTERFACE_ATTRIBUTE12
, SILB.STREAM_INTERFACE_ATTRIBUTE13 STREAM_INTERFACE_ATTRIBUTE13
, SILB.STREAM_INTERFACE_ATTRIBUTE14 STREAM_INTERFACE_ATTRIBUTE14
, SILB.STREAM_INTERFACE_ATTRIBUTE15 STREAM_INTERFACE_ATTRIBUTE15
, SIFB.TRANSACTION_NUMBER TRANSACTION_NUMBER
, SFEB.DAYS_IN_MONTH
, SFEB.DAYS_IN_YEAR
, SILB.DOWN_PAYMENT_AMOUNT
, SILB.CAPITALIZE_DOWN_PAYMENT_YN
FROM OKL_SIF_LINES SILB
, OKL_STREAM_INTERFACES SIFB
, OKL_SIF_FEES SFEB
WHERE SILB.SIL_TYPE = 'SGN'
AND SILB.SIF_ID = SIFB.ID
AND SILB.ID = SFEB.SIL_ID
AND SFEB.SFE_TYPE = 'SFN'
AND SFEB.LEVEL_INDEX_NUMBER = 0 ORDER BY SILB.INDEX_NUMBER

Columns