Labels

[ALRT] (3) [AR] (2) [BOM] (3) [GL] (2) [GTM] (1) [INV] (18) [MRP] (1) [OM] (27) [PO] (58) [QP] (3) [SYS] (39) [WIP] (4) AGIS (1) OM (1)

Wednesday, January 19, 2011

[PO] Position Hierarchy Used for PR/PO Approval

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_ALL WHERE segment1='myPRNumber')

Link approval_path_id to HR.PER_POSITION_STRUCTURES table to get hierarchy name used.

No comments:

Post a Comment