you can view the view Action History to find out the approval path.
you can know who has created, submitted and forwarded to whom and also name of the approver with timestamp.
From backend , you can know using the PO_ACTION_HISTORY table.
Navigation : PO Form > Menu > Inquire> View Action History
Actually i can see the list of approval persons- means -the participants of the approves list.(
(you can view the view Action History to find out the approval path). But how do i know the name of the approval hierachy example : Engineering Approval list, Operations Approval list.. etc
please clear my doubt.
what you required ? the approval hierarchy name only or complete approval hierarchy ?
HI Sanajy, Looking for " approval hierarchy name"
1 person found this helpful
Try with below sql.
from po_headers_all poh, wf_item_attribute_values av, per_position_structures pos
where av.item_type = poh.wf_item_type
and av.item_key = poh.wf_item_key
and av.name = 'APPROVAL_PATH_ID'
and to_number(av.NUMBER_VALUE) = pos.position_structure_id
and poh.org_id = 41
and poh.po_header_id =878995
Thanks....I got what i need
Have Good Days !!!!