disable PO

[Roshan]

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 ='[e-mail] '
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

[ErmanArslansOracleBlog]

We don't update the ebs standard tables.
We use APIs.

Anyways, this is not the place for asking this since It is a functional issue.

thx