This content has been marked as final. Show 3 replies
The below script will aid you in getting the current status,the approval hierarchy and the action history along with the approver names.Hope this helps you.
select DISTINCT c.segment1 Requisition_Number,
SUBSTR(c.type_lookup_code, 1,3) Type,
to_char(a.action_date, 'DD-Mon-YY HH:MM') Action_Date,
where a.employee_id = b.employee_id
AND a.object_id = c.po_header_id
AND a.approval_path_id = d.position_structure_id(+)
AND b.employee_id = ppf.person_id
AND object_type_code = 'PO'
AND c.segment1 = NVL(:po_number, c.segment1)
order by c.segment1, sequence_num
Thanks Bala Thanks very much . the above script is very useful for me.
now i am able to display the next approver name in case of APPROVE status.
where as client want to display next approver name in case of REJECT status also. can you guide me, how to display the next approver name in case of REJECT status.
Thanks in advance.