Tech Trainings

Blanket Purchase Agreement (BPA) – Approval – Configuration-Validation-BPM- Oracle Fusion ERP

February 21, 2025 by admin

--PO Agreement Table Details : 
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 ='PA' 
and pha.TYPE_LOOKUP_CODE ='BLANKET'
and pha.po_header_id = pah.object_id 

order by pha.creation_date desc 

--PO Action History Table
select 
 (
  select 
 pha.segment1 PO_NUMBER
 from  po_headers_all pha 
 where 1=1
 and pha.TYPE_LOOKUP_CODE ='BLANKET'
and pha.po_header_id = pah.object_id )  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 
where 1=1
and OBJECT_TYPE_CODE ='PA' 


order by pah.creation_date desc

--BPM WF History Table
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  = NVL ( :P_IDENTIFICATIONKEY,IDENTIFICATIONKEY)

order by createddate desc

Comments |0|