I am needing to write an sql statement to email me an alert of P.O.'s that need to be approved. They are in a requisition stage before they become a P.O. I'm am try to get a list emailed to me. Any help would be appreciated.
select * from po_headers_all where authorization_status!='APPROVED';
you may need to modify the query according to your requirement.
Hope this will help you...