SELECT 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('2846076','2845500','2845654','2844616','2845795'
  ,'2846092','2846281','2845842','2846310','2845769','2844755','2846081','2846540',
  '2846328','2846405','2845852','2846704','2846367','2846220','2846899','2846501','2846842',
  '2846779','2846909','2846500','2846716','2847046','2846086','2846727','2845566','2846891','2846116',
  '2846359','2846242','2846392','2846091','2845648','2846327','2846890','2844277','2846101','2846732','2846940',
  '2845121','2846318','2846418','2847043')   
     AND YZZT00 in ('1','2')   
      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 '20231227' and '20231228'          
                 and ZXRQ00 || ZXSJ00 >= '20231227' || decode(a.KFBZ00, 'Y', '00:00:00', '00:00:00')        
                     and ZXRQ00 || ZXSJ00 < '20231228' || decode(a.KFBZ00, 'Y', '00:00:00', '00:00:00'))
                      and A.YPNM00 = C.YPNM00 and A.YFBMBH = C.YFBMBH and nvl(A.YTZRQ0,'20231227')>='20231227' 
                     
 order by rycwh0,tqrqsj,clbz00,yzid00,yzmxid