cancel
Showing results for 
Search instead for 
Did you mean: 

Query Help

Former Member
0 Kudos

Hello experts,

I have setup the approval procedures on a PO but the client wants to send the alerts via email for purchase orders that needs to be approved. Using the SBO mailer i created alerts to be sent out but the query is not complete. The approval procedures has several stages and when i query the ODRF i cant figure out what stage of approval the purchase order is in. All i see is a status where 'W' is for pending. Is there a way to know which stage of the process is the purchase order in?

Thank you

Chintan

Accepted Solutions (1)

Accepted Solutions (1)

msundararaja_perumal
Active Contributor
0 Kudos

Hi,

You can use OWDD table(Docs for confirmation) to retrieve the details of the approval status of the documents.

The Status column value indicates as below

A-Generated by Authorized

C-Cancelled

N-Rejected

P-Generated

W-Pending

Y-Approved

Hope this its helpful!

Former Member
0 Kudos

This does help but when i query the OWDD it does not give me document number. How do i connect the tables so that i can query to see what stage is the purchase order in? Do you know if there is way?

Thank you

Chintan

Answers (0)