ECC Lease Contracts, Lease Quote Summary

select
x.*
from
(
SELECT * FROM
(select contract_id, Contract_number,to_char(quote_number) quote_number,stream_code,
asset_number,gl_account,gl_acct_description,
sum(formula_value) forecasted_amount,
sum(remaining_balance) remaining_stream_bal,
sum(subledger_value) subledger_bal,
sum(remaining_balance)-sum(formula_value) Quote_adjustnment,
contract_id||'-'||quote_number||'-'||stream_code||'-'||asset_number||'-'||gl_account ecc_spec_id,
org_id,
ledger_name,
ledger_currency,
currency_code  --bug 32405966
--sty_tl.language language_code
from okl_ecc_arcon_quotes oaq
--okl_strm_type_tl     sty_tl
where processing_status_flag ='N'
and   quote_line_status <> 'CANCELLED'
--and oaq.stream_code = sty_tl.name
group by contract_id, Contract_number, quote_number,asset_number,gl_account,
gl_acct_description,ledger_name,ledger_currency,org_id,stream_code,currency_code)
) x
where
2=2