[Home] [Help]
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
Name |
TRANSACTION_NUMBER |
STREAM_TYPE_NAME |
SIF_ID |
SFE_ID |
FEE_INDEX_NUMBER |
ASSET_INDEX_NUMBER |
SFE_TYPE |
SIL_TYPE |
PRICING_NAME |