Oracle Fusion – BPM Approval Group – User Details

by admin

•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

Comments |0|

Legend *) Required fields are marked
**) You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
Category: OracleSaaSQueries