select rownum xh0000,decode(g.mzzybz,'0',g.zyhghh,to_char(g.zyghid)) JKSJH0,g.* from (
Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,(select BRBLH0 from bm_brxxb0 where BRID00=b.BRID00) BRBLH0,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,substr(b.brnl00,1,100) brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.kdksbh,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,ZLDCCF,b.CXSL00,b.txm000,b.FBBH00,b.CH0000,b.yjksbh,(select bmmc00 from bm_bmbm00 where bmbh00=b.YJKSBH) YJKSMC, b.BRZJBH,b.YBKH00,APNUM0,BBMC00,b.DW0000,b.RYCWH0,b.FYJDJH,b.YQJJBZ from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' 
 and xmzt00 in ('0','1','2')
 and b.mzzybz='1'
 and brid00=?
 and YJKSBH=?
 and kdrq00 between ? and ? 
 and b.SL0000-nvl(b.CXSL00,0)-b.ZXSL00>0
 order by brid00,zyhghh,zyzbid,yzcfid,kdrq00,zlxmid) g