Supplier details - data extract

 SELECT

    pv.vendor_id,

    pv.segment1 AS vendor_number,

    pv.vendor_name,

    pv.vendor_type_lookup_code,

    pv.enabled_flag,

    pv.start_date_active,

    pv.end_date_active,

    pvs.vendor_site_id,

    pvs.vendor_site_code,

    pvs.address_line1,

    pvs.address_line2,

    pvs.city,

    pvs.state,

    pvs.zip,

    pvs.country,

    pvs.phone,

    pvs.fax,

    pvs.email_address,

    pvs.creation_date

FROM 

    apps.ap_suppliers pv,

    apps.ap_supplier_sites_all pvs

WHERE 

    pv.vendor_id = pvs.vendor_id

    AND pv.enabled_flag = 'Y'

    AND pvs.inactive_date IS NULL

ORDER BY 

    pv.vendor_name, pvs.vendor_site_code;