Alert Sql Help Info
Posted: Tue Apr 03, 2007 10:23 pm
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
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