R12 Disabled Supplier

//R12 Disabled Supplier

select vs.org_id, pv.segment1, pv.vendor_name, vs.vendor_site_code, pv.creation_date “Supplier Creation Date”, pv.END_DATE_ACTIVE “Supplier End Date”, vs.creation_date “Site Creation Date”
from apps.ap_suppliers pv, ap_supplier_sites_all vs
where pv.vendor_id = vs.vendor_id
–vs.last_updated_by = ‘14899’
and vs.org_id =132
AND pv.end_date_active IS NOT NULL
and (pv.LAST_UPDATE_DATE between TO_DATE(‘2015-02-16 00:00:00’ , ‘YYYY-MM-DD HH24:MI:SS’) and TO_DATE(‘2015-02-17 23:59:59’ , ‘YYYY-MM-DD HH24:MI:SS’))
order by 4;