Select Suppliers Details in R12

How to select Suppliers Details in R12:

SELECT  asp.vendor_id ,
asp.segment1 "Supplier Num" ,
asp.vendor_name "Supplier Name" ,
asp.vendor_name_alt  "Supplier Name Alt",
ass.vendor_site_code "site name" ,
hou.name "Operating Unit Name" ,
ass.address_line1 ,
ass.city ,
ass.state ,
ass.zip ,
ass.country ,
ass.phone ,asp.vat_registration_num vendor_tax_number ,ass.vat_registration_num site_vendor_tax
FROM ap_suppliers asp ,
ap_supplier_sites_all ass ,
hr_operating_units hou
WHERE ass.vendor_id = asp.vendor_id
AND ass.org_id = hou.organization_id
--and ass.vat_registration_num is not null

order by to_number(asp.segment1) ;