AP_INV_APRVL_HIST_ALL table will give you all the details related to approval of particular invoice.
Query to get the latest transaction on particular invoice :
select created_by from AP_INV_APRVL_HIST_ALL
where invoice_id = &inv_id
and approval_history_id =
(select max(approval_history_id) from AP_INV_APRVL_HIST_ALL
where invoice_id = &inv_id
)
Query to get the Initiator of particular invoice :
select created_by from AP_INV_APRVL_HIST_ALL
where invoice_id = &inv_id
and approval_history_id =
(select min(approval_history_id) from AP_INV_APRVL_HIST_ALL
where invoice_id = &inv_id
)
