For PR requisition we want to fetch approval history data from backend

Summary:

For PR requisition we want to fetch approval history data from backend.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Oracle fusion cloud 19.C

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT
PRHA.REQUISITION_HEADER_ID REQUISITION_HEADER_ID,
HR.NAME B_UNIT ,
'Purchase Requisition' D_TYPE ,
PRHA.REQUISITION_NUMBER DO_NUM ,
(
select
TO_CHAR((MAX(ACTION_DATE)),'DD-MON-YYYY', 'NLS_DATE_LANGUAGE=ENGLISH' )
from
PO_ACTION_HISTORY PAH1
where
UPPER(PAH1.ACTION_CODE) ='SUBMIT'
AND PAH1.OBJECT_TYPE_CODE = 'REQ'
AND PAH1.OBJECT_ID = PRHA.REQUISITION_HEADER_ID) DO_DATE ,