try thisselect a.vendor_name, b.vendor_site_code,u.organization_id, u.name,h.* from Po_headers_all h , po_vendors a, po_vendor_sites_all b,hr_organization_units uwhere h.segment1 = 228and a.vendor_id = h.vendor_idand a.vendor_id = b.vendor_idand h.vendor_site_id = b.vendor_site_idand h.org_id = u.organization_id