SELECT DISTINCT SFEB.FEE_INDEX_NUMBER FEE_INDEX_NUMBER, SFEB.SFE_TYPE SFE_TYPE, SFEB.DESCRIPTION DESCRIPTION, SIFB.TRANSACTION_NUMBER TRANSACTION_NUMBER, SFEB.STRUCTURE STRUCTURE , SFEB.days_in_month days_in_month, SFEB.days_in_year days_in_year, SFEB.down_payment_amount, sfeb.kle_id kle_id, sfeb.orig_contract_line_id orig_contract_line_id FROM OKL_SIF_FEES SFEB,OKL_STREAM_INTERFACES SIFB WHERE SFEB.SIF_ID = SIFB.ID ORDER BY SFEB.FEE_INDEX_NUMBER
SELECT DISTINCT SFEB.FEE_INDEX_NUMBER FEE_INDEX_NUMBER
, SFEB.SFE_TYPE SFE_TYPE
, SFEB.DESCRIPTION DESCRIPTION
, SIFB.TRANSACTION_NUMBER TRANSACTION_NUMBER
, SFEB.STRUCTURE STRUCTURE
, SFEB.DAYS_IN_MONTH DAYS_IN_MONTH
, SFEB.DAYS_IN_YEAR DAYS_IN_YEAR
, SFEB.DOWN_PAYMENT_AMOUNT
, SFEB.KLE_ID KLE_ID
, SFEB.ORIG_CONTRACT_LINE_ID ORIG_CONTRACT_LINE_ID
FROM OKL_SIF_FEES SFEB
, OKL_STREAM_INTERFACES SIFB
WHERE SFEB.SIF_ID = SIFB.ID ORDER BY SFEB.FEE_INDEX_NUMBER
|
|
|