disable PO

Posted by Roshan on Feb 25, 2016; 12:03pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/disable-PO-tp600.html

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