0
0
Select
Txnd.Status As Txn_Status
,Txnh.Module_Identifier
,p.person_number
,txnh.CREATION_DATE
,Txnh.Transaction_Id
,txnd.STATE as TXN_STATE
,txnh.CREATED_BY
,Txnh.Initiator_User_Id
,Txne.Fault_Date
,Txne.Error_Details
,wft.tasknumber
,wft.compositeinstanceid
,wft.TITLE
,wft.OUTCOME as WF_OUTCOME
,wft.STATE as WF_STATE
,Wft.Substate
,Wft.Assignees
,Wft.Assigneesdisplayname As Current_Assignee
,wft.Assigneddate
,wft.Approvers
from
Fusion.hrc_txn_header txnh, Fusion.hrc_txn_data txnd,
fa_fusion_soainfra.wftask wft,
fusion.hrc_txn_error txne, Fusion.per_all_people_f p
Where Txnh.Transaction_Id = Txnd.Transaction_Id
and txnh.transaction_id = txne.transaction_id(+)
And To_Char(Txnh.Transaction_Id) = Wft.Identificationkey(+)
And Txnh.subject_id = p.person_id(+)
And Txnh.Transaction_Id in (300000000000000)
I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.