SQL Query to get the Supplier Address Details - Oracle Fusion.

Here is the generic Suppliers Address Details as per the FBDI Template.

SELECT  

  hp.party_name 

         ,psa.party_site_name AddressName

  ,psa.country

  ,psa.address1

  ,psa.address2

  ,psa.address3

  ,psa.address4

  ,psa.address_lines_phonetic

  ,psa.addr_element_attribute1

  ,psa.addr_element_attribute2

  ,psa.addr_element_attribute3

  ,psa.addr_element_attribute4

  ,psa.addr_element_attribute5

  ,psa.building

  ,psa.floor_number

  ,psa.city

  ,psa.state

  ,psa.province

  ,psa.county

  ,psa.postal_code

  ,psa.postal_plus4_code

  ,psa.location_language

  ,psa.inactive_date

  ,psa.phone_country_code

  ,psa.phone_area_code

  ,psa.phone_number

  ,psa.phone_extension

  ,psa.fax_country_code

  ,psa.fax_phone_area_code

  ,psa.fax_phone_number

  ,psa.address_purpose_rfq_or_bidding

  ,psa.address_purpose_ordering

  ,psa.address_purpose_remit_to

,psa.email_address  email

FROM  poz_suppliers pos

     ,hz_parties hp

     ,poz_supplier_address_v psa 

, hz_party_sites hps

WHERE pos.party_id        = hp.party_id

  AND pos.vendor_id       = psa.vendor_id

  AND psa.party_id        = pos.party_id

  and hps.party_site_id = psa.party_site_id