|
|
Is the script below going to disable the sceduled SRL Purchase Order Report and update the supplier email?
Script to update supplier's email
update hz_contact_points
set email_address ='Erpsupport@sunresorts.mu '
where contact_point_id in (select hcpe.contact_point_id
from hz_relationships hr,
hz_contact_points hcpe,
hz_parties hp ,
Ap_Suppliers aps
WHERE hr.object_id = hp.party_id(+)
AND hcpe.owner_table_id(+) = hr.party_id
AND aps.party_id = hr.subject_id(+)
AND hcpe.OWNER_TABLE_NAME = 'HZ_PARTIES'
and hcpe.EMAIL_ADDRESS is not null
AND hcpe.status = 'A');
commit;
Thanks,
Regards,
Roshan
|
Locked
