A PR/PO was submitted for approval, how to check which Position Hierarchy user used? From Apps front end, it is impossible. Check it out from backend tables.
Sample codes:
SELECT approval_path_id FROM apps.PO_ACTION_HISTORY WHERE object_id in (SELECT requisition_header_id FROM apps.PO_REQUISITION_HEADERS_
Link approval_path_id to HR.PER_POSITION_STRUCTURES table to get hierarchy name used.
No comments:
Post a Comment