This content has been marked as final. Show 2 replies
If the requisition is already approved once, then you can take the approver name from the following query by joining with hr_employees/per_people_f
select employee_id from po_action_history where object_type_code = 'REQUISITION' and action_code = 'APPROVE'
I'm also in process to develope this kind of process, can u pls send your same source code...my id email@example.com