View: OKL_ST_MAP_SUBSIDIES_V

Product:	OKL - Lease and Finance Management
Description:	View added for subsidies
Implementation/DBA Data:	APPS.OKL_ST_MAP_SUBSIDIES_V

View Text

SELECT SIFB.TRANSACTION_NUMBER
, SFEB.SIF_ID SIF_ID
, SFEB.KLE_ID
, SFEB.SIL_ID
, SFEB.FEE_INDEX_NUMBER
, SFEB.DESCRIPTION
, SFEB.AMOUNT
, SILB.INDEX_NUMBER ASSET_INDEX_NUMBER
, SFEB.RATE
, SFEB.STREAM_INTERFACE_ATTRIBUTE01
, SFEB.STREAM_INTERFACE_ATTRIBUTE02
, SFEB.STREAM_INTERFACE_ATTRIBUTE03
, SFEB.STREAM_INTERFACE_ATTRIBUTE04
, SFEB.STREAM_INTERFACE_ATTRIBUTE05
, SFEB.STREAM_INTERFACE_ATTRIBUTE06
, SFEB.STREAM_INTERFACE_ATTRIBUTE07
, SFEB.STREAM_INTERFACE_ATTRIBUTE08
, SFEB.STREAM_INTERFACE_ATTRIBUTE09
, SFEB.STREAM_INTERFACE_ATTRIBUTE10
, SFEB.STREAM_INTERFACE_ATTRIBUTE11
, SFEB.STREAM_INTERFACE_ATTRIBUTE12
, SFEB.STREAM_INTERFACE_ATTRIBUTE13
, SFEB.STREAM_INTERFACE_ATTRIBUTE14
, SFEB.STREAM_INTERFACE_ATTRIBUTE15
, SFEB.STREAM_INTERFACE_ATTRIBUTE16
, SFEB.STREAM_INTERFACE_ATTRIBUTE17
, SFEB.STREAM_INTERFACE_ATTRIBUTE18
, SFEB.STREAM_INTERFACE_ATTRIBUTE19
, SFEB.STREAM_INTERFACE_ATTRIBUTE20
FROM OKL_SIF_FEES SFEB
, OKL_STREAM_INTERFACES SIFB
, OKL_SIF_LINES SILB
WHERE SIFB.ID = SFEB.SIF_ID
AND SFE_TYPE = 'SFB'
AND SILB.ID = SFEB.SIL_ID ORDER BY FEE_INDEX_NUMBER

Columns