Procurement - EBS (MOSC)

MOSC Banner

For Requisitions waiting approval how can I tell who the approval is waiting on

edited Jun 11, 2020 2:40AM in Procurement - EBS (MOSC) 3 commentsAnswered ✓

We need to know for open requisitions waiting approval, who has the requisition routed to them for approval at that time?  I am trying to write a query to get that data.  Can you tell me which table hold that data?  I found in po.po_approval_list_lines it has an approver_id.  This is the person the requisition was first sent to.  If that person has their vacation rules on or if your manually forward the approval in via the workflow status monitor it does not update the po.po_approval_list_lines with the new approver.  In Workflow Status Monitor it shows who the requisition is

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center