Oracle R12 Vendor Details Query

----Oracle R12 Supplier name and Address  

SELECT     (Select Name from hr_operating_units where organization_id=aps.ORG_ID) OU_NAME,
           ap.segment1 vendor_code,
           ap.vendor_name,
           aps.vendor_site_code vendor_Site_Code,
           ap.VENDOR_TYPE_LOOKUP_CODE Type_Code,
           aps.address_line1,
           aps.address_line2,
           aps.address_line3,
           aps.city,
           aps.state,
           aps.zip,
           aps.Country,
           apc.AREA_CODE,
           apc.PHONE,
           apc.FAX_AREA_CODE,
           apc.FAX,
           apc.EMAIL_ADDRESS
    FROM   ap_suppliers ap,
           ap_supplier_sites_all aps,
           ap_supplier_contacts apc
--           hz_party_sites hps,
--           zx_party_tax_profile zp
--           zx_registrations zr
   WHERE       ap.vendor_id = aps.vendor_id
           AND apc.VENDOR_CONTACT_ID(+) = ap.VENDOR_ID
           AND NVL(ap.VENDOR_TYPE_LOOKUP_CODE,'NA') <>  'EMPLOYEE'
           AND aps.vendor_site_code NOT IN 'OFFICE'
           AND ap.enabled_flag ='Y'
--           AND hps.PARTY_SITE_ID = aps.PARTY_SITE_ID
--           AND hps.party_id = zp.party_id
--           AND zp.PARTY_TYPE_CODE = 'THIRD_PARTY'
--           AND PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'
--           AND zr.party_tax_profile_id(+)= zp.party_tax_profile_id
--           AND ap.segment1='2406'
ORDER BY   ap.segment1, ap.vendor_name