1       23:57:05  SQL Execute: ORACLE -  select A.*,(SELECT SUM(HJJE00) FROM ZY_BRFY00 B WHERE B.ZYID00=A.ZYID00) FYJE00,
0 YPZJE0,0 QZFYBL,
SF_ZY_GETJE0(0,a.zyid00,A.BRID00,0) NLHJJE,
SF_ZY_GETJE0(1,a.zyid00,A.BRID00,0) BCHJJE,
SF_ZY_GETJE0(2,a.zyid00,A.BRID00,0) JCHJJE,
 YJJZE0 ,
greatest(to_date(decode(SJCYRQ,'20991231',to_char(sysdate,'YYYYMMDD'),SJCYRQ),'YYYYMMDD')-to_date(ryrq00,'YYYYMMDD'),1)  as ZYTS00
 from  VW_ZY_BRZYXX A where 1=1 
  and  BRZT00  like  '2%'
  and  NVL(RYRQ00,'20201204') <= '20201204'
  AND  (SJCYRQ='20991231' OR SJCYRQ is null) 

 order by A.DQBQMC,A.ZYH000