2008 (64)
2010 (42)
2011 (54)
2016 (1)
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;