Tech Trainings

Purchase Order Approval – Oracle Fusion ERP

February 18, 2025 by admin

SELECT 
wf.APPROVERS                  ,
wf.ASSIGNEES                  ,
wf.ASSIGNEESDISPLAYNAME       ,
wf.CREATOR                    ,
wf.PROCESSNAME                ,
wf.CREATEDDATE                ,
wf.FROMUSER                   ,
wf.OUTCOME                    ,
wf.STATE                      ,
wf.WORKFLOWPATTERN            ,
wf.IDENTIFICATIONKEY          ,
wf.TASKDEFINITIONNAME         ,
wf.PARTICIPANTNAME

FROM  fa_fusion_soainfra.wftaskhistory   wf 
WHERE 1=1
AND   PROCESSNAME ='ApprovePurchasingDocument' 
AND IDENTIFICATIONKEY  = :P_IDENTIFICATIONKEY
order by createddate desc

select 
 pha.po_header_id,
 pha.segment1 PO_NUMBER,
 pah.OBJECT_ID,
 pah.ASSIGNMENT_DATE ,
 pah.PO_VERSION_ID,
 pah.ACTION_CODE , 
 pah.IDENTIFICATION_KEY,
 pah.CREATED_BY  
from PO_ACTION_HISTORY pah , po_headers_all pha 
where 1=1
and OBJECT_TYPE_CODE ='PO' 
and pha.po_header_id = pah.object_id 

order by pha.creation_date desc 

Comments |0|