Topic: SQL*Plus and PL/SQL >> oracle alert sql query help
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: oracle alert sql query help |
| sgeeta |
Posted: Apr 04, 2007 11:51:50 PM |
Total Post: 1
Joined: Apr, 2007
|
Hi,
we are on APPS 11.5.7 I am using oracle alert.
I want the alert to email when some one only updates the payment terms like eg net30 to net20. Now if I update any thing it sends an email I dont want that any advice please help.
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 |
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 333 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
