1 16:20:30 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=:1 2 16:20:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571638.000000 3 16:20:30 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 4 16:20:30 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=:1 5 16:20:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571638.000000 6 16:20:30 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=? 7 16:20:30 SQL Prepare: ORACLE - Select SYSDATE from Dual 8 16:20:30 SQL Execute: ORACLE - Select SYSDATE from Dual 9 16:20:30 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 10 16:20:30 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 11 16:20:30 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 12 16:20:30 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 13 16:20:30 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0228766600039957' and ICKNBH = '0228766600039957' 14 16:20:30 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0228766600039957' and ICKNBH = '0228766600039957' 15 16:20:30 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=:1 16 16:20:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571639.000000 17 16:20:30 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 18 16:20:30 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=:1 19 16:20:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571639.000000 20 16:20:30 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=? 21 16:20:30 SQL Prepare: ORACLE - Select SYSDATE from Dual 22 16:20:30 SQL Execute: ORACLE - Select SYSDATE from Dual 23 16:20:30 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 24 16:20:30 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 25 16:20:30 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 26 16:20:30 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 27 16:20:30 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0228766600039957' and ICKNBH = '0228766600039957' 28 16:20:30 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0228766600039957' and ICKNBH = '0228766600039957' 29 16:20:30 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=:1 30 16:20:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571638.000000 31 16:20:30 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 32 16:20:30 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=:1 33 16:20:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571638.000000 34 16:20:30 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=? 35 16:20:30 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=:1 36 16:20:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571639.000000 37 16:20:30 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 38 16:20:30 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=:1 39 16:20:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571639.000000 40 16:20:30 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=? 41 16:20:31 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=:1 42 16:20:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571638.000000 43 16:20:31 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 44 16:20:31 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=:1 45 16:20:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571639.000000 46 16:20:31 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 47 16:20:31 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=:1 48 16:20:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571638.000000 49 16:20:31 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 50 16:20:31 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=:1 51 16:20:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571638.000000 52 16:20:31 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=? 53 16:20:31 SQL Prepare: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00); END; 54 16:20:31 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571638.000000 55 16:20:31 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 56 16:20:31 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 57 16:20:31 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 58 16:20:31 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 9999 59 16:20:31 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 821.000000 60 16:20:31 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00); END; 61 16:20:32 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=:1 62 16:20:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571639.000000 63 16:20:32 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 64 16:20:32 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=:1 65 16:20:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571639.000000 66 16:20:32 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=? 67 16:20:32 SQL Prepare: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00); END; 68 16:20:32 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571639.000000 69 16:20:32 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 70 16:20:32 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 71 16:20:32 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 72 16:20:32 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 9999 73 16:20:32 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 821.000000 74 16:20:32 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00); END; 75 16:20:32 SQL Prepare: ORACLE - select YJDJH0,BRID00,MZZYBZ,ZYHGHH,ZYGHID,KDKSBH,KDKS01,YJKSBH,ZXKS01,LBBH00,KDYS00,JKBH01,KDRQ00,XMZT00,YZCFID,SL0000,JCLBMC,JCLBWZ,ZLXMID from VW_ZS_JCJYD0 where LBBH00='4' and BRID00=:1 76 16:20:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 77 16:20:32 SQL Execute: ORACLE - select YJDJH0,BRID00,MZZYBZ,ZYHGHH,ZYGHID,KDKSBH,KDKS01,YJKSBH,ZXKS01,LBBH00,KDYS00,JKBH01,KDRQ00,XMZT00,YZCFID,SL0000,JCLBMC,JCLBWZ,ZLXMID from VW_ZS_JCJYD0 where LBBH00='4' and BRID00=? 78 16:20:32 SQL Prepare: ORACLE - Select SYSDATE from Dual 79 16:20:32 SQL Execute: ORACLE - Select SYSDATE from Dual 80 16:20:32 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 81 16:20:32 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 82 16:20:32 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 83 16:20:32 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 84 16:20:32 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0228766600039957' and ICKNBH = '0228766600039957' 85 16:20:32 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0228766600039957' and ICKNBH = '0228766600039957' 86 16:20:32 SQL Prepare: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END; 87 16:20:32 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1029127.000000 88 16:20:32 SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 89 16:20:32 SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 90 16:20:32 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 91 16:20:32 SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 92 16:20:32 SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 93 16:20:32 SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 94 16:20:32 SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 95 16:20:32 SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 96 16:20:32 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 97 16:20:32 SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 98 16:20:32 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 99 16:20:32 SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 100 16:20:32 SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 101 16:20:32 SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 102 16:20:32 SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 103 16:20:32 SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 104 16:20:32 SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END; 105 16:20:32 SQL Prepare: ORACLE - select nvl(SF_YJ_GETWSFXMZJE(821,1029127,'20120505','20120505'),'0') WSFZJE from dual 106 16:20:32 SQL Execute: ORACLE - select nvl(SF_YJ_GETWSFXMZJE(821,1029127,'20120505','20120505'),'0') WSFZJE from dual 107 16:20:32 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=:1 108 16:20:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571638.000000 109 16:20:32 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 110 16:20:32 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=:1 111 16:20:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571638.000000 112 16:20:32 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=? 113 16:20:32 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=:1 114 16:20:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571639.000000 115 16:20:32 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 116 16:20:32 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=:1 117 16:20:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571639.000000 118 16:20:32 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=? 119 16:20:32 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=:1 120 16:20:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571639.000000 121 16:20:32 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 122 16:20:32 SQL Prepare: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=:1 123 16:20:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3571639.000000 124 16:20:32 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=? 125 16:20:32 SQL Prepare: ORACLE - Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,ZLDCCF,b.CXSL00,b.txm000,b.FBBH00,b.CH0000,b.yjksbh,(select bmmc00 from bm_bmbm00 where bmbh00=b.YJKSBH) YJKSMC from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and xmzt00 in ('0','1','2') and b.mzzybz='0' and brid00=:1 and (YJKSBH=:2 or ( (((b.Zlxmid,b.kdksbh) in (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=:3)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=:4) )) and ( (',0,'=',0,') or (instr(',0,',:5 )>0) ) ) ) and kdrq00 between :6 and :7 and b.SL0000-nvl(b.CXSL00,0)-b.ZXSL00>0 order by brid00,zyhghh,zyzbid,yzcfid,kdrq00,zlxmid 126 16:20:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1029127.000000 127 16:20:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 821.000000 128 16:20:32 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 821.000000 129 16:20:32 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 821.000000 130 16:20:32 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = ,821, 131 16:20:32 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120505 132 16:20:32 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120505 133 16:20:32 SQL Execute: ORACLE - Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,ZLDCCF,b.CXSL00,b.txm000,b.FBBH00,b.CH0000,b.yjksbh,(select bmmc00 from bm_bmbm00 where bmbh00=b.YJKSBH) YJKSMC from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and xmzt00 in ('0','1','2') and b.mzzybz='0' and brid00=? and (YJKSBH=? or ( (((b.Zlxmid,b.kdksbh) in (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=?)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=?) )) and ( (',0,'=',0,') or (instr(',0,',? )>0) ) ) ) and kdrq00 between ? and ? and b.SL0000-nvl(b.CXSL00,0)-b.ZXSL00>0 order by brid00,zyhghh,zyzbid,yzcfid,kdrq00,zlxmid 134 16:20:32 SQL Prepare: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=:1 135 16:20:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 136 16:20:32 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000 from yj_ywmx00 where yjdjh0=? 137 16:20:32 SQL Prepare: ORACLE - select * from yj_yw0000 where yjdjh0 in (3571638,3571639) order by zyhghh,mzzybz 138 16:20:32 SQL Execute: ORACLE - select * from yj_yw0000 where yjdjh0 in (3571638,3571639) order by zyhghh,mzzybz 139 16:20:32 SQL Prepare: ORACLE - select * from yj_yw0000 where yjdjh0 in (3571638,3571639) order by zyhghh,mzzybz 140 16:20:32 SQL Execute: ORACLE - select * from yj_yw0000 where yjdjh0 in (3571638,3571639) order by zyhghh,mzzybz