SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00,
DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb,
DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00,
SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00,DYBZ00,SCCJ00,YBSCCJ,YBBZ00,GG0000, 
DECODE(MZZYBZ,'0','门诊','1','住院','2','门诊+住院')MZZYMC,MZZYBZ,BKEH83,BKEA96 
FROM  VW_BM_YBSFDYXMMCFP
WHERE FBBH00=? AND YBZXLB=? and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=? and rtrim(ltrim(bh0000)) like ?
) and sfybxm like ? and TZBZ00 like ?
 and FYID00=rpad(?,6,' ') 
and YBBL00 like '%自费%'
order by YYXMBH