1 10:50:36 SQL Execute: ORACLE - select * from ( select '20150401' KSRQ00,'20150401' JSRQ00, A.ZYID00,max(A.XM0000) XM0000,max(A.ZYH000) ZYH000,max(A.CZYXM0) CZYXM0, max(A.RYBQMC) RYBQMC,max(A.RYCWH0) RYCWH0 ,max(A.RZKSMC) RZKSMC, min(A.CZRQ00) ZXRQ, max(A.CZRQ00) ZDRQ,sum(A.HJJE00) Amount,MAX(B.FBBH00) FBBH00, max(RZKSBH) RZKSBH,max(PXXH00) PXXH00,max(RYBQBH) RYBQBH,a.yexm00 from VW_ZY_RQD000 A,ZY_BRXXB0 B where A.ZYID00=B.ZYID00 and A.ZYID00 in (1880961,1889811,1884113,1890111,1887411,1887461,1879611,1883661,1886062,1881261,1889164,1883611,1884264,1887462,1885817,1885814,1885011,1888361,1885818,1885813,1875912,1888611,1884861,1887711,1885764,1885819,1885820,1885821,1890311,1882816,1882814,1884911,1885815,1889561,1882411,1889361,1882361,1889661,1884161,1885911,1887361,1889611,1881011) group by A.ZYID00,a.yexm00 ) a order by A.RYCWH0,A.RYBQBH 2 10:55:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889811.000000 3 10:55:30 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 4 10:55:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889811.000000 5 10:55:30 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 6 10:55:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889811.000000 7 10:55:30 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 8 10:55:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1880961.000000 9 10:55:31 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 10 10:55:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889811.000000 11 10:55:31 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 12 10:55:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1880961.000000 13 10:55:31 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 14 10:55:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1890111.000000 15 10:55:31 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 16 10:55:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1880961.000000 17 10:55:31 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 18 10:55:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1890111.000000 19 10:55:31 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 20 10:55:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1884113.000000 21 10:55:31 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 22 10:55:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1890111.000000 23 10:55:31 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 24 10:55:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1884113.000000 25 10:55:31 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 26 10:55:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1887411.000000 27 10:55:31 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 28 10:55:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1884113.000000 29 10:55:31 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 30 10:55:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1887411.000000 31 10:55:31 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 32 10:55:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1887461.000000 33 10:55:31 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 34 10:55:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1887411.000000 35 10:55:32 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 36 10:55:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1887461.000000 37 10:55:32 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 38 10:55:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1879611.000000 39 10:55:32 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 40 10:55:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1887461.000000 41 10:55:32 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 42 10:55:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1879611.000000 43 10:55:32 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 44 10:55:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1883661.000000 45 10:55:32 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 46 10:55:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1879611.000000 47 10:55:32 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 48 10:55:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1883661.000000 49 10:55:32 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 50 10:55:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1886062.000000 51 10:55:32 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 52 10:55:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1883661.000000 53 10:55:32 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 54 10:55:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1886062.000000 55 10:55:32 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 56 10:55:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1881261.000000 57 10:55:33 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 58 10:55:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1886062.000000 59 10:55:33 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 60 10:55:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1881261.000000 61 10:55:33 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 62 10:55:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889164.000000 63 10:55:33 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 64 10:55:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1881261.000000 65 10:55:33 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 66 10:55:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889164.000000 67 10:55:33 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 68 10:55:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1883611.000000 69 10:55:33 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 70 10:55:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889164.000000 71 10:55:33 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 72 10:55:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1883611.000000 73 10:55:33 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 74 10:55:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1884264.000000 75 10:55:33 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 76 10:55:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1883611.000000 77 10:55:33 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 78 10:55:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1884264.000000 79 10:55:33 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 80 10:55:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1887462.000000 81 10:55:33 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 82 10:55:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1884264.000000 83 10:55:33 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 84 10:55:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1887462.000000 85 10:55:33 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 86 10:55:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885817.000000 87 10:55:34 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 88 10:55:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1887462.000000 89 10:55:34 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 90 10:55:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885817.000000 91 10:55:34 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 92 10:55:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885814.000000 93 10:55:34 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 94 10:55:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885817.000000 95 10:55:34 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 96 10:55:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885814.000000 97 10:55:34 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 98 10:55:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885011.000000 99 10:55:34 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 100 10:55:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885814.000000 101 10:55:34 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 102 10:55:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885011.000000 103 10:55:34 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 104 10:55:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1888361.000000 105 10:55:34 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 106 10:55:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885011.000000 107 10:55:34 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 108 10:55:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1888361.000000 109 10:55:34 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 110 10:55:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885818.000000 111 10:55:35 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 112 10:55:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1888361.000000 113 10:55:35 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 114 10:55:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885818.000000 115 10:55:35 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 116 10:55:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885813.000000 117 10:55:35 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 118 10:55:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885818.000000 119 10:55:35 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 120 10:55:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885813.000000 121 10:55:35 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 122 10:55:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1875912.000000 123 10:55:35 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 124 10:55:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885813.000000 125 10:55:35 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 126 10:55:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1875912.000000 127 10:55:35 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 128 10:55:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1888611.000000 129 10:55:35 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 130 10:55:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1875912.000000 131 10:55:36 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 132 10:55:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1888611.000000 133 10:55:36 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 134 10:55:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1884861.000000 135 10:55:36 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 136 10:55:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1888611.000000 137 10:55:36 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 138 10:55:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1884861.000000 139 10:55:36 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 140 10:55:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1887711.000000 141 10:55:36 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 142 10:55:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1884861.000000 143 10:55:36 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 144 10:55:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1887711.000000 145 10:55:36 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 146 10:55:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885764.000000 147 10:55:37 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 148 10:55:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1887711.000000 149 10:55:37 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 150 10:55:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885764.000000 151 10:55:37 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 152 10:55:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885819.000000 153 10:55:37 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 154 10:55:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885764.000000 155 10:55:37 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 156 10:55:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885819.000000 157 10:55:37 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 158 10:55:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885820.000000 159 10:55:37 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 160 10:55:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885819.000000 161 10:55:37 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 162 10:55:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885820.000000 163 10:55:37 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 164 10:55:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885821.000000 165 10:55:37 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 166 10:55:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885820.000000 167 10:55:37 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 168 10:55:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885821.000000 169 10:55:37 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 170 10:55:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1890311.000000 171 10:55:38 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 172 10:55:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885821.000000 173 10:55:38 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 174 10:55:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1890311.000000 175 10:55:38 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 176 10:55:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1882816.000000 177 10:55:38 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 178 10:55:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1890311.000000 179 10:55:38 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 180 10:55:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1882816.000000 181 10:55:38 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 182 10:55:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1882814.000000 183 10:55:38 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 184 10:55:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1882816.000000 185 10:55:38 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 186 10:55:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1882814.000000 187 10:55:38 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 188 10:55:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1884911.000000 189 10:55:38 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 190 10:55:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1882814.000000 191 10:55:38 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 192 10:55:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1884911.000000 193 10:55:38 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 194 10:55:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885815.000000 195 10:55:38 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 196 10:55:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1884911.000000 197 10:55:38 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 198 10:55:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885815.000000 199 10:55:38 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 200 10:55:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1882411.000000 201 10:55:38 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 202 10:55:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885815.000000 203 10:55:38 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 204 10:55:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1882411.000000 205 10:55:39 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 206 10:55:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889561.000000 207 10:55:39 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 208 10:55:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1882411.000000 209 10:55:39 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 210 10:55:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889561.000000 211 10:55:39 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 212 10:55:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1882361.000000 213 10:55:39 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 214 10:55:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889561.000000 215 10:55:39 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 216 10:55:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1882361.000000 217 10:55:39 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 218 10:55:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889361.000000 219 10:55:39 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 220 10:55:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1882361.000000 221 10:55:39 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 222 10:55:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889361.000000 223 10:55:39 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 224 10:55:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1884161.000000 225 10:55:39 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 226 10:55:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889361.000000 227 10:55:39 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 228 10:55:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1884161.000000 229 10:55:39 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 230 10:55:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889661.000000 231 10:55:39 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 232 10:55:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1884161.000000 233 10:55:39 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 234 10:55:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889661.000000 235 10:55:40 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 236 10:55:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885911.000000 237 10:55:40 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 238 10:55:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889661.000000 239 10:55:40 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 240 10:55:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885911.000000 241 10:55:40 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 242 10:55:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1887361.000000 243 10:55:40 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 244 10:55:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1885911.000000 245 10:55:40 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 246 10:55:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1887361.000000 247 10:55:40 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 248 10:55:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889611.000000 249 10:55:40 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 250 10:55:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1887361.000000 251 10:55:40 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 252 10:55:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889611.000000 253 10:55:40 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 254 10:55:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1881011.000000 255 10:55:41 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 256 10:55:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1889611.000000 257 10:55:41 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 258 10:55:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1881011.000000 259 10:55:41 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00 260 10:55:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1881011.000000 261 10:55:41 SQL Execute: ORACLE - select a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,a.XMDJ00,sum(a.XMSL00) XMSL00,sum(a.HJJE00) HJJE00,a.FPXMMC,a.FPXMBH,a.ZFBL00 ,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,+'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' YJJXX0 from VW_ZY_RQDMX_HZ A Where A.ZYID00=? and QDRQ00 between '20150401' and '20150401' group by GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH,'截止到'||'20150401'||' 23:59:59'||' 你的账户余额为:'||to_char(SF_ZY_GET_QDYJJE(A.ZYID00,'20150401','','2','1')-SF_ZY_GET_QDZFY(A.ZYID00,'20150401','',0))||'(医保病人的余额为预估值,以最后结算为准.)' having sum(a.XMSL00)<>0 order by GJBM00