(Select /* 12.0: bug#4526784 */ count(*) gcount,
jgd.group_id sales_group_id
from JTF.JTF_RS_GROUPS_DENORM jgd,
JTF.JTF_RS_GROUP_USAGES jgu
where 1=1
and jgd.latest_relationship_flag = 'Y'
and jgd.group_id = jgu.group_id
and jgu.usage='SALES' group by jgd.group_id )