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




          • 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", ...
          • 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, ...
          • Purchase Request details

            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 ...
          • Report on requests pending approval

            DB Compatibility : PGSQL & MSSQL Build Compatibility : Builds above 10000 SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",dpt.DEPTNAME "Department",wo.TITLE "Subject",ti.FIRST_NAME "Technician", std.STATUSNAME "Request Status", ...
          • Automatically close request after successive approval reminders.

            This post describes the use of a python script to close requests after successive approval reminders using Custom Schedules. Use Case: We have an option under the self-service portal in order to send reminders mail for the approvals, what would be ...