View: OKL_ST_MAP_STREAMS_V

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

View Text

SELECT SIFB.TRANSACTION_NUMBER TRANSACTION_NUMBER
, STYL. NAME STREAM_TYPE_NAME
, SITB.SIF_ID SIF_ID
, SITB.SFE_ID SFE_ID
, SFEB.FEE_INDEX_NUMBER FEE_INDEX_NUMBER
, SILB.INDEX_NUMBER ASSET_INDEX_NUMBER
, SFEB.SFE_TYPE SFE_TYPE
, SILB.SIL_TYPE SIL_TYPE
, SITB.PRICING_NAME PRICING_NAME
FROM OKL_STRM_TYPE_TL STYL
, OKL_STREAM_INTERFACES SIFB
, OKL_SIF_STREAM_TYPES SITB
, OKL_SIF_FEES SFEB
, OKL_SIF_LINES SILB
WHERE SITB.SIF_ID = SIFB.ID
AND SITB.STY_ID = STYL.ID
AND SITB.SIL_ID = SILB.ID(+)
AND SITB.SFE_ID = SFEB.ID(+)
AND STYL.LANGUAGE = 'US'

Columns