Query to See the Approver Name on Whom a PO is Pending For Approval
Summary
Query to See the Approver Name on Whom a PO is Pending For ApprovalContent
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
8