Requisition Authorization Tracking

Hi @LScruggs70 ,

Try below SQL,

SELECT PURCHASE_REQ_LINE_PART_API.Get_Date_Entered(pra.requisition_no, pra.line_no, pra.release_no) "PR_DATE",

pra.requisition_no, pra.line_no, pra.release_no, pra.sequence_no, pra.authorize_id, pra.authorize_group_id,

pra.signature_id "AUTH_BY",pra.date_approved,

(SELECT MIN(a.date_entered) FROM   purchase_order_line_hist a, PURCHASE_REQ_LINE_PART b

WHERE  a.order_no = b.ORDER_NO AND a.LINE_NO = b.ASSG_LINE_NO AND a.RELEASE_NO = b.ASSG_RELEASE_NO

AND b.REQUISITION_NO =  pra.requisition_no AND b.LINE_NO = pra.line_no AND b.RELEASE_NO = pra.release_no) "PO_DATE"

FROM   purch_req_line_approval pra

WHERE PURCHASE_REQ_LINE_PART_API.Get_Objstate(pra.requisition_no, pra.line_no, pra.release_no) = 'PO Created'

Hope this will help

Regards,

Akila

Susith wrote:

Hi @LScruggs70 ,

 

Have you tried the below query from Purchase Requisition Line Authorization overview?

 

 

Thank you!  I am still learning what all these fields mean and how to use them.  This has been a great help!  

Another question: Would you know why there would be no name listed in the Authorization name field?   However, I did find that the Signature line gives me what I assume would be that name.  

Hi @LScruggs70 ,

If there are no specific authorizers defined under the authorization routing template Authorizer ID and Name would be blank (as you stated) and also it means the PR line has not been authorized yet.

Authorizer ID/Name - Person to be authorized
Signature ID/Name - Person authorized (after authorization)