Assistance Required: SQL Query for Mail ID and From Date Using Site Number

Hi All,

I need an SQL query to retrieve the mail ID and from date in Receivables Billing using the site number in Oracle Fusion.

Application navigation:
Receivables → Billing → Task (Manage Customers) → Registry ID

I have already used the query below, but it is not giving the exact output.

Could you please suggest? Thank you in advance for your help.

SELECT
hps.party_site_number,
hcp.EMAIL_ADDRESS,
hcp.START_DATE

FROM
hz_party_sites hps
JOIN hz_parties hp ON hps.party_id = hp.party_id
JOIN hz_relationships hr ON hr.object_id = hp.party_id
AND hr.relationship_code = 'CONTACT_OF'