EXample of Relationship between Checks and Payments, Invoices

SELECT

v.vendor_id,

v.invoice_id,

v.invoice_amount        InvoiceAmount ,

c.check_id              CheckID,

c.amount                CheckAmount,

p.amount                PaymentAmount

FROM

Ap_Invoices_All            v,

Ap_Checks_All              c,

AP.AP_INVOICE_PAYMENTS_ALL p

WHERE

         c.check_id=p.check_id

and      v.invoice_id=p.invoice_id

and v.invoice_date between '1-JAN-2009' and '30-FEB-2010'

and v.vendor_id='0000'

and v.invoice_type_lookup_code='STANDARD'