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;

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