select t2.CFLSH0,
       t2.zb0000,
       t2.CSL000,
       t2.JLDW00,
       t2.YPMC00 || ' ' || DECode(Sign(t2.CSL000 - 1), -1, '0', '') ||
       t2.csl000 || t2.JLDW00 YPMC00,
       Substrb(t2.YYZF00, 1, 10) yyzf00,
       (SELECT YPYFMC
          FROM BM_YPYF00 P
         WHERE t2.YFID00 = P.YFID00
           AND ROWNUM = 1) YPYF00,
           decode(nvl(t3.YYSJ00, 1), 0, 1, t3.YYSJ00) yysj00
  from YS_CFMX00 t2, YF_MZCFMX t3, YJ_ZLXMID_TMP t1
 WHERE t2.cfid00 = t1.ZLXMID(+)
   and t2.CFLSH0 in ('13448595')
   and t2.cfid00 = t3.cfid00
   and t3.cxbz00 = 'Z'
   --当t3.YYSJ00用药时间为空时，这一句条件判断影响的
   and decode(nvl(t3.YYSJ00, 1), 0, 1, t3.YYSJ00) >= 1  --这个条件影响的
 order by t2.zb0000, t1.zb0000, t1.ZLXMID