Query on pending approval for PRs
Can anyone please provide me the query to be run on toad for pending approval for PRs, basically the PRs which are in 'in process' status.
The output should contain, PR no,.approver's name, authorisation status,requestor's name,preparer name,creation date,cateory description,deliver to location,item description,unit price,quantity,total amount, PR description,preparer name.
Thanks & Regards,
Roshan