1 16:27:58 Log started for: 门诊挂号收费管理系统 2 16:27:58 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 16:27:58 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 4 16:27:58 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','4','PrjMZ_MZSF.exe'||'+'||'门诊挂号收费管理系统','160','11590' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@343:E9F8590D659E1AC146B4AE8A94C8F11A' from dual 5 16:27:58 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','4','PrjMZ_MZSF.exe'||'+'||'门诊挂号收费管理系统','160','11590' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@343:E9F8590D659E1AC146B4AE8A94C8F11A' from dual 6 16:27:58 SQL Data In: ORACLE - Rows affected = 1 7 16:27:58 SQL Prepare: ORACLE - Commit 8 16:27:58 SQL Execute: ORACLE - Commit 9 16:27:58 SQL Data In: ORACLE - Rows affected = 0 10 16:27:58 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 11 16:27:58 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 12 16:27:59 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 13 16:27:59 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 14 16:27:59 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 15 16:27:59 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 16 16:27:59 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 17 16:27:59 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 18 16:27:59 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','4','PrjMZ_MZSF.exe'||'+'||'门诊挂号收费管理系统','141','49234' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:22B92C467B2618E2A5E9AD7F90CF4AD6' from dual 19 16:27:59 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','4','PrjMZ_MZSF.exe'||'+'||'门诊挂号收费管理系统','141','49234' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:22B92C467B2618E2A5E9AD7F90CF4AD6' from dual 20 16:27:59 SQL Data In: ORACLE - Rows affected = 1 21 16:27:59 SQL Prepare: ORACLE - Commit 22 16:27:59 SQL Execute: ORACLE - Commit 23 16:27:59 SQL Data In: ORACLE - Rows affected = 0 24 16:27:59 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='4' 25 16:27:59 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='4' 26 16:27:59 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 27 16:27:59 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 28 16:27:59 SQL Prepare: ORACLE - Select SYSDATE from Dual 29 16:27:59 SQL Execute: ORACLE - Select SYSDATE from Dual 30 16:27:59 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 31 16:27:59 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 32 16:27:59 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 33 16:27:59 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 34 16:27:59 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='4' 35 16:27:59 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='4' 36 16:27:59 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 37 16:27:59 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 38 16:27:59 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 39 16:27:59 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 40 16:27:59 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)='343')) 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)='343')) order by b.PLXH00,a.BH0000 41 16:27:59 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)='343')) 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)='343')) order by b.PLXH00,a.BH0000 42 16:27:59 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '343'='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)='343')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 43 16:27:59 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '343'='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)='343')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 44 16:27:59 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143 45 16:27:59 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143 46 16:27:59 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 47 16:27:59 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 48 16:27:59 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 49 16:27:59 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 50 16:27:59 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 51 16:27:59 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 52 16:27:59 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 53 16:27:59 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 54 16:27:59 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')) 55 16:27:59 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')) 56 16:27:59 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4143638,1143,'wlzx-3','4',nvl('227877557',' '),'192.168.5.33#141:49234@PrjMZ_MZSF.exe+门诊挂号收费管理系统',44) 57 16:27:59 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4143638,1143,'wlzx-3','4',nvl('227877557',' '),'192.168.5.33#141:49234@PrjMZ_MZSF.exe+门诊挂号收费管理系统',44) 58 16:27:59 SQL Data In: ORACLE - Rows affected = 1 59 16:27:59 SQL Prepare: ORACLE - Commit 60 16:27:59 SQL Execute: ORACLE - Commit 61 16:27:59 SQL Data In: ORACLE - Rows affected = 0 62 16:27:59 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 44 63 16:27:59 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 44 64 16:27:59 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 65 16:27:59 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 66 16:27:59 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 67 16:27:59 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 68 16:27:59 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33' 69 16:27:59 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33' 70 16:27:59 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 71 16:27:59 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 72 16:27:59 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 44 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 73 16:27:59 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 44 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 74 16:27:59 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 75 16:27:59 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 76 16:27:59 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'4'||',')>0 77 16:27:59 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'4'||',')>0 78 16:28:01 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN' 79 16:28:01 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN' 80 16:28:01 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 81 16:28:01 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 82 16:28:01 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140606' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',44,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='4') 83 16:28:01 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140606' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',44,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='4') 84 16:28:01 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 85 16:28:01 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 86 16:28:01 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 87 16:28:01 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 88 16:28:01 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='4' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='4'))) 89 16:28:01 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='4' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='4'))) 90 16:28:01 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 91 16:28:01 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 92 16:28:01 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 ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 93 16:28:01 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 ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 94 16:28:01 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 95 16:28:01 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 96 16:28:01 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 97 16:28:01 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 98 16:28:01 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 99 16:28:01 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 100 16:28:04 SQL Prepare: ORACLE - Update SF_BRDB00 set SFYX00='N' where DBJSRQ < to_char(sysdate,'yyyymmdd') and SFYX00 = 'Y' 101 16:28:04 SQL Execute: ORACLE - Update SF_BRDB00 set SFYX00='N' where DBJSRQ < to_char(sysdate,'yyyymmdd') and SFYX00 = 'Y' 102 16:28:04 SQL Data In: ORACLE - Rows affected = 0 103 16:28:04 SQL Prepare: ORACLE - Commit 104 16:28:04 SQL Execute: ORACLE - Commit 105 16:28:04 SQL Data In: ORACLE - Rows affected = 0 106 16:28:04 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' 107 16:28:04 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' 108 16:28:04 SQL Prepare: ORACLE - select * from bm_brzffs where ZFFSMC = '现金' 109 16:28:04 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC = '现金' 110 16:28:04 SQL Prepare: ORACLE - select count(*) NUM from bm_brjflb where jflbid=0 or sybz00 = '0' or sybz00 = '1' 111 16:28:04 SQL Execute: ORACLE - select count(*) NUM from bm_brjflb where jflbid=0 or sybz00 = '0' or sybz00 = '1' 112 16:28:04 SQL Prepare: ORACLE - select sysdate nowtime from dual 113 16:28:04 SQL Execute: ORACLE - select sysdate nowtime from dual 114 16:28:04 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00 = 1143 115 16:28:04 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 1143 116 16:28:04 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','SF_PJGDZS') 117 16:28:04 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','SF_PJGDZS') 118 16:28:04 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_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','SF_SFDYMZBL','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_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','SF_YJJPJ0','SF_XMYBZLFID','SF_MZSFYSZJHM','SF_YBSFFSGHKSBM') 119 16:28:04 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_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','SF_SFDYMZBL','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_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','SF_YJJPJ0','SF_XMYBZLFID','SF_MZSFYSZJHM','SF_YBSFFSGHKSBM') 120 16:28:04 SQL Prepare: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 121 16:28:04 SQL Execute: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 122 16:28:04 SQL Prepare: ORACLE - select * from bm_yysfxm where sfxmid=8000000218 123 16:28:04 SQL Execute: ORACLE - select * from bm_yysfxm where sfxmid=8000000218 124 16:28:04 SQL Prepare: ORACLE - select name00,bz0000 from xt_xtcs00 WHERE name00 in ('SF_XZXGTBLBCS','SF_FYQDBZXXNR') 125 16:28:04 SQL Execute: ORACLE - select name00,bz0000 from xt_xtcs00 WHERE name00 in ('SF_XZXGTBLBCS','SF_FYQDBZXXNR') 126 16:28:04 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','SF_ZZJESFYXJTK','ZY_QDDYSFGJNRCDZDHH','SF_ZHWHQX','SF_JKRBBSFXSGHF','SF_SFMRDYFW','SF_SFQYPOSJK','SF_FYJSFPDYLX','SST_ZZJSFY','SF_YBBRCYJSSFBCWJ') 127 16:28:04 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','SF_ZZJESFYXJTK','ZY_QDDYSFGJNRCDZDHH','SF_ZHWHQX','SF_JKRBBSFXSGHF','SF_SFMRDYFW','SF_SFQYPOSJK','SF_FYJSFPDYLX','SST_ZZJSFY','SF_YBBRCYJSSFBCWJ') 128 16:28:04 SQL Prepare: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL30' order by YBYLZD 129 16:28:04 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL30' order by YBYLZD 130 16:28:04 SQL Prepare: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBSM01' and YBYLZD<='YBSM08' order by YBYLZD 131 16:28:04 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBSM01' and YBYLZD<='YBSM08' order by YBYLZD 132 16:28:04 SQL Prepare: ORACLE - select VALUE0,BZ0000,to_date(substrb(VALUE0,1,8),'YYYYMMDD') SQRQ00,sysdate DTRQ00 from XT_XTCS00 where name00='SF_XNHFK' 133 16:28:04 SQL Execute: ORACLE - select VALUE0,BZ0000,to_date(substrb(VALUE0,1,8),'YYYYMMDD') SQRQ00,sysdate DTRQ00 from XT_XTCS00 where name00='SF_XNHFK' 134 16:28:11 SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000' 135 16:28:11 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000' 136 16:28:11 SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000' 137 16:28:11 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000' 138 16:28:11 SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000' 139 16:28:11 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000' 140 16:28:11 SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000' 141 16:28:11 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000' 142 16:28:11 SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000' 143 16:28:11 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000' 144 16:28:11 SQL Prepare: ORACLE - select YYID00,YYJC00 from XT_YYXX00 145 16:28:11 SQL Execute: ORACLE - select YYID00,YYJC00 from XT_YYXX00 146 16:28:11 SQL Prepare: ORACLE - select * from ic_ybbrlb where yblb00 <> '0' 147 16:28:11 SQL Execute: ORACLE - select * from ic_ybbrlb where yblb00 <> '0' 148 16:28:11 SQL Prepare: ORACLE - select YYID00 from xt_yyxx00 where rownum=1 149 16:28:11 SQL Execute: ORACLE - select YYID00 from xt_yyxx00 where rownum=1 150 16:28:34 SQL Prepare: ORACLE - BEGIN "SP_SF_MZSRYB_RBB000" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_CZYXM0 => :AS_CZYXM0,AS_YBZXMC => :AS_YBZXMC,AS_TJBZ00 => :AS_TJBZ00,AD_ID0000 => :AD_ID0000,AS_SFRQYS => :AS_SFRQYS,as_BRYBZX => :as_BRYBZX,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_YYID00 => :as_YYID00,as_TJFS00 => :as_TJFS00); END; 151 16:28:34 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140501 152 16:28:34 SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140502 153 16:28:34 SQL Data In: ORACLE - Param = 3, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 154 16:28:34 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59 155 16:28:34 SQL Data In: ORACLE - Param = 5, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 156 16:28:34 SQL Data In: ORACLE - Param = 6, Name = AS_YBZXMC, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 157 16:28:34 SQL Data In: ORACLE - Param = 7, Name = AS_TJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 158 16:28:34 SQL Data In: ORACLE - Param = 8, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 159 16:28:34 SQL Data In: ORACLE - Param = 9, Name = AS_SFRQYS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 160 16:28:34 SQL Data In: ORACLE - Param = 10, Name = as_BRYBZX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 161 16:28:34 SQL Data In: ORACLE - Param = 11, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 162 16:28:34 SQL Data In: ORACLE - Param = 12, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 163 16:28:34 SQL Data In: ORACLE - Param = 13, Name = as_YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 222137 164 16:28:34 SQL Data In: ORACLE - Param = 14, Name = as_TJFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 165 16:28:34 SQL Execute: ORACLE - BEGIN "SP_SF_MZSRYB_RBB000" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_CZYXM0 => :AS_CZYXM0,AS_YBZXMC => :AS_YBZXMC,AS_TJBZ00 => :AS_TJBZ00,AD_ID0000 => :AD_ID0000,AS_SFRQYS => :AS_SFRQYS,as_BRYBZX => :as_BRYBZX,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_YYID00 => :as_YYID00,as_TJFS00 => :as_TJFS00); END; 166 16:28:37 SQL Prepare: ORACLE - select C.ZWXM00,A.GHRQ00,A.BEIZHU FZXMC0,sum(A.GHKS03) GHKS03,sum(A.GHKS04) GHKS04,sum(A.GHKS05) GHKS05,sum(A.GHKS06) GHKS06,sum(A.GHKS07) GHKS07,sum(A.GHKS08) GHKS08,sum(GHKS09) GHKS09,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0))) XMHJ00,nvl(sum(GHKS10),0) GHKS10, NVL((sum(XMHJ00)-nvl(sum(GHKS10),0)),0) GHKS11,sum(A.GHKS12) GHKS12,sum(A.GHKS13) GHKS13,sum(A.GHKS14) GHKS14,sum(A.GHKS15) GHKS15,sum(A.GHKS16) GHKS16 ,sum(A.GHKS51) GHKS51,sum(A.GHKS52) GHKS52 from BM_GHKSTJ A ,BM_YGBM00 C where A.GHKS02 = C.YGBH00(+) and ID0000=:1 and A.XMHJ00<>0 group by A.GHRQ00,C.ZWXM00,A.BEIZHU order by A.GHRQ00 167 16:28:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1735968.000000 168 16:28:37 SQL Execute: ORACLE - select C.ZWXM00,A.GHRQ00,A.BEIZHU FZXMC0,sum(A.GHKS03) GHKS03,sum(A.GHKS04) GHKS04,sum(A.GHKS05) GHKS05,sum(A.GHKS06) GHKS06,sum(A.GHKS07) GHKS07,sum(A.GHKS08) GHKS08,sum(GHKS09) GHKS09,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0))) XMHJ00,nvl(sum(GHKS10),0) GHKS10, NVL((sum(XMHJ00)-nvl(sum(GHKS10),0)),0) GHKS11,sum(A.GHKS12) GHKS12,sum(A.GHKS13) GHKS13,sum(A.GHKS14) GHKS14,sum(A.GHKS15) GHKS15,sum(A.GHKS16) GHKS16 ,sum(A.GHKS51) GHKS51,sum(A.GHKS52) GHKS52 from BM_GHKSTJ A ,BM_YGBM00 C where A.GHKS02 = C.YGBH00(+) and ID0000=? and A.XMHJ00<>0 group by A.GHRQ00,C.ZWXM00,A.BEIZHU order by A.GHRQ00 169 16:28:38 SQL Prepare: ORACLE - select A.GHRQ00,DECODE(trim(A.GHRQ00),'合计','',b.BRBLH0) BRBLH0,B.YBKH00,DECODE(trim(A.GHRQ00),'合计','',B.BRXM00) BRXM00 ,DECODE(trim(A.GHRQ00),'合计','',B.BRXB00) BRXB00,DECODE(trim(A.GHRQ00),'合计','',C.ZWXM00) ZWXM00,sum(A.GHKS03) GHKS03, sum(A.GHKS04)GHKS04,sum(A.GHKS05)GHKS05,sum(A.GHKS06)GHKS06,sum(A.GHKS07)GHKS07,sum(A.GHKS08)GHKS08,sum(A.GHKS09)GHKS09,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0))) XMHJ00,nvl(sum(GHKS10),0) GHKS10, NVL((sum(XMHJ00)-nvl(sum(GHKS10),0)),0) GHKS11,sum(A.GHKS12) GHKS12,sum(A.GHKS13) GHKS13,sum(A.GHKS14) GHKS14,sum(A.GHKS15) GHKS15 ,B.BRZTQK,B.TYDWMC,sum(GHKS16)GHKS16,sum(GHKS17)GHKS17,sum(GHKS18)GHKS18,sum(GHKS19)GHKS19,sum(GHKS20)GHKS20,sum(GHKS21)GHKS21,sum(GHKS22)GHKS22,sum(GHKS23)GHKS23,sum(GHKS24)GHKS24,sum(GHKS25)GHKS25,sum(GHKS26)GHKS26,sum(GHKS27)GHKS27,sum(GHKS28)GHKS28 ,sum(GHKS29)GHKS29,sum(GHKS30)GHKS30,sum(GHKS31)GHKS31,sum(GHKS32)GHKS32,sum(GHKS33)GHKS33,sum(GHKS34)GHKS34,sum(GHKS35)GHKS35,sum(GHKS36)GHKS36,sum(GHKS37)GHKS37 ,sum(A.GHKS51) GHKS51,sum(A.GHKS52) GHKS52 ,A.BEIZHU FZXMC0 ,' ' GHKS99 ,' ' BMMC00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,BM_BMBM00 D where A.GHKS01=B.BRID00(+) and A.GHKS02=C.YGBH00(+) and A.GHKS98=D.BMBH00(+) and ID0000=:1 group by A.GHRQ00,B.BRBLH0,B.YBKH00,B.BRXM00,B.BRXB00,C.ZWXM00,B.BRZTQK,B.TYDWMC,A.BEIZHU order by A.GHRQ00 170 16:28:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1735968.000000 171 16:28:38 SQL Execute: ORACLE - select A.GHRQ00,DECODE(trim(A.GHRQ00),'合计','',b.BRBLH0) BRBLH0,B.YBKH00,DECODE(trim(A.GHRQ00),'合计','',B.BRXM00) BRXM00 ,DECODE(trim(A.GHRQ00),'合计','',B.BRXB00) BRXB00,DECODE(trim(A.GHRQ00),'合计','',C.ZWXM00) ZWXM00,sum(A.GHKS03) GHKS03, sum(A.GHKS04)GHKS04,sum(A.GHKS05)GHKS05,sum(A.GHKS06)GHKS06,sum(A.GHKS07)GHKS07,sum(A.GHKS08)GHKS08,sum(A.GHKS09)GHKS09,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0))) XMHJ00,nvl(sum(GHKS10),0) GHKS10, NVL((sum(XMHJ00)-nvl(sum(GHKS10),0)),0) GHKS11,sum(A.GHKS12) GHKS12,sum(A.GHKS13) GHKS13,sum(A.GHKS14) GHKS14,sum(A.GHKS15) GHKS15 ,B.BRZTQK,B.TYDWMC,sum(GHKS16)GHKS16,sum(GHKS17)GHKS17,sum(GHKS18)GHKS18,sum(GHKS19)GHKS19,sum(GHKS20)GHKS20,sum(GHKS21)GHKS21,sum(GHKS22)GHKS22,sum(GHKS23)GHKS23,sum(GHKS24)GHKS24,sum(GHKS25)GHKS25,sum(GHKS26)GHKS26,sum(GHKS27)GHKS27,sum(GHKS28)GHKS28 ,sum(GHKS29)GHKS29,sum(GHKS30)GHKS30,sum(GHKS31)GHKS31,sum(GHKS32)GHKS32,sum(GHKS33)GHKS33,sum(GHKS34)GHKS34,sum(GHKS35)GHKS35,sum(GHKS36)GHKS36,sum(GHKS37)GHKS37 ,sum(A.GHKS51) GHKS51,sum(A.GHKS52) GHKS52 ,A.BEIZHU FZXMC0 ,' ' GHKS99 ,' ' BMMC00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,BM_BMBM00 D where A.GHKS01=B.BRID00(+) and A.GHKS02=C.YGBH00(+) and A.GHKS98=D.BMBH00(+) and ID0000=? group by A.GHRQ00,B.BRBLH0,B.YBKH00,B.BRXM00,B.BRXB00,C.ZWXM00,B.BRZTQK,B.TYDWMC,A.BEIZHU order by A.GHRQ00 172 16:28:38 SQL Prepare: ORACLE - select A.GHRQ00,sum(A.GHKS03) GHKS03,sum(A.GHKS04) GHKS04,sum(A.GHKS05) GHKS05,sum(A.GHKS06) GHKS06,sum(A.GHKS07) GHKS07,sum(A.GHKS08) GHKS08,sum(GHKS09) GHKS09,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0))) XMHJ00,nvl(sum(GHKS10),0) GHKS10, NVL((sum(XMHJ00)-nvl(sum(GHKS10),0)),0) GHKS11,sum(A.GHKS12) GHKS12,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0)))-nvl(SUM(GHKS03),0) YBFY00,sum(A.GHKS13) GHKS13,sum(A.GHKS14) GHKS14,sum(A.GHKS15) GHKS15,sum(A.GHKS16) GHKS16 ,sum(A.GHKS51) GHKS51,sum(A.GHKS52) GHKS52 ,A.BEIZHU FZXMC0 from BM_GHKSTJ A,BM_YGBM00 C where A.GHKS02 = C.YGBH00(+) and ID0000=:1 group by A.GHRQ00,A.BEIZHU order by A.GHRQ00 173 16:28:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1735968.000000 174 16:28:38 SQL Execute: ORACLE - select A.GHRQ00,sum(A.GHKS03) GHKS03,sum(A.GHKS04) GHKS04,sum(A.GHKS05) GHKS05,sum(A.GHKS06) GHKS06,sum(A.GHKS07) GHKS07,sum(A.GHKS08) GHKS08,sum(GHKS09) GHKS09,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0))) XMHJ00,nvl(sum(GHKS10),0) GHKS10, NVL((sum(XMHJ00)-nvl(sum(GHKS10),0)),0) GHKS11,sum(A.GHKS12) GHKS12,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0)))-nvl(SUM(GHKS03),0) YBFY00,sum(A.GHKS13) GHKS13,sum(A.GHKS14) GHKS14,sum(A.GHKS15) GHKS15,sum(A.GHKS16) GHKS16 ,sum(A.GHKS51) GHKS51,sum(A.GHKS52) GHKS52 ,A.BEIZHU FZXMC0 from BM_GHKSTJ A,BM_YGBM00 C where A.GHKS02 = C.YGBH00(+) and ID0000=? group by A.GHRQ00,A.BEIZHU order by A.GHRQ00 175 16:28:38 SQL Prepare: ORACLE - select A.GHRQ00,DECODE(trim(A.GHRQ00),'合计','',b.BRBLH0) BRBLH0,B.YBKH00,DECODE(trim(A.GHRQ00),'合计','',B.BRXM00) BRXM00 ,DECODE(trim(A.GHRQ00),'合计','',B.BRXB00) BRXB00,sum(A.GHKS03) GHKS03, sum(A.GHKS04) GHKS04,sum(A.GHKS05) GHKS05,sum(A.GHKS06) GHKS06,sum(A.GHKS07) GHKS07,sum(A.GHKS08) GHKS08,sum(A.GHKS09) GHKS09,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0))) XMHJ00,nvl(sum(GHKS10),0) GHKS10, NVL((sum(XMHJ00)-nvl(sum(GHKS10),0)),0) GHKS11,sum(A.GHKS12) GHKS12,sum(A.GHKS13) GHKS13,sum(A.GHKS14) GHKS14,sum(A.GHKS15) GHKS15 ,sum(A.GHKS16) GHKS16,sum(A.GHKS17) GHKS17,sum(A.GHKS18) GHKS18,sum(A.GHKS19) GHKS19,sum(A.GHKS20) GHKS20,sum(A.GHKS21) GHKS21,sum(A.GHKS22) GHKS22,sum(A.GHKS23) GHKS23 ,sum(A.GHKS24) GHKS24,sum(A.GHKS25) GHKS25,sum(A.GHKS26) GHKS26,sum(A.GHKS27) GHKS27,sum(A.GHKS28) GHKS28,sum(A.GHKS29) GHKS29,sum(A.GHKS30) GHKS30,sum(A.GHKS31) GHKS31 ,sum(A.GHKS32) GHKS32,sum(A.GHKS33) GHKS33,sum(A.GHKS34) GHKS34,sum(A.GHKS35) GHKS35,sum(A.GHKS36) GHKS36,sum(A.GHKS37) GHKS37 ,sum(A.GHKS51) GHKS51,sum(A.GHKS52) GHKS52 ,A.BEIZHU FZXMC0 ,' ' BMMC00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,BM_BMBM00 D where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS98=D.BMBH00(+) and ID0000=:1 group by A.GHRQ00,B.BRBLH0,B.YBKH00,B.BRXM00,B.BRXB00,A.BEIZHU order by A.GHRQ00 176 16:28:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1735968.000000 177 16:28:38 SQL Execute: ORACLE - select A.GHRQ00,DECODE(trim(A.GHRQ00),'合计','',b.BRBLH0) BRBLH0,B.YBKH00,DECODE(trim(A.GHRQ00),'合计','',B.BRXM00) BRXM00 ,DECODE(trim(A.GHRQ00),'合计','',B.BRXB00) BRXB00,sum(A.GHKS03) GHKS03, sum(A.GHKS04) GHKS04,sum(A.GHKS05) GHKS05,sum(A.GHKS06) GHKS06,sum(A.GHKS07) GHKS07,sum(A.GHKS08) GHKS08,sum(A.GHKS09) GHKS09,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0))) XMHJ00,nvl(sum(GHKS10),0) GHKS10, NVL((sum(XMHJ00)-nvl(sum(GHKS10),0)),0) GHKS11,sum(A.GHKS12) GHKS12,sum(A.GHKS13) GHKS13,sum(A.GHKS14) GHKS14,sum(A.GHKS15) GHKS15 ,sum(A.GHKS16) GHKS16,sum(A.GHKS17) GHKS17,sum(A.GHKS18) GHKS18,sum(A.GHKS19) GHKS19,sum(A.GHKS20) GHKS20,sum(A.GHKS21) GHKS21,sum(A.GHKS22) GHKS22,sum(A.GHKS23) GHKS23 ,sum(A.GHKS24) GHKS24,sum(A.GHKS25) GHKS25,sum(A.GHKS26) GHKS26,sum(A.GHKS27) GHKS27,sum(A.GHKS28) GHKS28,sum(A.GHKS29) GHKS29,sum(A.GHKS30) GHKS30,sum(A.GHKS31) GHKS31 ,sum(A.GHKS32) GHKS32,sum(A.GHKS33) GHKS33,sum(A.GHKS34) GHKS34,sum(A.GHKS35) GHKS35,sum(A.GHKS36) GHKS36,sum(A.GHKS37) GHKS37 ,sum(A.GHKS51) GHKS51,sum(A.GHKS52) GHKS52 ,A.BEIZHU FZXMC0 ,' ' BMMC00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,BM_BMBM00 D where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS98=D.BMBH00(+) and ID0000=? group by A.GHRQ00,B.BRBLH0,B.YBKH00,B.BRXM00,B.BRXB00,A.BEIZHU order by A.GHRQ00 178 16:28:38 SQL Prepare: ORACLE - select C.YBMC00,sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GRZHZF) GRZHZF,SUM(A.TCJJZF) TCJJZF,SUM(A.SBGRZH) SBGRZH,SUM(A.SBTCJJ) SBTCJJ,SUM(A.GFJE00) GFJE00,SUM(A.SYBXZF) SYBXZF,SUM(A.BRZJE0) BRZJE0,SUM(A.SBZFE0) SBZFE0,SUM(A.BJZFE0) BJZFE0, sum(A.GWYBZ0) GWYBZ0 ,sum(a.YBYL11)GHKS51,sum(a.YBYL13)GHKS52 from SF_JZB000 A,IC_YBBRLB C,BM_YGBM00 E ,SF_BRXXB0 B,bm_ybbrlb F where A.YBLB00 = C.YBLB00 and A.FBBH00 = C.FBBH00 and C.YBLB00 <> '0' and a.fbbh00 = f.fbbh00 and a.ybbrlb = f.ybbrlb and c.ybzxlb = f.ybzxlb and A.JZRQ00 >= :1 and A.JZRQ00 <= :2 and A.JZRQ00||A.JZSJ00 >= :3 and A.JZRQ00||A.JZSJ00 <= :4 and A.JZY000 = E.YGBH00 and A.MZID00=B.GHID00 and B.BXLB00 IN ('生育','工伤') AND A.CZYKS0 in (select d.bmbh00 from BM_BMBM00 D where d.yyid00=:5) GROUP BY C.YBMC00 union all select '合计',sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GRZHZF) GRZHZF,SUM(A.TCJJZF) TCJJZF,SUM(A.SBGRZH) SBGRZH,SUM(A.SBTCJJ) SBTCJJ,SUM(A.GFJE00) GFJE00,SUM(A.SYBXZF) SYBXZF,SUM(A.BRZJE0) BRZJE0,SUM(A.SBZFE0) SBZFE0,SUM(A.BJZFE0) BJZFE0, SUM(A.GWYBZ0) GWYBZ0 ,sum(a.YBYL11)GHKS51,sum(a.YBYL13)GHKS52 from SF_JZB000 A,IC_YBBRLB C,BM_YGBM00 E ,SF_BRXXB0 B,bm_ybbrlb F where A.YBLB00 = C.YBLB00 and A.FBBH00 = C.FBBH00 and C.YBLB00 <> '0' and a.fbbh00 = f.fbbh00 and a.ybbrlb = f.ybbrlb and c.ybzxlb = f.ybzxlb and A.JZRQ00 >= :6 and A.JZRQ00 <= :7 and A.JZRQ00||A.JZSJ00 >= :8 and A.JZRQ00||A.JZSJ00 <= :9 and A.JZY000 = E.YGBH00 and A.MZID00=B.GHID00 and B.BXLB00 IN ('生育','工伤') AND A.CZYKS0 in (select d.bmbh00 from BM_BMBM00 D where d.yyid00=:10) 179 16:28:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140501 180 16:28:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140502 181 16:28:38 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2014050100:00:00 182 16:28:38 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2014050223:59:59 183 16:28:38 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 222137 184 16:28:38 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140501 185 16:28:38 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140502 186 16:28:38 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2014050100:00:00 187 16:28:38 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2014050223:59:59 188 16:28:38 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 222137 189 16:28:38 SQL Execute: ORACLE - select C.YBMC00,sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GRZHZF) GRZHZF,SUM(A.TCJJZF) TCJJZF,SUM(A.SBGRZH) SBGRZH,SUM(A.SBTCJJ) SBTCJJ,SUM(A.GFJE00) GFJE00,SUM(A.SYBXZF) SYBXZF,SUM(A.BRZJE0) BRZJE0,SUM(A.SBZFE0) SBZFE0,SUM(A.BJZFE0) BJZFE0, sum(A.GWYBZ0) GWYBZ0 ,sum(a.YBYL11)GHKS51,sum(a.YBYL13)GHKS52 from SF_JZB000 A,IC_YBBRLB C,BM_YGBM00 E ,SF_BRXXB0 B,bm_ybbrlb F where A.YBLB00 = C.YBLB00 and A.FBBH00 = C.FBBH00 and C.YBLB00 <> '0' and a.fbbh00 = f.fbbh00 and a.ybbrlb = f.ybbrlb and c.ybzxlb = f.ybzxlb and A.JZRQ00 >= ? and A.JZRQ00 <= ? and A.JZRQ00||A.JZSJ00 >= ? and A.JZRQ00||A.JZSJ00 <= ? and A.JZY000 = E.YGBH00 and A.MZID00=B.GHID00 and B.BXLB00 IN ('生育','工伤') AND A.CZYKS0 in (select d.bmbh00 from BM_BMBM00 D where d.yyid00=?) GROUP BY C.YBMC00 union all select '合计',sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GRZHZF) GRZHZF,SUM(A.TCJJZF) TCJJZF,SUM(A.SBGRZH) SBGRZH,SUM(A.SBTCJJ) SBTCJJ,SUM(A.GFJE00) GFJE00,SUM(A.SYBXZF) SYBXZF,SUM(A.BRZJE0) BRZJE0,SUM(A.SBZFE0) SBZFE0,SUM(A.BJZFE0) BJZFE0, SUM(A.GWYBZ0) GWYBZ0 ,sum(a.YBYL11)GHKS51,sum(a.YBYL13)GHKS52 from SF_JZB000 A,IC_YBBRLB C,BM_YGBM00 E ,SF_BRXXB0 B,bm_ybbrlb F where A.YBLB00 = C.YBLB00 and A.FBBH00 = C.FBBH00 and C.YBLB00 <> '0' and a.fbbh00 = f.fbbh00 and a.ybbrlb = f.ybbrlb and c.ybzxlb = f.ybzxlb and A.JZRQ00 >= ? and A.JZRQ00 <= ? and A.JZRQ00||A.JZSJ00 >= ? and A.JZRQ00||A.JZSJ00 <= ? and A.JZY000 = E.YGBH00 and A.MZID00=B.GHID00 and B.BXLB00 IN ('生育','工伤') AND A.CZYKS0 in (select d.bmbh00 from BM_BMBM00 D where d.yyid00=?) 190 16:28:38 SQL Prepare: ORACLE - BEGIN "SP_SF_MZSRYB_JZBRMX" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_CZYXM0 => :AS_CZYXM0,AS_YBZXMC => :AS_YBZXMC,AS_TJBZ00 => :AS_TJBZ00,AD_ID0000 => :AD_ID0000,AS_SFRQYS => :AS_SFRQYS,as_BRYBZX => :as_BRYBZX,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_YYID00 => :as_YYID00,as_TJFS00 => :as_TJFS00); END; 191 16:28:38 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140501 192 16:28:38 SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140502 193 16:28:38 SQL Data In: ORACLE - Param = 3, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 194 16:28:38 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59 195 16:28:38 SQL Data In: ORACLE - Param = 5, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 196 16:28:38 SQL Data In: ORACLE - Param = 6, Name = AS_YBZXMC, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 197 16:28:38 SQL Data In: ORACLE - Param = 7, Name = AS_TJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 198 16:28:38 SQL Data In: ORACLE - Param = 8, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 199 16:28:38 SQL Data In: ORACLE - Param = 9, Name = AS_SFRQYS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 200 16:28:38 SQL Data In: ORACLE - Param = 10, Name = as_BRYBZX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 201 16:28:38 SQL Data In: ORACLE - Param = 11, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 202 16:28:38 SQL Data In: ORACLE - Param = 12, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 203 16:28:38 SQL Data In: ORACLE - Param = 13, Name = as_YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 222137 204 16:28:38 SQL Data In: ORACLE - Param = 14, Name = as_TJFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 205 16:28:38 SQL Execute: ORACLE - BEGIN "SP_SF_MZSRYB_JZBRMX" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_CZYXM0 => :AS_CZYXM0,AS_YBZXMC => :AS_YBZXMC,AS_TJBZ00 => :AS_TJBZ00,AD_ID0000 => :AD_ID0000,AS_SFRQYS => :AS_SFRQYS,as_BRYBZX => :as_BRYBZX,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_YYID00 => :as_YYID00,as_TJFS00 => :as_TJFS00); END; 206 16:28:47 SQL Prepare: ORACLE - select A.GHRQ00,A.BEIZHU FZXMC0, B.BRBLH0,B.YBKH00,A.GHKS99 JZDH00 ,B.BRID00,B.BRXM00, (select BB.MC0000 from XT_YBTSBZ AA,BM_TSBZB0 BB where AA.TSBZBH = BB.BH0000 and AA.BRID00=b.BRID00 AND AA.jzdh00=A.GHKS99 AND ROWNUM=1)TSBZMC, GHKS03,GHKS04,GHKS05,GHKS06,GHKS07,GHKS08,GHKS09,DECODE('Y','Y',A.XMHJ00,nvl(A.XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0)) XMHJ00,nvl(GHKS10,0) GHKS10, (NVL(XMHJ00,0)-nvl(GHKS10,0)) GHKS11,A.GHKS12,A.GHKS13,A.GHKS14,A.GHKS15,A.GHKS16 ,A.GHKS51,A.GHKS52 from BM_GHKSTJ A,bm_brxxb0 B ,IC_YBBRLB D where A.GHKS01 = B.BRID00(+) and B.YBLB00 = D.YBLB00 and B.FBBH00 = D.FBBH00 and ID0000=:1 and a.XMHJ00<>0 and a.DYID00=1 order by B.BRID00, A.GHRQ00 207 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1735969.000000 208 16:28:47 SQL Execute: ORACLE - select A.GHRQ00,A.BEIZHU FZXMC0, B.BRBLH0,B.YBKH00,A.GHKS99 JZDH00 ,B.BRID00,B.BRXM00, (select BB.MC0000 from XT_YBTSBZ AA,BM_TSBZB0 BB where AA.TSBZBH = BB.BH0000 and AA.BRID00=b.BRID00 AND AA.jzdh00=A.GHKS99 AND ROWNUM=1)TSBZMC, GHKS03,GHKS04,GHKS05,GHKS06,GHKS07,GHKS08,GHKS09,DECODE('Y','Y',A.XMHJ00,nvl(A.XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0)) XMHJ00,nvl(GHKS10,0) GHKS10, (NVL(XMHJ00,0)-nvl(GHKS10,0)) GHKS11,A.GHKS12,A.GHKS13,A.GHKS14,A.GHKS15,A.GHKS16 ,A.GHKS51,A.GHKS52 from BM_GHKSTJ A,bm_brxxb0 B ,IC_YBBRLB D where A.GHKS01 = B.BRID00(+) and B.YBLB00 = D.YBLB00 and B.FBBH00 = D.FBBH00 and ID0000=? and a.XMHJ00<>0 and a.DYID00=1 order by B.BRID00, A.GHRQ00 209 16:28:47 SQL Prepare: ORACLE - select count(distinct GHKS01) from BM_GHKSTJ where DYID00=1 and ID0000='1735969' 210 16:28:47 SQL Execute: ORACLE - select count(distinct GHKS01) from BM_GHKSTJ where DYID00=1 and ID0000='1735969' 211 16:28:47 SQL Prepare: ORACLE - select A.BEIZHU AS KSMC00,A.GHRQ00 AS YBMC00, A.GHKS54 AS GHRC00,A.XMHJ00 AS HJJE00,A.GHKS05 AS TCJJZF,A.GHKS04 AS YBZHZF, A.GHKS03 AS ZFJE00,A.GHKS15 AS GWYBZ0,A.GHKS07 AS SBTCZF,A.GHKS06 AS SBZHZF, A.GHKS12 AS SYBXZF,A.GHKS13 AS SBJJZF,A.GHKS14 AS BJJJZF,A.GHKS16 AS MZBZJE, A.GHKS08 AS JZJE00,A.GHKS09 AS JMJE00,A.GHKS51 AS JKZHZF,A.GHKS52 AS GJZHZF, A.GHKS53 AS YPF000,A.GHKS55 AS YPBL00,A.GHKS56 AS RJFY00 from BM_GHKSTJ A where ID0000=:1 and a.DYID00=2 order by A.GHKS98 212 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1735969.000000 213 16:28:47 SQL Execute: ORACLE - select A.BEIZHU AS KSMC00,A.GHRQ00 AS YBMC00, A.GHKS54 AS GHRC00,A.XMHJ00 AS HJJE00,A.GHKS05 AS TCJJZF,A.GHKS04 AS YBZHZF, A.GHKS03 AS ZFJE00,A.GHKS15 AS GWYBZ0,A.GHKS07 AS SBTCZF,A.GHKS06 AS SBZHZF, A.GHKS12 AS SYBXZF,A.GHKS13 AS SBJJZF,A.GHKS14 AS BJJJZF,A.GHKS16 AS MZBZJE, A.GHKS08 AS JZJE00,A.GHKS09 AS JMJE00,A.GHKS51 AS JKZHZF,A.GHKS52 AS GJZHZF, A.GHKS53 AS YPF000,A.GHKS55 AS YPBL00,A.GHKS56 AS RJFY00 from BM_GHKSTJ A where ID0000=? and a.DYID00=2 order by A.GHKS98 214 16:28:47 SQL Prepare: ORACLE - select A.GHRQ00,A.BEIZHU FZXMC0, B.BRBLH0,B.YBKH00,A.GHKS99 JZDH00 ,B.BRXM00, (select BB.MC0000 from XT_YBTSBZ AA,BM_TSBZB0 BB where AA.TSBZBH = BB.BH0000 and AA.BRID00=b.BRID00 AND AA.jzdh00=A.GHKS99 AND ROWNUM=1)TSBZMC, GHKS03,GHKS04,GHKS05,GHKS06,GHKS07,GHKS08,GHKS09,A.GHKS12,A.GHKS13,A.GHKS14,A.GHKS15,A.GHKS16,A.GHKS51,A.GHKS52, DECODE('Y','Y',A.XMHJ00,nvl(A.XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0)) XMHJ00, GHKS21,GHKS22,GHKS23,GHKS24,GHKS25,GHKS26,GHKS27,GHKS28,GHKS29, GHKS30,GHKS31,GHKS32,GHKS33,GHKS34,GHKS35,GHKS36,GHKS37,GHKS38,GHKS39, GHKS40,GHKS41,GHKS42,GHKS43,GHKS44,GHKS45,GHKS46,GHKS47,GHKS48,GHKS49 from BM_GHKSTJ A,bm_brxxb0 B ,IC_YBBRLB D where A.GHKS01 = B.BRID00(+) and B.YBLB00 = D.YBLB00 and B.FBBH00 = D.FBBH00 and ID0000=:1 and a.XMHJ00<>0 and a.DYID00=1 order by B.BRID00, A.GHRQ00 215 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1735969.000000 216 16:28:47 SQL Execute: ORACLE - select A.GHRQ00,A.BEIZHU FZXMC0, B.BRBLH0,B.YBKH00,A.GHKS99 JZDH00 ,B.BRXM00, (select BB.MC0000 from XT_YBTSBZ AA,BM_TSBZB0 BB where AA.TSBZBH = BB.BH0000 and AA.BRID00=b.BRID00 AND AA.jzdh00=A.GHKS99 AND ROWNUM=1)TSBZMC, GHKS03,GHKS04,GHKS05,GHKS06,GHKS07,GHKS08,GHKS09,A.GHKS12,A.GHKS13,A.GHKS14,A.GHKS15,A.GHKS16,A.GHKS51,A.GHKS52, DECODE('Y','Y',A.XMHJ00,nvl(A.XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0)) XMHJ00, GHKS21,GHKS22,GHKS23,GHKS24,GHKS25,GHKS26,GHKS27,GHKS28,GHKS29, GHKS30,GHKS31,GHKS32,GHKS33,GHKS34,GHKS35,GHKS36,GHKS37,GHKS38,GHKS39, GHKS40,GHKS41,GHKS42,GHKS43,GHKS44,GHKS45,GHKS46,GHKS47,GHKS48,GHKS49 from BM_GHKSTJ A,bm_brxxb0 B ,IC_YBBRLB D where A.GHKS01 = B.BRID00(+) and B.YBLB00 = D.YBLB00 and B.FBBH00 = D.FBBH00 and ID0000=? and a.XMHJ00<>0 and a.DYID00=1 order by B.BRID00, A.GHRQ00 217 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 218 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 219 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 220 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 221 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 222 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 223 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 224 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 225 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 226 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 227 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 228 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 229 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 230 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000 231 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 232 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 233 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6.000000 234 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 235 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 236 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7.000000 237 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 238 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 239 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000 240 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 241 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 242 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9.000000 243 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 244 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 245 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10.000000 246 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 247 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 248 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 11.000000 249 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 250 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 251 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 252 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 253 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 254 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 255 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 256 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 257 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 258 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 259 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 260 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15.000000 261 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 262 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 263 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 16.000000 264 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 265 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 266 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 17.000000 267 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 268 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 269 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 18.000000 270 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 271 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 272 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19.000000 273 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 274 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 275 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 20.000000 276 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 277 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 278 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21.000000 279 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 280 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 281 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000 282 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 283 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 284 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 23.000000 285 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 286 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 287 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000 288 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 289 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 290 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 25.000000 291 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 292 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 293 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 26.000000 294 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 295 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 296 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 27.000000 297 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 298 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 299 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 300 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 301 16:28:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where FPXMID =:1 302 16:28:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29.000000 303 16:28:47 SQL Execute: ORACLE - select * from BM_FPXM00 where FPXMID =? 304 16:29:31 SQL Prepare: ORACLE - select A.GHRQ00,sum(A.GHKS03) GHKS03,sum(A.GHKS04) GHKS04,sum(A.GHKS05) GHKS05,sum(A.GHKS06) GHKS06,sum(A.GHKS07) GHKS07,sum(A.GHKS08) GHKS08,sum(GHKS09) GHKS09,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0))) XMHJ00,nvl(sum(GHKS10),0) GHKS10, NVL((sum(XMHJ00)-nvl(sum(GHKS10),0)),0) GHKS11,sum(A.GHKS12) GHKS12,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0)))-nvl(SUM(GHKS03),0) YBFY00,sum(A.GHKS13) GHKS13,sum(A.GHKS14) GHKS14,sum(A.GHKS15) GHKS15,sum(A.GHKS16) GHKS16 ,sum(A.GHKS51) GHKS51,sum(A.GHKS52) GHKS52 ,A.BEIZHU FZXMC0 from BM_GHKSTJ A,BM_YGBM00 C where A.GHKS02 = C.YGBH00(+) and ID0000=:1 group by A.GHRQ00,A.BEIZHU ORDER BY YBFY00 305 16:29:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1735968.000000 306 16:29:31 SQL Execute: ORACLE - select A.GHRQ00,sum(A.GHKS03) GHKS03,sum(A.GHKS04) GHKS04,sum(A.GHKS05) GHKS05,sum(A.GHKS06) GHKS06,sum(A.GHKS07) GHKS07,sum(A.GHKS08) GHKS08,sum(GHKS09) GHKS09,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0))) XMHJ00,nvl(sum(GHKS10),0) GHKS10, NVL((sum(XMHJ00)-nvl(sum(GHKS10),0)),0) GHKS11,sum(A.GHKS12) GHKS12,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0)))-nvl(SUM(GHKS03),0) YBFY00,sum(A.GHKS13) GHKS13,sum(A.GHKS14) GHKS14,sum(A.GHKS15) GHKS15,sum(A.GHKS16) GHKS16 ,sum(A.GHKS51) GHKS51,sum(A.GHKS52) GHKS52 ,A.BEIZHU FZXMC0 from BM_GHKSTJ A,BM_YGBM00 C where A.GHKS02 = C.YGBH00(+) and ID0000=? group by A.GHRQ00,A.BEIZHU ORDER BY YBFY00