In this session, we are going to see how to fetch Oracle Cloud Supplier data using SQL. SQL Text: select sup . vendor_name Supplier_Name , sup . segment1 Supplier_Number , sup_addr . party_site_name Address_Name , sup_addr . address1 Address_Line_1 , sup_addr . city City , sup_addr . state State , sup_addr . postal_code Postal_Code , case when ( sup_addr . phone_country_code is not null and sup_addr . phone_area_code is not null and sup_addr . phone_number is not null ) then '+' || sup_addr . phone_country_code || ' (' || sup_addr . phone_area_code || ') ' || substr ( sup_addr . phone_number , 1 , 3 ) || '-' || substr ( sup_addr . phone_number , 4 , 4 ) else '' end Phone , case when ( sup_addr . address_purpose_ordering = 'Y' and sup_addr . address_purpose_remit_to = 'Y' and sup_addr . address_