Query for inactivity suppliers list

Hi all,

I need to retrieve the suppliers have an extended period of inactivity and going to end the suppliers in the  

AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL tables. 

Below is the query (initial draft) to get the Suppliers that are not Paid in since Oct-12.

select distinct v.vendor_id, vs.vendor_site_id

FROM AP_SUPPLIERS v

,AP_SUPPLIER_SITES_ALL vs

,AP_CHECKS_ALL ac

WHERE v.vendor_id = vs.vendor_id

and ac.vendor_id = v.vendor_id

and ac.vendor_site_id = vs.vendor_site_id

and ac.status_lookup_code <> 'VOIDED'

and v