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
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
|
|
|