oracle group by 问题

b表在红框内条件下结果集为空，导致最终的结果集为空。其他表的结果集不为空的，有什么解决办法吗？ 最好帮我改造下sql

select count(distinct b.id) as recover,count(distinct d.reid) as workCount,a.name,a.service_no,
c.money_recovery as recoverTotal,c.workcount as workTotal
from dgrpmanagermsg a,ep_owerecord_info b,ep_dict_manage c,ep_market_record d where a.service_no in(
select login_no from ep_sys_loginmsg_info where group_id='10070'
) and a.name=c.region_name and a.service_no=c.region_no and c.status_code='04'
and b.service_name=a.name and b.service_no=a.service_no and b.record_status='04'
and replace(substr(b.op_time,length(b.op_time)-10,7),'-','') = substr(c.order_no,length(c.order_no)-7,6 )
and d.manager_name=a.name and d.login_no=a.service_no and d.status='3'
and replace(substr(d.create_time,0,7),'/','') = substr(c.order_no,length(c.order_no)-7,6 )
and substr(c.order_no,length(c.order_no)-7,6 ) = to_char(sysdate,'yyyyMM')
group by a.name,a.service_no,c.money_recovery,c.workcount