Alert Sql Help Info

[sgeeta]

Hi,
I want the alert email when some one only updates the terms like eg net 30 to net 20. Now if I update any thing it sends an email I dont want that any advice.

EVENT ALERT TABLE NAME: PO_VENDOR_SITES_ALL
SELECT
PV.SEGMENT1,
PV.VENDOR_NAME,
PV.LAST_UPDATE_DATE,
AA.NAME,
U.DESCRIPTION
INTO
&VNUM
&VNAME
&UDATE
&TNAME
&WHO
FROM PO_VENDORS PV, AP_TERMS AA,FND_USER U,PO_VENDOR_SITES_ALL PP
WHERE PV.TERMS_ID = AA.TERM_ID
---AND PV.LAST_UPDATE_DATE > TO_DATE('01-APR-07')
AND PP.VENDOR_ID = PV.VENDOR_ID
AND PV.LAST_UPDATED_BY = U.USER_ID
AND PP.PAY_SITE_FLAG = 'Y'
AND PP.ROWID =:ROWID

Thanks

[ramkic]

Hi,
One way you can achieve this by having an update trigger on Payment Terms on po_vendor_sites_all table and call utl_smtp protocol to send email notifications to responsible persons.
Regards
ramkic

[sgeeta]

we are on 11.5.7 and database 8.1.0 thx
[quote]Hi,
One way you can achieve this by having an update trigger on Payment Terms on po_vendor_sites_all table and call utl_smtp protocol to send email notifications to responsible persons.
Regards
ramkic

<i><div align="right">Originally posted by ramkic

[sgeeta]

Hi Ramkic

do you have any sample code to do that we are on 8.0.1 does that have smtp mail please advice

[ramkic]

Hi,
I will be working on the script. Can you please send me your email id, so that I can send it. Once you have tested that, we can request "Admin" to upload the same for future use.
Thanks
ramkic

[sgeeta]

Thanks so much ramkic its sgeeta21@gmail.com
[quote]Hi,
I will be working on the script. Can you please send me your email id, so that I can send it. Once you have tested that, we can request "Admin" to upload the same for future use.
Thanks
ramkic

<i><div align="right">Originally posted by ramkic