Customer Contact Information - Basic

SELECT PARTY_ID,
       Person_last_name,
       person_first_name,
       party_number,
       party_name,
       status,
       email_address
FROM fusion.hz_Parties
WHERE upper(party_name) LIKE upper('%&PARTY_NAME%')
  AND party_type = 'PERSON';