ECC Lease Contracts, Lease Vendor Cash Summary

select
x.*
from
(
SELECT * FROM
(SELECT
    contract_id||ovs.contract_number||cle_id||customer_trx_line_id||line_type ECC_SPEC_ID,
    contract_id,
    ovs.contract_number,
    cle_id,
    customer_trx_line_id,
    line_type,
    ar_inv_number,
    nvl(asset_number,'  ')  asset_number,
    ar_inv_line_amt ar_inv_line_amt,
    receipt_amt_applied,
    remaining_balance ,
    ap_inv_line_amount,
    ap_line_amount_paid ,
    summarization_date,
    nvl(sttl.name,'  ') PASSTHRU_STREAM_PURPOSE,
    (decode(ovs.passthru_stream_type_purpose,'PASS_THROUGH_ADVANCE',to_number(0),stream_amount)) stream_amount ,
    nvl(sttl.language,'US') language_code,
    ovs.org_id,
    clawback_flag
FROM
    okl_ecc_vcf_summary_dts_v ovs,
    okl_strm_type_tl sttl
WHERE  ovs.passthru_stream_type_id = sttl.id(+)
AND    sttl.language in('US')
AND    processing_status_flag='N')
PIVOT            (MAX(passthru_stream_purpose) AS passthru_stream_purpose
                  FOR language_code IN ('US' "US"))
) x
where
2=2