Query to find Basic Supplier Details in Oracle Fusion Cloud

This Oracle query can be used to extract the details of all the Supplier data including Supplier Address and Supplier Sites in Oracle ERP Cloud. This can be pasted directly to the Oracle cloud BI catalog Data Model. 
Have added sample commented filters that can be enabled to narrow down the search for the relavent suppliers.

SELECT ffbu.bu_name                               PROCUREMENT_BU,

       hp.party_name                                     VENDOR_NAME,

       ps.segment1                                        SUPPLIER_NUMBER,

   hps.party_site_name                              SUPPLIER_ADDRESS_NAME,

       pssv.vendor_site_code                       SUPPLIER_SITE_NAME,

       ps.vendor_type_lookup_code            SUPPLIER_TYPE,

       ps.organization_type_lookup_code TAX_ORGANIZATION_TYPE,

       ps.business_relationship,

       hop.duns_number_c                           DUNS_NUMBER,

       ps.customer_num,

       ps.standard_industry_class               SIC,

       hop.party_number                               PARTY_NUMBER,

       psp.income_tax_id                              TAX_PAYER_ID,

       pssv.pay_group_lookup_code           PAY_GROUP,

       hp.address1,

       hp.address2,

       hp.city,

       hp.state,

       hp.county

FROM   poz_suppliers ps,

       hz_parties hp,

       hz_organization_profiles hop,

       poz_suppliers_pii psp,

       hz_party_sites hps,

       hz_parties hp_contact,

       poz_supplier_sites_v pssv,

       fun_fin_business_units_v ffbu

WHERE  hp.party_id = ps.party_id

       AND ps.vendor_id = pssv.vendor_id

       AND hop.party_id = ps.party_id

       AND pssv.prc_bu_id = FFBU.bu_id

       AND psp.vendor_id(+) = ps.vendor_id

       AND hps.party_site_id(+) = hp.iden_addr_party_site_id

       AND hp_contact.party_id(+) = hp.preferred_contact_person_id

        — AND ps.creation_date > SYSDATE – 365

        — AND hp.party_name like ‘ABC%’