compare two invoices with same distribution line count

 Hello ,

Assistance needed in achieving the following:

Release - 11i

I am trying to pull data out of Oracle Payables -  invoices for which the invoice amount ,the vendor and distribution line count is same.

I could achieve pulling invoices with same Vendor having same amount.But finding hard to compare the counts.

Can anyone share ideas on how to achieve this ... Tried self join but did not work.

The query which I used is as follows :

select invoice_num,invoice_id,invoice_amount,vendor_id,

(select vendor_name from apps.po_vendors where vendor_id=aia.vendor_id) vendor_name,