SELECT   UPPER (v.vendor_name) "Vendor Name", v.segment1 "Vendor Number",
         c.bank_account_name "Bank Account Name",
         c.check_number "Check Number", c.check_date "Check Date",
         c.amount "Check Amount", 
         --c.currency_code "Currency",
         c.void_date "Void Date", c.check_id "Check Id",
         i.invoice_num "Invoice Number", i.invoice_date "Invoice Date",
         i.invoice_amount "Invoice Amount", ip.amount "Payment Amount",
         i.creation_date "Creation Date",
         i.payment_method_lookup_code "Payment Method Type",
         po.segment1 "PO Number",
         i.description "Description", 
         v.vendor_type_lookup_code "Employee Type"
   FROM apps.ap_checks_all c,
         apps.po_vendors v,
         apps.ap_invoices_all i,
         apps.ap_invoice_payments_all ip,
         apps.ap_invoice_distributions_all ap,
         apps.po_headers_all po
  WHERE po.vendor_id (+) = i.vendor_id 
     AND ip.invoice_id = i.invoice_id
     AND i.invoice_id = ap.invoice_id 
--     AND i.payment_method_lookup_code = 'CHECK'
     AND c.vendor_id = v.vendor_id
     AND c.check_id = ip.check_id
     AND v.vendor_id = i.vendor_id (+)
     AND c.check_date BETWEEN TO_DATE ('01/01/2007', 'dd/mm/yyyy')
                          AND TO_DATE ('31/03/2007', 'dd/mm/yyyy')
ORDER BY v.vendor_name