SELECT A.YFBMBH , C.YFBMBH ,c.YPNM00 ,a.yfbmbh,YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱') CLBZ00 , 
YPMC00,trim(YL0000) YL0000,YZNR01, TO_CHAR(QYRQSJ,'YYYY.MM.DD') 
qyrqsjstr , trim(LBMC00) LBMC00,TO_CHAR(TQRQSJ,'YYYY.MM.DD')tqrqsjstr, 
TS0000,KZYSXM,YZCLLB,ZYL000,XM0000,RYCWH0,a.ZYID00,C.SJKCSL,C.YCKCSL,
 (SF_BQ_KYJE00(b.ZYID00,b.BRID00) - C.LSDJ00)  
 SYJE00,A.PSPC00,A.YTZRQ0,A.YTZSJ0,A.TZYS00,A.HDR000,A.PSPC00  FROM
  VW_BQ_YPYZTQ a, ZY_BRXXB0 b ,YF_YPKCXX c WHERE 
  a.zyid00=b.zyid00 and a.ZYID00 in('100119')    
    AND YZZT00 in ('1','2')   and yzid00= '49637405'
 and A.YPNM00 = C.YPNM00  and A.YFBMBH = C.YFBMBH  --总院分院模式，这个判断限制。
 and nvl(A.YTZRQ0,'20210130')>='20210130'  
   and exists (select 1          
     from BQ_YZCFMX x          where x.YZID00 = a.YZID00         
        and TQBZ00 = '0'            and (YXBZ00 = '1' or YXBZ00 is null)           
         and ZXRQ00 between '20210128' and '20210129'         
            and ZXRQ00 || ZXSJ00 >= '20210128' || 
            decode(a.KFBZ00, 'Y', '00:00:00', '00:00:00')         
 and ZXRQ00 || ZXSJ00 < '20210129' || decode(a.KFBZ00, 'Y', '00:00:00', '00:00:00'))
order by rycwh0,tqrqsj,clbz00,yzid00,yzmxid