Go to previous topic
Go to next topic
Last Post 8/31/2022 6:04 PM by  Jay S
SQL query to pull Reqs and who Approved them
 1 Replies
Author Messages
twinsmomma
ERP Advisor
Dell Services
New Member
(2 points)
New Member
Posts:2


Send Message:

--
8/30/2022 8:17 PM

    Which tables do I use?  I found the PFIWORKUNIT and can filter on Req Approval with Statuse codes, but how can I link the Approvers  for Approver 1 and Approver 2 and who approved these or denied?  

     

     

    Tags: Process Flow Approval SQL Requisition
    Jay S
    Application Analyst III - Lawson
    Sutter Health
    Basic Member
    (18 points)
    Basic Member
    Posts:6


    Send Message:

    --
    8/31/2022 6:04 PM


    My SQL novice query uses PFIMETRICS.  Hope this helps

    SELECT PFIMETRICS.PFIWORKUNIT, PFIMETRICS.PMPFIUSERPROFILE, PFIMETRICS.PMPTTASKNAME, PFIMETRICS.ACTIONDATE, PFIMETRICS.ACTIONTAKEN, PFIWORKUNIT.WORKTITLE, PFIWORKUNIT.FLOWDEFINITION, PFIWORKUNIT.STARTDATE
    FROM PFIMETRICS INNER JOIN PFIWORKUNIT ON PFIMETRICS.PFIWORKUNIT = PFIWORKUNIT.PFIWORKUNIT
    WHERE (((PFIMETRICS.PFIWORKUNIT)>14700000) AND ((PFIWORKUNIT.FLOWDEFINITION) Like "*ReqApp*" AND ((PFIWORKUNIT.STARTDATE)>#8/30/2022#))
    ORDER BY PFIWORKUNIT.WORKTITLE;

     



    ---