SELECT * FROM ( SELECT PoVendors . vendor_id AS SUPPLIER_ID , PoVendorSitesAll . vendor_site_id AS SUPPLIER_SITE_ID , PoVendorContacts . vendor_contact_id AS SUPPLIER_CONTACT_ID , PoVendors . vendor_name AS SUPPLIER_NAME , Decode ( PoVendorContacts . first_name , NULL , PoVendorContacts . last_name , PoVendorContacts . last_name || ', ' || PoVendorContacts . first_name ) AS SUPPLIER_CONTACT_NAME , PoVendorSitesAll . address_line1 || ' ' || PoVendorSitesAll . address_line2 || ' ' || PoVendorSitesAll . address_line3 || ' ' || PoVendorSitesAll . city || ' ' || PoVendorSitesAll . state || ' ' || PoVendorSitesAll . zip || ' ' || PoVendorSitesAll . co