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