select distinct BBID00,BBMC00,YBH000,PYRQ00 from (
select BBID00,nvl(BBMC00,'δ֪') BBMC00 , YBH000,PYRQ00,XJID00,ZWMC00 from vw_jy_xjjg00
where  --SFNRTJ='Y' and SFYXXJ='Y' AND
  BGRQ00 between PKSRQ00 and  PJSRQ00 and (SQKS00=to_number(PKSBH00) or to_number(PKSBH00)=0) and (MZZYBZ=PMZZYBZ or PMZZYBZ='2') and (BBMC00=nvl(PBBMC00,BBMC00)) )
)