1       15:46:29  Log started for: 住院收费管理系统
2       15:46:48  SQL Execute: ORACLE -  select decode(SJCYRQ,'20991231','',SJCYRQ) SJCYRQ, decode(CYDJRQ,'20991231','',CYDJRQ) CYDJRQ, 
 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 ,
decode(substr(BRZT00,1,1),'9',0,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,'20220413') <= '20220413'
  AND  (SJCYRQ='20991231' OR SJCYRQ is null) 

 order by A.DQBQMC,A.ZYH000