5 Replies Latest reply on Jul 29, 2015 9:43 AM by Jagadekara

    Approver details for POs, Requisitions and Receipts.




      I would like to know how you retrieve the approver information for Purchase Orders, Requisitions and receipts. I currently use wf_item_key on these records to go to the workflow tables to retrieve this information but this is not always accurate on "trustworthy" so i would like to know if there is another way to do this.


      Invoice approvers are stored in the AP_INV_APRVL_HIST_ALL table, does something similar exists for the above.