Need customer contacts with address at site level

Hello Team,

I'm looking for a customer contact names along with their addresses at site level ? Kindly help to provide a query.

Below is the one which I'm looking but it doesn't have contact name info in it.

select account_number "Account Number"

     , hp.party_name  "Customer Name"

     , loc.address1 ||

       decode(loc.address2, null, null, ', ' || loc.address2) ||

       decode(loc.address3, null, null, ', ' || loc.address3) ||

       decode(loc.address4, null, null, ', ' || loc.address4) ||

       ' ' || loc.city || ', ' || loc.state || ' ' || loc.postal_code "Address"

     , hcp.contact_point_type || ': ' ||

       DECODE(hcp.contact_point_type, 'EMAIL', hcp.email_address