/*******************************************************************
*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;