1 09:02:22 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',55,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',830,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =830 AND b.JSKSBH = '55') AND (INSTR (',' || a.jsksbh || ',',',55,') > 0 or a.jsksbh is null) 2 09:02:24 SQL Data In: ORACLE - Param = 1, Name = AD_PJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12095514.000000 3 09:02:24 SQL Data In: ORACLE - Param = 2, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 830.000000 4 09:02:24 SQL Data In: ORACLE - Param = 3, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 朱宝惠 5 09:02:24 SQL Data In: ORACLE - Param = 4, Name = AD_NEWPJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6 09:02:24 SQL Data In: ORACLE - Param = 5, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 7 09:02:24 SQL Data In: ORACLE - Param = 6, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 8 09:02:24 SQL Execute: ORACLE - BEGIN "SP_SF_TJDWPJBD" (AD_PJH000 => :AD_PJH000,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_NEWPJH => :AD_NEWPJH,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 9 09:02:24 SQL Execute: ORACLE - Commit 10 09:02:24 SQL Data In: ORACLE - Rows affected = 0 11 09:02:24 SQL Execute: ORACLE - select * from vw_sf_fp0000 where pjh000=12095571 12 09:02:24 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00='非税收入医疗票据开票接口' order by XSXH00 13 09:02:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 830.000000 14 09:02:24 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=? 15 09:02:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 100046 16 09:02:24 SQL Execute: ORACLE - Select SF_SF_JKLXMC(?)FHXX00 from dual 17 09:02:24 SQL Data In: ORACLE - Param = 1, Name = P_INID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 18 09:02:24 SQL Data In: ORACLE - Param = 2, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 19 09:02:24 SQL Data In: ORACLE - Param = 3, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 830.000000 20 09:02:24 SQL Data In: ORACLE - Param = 4, Name = P_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 55.000000 21 09:02:24 SQL Data In: ORACLE - Param = 5, Name = P_JKLXBH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 100046 22 09:02:24 SQL Data In: ORACLE - Param = 6, Name = P_INCS00, Type = fldZSTRING, Precision = 31, Scale = 0, Data = 结算异常重打(单位体检)|22391963 23 09:02:24 SQL Data In: ORACLE - Param = 7, Name = P_CZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 24 09:02:24 SQL Data In: ORACLE - Param = 8, Name = P_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5996398.000000 25 09:02:24 SQL Data In: ORACLE - Param = 9, Name = P_SFFSJK, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 26 09:02:24 SQL Data In: ORACLE - Param = 10, Name = P_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 27 09:02:24 SQL Data In: ORACLE - Param = 11, Name = AS_OUTCS0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 28 09:02:24 SQL Data In: ORACLE - Param = 12, Name = AS_OUTID0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 29 09:02:24 SQL Data In: ORACLE - Param = 13, Name = AS_JBZXZT, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 30 09:02:24 SQL Data In: ORACLE - Param = 14, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 31 09:02:24 SQL Data In: ORACLE - Param = 15, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 32 09:02:24 SQL Execute: ORACLE - BEGIN "SP_SF_FSFPJK" (P_INID00 => :P_INID00,P_BRID00 => :P_BRID00,P_CZY000 => :P_CZY000,P_CZYKS0 => :P_CZYKS0,P_JKLXBH => :P_JKLXBH,P_INCS00 => :P_INCS00,P_CZLX00 => :P_CZLX00,P_JZDH00 => :P_JZDH00,P_SFFSJK => :P_SFFSJK,P_COMMIT => :P_COMMIT,AS_OUTCS0 => :AS_OUTCS0,AS_OUTID0 => :AS_OUTID0,AS_JBZXZT => :AS_JBZXZT,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 33 09:02:24 SQL Execute: ORACLE - COMMIT 34 09:02:24 SQL Data In: ORACLE - Rows affected = 0 35 09:02:32 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '4') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',55,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',830,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =830 AND b.JSKSBH = '55') AND (INSTR (',' || a.jsksbh || ',',',55,') > 0 or a.jsksbh is null)