Query to get Fusion Workflow Approvals
Hello,
Is there a query where i can get all pending approvers for a transaction, not only the current assignee?
I was able to identify the current assignee using the below query.SELECT wf.identificationkey, wf.outcome, wf.enddate, wf.assigneesdisplayname,
wf.creator, wf.assigneddate, wf.state, hth.transaction_id
FROM fa_fusion_soainfra.wftask wf,
hrc_txn_header hth,
fnd_console_transaction_info fcti
WHERE 1 = 1
AND TO_CHAR (hth.transaction_id) = wf.identificationkey
AND hth.transaction_id = fcti.transaction_id
AND wf.workflowpattern = 'SequentialParticipant'
AND wf.compositeinstanceid = fcti.module_instance_id
UNION
SELECT wf.identificationkey, wf.outcome, wf.enddate, wf.assigneesdisplayname,
Tagged:
1