Supplier Communication

Hello All,

We are in process of developing a scnerio in which :

1- Requistion to be Auto created.
2- Requistion to be Auto Approved.
3- Blanket Release /STD .PO to be Auto created.
4- Blanket Release /STD .PO to be Auto Approved.
5- Auto Email communication to supplier after generation of Std PO./ Blanket release.

Now From Sr.1 to Sr.No. 4 : SUCCESSFULLY DONE.
Problem for Sr.No. 5: Email communication to supplier

when i create a STANDARD PO ....email is sent to supplier.
The below query return 3 rows.
Select notification_id, USER_KEY, TO_USER, FROM_USER from apps.wf_notifications where user_key= 'xxxx'