Purchase Request Approval

Purchase Request Approval





SELECT pr.Requestid "Requestid",
       pr.Subject "Subject",
       pr.Description "Description",
       longtodate(pr.Requesteddate) "Requesteddate",
       longtodate(pr.Daterequired) "Daterequired",
       longtodate(pr.createddate) "createddate",
       pr.Shipping_details "Shipping_details",
       cri.FIRST_NAME "Created By",
       aau.FIRST_NAME "Requester",
       ti.FIRST_NAME "Technician",
       pd.PRIORITYNAME "Priority",
       std.statusname "Status",
       (aaa.FIRST_NAME) "Approver",
       (pos1.STATUSNAME) "PO Approval Status",
       LONGTODATE(poa1.APPROVAL_DATE) "Approval Date" FROM purchaserequest pr
LEFT JOIN SDUser sdu ON pr.Requestedby=sdu.USERID
LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID
LEFT JOIN SDUser crd ON pr.Createdby=crd.USERID
LEFT JOIN AaaUser cri ON crd.USERID=cri.USER_ID
LEFT JOIN SDUser td ON pr.Technicianid=td.USERID
LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID
LEFT JOIN PriorityDefinition pd ON pr.PRIORITYID=pd.PRIORITYID
LEFT JOIN POStatus std ON pr.statusid=std.statusid
LEFT JOIN PRLevelInfo pol ON pr.requestid=pol.requestid
LEFT JOIN PurchaseApprovalDetails poa1 ON pol.LEVELINFOID=poa1.LEVELINFOID
LEFT JOIN AaaUser aaa ON poa1.APPROVERID=aaa.USER_ID
LEFT JOIN levelinfo li ON pol.LEVELINFOID=li.LEVELINFOID
LEFT JOIN POApprovalStatus pos1 ON li.LEVELSTATUSID=pos1.STATUSID
ORDER BY 1




                  New to ADSelfService Plus?

                    • Related Articles

                    • Purchase order approval details

                      SELECT po.POCUSTOMID AS "PO Number", max(po.PONAME) AS "PO Name", max(poa.FIRST_NAME) AS "Purchase Requester", longtodate(max(po.DATEORDERED)) AS "Ordered Date", longtodate(max(po.DATEREQUIRED)) AS "Required Date", max(pos.STATUSNAME) AS "PO Status", ...
                    • Purchase Request details

                      Select pr.REQUESTID AS "Request Id", pr.SUBJECT AS "PR Subject", pr.DESCRIPTION AS "Description", LONGTODATE(pr.REQUESTEDDATE) AS "Requested Date", LONGTODATE(pr.DATEREQUIRED) AS "Date Required", LONGTODATE(pr.CREATEDDATE) AS "Created Date", ...
                    • Request Approval Details

                      This report is used to view the historical details of Approved and Denied approval processes and their individual steps. We can also use this report to display all details for which an approval decision is pending. To make any changes to a query, ...
                    • Query to list Service Request Approver and Purchase Request Approver (MSSQL & PGSQL)

                      Tested in Build PGSQL (14300) or MSSQL (14306) Select aau.first_name "Name", po.approverstatus "Purchase Request Approver", sr.approverstatus "Service Request Approver", adef.org_name "Account" from aaauser aau left join POApproverDetails po on ...
                    • Query to get approval status per request with approvers by account (MSSQL)

                      Tested in build MSSQL (14306) SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", wo.DESCRIPTION As "DESCRIPTION", aau.FIRST_NAME AS "Requester", dpt1.DEPTNAME AS " Requester Department", srep.First_Name As "Suprep", qd.QUEUENAME AS ...