Oracle Fusion – BPM Approval Group – User Details

•Setup and Maintenance — Task List — Search — Manage Approval Groups

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