The easiest way to find Approvers assigned in Position Hierarchy - Oracle EBS R12

https://purchasingpo.blogspot.com/2019/05/the-easiest-way-to-find-approvers.html

The easiest way to find Approvers assigned in Position Hierarchy

Navigate to HRMS> Work Structures> Position> Diagrammer

Press F11 and search for Position Hierarchy Name

Press Ctrl+F11

Press Open Editor

Expand

It is Showing Hierarchy from Top to Down

You can use the following styles as easy for you

How to know the position hierarchy used in a PO document - Oracle EBS R12

https://purchasingpo.blogspot.com/2019/05/how-to-know-position-hierarchy-used-in.html

Requisitions

select prh.segment1, pps.name
from po_requisition_headers_all prh, po_action_history pah, per_position_structures pps
where pah.approval_path_id = pps.position_structure_id
and prh.requisition_header_id = pah.object_id
and object_type_code = 'REQUISITION'
and action_code = 'SUBMIT'
and prh.segment1 = '&REQNUMBER'

Purchase Orders

select ph.segment1, pps.name
from po_headers_all ph, po_action_history pah, per_position_structures pps
where pah.approval_path_id = pps.position_structure_id
and ph.po_header_id = pah.object_id
and object_type_code = 'PO'
and action_code = 'SUBMIT'
and ph.segment1 = '&PONUMBER'