1 08:21:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1513.000000 2 08:21:16 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 1 and PJSYR0=? and SYBZ00 = 'Y' 3 08:21:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 4 08:21:16 SQL Execute: ORACLE - Select FBBH00 FROM BM_BRXXB0 where brid00=? 5 08:21:16 SQL Execute: ORACLE - select SF_SF_GetYYKSBM(301,4287629,0) YYKSBM from dual 6 08:21:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 7 08:21:16 SQL Execute: ORACLE - Select FBBH00 FROM BM_BRXXB0 where brid00=? 8 08:21:16 SQL Execute: ORACLE - select SF_SF_GetYYKSBM(301,4287629,1) YYKSBM from dual 9 08:21:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 10 08:21:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 4287629 11 08:21:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 12 08:21:16 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 13 08:21:16 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210308 14 08:21:16 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210308 15 08:21:16 SQL Execute: ORACLE - select SF_SF_ZRZYXX(?,?,?,?,?,?)SFZRZY from dual 16 08:21:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 17 08:21:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 中医内科 18 08:21:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 主任医师 19 08:21:16 SQL Execute: ORACLE - select SF_SF_FSDYLX(?,?,?) FSDYLX from dual 20 08:21:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 21 08:21:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 2 22 08:21:16 SQL Execute: ORACLE - select SRRQ00,LBMC00,D.GHH000,F.GHRQ00 from YF_MZCF00 D,BM_YPLB00 E,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 AND D.YPDLBH=E.LBBH00 and D.CFZT00 in ('0','5') and D.BCCFH0 in (select CFLSH0 from yf_mzcf00 A,sf_brfy00 B where A.DJH000=B.DJH000 and B.JZDH00+0=0 and b.brid00= ?) and d.srrq00>=to_char(sysdate-?,'YYYYMMDD') 23 08:21:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 24 08:21:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 25 08:21:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 7 26 08:21:16 SQL Execute: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 AND d.brid00=? and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00+0 = 0 and a.brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') 27 08:21:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 28 08:21:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 2 29 08:21:16 SQL Execute: ORACLE - select a.SRRQ00,D.LBMC00,A.GHH000,F.GHRQ00 from YF_MZCF00 A,sf_brfy00 B,yf_mzcf00 C,BM_YPLB00 d,SF_BRXXB0 F where 1 = 1 and a.ghh000=f.ghh000 and B.BRID00= ? and A.CFZT00 IN('0','5') and A.BCCFH0 = C.CFLSH0 and B.DJH000=C.DJH000 and B.JZDH00+0<>0 and A.srrq00>=to_char(sysdate-?,'YYYYMMDD') and A.YPDLBH=D.LBBH00 30 08:21:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 31 08:21:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 32 08:21:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 7 33 08:21:16 SQL Execute: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and d.ghh000=f.ghh000 and d.brid00= ? and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00> 0 and a.brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') 34 08:21:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 35 08:21:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 36 08:21:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 2 37 08:21:16 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 in( '0','5') and b.brid00=? and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= ?) and B.srrq00>=to_char(sysdate-?,'YYYYMMDD') and B.YPDLBH=C.LBBH00 group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 38 08:21:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 39 08:21:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 40 08:21:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 41 08:21:16 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 = '1' and b.brid00= ? and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= ?) and B.srrq00>=to_char(sysdate-?,'YYYYMMDD') and B.YPDLBH=C.LBBH00 and b.SFKSLY<>'Y' group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 42 08:21:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 43 08:21:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 44 08:21:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 7 45 08:21:16 SQL Execute: ORACLE - select count(1) ss,e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 from YJ_YW0000 D,bm_bmbm00 e,SF_BRXXB0 F WHERE 1=1 and D.ZYHGHH=F.GHH000 and d.MZZYBZ='0' and D.XMZT00 in( '1') and nvl(CXDJH0,0)=0 and D.brid00= ? and not exists (select 1 from yj_yw0000 where cxdjh0=d.yjdjh0 and brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') and d.KDKSBH=e.bmbh00 group by e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 46 08:21:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 47 08:21:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 4287629 48 08:21:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 49 08:21:16 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 50 08:21:16 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 51 08:21:16 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 52 08:21:16 SQL Execute: ORACLE - select SF_SF_ZRZYXX(?,?,?,?,?,?)SFZRZY from dual 53 08:21:17 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 54 08:21:17 SQL Data In: ORACLE - Param = 2, Name = PTEMPID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2939140.000000 55 08:21:17 SQL Data In: ORACLE - Param = 3, Name = PGHH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4287629 56 08:21:17 SQL Data In: ORACLE - Param = 4, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 57 08:21:17 SQL Data In: ORACLE - Param = 5, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 58 08:21:17 SQL Data In: ORACLE - Param = 6, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 59 08:21:17 SQL Data In: ORACLE - Param = 7, Name = PID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2939140.000000 60 08:21:17 SQL Execute: ORACLE - BEGIN "SP_SF_WSPYPTS" (PBRID00 => :PBRID00,PTEMPID => :PTEMPID,PGHH000 => :PGHH000,PJZDH00 => :PJZDH00,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0,PID0000 => :PID0000); END; 61 08:21:17 SQL Data In: ORACLE - Param = 1, Name = PTSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 62 08:21:17 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 63 08:21:17 SQL Data In: ORACLE - Param = 3, Name = PTEMPID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2939140.000000 64 08:21:17 SQL Data In: ORACLE - Param = 4, Name = PGHH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4287629 65 08:21:17 SQL Data In: ORACLE - Param = 5, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 66 08:21:17 SQL Data In: ORACLE - Param = 6, Name = PYPMCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 67 08:21:17 SQL Data In: ORACLE - Param = 7, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 68 08:21:17 SQL Data In: ORACLE - Param = 8, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 69 08:21:17 SQL Data In: ORACLE - Param = 9, Name = AS_CFLSH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 70 08:21:17 SQL Data In: ORACLE - Param = 10, Name = PID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2939140.000000 71 08:21:17 SQL Execute: ORACLE - BEGIN "SP_SF_TSBZWMLTS" (PTSBZBH => :PTSBZBH,PBRID00 => :PBRID00,PTEMPID => :PTEMPID,PGHH000 => :PGHH000,PJZDH00 => :PJZDH00,PYPMCS0 => :PYPMCS0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_CFLSH0 => :AS_CFLSH0,PID0000 => :PID0000); END; 72 08:21:17 SQL Execute: ORACLE - COMMIT 73 08:21:17 SQL Data In: ORACLE - Rows affected = 0 74 08:21:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2939140.000000 75 08:21:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 76 08:21:17 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 77 08:21:17 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4287629 78 08:21:17 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210308 79 08:21:17 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210308 80 08:21:17 SQL Execute: ORACLE - select SF_SF_TSBZJM(?,?,?,?,?,?) FSDYLX from dual 81 08:21:17 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2939140.000000 82 08:21:17 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 83 08:21:17 SQL Data In: ORACLE - Param = 3, Name = PJSFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 84 08:21:17 SQL Data In: ORACLE - Param = 4, Name = PZHLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 85 08:21:17 SQL Data In: ORACLE - Param = 5, Name = PYBJKLX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 86 08:21:17 SQL Data In: ORACLE - Param = 6, Name = PTSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 87 08:21:17 SQL Data In: ORACLE - Param = 7, Name = PYBGHH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 88 08:21:17 SQL Data In: ORACLE - Param = 8, Name = PYBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 89 08:21:17 SQL Data In: ORACLE - Param = 9, Name = PSYDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 90 08:21:17 SQL Data In: ORACLE - Param = 10, Name = PBJDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 91 08:21:17 SQL Data In: ORACLE - Param = 11, Name = PYBCXDH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 92 08:21:17 SQL Data In: ORACLE - Param = 12, Name = PHJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 53.000000 93 08:21:17 SQL Data In: ORACLE - Param = 13, Name = PBCBXF0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 94 08:21:17 SQL Data In: ORACLE - Param = 14, Name = PTCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 95 08:21:17 SQL Data In: ORACLE - Param = 15, Name = PGRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 96 08:21:17 SQL Data In: ORACLE - Param = 16, Name = PZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 53.000000 97 08:21:17 SQL Data In: ORACLE - Param = 17, Name = PGWYBZ0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 98 08:21:17 SQL Data In: ORACLE - Param = 18, Name = PZHZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 99 08:21:17 SQL Data In: ORACLE - Param = 19, Name = PGRZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 100 08:21:17 SQL Data In: ORACLE - Param = 20, Name = PFYBJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 101 08:21:17 SQL Data In: ORACLE - Param = 21, Name = PSBGRZH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 102 08:21:17 SQL Data In: ORACLE - Param = 22, Name = PSBTCJJ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 103 08:21:17 SQL Data In: ORACLE - Param = 23, Name = PYBXJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 104 08:21:17 SQL Data In: ORACLE - Param = 24, Name = PYLZFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 105 08:21:17 SQL Data In: ORACLE - Param = 25, Name = PCFDXJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 106 08:21:17 SQL Data In: ORACLE - Param = 26, Name = PBCKBCS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 107 08:21:17 SQL Data In: ORACLE - Param = 27, Name = PJJZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 108 08:21:17 SQL Data In: ORACLE - Param = 28, Name = PSYBXZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 109 08:21:17 SQL Data In: ORACLE - Param = 29, Name = PYBZHYE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 110 08:21:17 SQL Data In: ORACLE - Param = 30, Name = PSBZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 111 08:21:17 SQL Data In: ORACLE - Param = 31, Name = PBJZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 112 08:21:17 SQL Data In: ORACLE - Param = 32, Name = PYBYL01, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 113 08:21:17 SQL Data In: ORACLE - Param = 33, Name = PYBYL02, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 114 08:21:17 SQL Data In: ORACLE - Param = 34, Name = PYBYL03, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 115 08:21:17 SQL Data In: ORACLE - Param = 35, Name = PYBYL04, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 116 08:21:17 SQL Data In: ORACLE - Param = 36, Name = PYBYL05, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 117 08:21:17 SQL Data In: ORACLE - Param = 37, Name = PYBYL06, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 118 08:21:17 SQL Data In: ORACLE - Param = 38, Name = PYBYL07, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 119 08:21:17 SQL Data In: ORACLE - Param = 39, Name = PYBYL08, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 120 08:21:17 SQL Data In: ORACLE - Param = 40, Name = PYBYL09, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 121 08:21:17 SQL Data In: ORACLE - Param = 41, Name = PYBYL10, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 122 08:21:17 SQL Data In: ORACLE - Param = 42, Name = PYBYL11, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 123 08:21:17 SQL Data In: ORACLE - Param = 43, Name = PYBYL12, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 124 08:21:17 SQL Data In: ORACLE - Param = 44, Name = PYBYL13, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 125 08:21:17 SQL Data In: ORACLE - Param = 45, Name = PYBYL14, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 126 08:21:17 SQL Data In: ORACLE - Param = 46, Name = PYBYL15, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 127 08:21:17 SQL Data In: ORACLE - Param = 47, Name = PYBYL16, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 128 08:21:17 SQL Data In: ORACLE - Param = 48, Name = PYBYL17, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 129 08:21:17 SQL Data In: ORACLE - Param = 49, Name = PYBYL18, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 130 08:21:17 SQL Data In: ORACLE - Param = 50, Name = PYBYL19, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 131 08:21:17 SQL Data In: ORACLE - Param = 51, Name = PYBYL20, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 132 08:21:17 SQL Data In: ORACLE - Param = 52, Name = PYBYL21, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 133 08:21:17 SQL Data In: ORACLE - Param = 53, Name = PYBYL22, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 134 08:21:17 SQL Data In: ORACLE - Param = 54, Name = PYBYL23, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 135 08:21:17 SQL Data In: ORACLE - Param = 55, Name = PYBYL24, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 136 08:21:17 SQL Data In: ORACLE - Param = 56, Name = PYBYL25, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 137 08:21:17 SQL Data In: ORACLE - Param = 57, Name = PYBYL26, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 138 08:21:17 SQL Data In: ORACLE - Param = 58, Name = PYBYL27, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 139 08:21:17 SQL Data In: ORACLE - Param = 59, Name = PYBYL28, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 140 08:21:17 SQL Data In: ORACLE - Param = 60, Name = PYBYL29, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 141 08:21:17 SQL Data In: ORACLE - Param = 61, Name = PYBYL30, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 142 08:21:17 SQL Data In: ORACLE - Param = 62, Name = PYBYL31, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 143 08:21:17 SQL Data In: ORACLE - Param = 63, Name = PYBYL32, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 144 08:21:17 SQL Data In: ORACLE - Param = 64, Name = PYBYL33, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 145 08:21:17 SQL Data In: ORACLE - Param = 65, Name = PYBYL34, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 146 08:21:17 SQL Data In: ORACLE - Param = 66, Name = PYBYL35, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 147 08:21:17 SQL Data In: ORACLE - Param = 67, Name = PYBYL36, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 148 08:21:17 SQL Data In: ORACLE - Param = 68, Name = PYBYL37, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 149 08:21:17 SQL Data In: ORACLE - Param = 69, Name = PYBYL38, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 150 08:21:17 SQL Data In: ORACLE - Param = 70, Name = PYBYL39, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 151 08:21:17 SQL Data In: ORACLE - Param = 71, Name = PYBYL40, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 152 08:21:17 SQL Data In: ORACLE - Param = 72, Name = PYBYL41, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 153 08:21:17 SQL Data In: ORACLE - Param = 73, Name = PYBYL42, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 154 08:21:17 SQL Data In: ORACLE - Param = 74, Name = PYBYL43, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 155 08:21:17 SQL Data In: ORACLE - Param = 75, Name = PYBYL44, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 156 08:21:17 SQL Data In: ORACLE - Param = 76, Name = PYBYL45, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 157 08:21:17 SQL Data In: ORACLE - Param = 77, Name = PYBYL46, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 158 08:21:17 SQL Data In: ORACLE - Param = 78, Name = PYBYL47, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 159 08:21:17 SQL Data In: ORACLE - Param = 79, Name = PYBYL48, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 160 08:21:17 SQL Data In: ORACLE - Param = 80, Name = PYBYL49, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 161 08:21:17 SQL Data In: ORACLE - Param = 81, Name = PMXZJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 162 08:21:17 SQL Data In: ORACLE - Param = 82, Name = PYBSM01, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 163 08:21:17 SQL Data In: ORACLE - Param = 83, Name = PYBSM02, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 164 08:21:17 SQL Data In: ORACLE - Param = 84, Name = PYBSM03, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 165 08:21:17 SQL Data In: ORACLE - Param = 85, Name = PYBSM04, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 166 08:21:17 SQL Data In: ORACLE - Param = 86, Name = PYBSM05, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 167 08:21:17 SQL Data In: ORACLE - Param = 87, Name = PYBSM06, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 168 08:21:17 SQL Data In: ORACLE - Param = 88, Name = PYBSM07, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 169 08:21:17 SQL Data In: ORACLE - Param = 89, Name = PYBSM08, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 170 08:21:17 SQL Data In: ORACLE - Param = 90, Name = PMSTYE0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 171 08:21:17 SQL Data In: ORACLE - Param = 91, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 172 08:21:17 SQL Data In: ORACLE - Param = 92, Name = PYHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 173 08:21:17 SQL Data In: ORACLE - Param = 93, Name = PSYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 174 08:21:17 SQL Data In: ORACLE - Param = 94, Name = PYBSM09, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 175 08:21:17 SQL Data In: ORACLE - Param = 95, Name = PYBSM10, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 176 08:21:17 SQL Data In: ORACLE - Param = 96, Name = PYBSM11, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 177 08:21:17 SQL Data In: ORACLE - Param = 97, Name = PYBSM12, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 178 08:21:17 SQL Data In: ORACLE - Param = 98, Name = PYBSM13, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 179 08:21:17 SQL Data In: ORACLE - Param = 99, Name = PYBSM14, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 180 08:21:17 SQL Data In: ORACLE - Param = 100, Name = PYBSM15, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 181 08:21:17 SQL Data In: ORACLE - Param = 101, Name = PYBSM16, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 182 08:21:17 SQL Data In: ORACLE - Param = 102, Name = pYBYL50, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 183 08:21:17 SQL Data In: ORACLE - Param = 103, Name = PYBYL51, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 184 08:21:17 SQL Data In: ORACLE - Param = 104, Name = PYBYL52, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 185 08:21:17 SQL Data In: ORACLE - Param = 105, Name = PYBYL53, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 186 08:21:17 SQL Data In: ORACLE - Param = 106, Name = PYBYL54, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 187 08:21:17 SQL Data In: ORACLE - Param = 107, Name = PYBYL55, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 188 08:21:17 SQL Data In: ORACLE - Param = 108, Name = PYBYL56, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 189 08:21:17 SQL Data In: ORACLE - Param = 109, Name = PYBYL57, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 190 08:21:17 SQL Data In: ORACLE - Param = 110, Name = PYBYL58, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 191 08:21:17 SQL Data In: ORACLE - Param = 111, Name = PYBYL59, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 192 08:21:17 SQL Data In: ORACLE - Param = 112, Name = PYBYL60, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 193 08:21:17 SQL Data In: ORACLE - Param = 113, Name = PYBYL61, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 194 08:21:17 SQL Data In: ORACLE - Param = 114, Name = PYBYL62, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 195 08:21:17 SQL Data In: ORACLE - Param = 115, Name = PYBYL63, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 196 08:21:17 SQL Data In: ORACLE - Param = 116, Name = PYBYL64, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 197 08:21:17 SQL Data In: ORACLE - Param = 117, Name = PYBYL65, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 198 08:21:17 SQL Data In: ORACLE - Param = 118, Name = PYBYL66, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 199 08:21:17 SQL Data In: ORACLE - Param = 119, Name = PYBYL67, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 200 08:21:17 SQL Data In: ORACLE - Param = 120, Name = PYBYL68, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 201 08:21:17 SQL Data In: ORACLE - Param = 121, Name = PYBYL69, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 202 08:21:17 SQL Data In: ORACLE - Param = 122, Name = PYBSM17, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 203 08:21:17 SQL Data In: ORACLE - Param = 123, Name = PYBSM18, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 204 08:21:17 SQL Data In: ORACLE - Param = 124, Name = PYBSM19, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 205 08:21:17 SQL Data In: ORACLE - Param = 125, Name = PYBSM20, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 206 08:21:17 SQL Data In: ORACLE - Param = 126, Name = PYBSM21, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 207 08:21:17 SQL Data In: ORACLE - Param = 127, Name = PYBSM22, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 208 08:21:17 SQL Data In: ORACLE - Param = 128, Name = PYBSM23, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 209 08:21:17 SQL Data In: ORACLE - Param = 129, Name = PYBSM24, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 210 08:21:17 SQL Data In: ORACLE - Param = 130, Name = PYBSM25, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 211 08:21:17 SQL Data In: ORACLE - Param = 131, Name = PYBSM26, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 212 08:21:17 SQL Data In: ORACLE - Param = 132, Name = PYBSM27, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 213 08:21:17 SQL Data In: ORACLE - Param = 133, Name = PYBSM28, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 214 08:21:17 SQL Data In: ORACLE - Param = 134, Name = PYBSM29, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 215 08:21:17 SQL Data In: ORACLE - Param = 135, Name = PYBJKID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 216 08:21:17 SQL Data In: ORACLE - Param = 136, Name = PMXLSH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 217 08:21:17 SQL Execute: ORACLE - BEGIN "SP_SF_FYXX00_YBJS00" (PID0000 => :PID0000,PBRID00 => :PBRID00,PJSFS00 => :PJSFS00,PZHLB00 => :PZHLB00,PYBJKLX => :PYBJKLX,PTSBZBH => :PTSBZBH,PYBGHH0 => :PYBGHH0,PYBDJH0 => :PYBDJH0,PSYDJH0 => :PSYDJH0,PBJDJH0 => :PBJDJH0,PYBCXDH => :PYBCXDH,PHJJE00 => :PHJJE00,PBCBXF0 => :PBCBXF0,PTCJJZF => :PTCJJZF,PGRZHZF => :PGRZHZF,PZFJE00 => :PZFJE00,PGWYBZ0 => :PGWYBZ0,PZHZFE0 => :PZHZFE0,PGRZFE0 => :PGRZFE0,PFYBJE0 => :PFYBJE0,PSBGRZH => :PSBGRZH,PSBTCJJ => :PSBTCJJ,PYBXJZF => :PYBXJZF,PYLZFJE => :PYLZFJE,PCFDXJE => :PCFDXJE,PBCKBCS => :PBCKBCS,PJJZFE0 => :PJJZFE0,PSYBXZF => :PSYBXZF,PYBZHYE => :PYBZHYE,PSBZFE0 => :PSBZFE0,PBJZFE0 => :PBJZFE0,PYBYL01 => :PYBYL01,PYBYL02 => :PYBYL02,PYBYL03 => :PYBYL03,PYBYL04 => :PYBYL04,PYBYL05 => :PYBYL05,PYBYL06 => :PYBYL06,PYBYL07 => :PYBYL07,PYBYL08 => :PYBYL08,PYBYL09 => :PYBYL09,PYBYL10 => :PYBYL10,PYBYL11 => :PYBYL11,PYBYL12 => :PYBYL12,PYBYL13 => :PYBYL13,PYBYL14 => :PYBYL14,PYBYL15 => :PYBYL15,PYBYL16 => :PYBYL16,PYBYL17 => :PYBYL17,PYBYL18 => :PYBYL18,PYBYL19 => :PYBYL19,PYBYL20 => :PYBYL20,PYBYL21 => :PYBYL21,PYBYL22 => :PYBYL22,PYBYL23 => :PYBYL23,PYBYL24 => :PYBYL24,PYBYL25 => :PYBYL25,PYBYL26 => :PYBYL26,PYBYL27 => :PYBYL27,PYBYL28 => :PYBYL28,PYBYL29 => :PYBYL29,PYBYL30 => :PYBYL30,PYBYL31 => :PYBYL31,PYBYL32 => :PYBYL32,PYBYL33 => :PYBYL33,PYBYL34 => :PYBYL34,PYBYL35 => :PYBYL35,PYBYL36 => :PYBYL36,PYBYL37 => :PYBYL37,PYBYL38 => :PYBYL38,PYBYL39 => :PYBYL39,PYBYL40 => :PYBYL40,PYBYL41 => :PYBYL41,PYBYL42 => :PYBYL42,PYBYL43 => :PYBYL43,PYBYL44 => :PYBYL44,PYBYL45 => :PYBYL45,PYBYL46 => :PYBYL46,PYBYL47 => :PYBYL47,PYBYL48 => :PYBYL48,PYBYL49 => :PYBYL49,PMXZJE0 => :PMXZJE0,PYBSM01 => :PYBSM01,PYBSM02 => :PYBSM02,PYBSM03 => :PYBSM03,PYBSM04 => :PYBSM04,PYBSM05 => :PYBSM05,PYBSM06 => :PYBSM06,PYBSM07 => :PYBSM07,PYBSM08 => :PYBSM08,PMSTYE0 => :PMSTYE0,PCOMMIT => :PCOMMIT,PYHMSG0 => :PYHMSG0,PSYSMSG => :PSYSMSG,PYBSM09 => :PYBSM09,PYBSM10 => :PYBSM10,PYBSM11 => :PYBSM11,PYBSM12 => :PYBSM12,PYBSM13 => :PYBSM13,PYBSM14 => :PYBSM14,PYBSM15 => :PYBSM15,PYBSM16 => :PYBSM16,pYBYL50 => :pYBYL50,PYBYL51 => :PYBYL51,PYBYL52 => :PYBYL52,PYBYL53 => :PYBYL53,PYBYL54 => :PYBYL54,PYBYL55 => :PYBYL55,PYBYL56 => :PYBYL56,PYBYL57 => :PYBYL57,PYBYL58 => :PYBYL58,PYBYL59 => :PYBYL59,PYBYL60 => :PYBYL60,PYBYL61 => :PYBYL61,PYBYL62 => :PYBYL62,PYBYL63 => :PYBYL63,PYBYL64 => :PYBYL64,PYBYL65 => :PYBYL65,PYBYL66 => :PYBYL66,PYBYL67 => :PYBYL67,PYBYL68 => :PYBYL68,PYBYL69 => :PYBYL69,PYBSM17 => :PYBSM17,PYBSM18 => :PYBSM18,PYBSM19 => :PYBSM19,PYBSM20 => :PYBSM20,PYBSM21 => :PYBSM21,PYBSM22 => :PYBSM22,PYBSM23 => :PYBSM23,PYBSM24 => :PYBSM24,PYBSM25 => :PYBSM25,PYBSM26 => :PYBSM26,PYBSM27 => :PYBSM27,PYBSM28 => :PYBSM28,PYBSM29 => :PYBSM29,PYBJKID => :PYBJKID,PMXLSH0 => :PMXLSH0); END; 218 08:21:17 SQL Execute: ORACLE - COMMIT 219 08:21:17 SQL Data In: ORACLE - Rows affected = 0 220 08:21:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 221 08:21:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2939140.000000 222 08:21:17 SQL Execute: ORACLE - select SF_SF_FYXX00_QFJE00(?,?,0) QFJE00 from dual 223 08:21:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 224 08:21:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2939140.000000 225 08:21:17 SQL Execute: ORACLE - select SF_SF_FYXX00_QFJE00(?,?,1) QFJE00 from dual 226 08:21:17 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2939140.000000 227 08:21:17 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 228 08:21:17 SQL Data In: ORACLE - Param = 3, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1513.000000 229 08:21:17 SQL Data In: ORACLE - Param = 4, Name = PFPXH00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 0000085 230 08:21:17 SQL Data In: ORACLE - Param = 5, Name = PTSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 231 08:21:17 SQL Data In: ORACLE - Param = 6, Name = PSFDYFP, Type = fldZSTRING, Precision = 3, Scale = 0, Data = Y,N 232 08:21:17 SQL Data In: ORACLE - Param = 7, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 233 08:21:17 SQL Data In: ORACLE - Param = 8, Name = PYHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 234 08:21:17 SQL Data In: ORACLE - Param = 9, Name = PSYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 235 08:21:17 SQL Execute: ORACLE - BEGIN "SP_SF_FYXX00_JS0000" (PID0000 => :PID0000,PBRID00 => :PBRID00,PCZY000 => :PCZY000,PFPXH00 => :PFPXH00,PTSBZBH => :PTSBZBH,PSFDYFP => :PSFDYFP,PJZDH00 => :PJZDH00,PYHMSG0 => :PYHMSG0,PSYSMSG => :PSYSMSG); END; 236 08:21:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2939140.000000 237 08:21:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 238 08:21:18 SQL Execute: ORACLE - select distinct CFLSH0,YJDJH0,XMFL00 From SF_FYXX00_DJH000 where 1=1 and ID0000=? and BRID00=? and KFZT00='0' and JZDH00=0 and ((XMFL00='0' and CFID00>0) or (XMFL00='1' and YJDJH0>0)) order by XMFL00, CFLSH0,YJDJH0 239 08:21:18 SQL Execute: ORACLE - COMMIT 240 08:21:18 SQL Data In: ORACLE - Rows affected = 0 241 08:21:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 242 08:21:18 SQL Execute: ORACLE - select * from VW_SF_BRZHXX where jflbid = 1 and brid00=? 243 08:21:18 SQL Execute: ORACLE - select pjh000 from vw_sf_fp0000 WHERE JZDH00=2545497 group by pjh000 244 08:21:18 SQL Execute: ORACLE - select * from vw_sf_fp0000 where PJH000=10377693 245 08:21:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2545497.000000 246 08:21:18 SQL Execute: ORACLE - select SF_SF_FPXSPDXH(?) PDXLMC from dual 247 08:21:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2545497.000000 248 08:21:18 SQL Execute: ORACLE - select C.DLXH00,C.YFMC00,C.CKMC00||'窗口' FYCK00,C.FYDLXH,c.PHBZ00,b.ZYDJS0,B.YPDLBH from SF_BRFY00 A,YF_MZCF00 B,VW_YF_PDPRINT C WHERE 1=1 AND A.DJH000=B.DJH000 and B.CFLSH0=C.CFLSH0 and C.PHBZ00 in ('0','2','3') AND A.JZDH00=? 249 08:21:18 SQL Execute: ORACLE - update YF_CFDL00 set phdycs=nvl(phdycs,0)+1,QHDDY0=nvl(QHDDY0,0)+1,PHBZ00='3' where PHBZ00='0' AND DLXH00 in (2736753 ) 250 08:21:18 SQL Data In: ORACLE - Rows affected = 1 251 08:21:18 SQL Execute: ORACLE - insert into YF_PHDYRZ(ID0000,XTMC00,CFLSH0,BRXM00,PHDYCS,CZRQ00,CZSJ00,CZY000,IP0000) select SQ_YF_PHDYRZ_ID0000.NEXTVAL,'门诊收费',CFLSH0,BRXM00,PHDYCS,to_char(sysdate,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS'),1513,'192.168.10.200' from YF_CFDL00 WHERE DLXH00 in (2736753 ) 252 08:21:18 SQL Data In: ORACLE - Rows affected = 1 253 08:21:18 SQL Execute: ORACLE - Commit 254 08:21:18 SQL Data In: ORACLE - Rows affected = 0 255 08:21:18 SQL Execute: ORACLE - select B.DWMC00 from BM_BRXXB0 A,BM_TYDWB0 B where A.TYDWID=B.DWID00 and A.BRID00=301 256 08:21:18 SQL Execute: ORACLE - SELECT B.XMMC00,b.sfje00 FROM xt_xtcs00 A,BM_YYSFXM B WHERE TO_NUMBER(A.VALUE0)=B.SFXMID AND A.NAME00='IC_SFDM' 257 08:21:18 SQL Execute: ORACLE - select nvl(sum(a.hjje00),0) ickje0 from sf_fymx00 a,sf_brfy00 b where a.djh000=b.djh000 and a.XMBH00=8000027006 and b.jzdh00+0=0 and b.brid00= 301 258 08:21:18 SQL Execute: ORACLE - select count(1) from bm_brxxb0 a,ic_yhxx00 b where a.brid00=b.brid00 and a.brid00=301 and (a.FBBH00 in (1,3,29,30,31) or b.ZT0000=4) 259 08:21:18 SQL Execute: ORACLE - select * from BM_TSBZB0 where BH0000='' 260 08:21:18 SQL Execute: ORACLE - select A.YBID00, A.fbbh00,B.FBMC00 from BM_BRXXB0 A,BM_BRFBB0 B where A.FBBH00=B.FBBH00 AND A.BRID00=301 261 08:21:18 SQL Execute: ORACLE - select SF_SF_YBFPJE(2545497,2) XSNR00 from dual 262 08:21:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 301 263 08:21:18 SQL Execute: ORACLE - select SFXNH0 from bm_brxxb0 a,ic_ybbrlb b where a.fbbh00=b.fbbh00 and a.yblb00=b.yblb00 and a.brid00=? 264 08:21:18 SQL Execute: ORACLE - select sf_js_dyghrq(2545497) ghrq00 from dual 265 08:21:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2545497.000000 266 08:21:18 SQL Execute: ORACLE - select NVL(max(JFLBID),1) JFLBID from SF_BRJFB0 where JZDH00 =? 267 08:21:18 SQL Execute: ORACLE - select NVL(ZYE000,0) ZYE000 from sf_brzhxx where jflbid = 1 and brid00 =301 268 08:21:18 SQL Execute: ORACLE - select * from VW_SF_PJSYMX where xmje00<>0 and PJH000 =10377693 order by XMBH00 269 08:21:20 SQL Execute: ORACLE - COMMIT 270 08:21:20 SQL Data In: ORACLE - Rows affected = 0 271 08:21:20 SQL Execute: ORACLE - rollback 272 08:21:20 SQL Data In: ORACLE - Rows affected = 0 273 08:21:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 274 08:21:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 275 08:21:20 SQL Execute: ORACLE - select nvl(round(sum(a.LSDJ00*a.YPZSL0),2), 0)HJJE00 from yf_mzcfmx a ,yf_mzcf00 b where a.CFLSH0=b.CFLSH0 and b.BCCFH0 is null and b.CFZT00 = '0' and b.BRID00 = ? and a.SFZBY0<>'Y' and b.ghid00 in(select ghid00 from sf_brxxb0 where to_date(GHRQ00,'YYYYMMDD')>=sysdate-3 and brid00= ?) 276 08:21:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 301.000000 277 08:21:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000027006.000000 278 08:21:20 SQL Execute: ORACLE - select nvl(sum(a.HJJE00),0) hjje00 from sf_fymx00 a,sf_brfy00 b where a.djh000=b.djh000 and b.jzdh00+0=0 and b.brid00= ? and a.xmbh00+0<> ?