Please elaborate your requirements in details.
As I understand, you can get the approver name from PO Action History.
From Back end , you can get the same using PO_ACTION_HISTORY table.
1 person found this helpful
thanks a lot for quick response.
Requirement : need to develop the report with the below details, but i am not able to get the approval name against specific requisition
For Approver name , join in the following way
PO_ACTION_HISTORY.OBJECT_ID = PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID
AND PO_ACTION_HISTORY.OBJECT_TYPE_CODE = 'REQUISITION'
AND PO_ACTION_HISTORY.ACTION_CODE = 'APPROVE'
Thank you Sanjay, I am able to get the required info