SQL Query to Check Approval Transaction ID and Workflow Status

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,
    fusion.per_all_people_f p,
    fa_fusion_soainfra.wftask wft,
    fusion.hrc_txn_error txne
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 (300001152699363)

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.