1 10:30:20 Log started for: 门诊挂号收费管理系统 2 10:30:20 SQL Prepare: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','4',trim(PROGRAM)||'+'||'门诊挂号收费管理系统',SID,serial# ,'20110317','10:30:23','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 3 10:30:20 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','4',trim(PROGRAM)||'+'||'门诊挂号收费管理系统',SID,serial# ,'20110317','10:30:23','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 10:30:20 SQL Prepare: ORACLE - Commit 5 10:30:20 SQL Execute: ORACLE - Commit 6 10:30:20 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 7 10:30:20 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 10:30:20 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 9 10:30:20 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 10 10:30:20 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 11 10:30:20 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 12 10:30:20 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','4',trim(PROGRAM)||'+'||'门诊挂号收费管理系统',SID,serial# ,'20110317','10:30:23','sd_hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 13 10:30:20 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.15.15','4',trim(PROGRAM)||'+'||'门诊挂号收费管理系统',SID,serial# ,'20110317','10:30:23','sd_hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 14 10:30:20 SQL Prepare: ORACLE - Commit 15 10:30:20 SQL Execute: ORACLE - Commit 16 10:30:20 SQL Prepare: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 17 10:30:20 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 18 10:30:20 SQL Prepare: ORACLE - Commit 19 10:30:20 SQL Execute: ORACLE - Commit 20 10:30:20 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='4' 21 10:30:20 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='4' 22 10:30:20 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 23 10:30:20 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 24 10:30:20 SQL Prepare: ORACLE - Select SYSDATE from Dual 25 10:30:20 SQL Execute: ORACLE - Select SYSDATE from Dual 26 10:30:20 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 27 10:30:20 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 28 10:30:20 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 29 10:30:20 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 30 10:30:20 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='4' 31 10:30:20 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='4' 32 10:30:20 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 33 10:30:20 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 34 10:30:20 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 35 10:30:20 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 36 10:30:20 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('4') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 37 10:30:20 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('4') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 38 10:30:20 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '4' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 39 10:30:20 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '4' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 40 10:30:20 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 41 10:30:20 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 42 10:30:20 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 43 10:30:20 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 44 10:30:20 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 45 10:30:20 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 46 10:30:20 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 47 10:30:20 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 48 10:30:20 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 49 10:30:20 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 50 10:30:20 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 51 10:30:20 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 52 10:30:20 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2489536,476,'wlzx-2','4',nvl('3573958',' '),'192.168.15.15#826:1725@PrjMZ_MZSF.exe+门诊挂号收费管理系统',44) 53 10:30:20 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2489536,476,'wlzx-2','4',nvl('3573958',' '),'192.168.15.15#826:1725@PrjMZ_MZSF.exe+门诊挂号收费管理系统',44) 54 10:30:20 SQL Prepare: ORACLE - Commit 55 10:30:20 SQL Execute: ORACLE - Commit 56 10:30:20 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 44 57 10:30:20 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 44 58 10:30:20 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 59 10:30:20 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 60 10:30:20 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15' 61 10:30:20 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.15.15' 62 10:30:20 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 63 10:30:20 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 64 10:30:20 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 44 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 65 10:30:20 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 44 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 66 10:30:21 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 67 10:30:21 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 68 10:30:21 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 69 10:30:21 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 70 10:30:21 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='4') and YXQ000>='20110317' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',44,' )>0 ) 71 10:30:21 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='4') and YXQ000>='20110317' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',44,' )>0 ) 72 10:30:21 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 73 10:30:21 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 74 10:30:21 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 75 10:30:21 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 76 10:30:21 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='4' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='4' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 77 10:30:21 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='4' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='4' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 78 10:30:21 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '4$%' and A.XTDM00='4' and trim(A.MKDM00)='4$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 79 10:30:21 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '4$%' and A.XTDM00='4' and trim(A.MKDM00)='4$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 80 10:30:21 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 81 10:30:21 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 82 10:30:21 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 83 10:30:21 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 84 10:30:21 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 85 10:30:21 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 86 10:30:22 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 87 10:30:22 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 88 10:30:23 SQL Prepare: ORACLE - Update SF_BRDB00 set SFYX00='N' where DBJSRQ < to_char(sysdate,'yyyymmdd') and SFYX00 = 'Y' 89 10:30:23 SQL Execute: ORACLE - Update SF_BRDB00 set SFYX00='N' where DBJSRQ < to_char(sysdate,'yyyymmdd') and SFYX00 = 'Y' 90 10:30:23 SQL Prepare: ORACLE - Commit 91 10:30:23 SQL Execute: ORACLE - Commit 92 10:30:23 SQL Prepare: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_SF_SF_BRFY00_INSERT','TR_SF_SF_BRJFB0_INSERT', 'TR_SF_SF_BRDB00_UPDATE','TR_SF_SF_PJSYQK_INSERT', 'TR_SF_SF_BRJFB0_UPDATE','TR_SF_SF_BRXXB0_INSERT','TR_SF_SF_PJSYQK_INSERT') and STATUS = 'ENABLED' 93 10:30:23 SQL Execute: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_SF_SF_BRFY00_INSERT','TR_SF_SF_BRJFB0_INSERT', 'TR_SF_SF_BRDB00_UPDATE','TR_SF_SF_PJSYQK_INSERT', 'TR_SF_SF_BRJFB0_UPDATE','TR_SF_SF_BRXXB0_INSERT','TR_SF_SF_PJSYQK_INSERT') and STATUS = 'ENABLED' 94 10:30:23 SQL Prepare: ORACLE - select * from bm_brzffs where ZFFSMC = '现金' 95 10:30:23 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC = '现金' 96 10:30:23 SQL Prepare: ORACLE - select count(*) NUM from bm_brjflb where jflbid=0 or sybz00 = '0' or sybz00 = '1' 97 10:30:23 SQL Execute: ORACLE - select count(*) NUM from bm_brjflb where jflbid=0 or sybz00 = '0' or sybz00 = '1' 98 10:30:23 SQL Prepare: ORACLE - select sysdate nowtime from dual 99 10:30:23 SQL Execute: ORACLE - select sysdate nowtime from dual 100 10:30:23 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 101 10:30:23 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 102 10:30:23 SQL Prepare: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('SF_YBSFYGSSYLB','SF_MZFPSFDYYJJYE','SF_YBJSSAZTSBZ','SF_FYJSWSFTSWJSFY','MZSF_SFTSDYZSFP','SF_CJFY','SF_PRINTGHHFZDXZDY','SF_MZQDSFXSJMJE','SF_MZJSSFKYCZTYDW','SF_YHKLB','SF_GHXXSFTXJT','SF_FYJSSFXXZTSBZ','SF_GHLBBH','SF_GHXMBH','SF_PJQKSFDYFS','SF_SFSYFPXMZMYHJM','SF_FPGS00','SF_YYIDPDDLKS','SF_TSBZ_SFMRSCJZTSBZ','SF_TSBZ_SFZJSBTSBZFY','SF_FYDJSFXSGQGH','SF_YBFYDJSFZDBSDJF','SF_MZFPSFXSTSBZ','SF_MZRQDSFXSZHYE','SF_MZLSCFSFCSMFH','SF_LSCLSFXZ','SF_SFQYAKYYGH','SF_YJJDLEFTTOP','SF_TYJJDLEFTTOP','SF_DYBRXX_TOPLEFT','MZSF_YJJGHFB','SF_GHCKNLDYS','SF_GHCKSFTSZFCK','SF_SFKYQZTKCZ','SF_KP_SFQDZRXDTS','SF_BRGKSFXSMMK','SF_GRZFSFBHSB','SF_SFYJXGSJQY','SF_SFYXSFCDLYJXM','SF_PJWLYBNSY','SF_SFYXCKDQPJH','SF_YJXMYXTS','SF_CSBSYBFPSFFKCL','SF_RQDZFBLSFTXNJYY','SF_YBZGTJHSFYZMTJJK','MZSF_SFJSTXJKYCX','SF_MZFPSFXSQYXX','SF_SFHANHTSBZBR','SF_YBJKSFXDYNK','SF_FPBDJSRQSFXSQSRQ','SF_BJJESFBKKQFJE','SF_JSJZTKFPSFXSQZQYJJYE','SF_LSTDBRFB','SF_GHJFYCLXJBRZYXYXJZFFS','SF_YBGRZHZWYXQFJE') 103 10:30:23 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('SF_YBSFYGSSYLB','SF_MZFPSFDYYJJYE','SF_YBJSSAZTSBZ','SF_FYJSWSFTSWJSFY','MZSF_SFTSDYZSFP','SF_CJFY','SF_PRINTGHHFZDXZDY','SF_MZQDSFXSJMJE','SF_MZJSSFKYCZTYDW','SF_YHKLB','SF_GHXXSFTXJT','SF_FYJSSFXXZTSBZ','SF_GHLBBH','SF_GHXMBH','SF_PJQKSFDYFS','SF_SFSYFPXMZMYHJM','SF_FPGS00','SF_YYIDPDDLKS','SF_TSBZ_SFMRSCJZTSBZ','SF_TSBZ_SFZJSBTSBZFY','SF_FYDJSFXSGQGH','SF_YBFYDJSFZDBSDJF','SF_MZFPSFXSTSBZ','SF_MZRQDSFXSZHYE','SF_MZLSCFSFCSMFH','SF_LSCLSFXZ','SF_SFQYAKYYGH','SF_YJJDLEFTTOP','SF_TYJJDLEFTTOP','SF_DYBRXX_TOPLEFT','MZSF_YJJGHFB','SF_GHCKNLDYS','SF_GHCKSFTSZFCK','SF_SFKYQZTKCZ','SF_KP_SFQDZRXDTS','SF_BRGKSFXSMMK','SF_GRZFSFBHSB','SF_SFYJXGSJQY','SF_SFYXSFCDLYJXM','SF_PJWLYBNSY','SF_SFYXCKDQPJH','SF_YJXMYXTS','SF_CSBSYBFPSFFKCL','SF_RQDZFBLSFTXNJYY','SF_YBZGTJHSFYZMTJJK','MZSF_SFJSTXJKYCX','SF_MZFPSFXSQYXX','SF_SFHANHTSBZBR','SF_YBJKSFXDYNK','SF_FPBDJSRQSFXSQSRQ','SF_BJJESFBKKQFJE','SF_JSJZTKFPSFXSQZQYJJYE','SF_LSTDBRFB','SF_GHJFYCLXJBRZYXYXJZFFS','SF_YBGRZHZWYXQFJE') 104 10:30:23 SQL Prepare: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_JSSRTDXXTJBBSFCF','ZY_JSSRTDXXTJBBCFLS','ZY_JSSRTDXXTJBBCFHS','GHYXTS','YJ_XMYXTS','SF_PJHSC0','SF_DYYBFP','SF_MZBLH0','XT_JEQZ00','XT_YBJEQZ','SF_ZHTYJE','SF_ZHBJJE','SF_PJDKDY','YF_CFZJE_SRWS_YB','YF_CFZJE_CZFS_YB','YF_CFMXJE_SRWS','YF_YZMXJE_SRWS','YF_CFZJE_SRWS','YF_CFZJE_CZFS','YF_CFMXJE_CZFS','YF_YZMXJE_CZFS','SF_SFYJS0_BZ0000','SF_GHD000_PRINT0','SF_PRINTSCALE','SF_TKPAR0_CZY000','SF_PARAMS_GHYXTS','ZY_RQDZZ0_SETUP0','SF_PageWidth','SF_PageHeigh','SF_PageDirect','SF_GHDLX0','SF_GHDSFTD','SF_JHFPSFTD','SF_SFSYJZK','SF_TJKSSJ','SF_TJJSSJ','SF_SFGLGZGHD','SF_YBGHFJF','SF_YBBRXB','SF_FPWidth','SF_FPHeigh','SF_NEWFPWidth','SF_NEWFPHeigh','SF_GHDWidth','SF_GHDHeigh','YF_ZYFJF_YPNM00','ZY_PJLYXYLYQR','SF_GHXGSFBRCZ','SF_JKDSFTD','SF_JKDJSFZDJS','SF_JKSFAJJBSJ','SF_NEWFPGS','SF_MZSFJJBSJ','SF_SYDJSBBGBF','SF_FYBXMSFSYYBBH','SF_GHCZSBBGBF','SF_MZJKDGS0','SF_YJJDGS0','SF_FYJSMR0','IC_YBYYJKLM','SF_COMMIT_READICK','SF_YBDJSLJE','SF_SFSYICK','SF_FPLXBZ0','XT_YBFSJK','XT_SGLRKH','XT_XYCYTCF','SF_XJGHSK','SF_BLHSFZDSC','SF_MZBLSYGS','XT_GZYJJYXTJK','SF_KHBLHXT','SF_SSWUTSCL','SF_SFCYSSWR','SF_HKSFTF0','SF_SFTKZDSP','SF_SFDYQD','SF_GHSSFSBLDGGH','SF_SFCFFP','SF_DYQBFP','SF_SFPDYB_CF0000','SF_ZY_SFZDXS','ZY_YJJPJ0','SF_SFSYYBYKT','SF_XJJSSFDYZHYE','SF_SFSYYGKJ','SF_KFSFKQ','SF_YBSFYXQF','ZY_YBFPBH','SF_CKBRSYGHD','IC_SFDM','SF_SFTSWF','SF_YBSFAGHDJS','SF_SFYDDYJ','SFYBZHYE','SF_MZYJJXZ','SF_SFDYTSJKD','SF_MZJSTSNY','SF_SFZDTJYJD','SF_TYJJDYYE','SF_SFDYZLD','SF_SFSYJZSX','SF_EJBBSFCF','SF_EJBBCFLS','SF_EJBBCFHS','SF_FPLEFT','SF_FPTOP','SF_TKAZFFS','SF_JSATSBZ','SF_MZJKCZKZ','XT_JKTQSJ','SF_YJJGHZXJ','SF_SFCKJDDW','SF_DKZDDW','SF_ZY_FFJJ','SF_LSCFHJBRYF','SF_LSCFSFNFSRBRXM','SF_SFXMCGSXSFCF','SF_BRJKSFYXXDZ','SF_FYYFNFAZEYF','SF_YBFYDJSFLJJS','SF_YJJDSFDYPJH','SF_FYDJYSSFWK','SF_MZFPSFDYYBGRZHYE','SF_DEFAULT_HKSQKF','SF_YBBRJSSFTSDTJSFY','SF_YJJFXJZFZDXE','SF_YSXDHGHKSSFYXXG','SF_GHSYSXMSFYXWK','SF_BRNLSFXSDY','SF_SFYXXGBRBLH','SF_JZBRDTFPXZZS','SF_GHAXJYSXZLB','SF_SFQYCZPJKPJK','SF_KP_MZFPDYPLBH','SF_KP_FPZRDYMS','SF_KP_LJDLKPXTFS','XT_BRBYKFB','MZSF_FYBXJJZYXQC','SF_NNGHDTL','SF_RQDTOPLEFT','SF_RQDBOTTOMRIGHT','SF_YBJSSFYXQZHTK','SF_YBBNCZSSFZXJJZ','SF_SFYXTZZJE','SF_PRINTBLSYZDY','SF_PTBRSFAGHHJS','SF_YJJGHFYDJQDQYBZH','SF_GHFTC','SF_YJJTKQKYSPZSZ','SF_NLXDYSBSFXTLXR','SF_CKBRABLHJS','SF_FPDYGHRQ','SF_FYDJSSFBSYFYGH','SF_YJJDSFTD','SF_YJJTKDSFTD','SF_GYBRDTGHXDCS','SF_CGXESFYXQR','SF_LRSFXMSFABHPX','TJ_GRTJYXTS','SF_FZFPSFDYFYQZRQ','SF_PRINTYJJPJZDY','SF_PRINTYJJPJTKZDY','SF_FZFPDYPJXHLX','SF_HKSFKXZSQKF','XT_TJGHLB','SF_KP_CXZRSFZFYFP','SF_PRINTTJDWPJZDY','YS_SFYXPTBRTQGH','SF_MZFPSFXSFYBF','SF_XMFPSFXSYJJZE','SF_QSJDYJJZELB','SF_XMFPQDSFXSZLXM','MZ_FPGS00','SF_SFXMYBJK','IC_SFDM','SF_KP_ICKFSFDDLC','SF_SFCGHYSTHSQBZ','SF_XMYBFYDJSFKXZHLX','SF_GYZHPDBZ','SF_FPDYXS') 105 10:30:23 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_JSSRTDXXTJBBSFCF','ZY_JSSRTDXXTJBBCFLS','ZY_JSSRTDXXTJBBCFHS','GHYXTS','YJ_XMYXTS','SF_PJHSC0','SF_DYYBFP','SF_MZBLH0','XT_JEQZ00','XT_YBJEQZ','SF_ZHTYJE','SF_ZHBJJE','SF_PJDKDY','YF_CFZJE_SRWS_YB','YF_CFZJE_CZFS_YB','YF_CFMXJE_SRWS','YF_YZMXJE_SRWS','YF_CFZJE_SRWS','YF_CFZJE_CZFS','YF_CFMXJE_CZFS','YF_YZMXJE_CZFS','SF_SFYJS0_BZ0000','SF_GHD000_PRINT0','SF_PRINTSCALE','SF_TKPAR0_CZY000','SF_PARAMS_GHYXTS','ZY_RQDZZ0_SETUP0','SF_PageWidth','SF_PageHeigh','SF_PageDirect','SF_GHDLX0','SF_GHDSFTD','SF_JHFPSFTD','SF_SFSYJZK','SF_TJKSSJ','SF_TJJSSJ','SF_SFGLGZGHD','SF_YBGHFJF','SF_YBBRXB','SF_FPWidth','SF_FPHeigh','SF_NEWFPWidth','SF_NEWFPHeigh','SF_GHDWidth','SF_GHDHeigh','YF_ZYFJF_YPNM00','ZY_PJLYXYLYQR','SF_GHXGSFBRCZ','SF_JKDSFTD','SF_JKDJSFZDJS','SF_JKSFAJJBSJ','SF_NEWFPGS','SF_MZSFJJBSJ','SF_SYDJSBBGBF','SF_FYBXMSFSYYBBH','SF_GHCZSBBGBF','SF_MZJKDGS0','SF_YJJDGS0','SF_FYJSMR0','IC_YBYYJKLM','SF_COMMIT_READICK','SF_YBDJSLJE','SF_SFSYICK','SF_FPLXBZ0','XT_YBFSJK','XT_SGLRKH','XT_XYCYTCF','SF_XJGHSK','SF_BLHSFZDSC','SF_MZBLSYGS','XT_GZYJJYXTJK','SF_KHBLHXT','SF_SSWUTSCL','SF_SFCYSSWR','SF_HKSFTF0','SF_SFTKZDSP','SF_SFDYQD','SF_GHSSFSBLDGGH','SF_SFCFFP','SF_DYQBFP','SF_SFPDYB_CF0000','SF_ZY_SFZDXS','ZY_YJJPJ0','SF_SFSYYBYKT','SF_XJJSSFDYZHYE','SF_SFSYYGKJ','SF_KFSFKQ','SF_YBSFYXQF','ZY_YBFPBH','SF_CKBRSYGHD','IC_SFDM','SF_SFTSWF','SF_YBSFAGHDJS','SF_SFYDDYJ','SFYBZHYE','SF_MZYJJXZ','SF_SFDYTSJKD','SF_MZJSTSNY','SF_SFZDTJYJD','SF_TYJJDYYE','SF_SFDYZLD','SF_SFSYJZSX','SF_EJBBSFCF','SF_EJBBCFLS','SF_EJBBCFHS','SF_FPLEFT','SF_FPTOP','SF_TKAZFFS','SF_JSATSBZ','SF_MZJKCZKZ','XT_JKTQSJ','SF_YJJGHZXJ','SF_SFCKJDDW','SF_DKZDDW','SF_ZY_FFJJ','SF_LSCFHJBRYF','SF_LSCFSFNFSRBRXM','SF_SFXMCGSXSFCF','SF_BRJKSFYXXDZ','SF_FYYFNFAZEYF','SF_YBFYDJSFLJJS','SF_YJJDSFDYPJH','SF_FYDJYSSFWK','SF_MZFPSFDYYBGRZHYE','SF_DEFAULT_HKSQKF','SF_YBBRJSSFTSDTJSFY','SF_YJJFXJZFZDXE','SF_YSXDHGHKSSFYXXG','SF_GHSYSXMSFYXWK','SF_BRNLSFXSDY','SF_SFYXXGBRBLH','SF_JZBRDTFPXZZS','SF_GHAXJYSXZLB','SF_SFQYCZPJKPJK','SF_KP_MZFPDYPLBH','SF_KP_FPZRDYMS','SF_KP_LJDLKPXTFS','XT_BRBYKFB','MZSF_FYBXJJZYXQC','SF_NNGHDTL','SF_RQDTOPLEFT','SF_RQDBOTTOMRIGHT','SF_YBJSSFYXQZHTK','SF_YBBNCZSSFZXJJZ','SF_SFYXTZZJE','SF_PRINTBLSYZDY','SF_PTBRSFAGHHJS','SF_YJJGHFYDJQDQYBZH','SF_GHFTC','SF_YJJTKQKYSPZSZ','SF_NLXDYSBSFXTLXR','SF_CKBRABLHJS','SF_FPDYGHRQ','SF_FYDJSSFBSYFYGH','SF_YJJDSFTD','SF_YJJTKDSFTD','SF_GYBRDTGHXDCS','SF_CGXESFYXQR','SF_LRSFXMSFABHPX','TJ_GRTJYXTS','SF_FZFPSFDYFYQZRQ','SF_PRINTYJJPJZDY','SF_PRINTYJJPJTKZDY','SF_FZFPDYPJXHLX','SF_HKSFKXZSQKF','XT_TJGHLB','SF_KP_CXZRSFZFYFP','SF_PRINTTJDWPJZDY','YS_SFYXPTBRTQGH','SF_MZFPSFXSFYBF','SF_XMFPSFXSYJJZE','SF_QSJDYJJZELB','SF_XMFPQDSFXSZLXM','MZ_FPGS00','SF_SFXMYBJK','IC_SFDM','SF_KP_ICKFSFDDLC','SF_SFCGHYSTHSQBZ','SF_XMYBFYDJSFKXZHLX','SF_GYZHPDBZ','SF_FPDYXS') 106 10:30:23 SQL Prepare: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 107 10:30:23 SQL Execute: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 108 10:30:23 SQL Prepare: ORACLE - select * from bm_yysfxm where sfxmid=8000000218 109 10:30:23 SQL Execute: ORACLE - select * from bm_yysfxm where sfxmid=8000000218 110 10:30:23 SQL Prepare: ORACLE - select * from xt_yyxx00 where rownum=1 111 10:30:23 SQL Execute: ORACLE - select * from xt_yyxx00 where rownum=1 112 10:30:23 SQL Prepare: ORACLE - select name00,bz0000 from xt_xtcs00 WHERE name00 in ('SF_XZXGTBLBCS','SF_FYQDBZXXNR') 113 10:30:23 SQL Execute: ORACLE - select name00,bz0000 from xt_xtcs00 WHERE name00 in ('SF_XZXGTBLBCS','SF_FYQDBZXXNR') 114 10:30:23 SQL Prepare: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('SF_YCZYBKDYBFZX','SF_SFQYPYYBJK','SF_PYYBSFSFJYYBDY','SF_XEXMHZMXBZDY','SF_GFBRXJJSSFKXFB','SF_GFBRXJJSSFKXGZFBL','SF_GFBRSFKAZFGH','SF_HFLJCYBJSDZDY','SF_FYQDBZXXNR','SF_GHSFZNCLBYYS','SF_MZPBGLSFZNCLBYYS','SF_MZHBGLSFZNCLBYYS','SF_SRYSSFXSBYYS','SF_FYDJXZCFD','SF_XZXGTBLBCS','SF_SFXYBFSJMJE','YJ_XMZJYSWSSKS','SF_FPJHJZYHKPTSFXS','SF_JMYBYFCS','SF_JMYBSCJG','SF_JMYBSCJEXZ','SF_JMYBMNJEXZ','SF_JMYBMYYSCCSXZ','SF_JMYBCXESFSF','SF_JMYBNFCS','SF_MZBRJKYJJW0','SF_FPSFXSDYRQ','SF_SFYJSGNZDQY','SF_MZBRZHWHTKMM','SF_BRZFFSXS','SF_MZRSRBBSFXSJZKYJ','SF_SFDYGEDZBB','SF_SFQYGTYBJK','SF_GTYBSFSFJYYBDY','SF_GTYBBRTKSFDYJK','SF_MZJSSFXSBFSYB','SF_BRCFQDSFXSTXM','SF_YJKTKZYXTSTK','SF_YJJCLCESFAZFJS','SF_ZCNHBRFYSFCSGYB','SF_SFQYPYJMYBJK','SF_PYJMYBSFSFJYYBDY','SF_TYDWBRSFJYJJJK','TJ_ZEJMXMID','SF_TJFYDZHSFKYTK','SF_TJPJDYSFTSXS','SF_ICKSFCYJS','SF_LEDDISPJK','SF_ZFJSSFYXQZHTK','SF_MZFPPDSFXYBR','SF_YBTKSFSYYGH','SF_HKSFSH','SF_YJJTKJESFXSFS','SF_JKRQSFGBCXGJKRQ','SF_ZFBRXB','SF_BBTJSFJQZDS','SF_ZZSRSFNYXJTC','SF_JKDYFWSFYZTYZDZ','SF_JYJJSFTSJFCG','SF_MZBKMZFSFSQKF','SF_MZRQDSFXSJFJE','SF_MZQZTKMRWZ','SF_MZQDSFXSZFJE','SF_PJJHPJSFYZSFPQF','SF_PYMTJSDZDY','SF_JKDJNLSFBT','SF_SFCLYBJKDFS','SF_SFSYSFXMZMYHJM','SF_SFCLYBJKDFS_BC','SF_JKDSFSYFR3XS','SF_SFXMJKYL','SF_MZBRQXJSSFYDK','SF_SFYJKRBBASFYHZ','SF_BRGHDJDKYJJ','SF_YBJSRBBZJYS','SF_YJJ_ZYJTDZWKSFTS','SF_FPSFDYGWYJE','SF_YBBRTSBZSFXSYJXM','ZY_XNHCSLX','SF_TSBRFYDJXMWH','ZY_XNHFZXMC','SF_YJJPZXS','SF_SFQYXFP_GZ','SF_TSBRFYDJ','SF_MZYSGZLTJ_KS','SF_MZYSGZLTJ_YS','SF_SFQYDZQB','SF_DZQBTKFS','SF_XNHBRBXSYBZHJE','SF_DZQBJKXSYE','SF_YJJFPSFSYXGS','SF_MZFYGZTFCL','SF_ZGFBJLKKHXZ','SF_YJJYEQKBSTFK','SF_FYJSQZGNSFQY','YJ_XMAPSFAKSCX','YJ_XMYXTS','XT_ZYXTGBDW','YJ_XMAPDYZDYID','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XMCXZJTF','BQ_YJ_BQXMCXSQ','YJ_YXCXTS','YJ_YJCXD_ZDY','YS_SFTHHCCX','SF_YJCXDYMBID','SF_MZQDXJSFXSZDYH','SF_MZYJJJKSYBLH') 115 10:30:23 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('SF_YCZYBKDYBFZX','SF_SFQYPYYBJK','SF_PYYBSFSFJYYBDY','SF_XEXMHZMXBZDY','SF_GFBRXJJSSFKXFB','SF_GFBRXJJSSFKXGZFBL','SF_GFBRSFKAZFGH','SF_HFLJCYBJSDZDY','SF_FYQDBZXXNR','SF_GHSFZNCLBYYS','SF_MZPBGLSFZNCLBYYS','SF_MZHBGLSFZNCLBYYS','SF_SRYSSFXSBYYS','SF_FYDJXZCFD','SF_XZXGTBLBCS','SF_SFXYBFSJMJE','YJ_XMZJYSWSSKS','SF_FPJHJZYHKPTSFXS','SF_JMYBYFCS','SF_JMYBSCJG','SF_JMYBSCJEXZ','SF_JMYBMNJEXZ','SF_JMYBMYYSCCSXZ','SF_JMYBCXESFSF','SF_JMYBNFCS','SF_MZBRJKYJJW0','SF_FPSFXSDYRQ','SF_SFYJSGNZDQY','SF_MZBRZHWHTKMM','SF_BRZFFSXS','SF_MZRSRBBSFXSJZKYJ','SF_SFDYGEDZBB','SF_SFQYGTYBJK','SF_GTYBSFSFJYYBDY','SF_GTYBBRTKSFDYJK','SF_MZJSSFXSBFSYB','SF_BRCFQDSFXSTXM','SF_YJKTKZYXTSTK','SF_YJJCLCESFAZFJS','SF_ZCNHBRFYSFCSGYB','SF_SFQYPYJMYBJK','SF_PYJMYBSFSFJYYBDY','SF_TYDWBRSFJYJJJK','TJ_ZEJMXMID','SF_TJFYDZHSFKYTK','SF_TJPJDYSFTSXS','SF_ICKSFCYJS','SF_LEDDISPJK','SF_ZFJSSFYXQZHTK','SF_MZFPPDSFXYBR','SF_YBTKSFSYYGH','SF_HKSFSH','SF_YJJTKJESFXSFS','SF_JKRQSFGBCXGJKRQ','SF_ZFBRXB','SF_BBTJSFJQZDS','SF_ZZSRSFNYXJTC','SF_JKDYFWSFYZTYZDZ','SF_JYJJSFTSJFCG','SF_MZBKMZFSFSQKF','SF_MZRQDSFXSJFJE','SF_MZQZTKMRWZ','SF_MZQDSFXSZFJE','SF_PJJHPJSFYZSFPQF','SF_PYMTJSDZDY','SF_JKDJNLSFBT','SF_SFCLYBJKDFS','SF_SFSYSFXMZMYHJM','SF_SFCLYBJKDFS_BC','SF_JKDSFSYFR3XS','SF_SFXMJKYL','SF_MZBRQXJSSFYDK','SF_SFYJKRBBASFYHZ','SF_BRGHDJDKYJJ','SF_YBJSRBBZJYS','SF_YJJ_ZYJTDZWKSFTS','SF_FPSFDYGWYJE','SF_YBBRTSBZSFXSYJXM','ZY_XNHCSLX','SF_TSBRFYDJXMWH','ZY_XNHFZXMC','SF_YJJPZXS','SF_SFQYXFP_GZ','SF_TSBRFYDJ','SF_MZYSGZLTJ_KS','SF_MZYSGZLTJ_YS','SF_SFQYDZQB','SF_DZQBTKFS','SF_XNHBRBXSYBZHJE','SF_DZQBJKXSYE','SF_YJJFPSFSYXGS','SF_MZFYGZTFCL','SF_ZGFBJLKKHXZ','SF_YJJYEQKBSTFK','SF_FYJSQZGNSFQY','YJ_XMAPSFAKSCX','YJ_XMYXTS','XT_ZYXTGBDW','YJ_XMAPDYZDYID','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XMCXZJTF','BQ_YJ_BQXMCXSQ','YJ_YXCXTS','YJ_YJCXD_ZDY','YS_SFTHHCCX','SF_YJCXDYMBID','SF_MZQDXJSFXSZDYH','SF_MZYJJJKSYBLH') 116 10:30:23 SQL Prepare: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL13' 117 10:30:23 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL13' 118 10:30:26 SQL Prepare: ORACLE - select * from ic_ybbrlb 119 10:30:26 SQL Execute: ORACLE - select * from ic_ybbrlb 120 10:30:26 SQL Prepare: ORACLE - select MZSJID,MZSJ00 from BM_MZSJB0 where SFYX00='Y' 121 10:30:26 SQL Execute: ORACLE - select MZSJID,MZSJ00 from BM_MZSJB0 where SFYX00='Y' 122 10:30:27 SQL Prepare: ORACLE - select * from XT_YYXX00 where 1=1 123 10:30:27 SQL Execute: ORACLE - select * from XT_YYXX00 where 1=1 124 10:30:35 SQL Prepare: ORACLE - select SQ_BM_YYSFTJ_ID0000.nextval DJH000 from dual 125 10:30:35 SQL Execute: ORACLE - select SQ_BM_YYSFTJ_ID0000.nextval DJH000 from dual 126 10:30:35 SQL Prepare: ORACLE - Insert into BM_YYSFTJ(ID0000,BMBH00,SFXM02,SFXM99,SFXM03) select 678207,kdzxys,xmbh00,kdzxks,sum(hjje00) from (select brid00,kdys00 kdzxys,xmbh00,kdks00 kdzxks,sum(a.hjje00) hjje00 from sf_fymx00 a,sf_brfy00 b where a.djh000=b.djh000 and ( ( A.CZRQ00>='20110201' and A.CZRQ00<='20110228' and A.CZRQ00||A.CZSJ00 >='2011020100:00:00' and A.CZRQ00||A.CZSJ00 <= '2011022823:59:59') ) group by brid00,kdys00,xmbh00,kdks00) e, (select brid00 from bm_brxxb0 where (fbbh00,yblb00) in (select fbbh00,yblb00 from ic_ybbrlb where (ybmc00='所有病人' or '所有病人'='所有病人'))) f where e.brid00=f.brid00 group by kdzxys,xmbh00,kdzxks 127 10:30:35 SQL Execute: ORACLE - Insert into BM_YYSFTJ(ID0000,BMBH00,SFXM02,SFXM99,SFXM03) select 678207,kdzxys,xmbh00,kdzxks,sum(hjje00) from (select brid00,kdys00 kdzxys,xmbh00,kdks00 kdzxks,sum(a.hjje00) hjje00 from sf_fymx00 a,sf_brfy00 b where a.djh000=b.djh000 and ( ( A.CZRQ00>='20110201' and A.CZRQ00<='20110228' and A.CZRQ00||A.CZSJ00 >='2011020100:00:00' and A.CZRQ00||A.CZSJ00 <= '2011022823:59:59') ) group by brid00,kdys00,xmbh00,kdks00) e, (select brid00 from bm_brxxb0 where (fbbh00,yblb00) in (select fbbh00,yblb00 from ic_ybbrlb where (ybmc00='所有病人' or '所有病人'='所有病人'))) f where e.brid00=f.brid00 group by kdzxys,xmbh00,kdzxks 128 10:31:51 SQL Prepare: ORACLE - BEGIN "SP_SF_MZYS00_TJ0000" (AD_INID00 => :AD_INID00,AS_TJLB00 => :AS_TJLB00,AS_HSLB00 => :AS_HSLB00,AD_ID0000 => :AD_ID0000,AD_XSNR00 => :AD_XSNR00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 129 10:31:51 SQL Execute: ORACLE - BEGIN "SP_SF_MZYS00_TJ0000" (AD_INID00 => :AD_INID00,AS_TJLB00 => :AS_TJLB00,AS_HSLB00 => :AS_HSLB00,AD_ID0000 => :AD_ID0000,AD_XSNR00 => :AD_XSNR00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 130 10:32:05 SQL Prepare: ORACLE - update BM_YYSFTJ A set SFXM79=(SELECT count(*) from SF_BRXXB0 B,BM_BRXXB0 C where (B.THRQ00 is null) AND B.BRID00=C.BRID00 and B.JZYS00=A.BMBH00 AND B.ghks00=a.sfxm99 and (C.FBBH00,C.YBLB00) IN (SELECT FBBH00,YBLB00 FROM IC_YBBRLB WHERE (YBMC00='所有病人' OR '所有病人'='所有病人')) and ( B.GHRQ00>='20110201' and B.GHRQ00<= '20110228' ) and ( B.GHRQ00||B.GHSJ00 >='2011020100:00:00' and B.GHRQ00||B.GHSJ00 <= '2011022823:59:59' ) ) where A.ID0000 =678208 131 10:32:05 SQL Execute: ORACLE - update BM_YYSFTJ A set SFXM79=(SELECT count(*) from SF_BRXXB0 B,BM_BRXXB0 C where (B.THRQ00 is null) AND B.BRID00=C.BRID00 and B.JZYS00=A.BMBH00 AND B.ghks00=a.sfxm99 and (C.FBBH00,C.YBLB00) IN (SELECT FBBH00,YBLB00 FROM IC_YBBRLB WHERE (YBMC00='所有病人' OR '所有病人'='所有病人')) and ( B.GHRQ00>='20110201' and B.GHRQ00<= '20110228' ) and ( B.GHRQ00||B.GHSJ00 >='2011020100:00:00' and B.GHRQ00||B.GHSJ00 <= '2011022823:59:59' ) ) where A.ID0000 =678208 132 10:32:49 SQL Prepare: ORACLE - update BM_YYSFTJ A set SFXM79=(SELECT count(*) from SF_BRXXB0 B,BM_BRXXB0 C where (B.THRQ00 is null) AND B.BRID00=C.BRID00 and (C.FBBH00,C.YBLB00) IN (SELECT FBBH00,YBLB00 FROM IC_YBBRLB WHERE (YBMC00='所有病人' OR '所有病人'='所有病人')) and ( B.GHRQ00>='20110201' and B.GHRQ00<= '20110228' ) and ( B.GHRQ00||B.GHSJ00 >='2011020100:00:00' and B.GHRQ00||B.GHSJ00 <= '2011022823:59:59' ) ) where A.BMBH00=9999999999 AND A.ID0000 =678208 133 10:32:49 SQL Execute: ORACLE - update BM_YYSFTJ A set SFXM79=(SELECT count(*) from SF_BRXXB0 B,BM_BRXXB0 C where (B.THRQ00 is null) AND B.BRID00=C.BRID00 and (C.FBBH00,C.YBLB00) IN (SELECT FBBH00,YBLB00 FROM IC_YBBRLB WHERE (YBMC00='所有病人' OR '所有病人'='所有病人')) and ( B.GHRQ00>='20110201' and B.GHRQ00<= '20110228' ) and ( B.GHRQ00||B.GHSJ00 >='2011020100:00:00' and B.GHRQ00||B.GHSJ00 <= '2011022823:59:59' ) ) where A.BMBH00=9999999999 AND A.ID0000 =678208 134 10:32:51 SQL Prepare: ORACLE - select B.YGBH00,A.BMBH00,C.BMMC00,DECODE(A.BMBH00,9999999999,' 总 计',B.ZWXM00) ZWXM00,B.XKH000,A.XMHJ00,A.SFXM79,decode(SFXM79,0,0,A.XMHJ00/A.SFXM79) SFXM81,A.YPHJ00,(A.YPHJ00/nvl(DECODE(A.XMHJ00,0,1,A.XMHJ00),1)) YPBL00, A.SFXM01,A.SFXM02,A.SFXM03,A.SFXM04,A.SFXM05,A.SFXM06, A.SFXM07,A.SFXM08,A.SFXM09,A.SFXM10,A.SFXM11,A.SFXM12,A.SFXM13,A.SFXM14,A.SFXM15,A.SFXM16, A.SFXM17,A.SFXM18,A.SFXM19,A.SFXM20, A.SFXM21,A.SFXM22,A.SFXM23,A.SFXM24,A.SFXM25,A.SFXM26,A.SFXM27,A.SFXM28,A.SFXM29,A.SFXM30,A.SFXM31, A.SFXM32,A.SFXM33,A.SFXM34,A.SFXM35,A.SFXM36,A.SFXM37,A.SFXM38,A.SFXM39,A.SFXM40,A.SFXM41,A.SFXM42, A.SFXM43,A.SFXM44,A.SFXM45,A.SFXM46,A.SFXM47,A.SFXM48,A.SFXM49,A.SFXM50,A.SFXM51,A.SFXM52,A.SFXM53, A.SFXM54,A.SFXM55,A.SFXM56,A.SFXM57,A.SFXM58,A.SFXM59,A.SFXM60,A.SFXM61,A.SFXM62,A.SFXM63,A.SFXM64, A.SFXM65,A.SFXM66,A.SFXM67,A.SFXM68,A.SFXM69,A.SFXM70,A.SFXM71,A.SFXM72,A.SFXM73,A.SFXM74,A.SFXM75, A.SFXM76,A.SFXM77,A.SFXM78,A.SFXM80 from BM_YYSFTJ A,BM_YGBM00 B,BM_BMBM00 C where A.BMBH00 = B.YGBH00(+) and A.SFXM99 = C.BMBH00(+) and A.ID0000 =:1 order by C.PXXH00,C.BMBH00,B.ZWXM00 135 10:32:51 SQL Execute: ORACLE - select B.YGBH00,A.BMBH00,C.BMMC00,DECODE(A.BMBH00,9999999999,' 总 计',B.ZWXM00) ZWXM00,B.XKH000,A.XMHJ00,A.SFXM79,decode(SFXM79,0,0,A.XMHJ00/A.SFXM79) SFXM81,A.YPHJ00,(A.YPHJ00/nvl(DECODE(A.XMHJ00,0,1,A.XMHJ00),1)) YPBL00, A.SFXM01,A.SFXM02,A.SFXM03,A.SFXM04,A.SFXM05,A.SFXM06, A.SFXM07,A.SFXM08,A.SFXM09,A.SFXM10,A.SFXM11,A.SFXM12,A.SFXM13,A.SFXM14,A.SFXM15,A.SFXM16, A.SFXM17,A.SFXM18,A.SFXM19,A.SFXM20, A.SFXM21,A.SFXM22,A.SFXM23,A.SFXM24,A.SFXM25,A.SFXM26,A.SFXM27,A.SFXM28,A.SFXM29,A.SFXM30,A.SFXM31, A.SFXM32,A.SFXM33,A.SFXM34,A.SFXM35,A.SFXM36,A.SFXM37,A.SFXM38,A.SFXM39,A.SFXM40,A.SFXM41,A.SFXM42, A.SFXM43,A.SFXM44,A.SFXM45,A.SFXM46,A.SFXM47,A.SFXM48,A.SFXM49,A.SFXM50,A.SFXM51,A.SFXM52,A.SFXM53, A.SFXM54,A.SFXM55,A.SFXM56,A.SFXM57,A.SFXM58,A.SFXM59,A.SFXM60,A.SFXM61,A.SFXM62,A.SFXM63,A.SFXM64, A.SFXM65,A.SFXM66,A.SFXM67,A.SFXM68,A.SFXM69,A.SFXM70,A.SFXM71,A.SFXM72,A.SFXM73,A.SFXM74,A.SFXM75, A.SFXM76,A.SFXM77,A.SFXM78,A.SFXM80 from BM_YYSFTJ A,BM_YGBM00 B,BM_BMBM00 C where A.BMBH00 = B.YGBH00(+) and A.SFXM99 = C.BMBH00(+) and A.ID0000 =? order by C.PXXH00,C.BMBH00,B.ZWXM00 136 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='01' 137 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='01' 138 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='02' 139 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='02' 140 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='03' 141 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='03' 142 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='04' 143 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='04' 144 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='05' 145 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='05' 146 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='06' 147 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='06' 148 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='07' 149 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='07' 150 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='08' 151 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='08' 152 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='09' 153 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='09' 154 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='10' 155 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='10' 156 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='11' 157 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='11' 158 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='12' 159 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='12' 160 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='13' 161 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='13' 162 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='14' 163 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='14' 164 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='15' 165 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='15' 166 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='16' 167 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='16' 168 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='17' 169 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='17' 170 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='18' 171 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='18' 172 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='19' 173 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='19' 174 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='20' 175 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='20' 176 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='21' 177 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='21' 178 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='22' 179 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='22' 180 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='23' 181 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='23' 182 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='24' 183 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='24' 184 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='25' 185 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='25' 186 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='26' 187 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='26' 188 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='27' 189 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='27' 190 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='28' 191 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='28' 192 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='29' 193 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='29' 194 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='30' 195 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='30' 196 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='31' 197 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='31' 198 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='32' 199 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='32' 200 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='33' 201 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='33' 202 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='34' 203 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='34' 204 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='35' 205 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='35' 206 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='36' 207 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='36' 208 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='37' 209 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='37' 210 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='38' 211 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='38' 212 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='39' 213 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='39' 214 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='40' 215 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='40' 216 10:32:51 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='41' 217 10:32:51 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='41' 218 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='42' 219 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='42' 220 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='43' 221 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='43' 222 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='44' 223 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='44' 224 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='45' 225 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='45' 226 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='46' 227 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='46' 228 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='47' 229 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='47' 230 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='48' 231 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='48' 232 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='49' 233 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='49' 234 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='50' 235 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='50' 236 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='51' 237 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='51' 238 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='52' 239 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='52' 240 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='53' 241 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='53' 242 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='54' 243 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='54' 244 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='55' 245 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='55' 246 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='56' 247 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='56' 248 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='57' 249 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='57' 250 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='58' 251 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='58' 252 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='59' 253 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='59' 254 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='60' 255 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='60' 256 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='61' 257 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='61' 258 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='62' 259 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='62' 260 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='63' 261 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='63' 262 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='64' 263 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='64' 264 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='65' 265 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='65' 266 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='66' 267 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='66' 268 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='67' 269 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='67' 270 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='68' 271 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='68' 272 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='69' 273 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='69' 274 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='70' 275 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='70' 276 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='71' 277 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='71' 278 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='72' 279 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='72' 280 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='73' 281 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='73' 282 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='74' 283 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='74' 284 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='75' 285 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='75' 286 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='76' 287 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='76' 288 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='77' 289 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='77' 290 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='78' 291 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='78' 292 10:32:52 SQL Prepare: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='80' 293 10:32:52 SQL Execute: ORACLE - select XMMC00 from BM_FPXM00 where BH0000='80'