VIEW: APPS.OKL_ST_MAP_STREAMS_V

Source

View Text - Preformatted

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_STRM_TYPE_B STY,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' AND SITB.STY_ID = STY.ID AND STY.STREAM_TYPE_PURPOSE <> 'ESTIMATED_PROPERTY_TAX' UNION 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 , NULL 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, OKL_STRM_TYPE_B STY WHERE SITB.SIF_ID = SIFB.ID AND SITB.STY_ID = STYL.ID AND SITB.SIL_ID = SILB.ID AND SITB.SIL_ID = SFEB.SIL_ID AND STYL.LANGUAGE = 'US' AND SITB.STY_ID = STY.ID AND STY.STREAM_TYPE_PURPOSE = 'ESTIMATED_PROPERTY_TAX' AND STY.STREAM_TYPE_PURPOSE = SFEB.DESCRIPTION

View Text - HTML Formatted

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_STRM_TYPE_B STY
, 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'
AND SITB.STY_ID = STY.ID
AND STY.STREAM_TYPE_PURPOSE <> 'ESTIMATED_PROPERTY_TAX' UNION 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
, NULL 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
, OKL_STRM_TYPE_B STY
WHERE SITB.SIF_ID = SIFB.ID
AND SITB.STY_ID = STYL.ID
AND SITB.SIL_ID = SILB.ID
AND SITB.SIL_ID = SFEB.SIL_ID
AND STYL.LANGUAGE = 'US'
AND SITB.STY_ID = STY.ID
AND STY.STREAM_TYPE_PURPOSE = 'ESTIMATED_PROPERTY_TAX'
AND STY.STREAM_TYPE_PURPOSE = SFEB.DESCRIPTION