Removing customer email addresses in non-production environment

To avoid accidently send emails to customers when we doing the testing in non-production environment, we need to remember to remove the real customer emails when we clone from production.

Here is the query to run:

update HZ_CONTACT_POINTS set email_address = '' where owner_table_id in

   (select party_sites.party_site_id from hz_party_sites party_sites, hz_cust_acct_sites a_bill

   where party_sites.party_site_id = a_bill.party_site_id )

commit;