SELECT
pv.vendor_type_lookup_code
,pv.segment1
,pv.tax_reporting_name
,pv.vendor_name
,PS.VENDOR_SITE_CODE
,PS.TAX_REPORTING_SITE_FLAG
,ps.address_line1
,ps.address_line2
,ps.city
,ps.state
,ps.zip
,pv.type_1099
,pv.num_1099
,c.check_number
,c.check_date
,IA.INVOICE_NUM
,IA.INVOICE_DATE
,IA.INVOICE_AMOUNT
,IA.AMOUNT_PAID


FROM
  AP.AP_INVOICES_ALL IA
 ,AP.AP_INVOICE_PAYMENTS_ALL IP
 ,AP.ap_checks_all c
 ,PO.po_vendors PV
 ,PO.PO_VENDOR_SITES_ALL PS

WHERE /*pv.vendor_type_lookup_code like '%1099%'
AND */IP.INVOICE_ID = IA.INVOICE_ID
AND IA.VENDOR_ID = PV.VENDOR_ID
AND PV.VENDOR_ID = PS.VENDOR_ID
/*AND PS.TAX_REPORTING_SITE_FLAG = 'Y'*/
and INVOICE_DATE > '01-DEC-11'
AND INVOICE_DATE < '01-SEP-13'
/*AND ia.org_id = 27779*/

AND IP.CHECK_ID = C.CHECK_ID

order by ps.address_line1