Oracle Supplier Based On Organization Profile Query

   SELECT DISTINCT a.Vendor_name,
                   a.segment1,
                   a.vendor_id,
                   b.vendor_site_id,
                   b.vendor_site_code,
                   c.name
     FROM ap_suppliers a, ap_supplier_sites_all b, hr_operating_units c
    WHERE a.vendor_id = b.vendor_id AND b.org_id = c.organization_id
    AND c.organization_id=fnd_profile.VALUE('ORG_ID');