Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Query to See the Approver Name on Whom a PO is Pending For Approval — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query to See the Approver Name on Whom a PO is Pending For Approval

Received Response
192
Views
4
Comments
edited Aug 24, 2018 1:37PM in Purchasing 4 comments

Summary

Query to See the Approver Name on Whom a PO is Pending For Approval

Content

Most of the time we get an SR with requirement to see or extract on which approval level a PO is pending currently for approval. And customer wants a Query for this. Below is the Query we have prepared which will give on whom the PO is currently pending for approval. You can prepare an OTBI report to get the extract of all open POs and you can modify the query as per what column you need.

 

SELECT poh.segment1
,approval_instance_id, assignees, wf.outcome, wf.state ,wf.workflowpattern, wf.title, wf.componentname, wf.compositename, pov.change_order_status

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!