How to Query with condition in Oracle Report Database

select
i.vendor_name,
i.vendor_number,
i.invoice_amount,
nvl(i.invoice_amount,0)-nvl(i.amount_paid,0)+ nvl(i.amount_withheld,0)  OpeningBalancePrepaid,
i.invoice_type,
i.vendor_site_code, i.invoice_date,
i.invoice_num,
i.invoice_currency_code,
i.invoice_amount,
i.prepay_amount_applied,
i.gl_date,
i.doc_sequence_value vno,
c.check_number,
p.description

from
ap_invoices_v i,
ap_checks_v c,
ap_invoice_payments_v p

where
i.vendor_id=c.vendor_id
and
i.invoice_id=p.invoice_id
and
c.check_number=p.check_number
and
rownum<=10;