Hi Floks
How to get PR action history from the back-end?
Below is the query.
select hr.name ORG_NAME,prh.segment1
Requisition_Number,prh.AUTHORIZATION_STATUS,pah.LAST_UPDATE_DATE,pah.CREATION_DATE,pah.OBJECT_ID,
NVL2(pah.ACTION_CODE,'COMPLETE','PENDING')Action_Status
,pah.ACTION_CODE,papf.full_name,pah.ACTION_DATE,pah.NOTE
from po_requisition_headers_all prh,po_action_history pah,
per_all_people_f papf,hr_all_organization_units hr
where papf.person_id = pah.employee_id
and pah.object_id = prh.REQUISITION_HEADER_ID
and prh.org_id = hr.organization_id
and prh.AUTHORIZATION_STATUS = 'IN PROCESS'
and prh.segment1 = :'PR_Number'
order by pah.LAST_UPDATE_DATE desc
