Valid for 11.5.10 .

1 Using the Alert Manager Responsibility
Navigate to Alert->Define form

Application: Purchasing
Alert type : Event alert
Table : PO_REQUISITION_HEADERS_ALL

Create an alert SQL statement which will fetch data only when a purchase order is approved

Alert SQL used
——————
select
segment1,
rowid,
authorization_status
into
&seg,
&rowid1,
&auth_status
from PO_REQUISITION_HEADERS_ALL
where upper(authorization_status)=’APPROVED’
and rowid=:rowid

2. Define action
For eg : send_msg
Message Level -> detail
Specify the valid address in the to field

3. Define a action set send_action_set
and add this action as a member to this action set

4. Mention the operating unit in the alert details->installations tab for which you need to run this alert.