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; |