DBA Data[Home] [Help]

VIEW: APPS.OKL_ST_MAP_RENT_INDEX_V

Source

View Text - Preformatted

SELECT DISTINCT SFEB.FEE_INDEX_NUMBER FEE_INDEX_NUMBER, SIFB.TRANSACTION_NUMBER TRANSACTION_NUMBER FROM OKL_SIF_FEES SFEB,OKL_STREAM_INTERFACES SIFB WHERE SFEB.SIF_ID = SIFB.ID AND SFEB.SFE_TYPE = 'SFR' ORDER BY SFEB.FEE_INDEX_NUMBER
View Text - HTML Formatted

SELECT DISTINCT SFEB.FEE_INDEX_NUMBER FEE_INDEX_NUMBER
, SIFB.TRANSACTION_NUMBER TRANSACTION_NUMBER
FROM OKL_SIF_FEES SFEB
, OKL_STREAM_INTERFACES SIFB
WHERE SFEB.SIF_ID = SIFB.ID
AND SFEB.SFE_TYPE = 'SFR' ORDER BY SFEB.FEE_INDEX_NUMBER