Supplier and Site in AP

select distinct 
       pv.vendor_id,
       pv.segment1,
       pv.attribute1 header_id,
       pv.vendor_name,
       pv.start_date_active ,
       pv.end_date_active,  
       ps.vendor_site_code,
       ps.inactive_date,
       ps.ADDRESS_LINE1,
       ps.ADDRESS_LINE2,
       ps.org_id,
       pv.creation_date v_created,
       ps.creation_date s_created,
--       pv.created_by,
--       ps.created_by,
       ps.ADDRESS_LINE3,
       ps.ADDRESS_LINE4,
       ps.city,
       ps.state,
       ps.zip
  from po_vendors pv, po_vendor_sites_all ps
 where pv.vendor_id = ps.vendor_id
   and pv.vendor_name like '%'