1       17:51:34  SQL Execute: ORACLE - select c.SYSJ00,c.BRXM00,DECODE(c.MZZYBZ,'0','门诊','住院') BRLX00,c.ZYHGHH,c.TXM000,c.ZLXMJC,decode(JGZT00,'1','已采集','2','已签收','4','已排样','5','已处理')JGZT01,decode(c.YXBZ00,'Y','是','N','否')SFJZ00,c.BBCYRQ,c.BBCYSJ,c.BBSDRQ,c.BBSDSJ,c.PYRQ00,c.PYSJ00 from (select a.JYYWID,a.brxm00,a.zyhghh,a.txm000,a.MZZYBZ,a.SFTJ00,a.YXBZ00,a.zlxmid,a.ZLXMJC,a.jgzt00,a.BBCYRQ,a.BBCYSJ,a.BBSDRQ,a.BBSDSJ,a.PYRQ00,a.PYSJ00, substrb(SF_JY_GETTATZZSJ(BBCYRQ,BBCYSJ,BBSDRQ,BBSDSJ,PYRQ00,PYSJ00,a.MZZYBZ,SFTJ00,JGZT00,YXBZ00,zlxmid,'0'),1,200)SYSJ00  from VW_JY_YW0000 a where a.JGZT00||'A' in ('1A','2A','4A','5A') and a.BBCYRQ between '20180701' and '20180704' )c  where c.SYSJ00<>'N'  order by BBCYRQ