OracleAppsDNA

SQL Query to Fetch BPM Approval Groups Information

/******************************************************************* 
 *PURPOSE: SQL Query to extract BPM Approval Groups Information    *
 *AUTHOR: Shailender Thallam 				           *
 *******************************************************************/
SELECT fwg.approvalgroupid ,fwg.approvalgroupname, fwgm.member, fwgm.type, fwgm.sequence
FROM fa_fusion_soainfra.wfapprovalgroups fwg,
     fa_fusion_soainfra.wfapprovalgroupmembers fwgm
WHERE 1=1
AND fwg.approvalgroupid = fwgm.approvalgroupid
ORDER BY fwgm.approvalgroupid, fwgm.sequence;
Exit mobile version