vendor details query

select 
pv.VENDOR_NAME,
pv.segment1 Supplier_number,
pvs.VENDOR_SITE_CODE site_name,
pv.match_option vendor_match_option,
pvs.match_option site_match_option,
ADDRESS_LINE1,
ADDRESS_LINE2,
ADDRESS_LINE3
CITY,
STATE,
ZIP,
PROVINCE,
COUNTRY ,
pv.START_DATE_ACTIVE,
pv.end_DATE_ACTIVE
from
po_vendors pv,
po_vendor_sites_all pvs
where pv.vendor_id = pvs.vendor_id
and pvs.org_id =111