Oracle Fusion – BPM Approval Group – User Details
•Setup and Maintenance — Task List — Search — Manage Approval Groups
![](http://oratrainings.com/wp-content/uploads/2023/11/image-4-1024x130.png)
![](http://oratrainings.com/wp-content/uploads/2023/11/image-3-1024x254.png)
SELECT wfg.approvalgroupid ,wfg.approvalgroupname, wfm.member, wfm.type, wfm.sequence
FROM fa_fusion_soainfra.WFAPPROVALGROUPS wfg,
fa_fusion_soainfra.WFAPPROVALGROUPMEMBERS wfm
WHERE 1=1
AND wfg.approvalgroupid = wfm.approvalgroupid
AND wfg.approvalgroupname='ORA_Approval_Group'
ORDER BY wfm.approvalgroupid, wfm.sequence
![](http://oratrainings.com/wp-content/uploads/2023/11/image-2-1024x204.png)