1 16:10:40 Log started for: 住院收费管理系统 2 16:10:40 SQL Prepare: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 16:10:40 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 4 16:10:40 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.252','5',trim(PROGRAM)||'+'||'住院收费管理系统',SID,serial# ,'20110401','16:10:43','scott@305:DA0EAE149D09996EA79567577DAFEB94' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 5 16:10:40 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.252','5',trim(PROGRAM)||'+'||'住院收费管理系统',SID,serial# ,'20110401','16:10:43','scott@305:DA0EAE149D09996EA79567577DAFEB94' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 6 16:10:40 SQL Prepare: ORACLE - Commit 7 16:10:40 SQL Execute: ORACLE - Commit 8 16:10:40 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 9 16:10:40 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 10 16:10:40 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 11 16:10:40 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 12 16:10:40 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='305' and CZBZ00 in ('1') 13 16:10:40 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='305' and CZBZ00 in ('1') 14 16:10:43 SQL Prepare: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 15 16:10:43 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 16 16:10:43 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.252','5',trim(PROGRAM)||'+'||'住院收费管理系统',SID,serial# ,'20110401','16:10:46','scott@3056:FF417340937A6530FE661B589629BF02' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 17 16:10:43 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.252','5',trim(PROGRAM)||'+'||'住院收费管理系统',SID,serial# ,'20110401','16:10:46','scott@3056:FF417340937A6530FE661B589629BF02' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 18 16:10:43 SQL Prepare: ORACLE - Commit 19 16:10:43 SQL Execute: ORACLE - Commit 20 16:10:43 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 21 16:10:43 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 22 16:10:43 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 23 16:10:43 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 24 16:10:43 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='3056' and CZBZ00 in ('1') 25 16:10:43 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='3056' and CZBZ00 in ('1') 26 16:10:43 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.252','5',trim(PROGRAM)||'+'||'住院收费管理系统',SID,serial# ,'20110401','16:10:46','sd_Hospital@3056:BE33A6A4115479221D7782FD79E5B0BC' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 27 16:10:43 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.252','5',trim(PROGRAM)||'+'||'住院收费管理系统',SID,serial# ,'20110401','16:10:46','sd_Hospital@3056:BE33A6A4115479221D7782FD79E5B0BC' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 28 16:10:43 SQL Prepare: ORACLE - Commit 29 16:10:43 SQL Execute: ORACLE - Commit 30 16:10:43 SQL Prepare: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 31 16:10:43 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 32 16:10:43 SQL Prepare: ORACLE - Commit 33 16:10:43 SQL Execute: ORACLE - Commit 34 16:10:43 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='5' 35 16:10:43 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='5' 36 16:10:43 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='3056' and CZBZ00 in ('1') 37 16:10:43 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='3056' and CZBZ00 in ('1') 38 16:10:43 SQL Prepare: ORACLE - Select SYSDATE from Dual 39 16:10:43 SQL Execute: ORACLE - Select SYSDATE from Dual 40 16:10:43 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 41 16:10:43 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 42 16:10:43 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 43 16:10:43 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 44 16:10:43 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='5' 45 16:10:43 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='5' 46 16:10:43 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 47 16:10:43 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 48 16:10:43 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 49 16:10:43 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 50 16:10:43 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 51 16:10:43 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 52 16:10:43 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3056')) 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='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3056')) order by b.PLXH00,a.BH0000 53 16:10:43 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3056')) 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='5' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3056')) order by b.PLXH00,a.BH0000 54 16:10:43 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '3056'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '5' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3056')) 55 16:10:43 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '3056'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '5' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3056')) 56 16:10:43 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=164 57 16:10:43 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=164 58 16:10:43 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 59 16:10:43 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 60 16:10:43 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 61 16:10:43 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 62 16:10:43 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 63 16:10:43 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 64 16:10:43 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 65 16:10:43 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 66 16:10:43 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')) 67 16:10:43 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')) 68 16:10:43 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2509871,164,'clyytest','5',nvl('3697448',' '),'192.168.9.252#753:2602@PrjZY_ZYSF.exe+住院收费管理系统',43) 69 16:10:43 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2509871,164,'clyytest','5',nvl('3697448',' '),'192.168.9.252#753:2602@PrjZY_ZYSF.exe+住院收费管理系统',43) 70 16:10:43 SQL Prepare: ORACLE - Commit 71 16:10:43 SQL Execute: ORACLE - Commit 72 16:10:43 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 43 73 16:10:43 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 43 74 16:10:43 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 75 16:10:43 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 76 16:10:43 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.252' 77 16:10:43 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.252' 78 16:10:43 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 79 16:10:43 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 80 16:10:43 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 43 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 81 16:10:43 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 43 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 82 16:10:43 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 83 16:10:43 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 84 16:10:43 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='164' and name00='SYSTEMSKIN' 85 16:10:43 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='164' and name00='SYSTEMSKIN' 86 16:10:43 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='5') and YXQ000>='20110401' 87 16:10:43 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='5') and YXQ000>='20110401' 88 16:10:43 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 89 16:10:43 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 90 16:10:43 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 91 16:10:43 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 92 16:10:43 SQL Prepare: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_ZY_ZY_BRFY00_INSERT','TR_ZY_ZY_BRJFB0_INSERT', 'TR_ZY_ZY_BRDB00_UPDATE','TR_ZY_ZY_PJSYQK_INSERT', 'TR_ZY_ZY_BRJFB0_UPDATE','TR_ZY_ZY_BRXXB0_INSERT','TR_ZY_ZY_PJSYQK_INSERT') and STATUS = 'ENABLED' 93 16:10:43 SQL Execute: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_ZY_ZY_BRFY00_INSERT','TR_ZY_ZY_BRJFB0_INSERT', 'TR_ZY_ZY_BRDB00_UPDATE','TR_ZY_ZY_PJSYQK_INSERT', 'TR_ZY_ZY_BRJFB0_UPDATE','TR_ZY_ZY_BRXXB0_INSERT','TR_ZY_ZY_PJSYQK_INSERT') and STATUS = 'ENABLED' 94 16:10:43 SQL Prepare: ORACLE - select sysdate nowtime from dual 95 16:10:43 SQL Execute: ORACLE - select sysdate nowtime from dual 96 16:10:43 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00 = 164 97 16:10:43 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 164 98 16:10:43 SQL Prepare: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_PJHSC0','ZY_MRNZYH','ZY_DYYBFP','XT_JEQZ00','SF_ZHTYJE','SF_ZHBJJE','ZY_YBJSTKD','ZY_SFYJS0_BZ0000','ZY_WJZBNCY','ZY_PRINTSCALE','ZY_XTDBQX','ZY_XTQFQX','ZY_QXCYQX','ZY_TKPAR0_CZY000','ZY_RQDZZ0_SETUP0','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_YTFSFYXCY','SF_SFSYJZK','ZY_TJKSSJ','ZY_TJJSSJ','SF_YBBRXB','ZY_FPWidth','ZY_FPHeigh','ZY_ZYSFJJBSJ','ZY_SYDJKYDBQF','ZY_PJLYXYLYQR','XT_QDXXZHYE','XT_QDXXZHYE_LX','ZY_JKDSFTD','ZY_JKSFAJJBSJ','ZY_ZYJKDGS0','ZY_YJJDJGS','ZY_YBRQDFS','IC_YBYYJKLM','ZY_RYDJSFFZ','ZY_YBBRZFXMFS','SF_ZY_SFZDXS','SF_SFCFFP','ZY_FPTOP','ZY_SFFSXM','ZY_YBFPBH','ZY_SFQZGSYB','ZY_RQDGSCS','YF_ZYFJF_YPNM00','YF_CFMXJE_CZFS','XT_XYCYTCF','ZY_JMXMFS','ZY_EJBBSFCF','ZY_EJBBCFLS','ZY_EJBBCFHS','ZY_CYBRQFMXBB_SFCF','ZY_CYBRQFMXBBLS','ZY_CYBRQFMXBBHS','YF_CFMXJE_SRWS','YF_CFZJE_CZFS','ZY_RQDFPXMSFDY','SF_GFBRJKBXSRDW','YF_CFZJE_SRWS_YB','YF_CFZJE_SRWS','XT_ZYXTSFSYZLK',+'YF_CFZJE_CZFS_YB','ZY_RQDMX0_ZFHB','ZY_ZYDJBLHPB','ZY_ZYHSFZDSC','XT_JKTQSJ','ZY_CXJSSFDYDJ','ZY_YBRYSFSYDT','ZY_DYQBFP','ZY_FPLEFT','ZY_SFDYZLD','XT_TFXYSHBZ','ZY_RYDJTCTS','ZY_YJJGS0_SFDYYE','YF_AutoMatch','ZY_SFHHXMMX','ZY_SFDYTKTZS','ZY_JSTKAYJJFS','ZY_JSSRTDXXTJBBSFCF','ZY_JSSRTDXXTJBBCFLS','ZY_JSSRTDXXTJBBCFHS','ZY_SFDYBASY','ZY_SFDYJZD','ZY_FBZHXTYZ','ZY_SFMHEYJKD','ZY_NPYBCYJSXSYBZHZF','ZYSF_TDXMTDKS_YXQF','ZY_CRYTJSFAKS','ZY_PJWLYBNSY','ZY_PRINTBASYZDY','ZY_SFQYCZPJKPJK','ZY_KP_LJDLKPXTFS','ZY_KP_ZYFPDYPLBH','ZY_KP_FPZRDYMS','ZY_ZYFPSFXSFYBF','ZY_QDDYGJBMXSFS','ZY_JSBBSFXSJCJE','ZY_YYBRSFYWFY','BQ_YBCYSFBXLRCYZD','ZY_YBCYJSHZDCSBASY','ZY_JZSRKSSRSFCF','ZY_JZSRKSSRSFZDZTJKD','ZY_YBJKSFJHZHDK','ZY_YBCXJZRQ','ZY_YBFSKSMCZDHZS','ZYSF_RYDJMS','ZYSF_RYDJMRBQ','ZYSF_RYDJMRKS','ZY_WSZBRSFKYXGRYXX') 99 16:10:43 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_PJHSC0','ZY_MRNZYH','ZY_DYYBFP','XT_JEQZ00','SF_ZHTYJE','SF_ZHBJJE','ZY_YBJSTKD','ZY_SFYJS0_BZ0000','ZY_WJZBNCY','ZY_PRINTSCALE','ZY_XTDBQX','ZY_XTQFQX','ZY_QXCYQX','ZY_TKPAR0_CZY000','ZY_RQDZZ0_SETUP0','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_YTFSFYXCY','SF_SFSYJZK','ZY_TJKSSJ','ZY_TJJSSJ','SF_YBBRXB','ZY_FPWidth','ZY_FPHeigh','ZY_ZYSFJJBSJ','ZY_SYDJKYDBQF','ZY_PJLYXYLYQR','XT_QDXXZHYE','XT_QDXXZHYE_LX','ZY_JKDSFTD','ZY_JKSFAJJBSJ','ZY_ZYJKDGS0','ZY_YJJDJGS','ZY_YBRQDFS','IC_YBYYJKLM','ZY_RYDJSFFZ','ZY_YBBRZFXMFS','SF_ZY_SFZDXS','SF_SFCFFP','ZY_FPTOP','ZY_SFFSXM','ZY_YBFPBH','ZY_SFQZGSYB','ZY_RQDGSCS','YF_ZYFJF_YPNM00','YF_CFMXJE_CZFS','XT_XYCYTCF','ZY_JMXMFS','ZY_EJBBSFCF','ZY_EJBBCFLS','ZY_EJBBCFHS','ZY_CYBRQFMXBB_SFCF','ZY_CYBRQFMXBBLS','ZY_CYBRQFMXBBHS','YF_CFMXJE_SRWS','YF_CFZJE_CZFS','ZY_RQDFPXMSFDY','SF_GFBRJKBXSRDW','YF_CFZJE_SRWS_YB','YF_CFZJE_SRWS','XT_ZYXTSFSYZLK',+'YF_CFZJE_CZFS_YB','ZY_RQDMX0_ZFHB','ZY_ZYDJBLHPB','ZY_ZYHSFZDSC','XT_JKTQSJ','ZY_CXJSSFDYDJ','ZY_YBRYSFSYDT','ZY_DYQBFP','ZY_FPLEFT','ZY_SFDYZLD','XT_TFXYSHBZ','ZY_RYDJTCTS','ZY_YJJGS0_SFDYYE','YF_AutoMatch','ZY_SFHHXMMX','ZY_SFDYTKTZS','ZY_JSTKAYJJFS','ZY_JSSRTDXXTJBBSFCF','ZY_JSSRTDXXTJBBCFLS','ZY_JSSRTDXXTJBBCFHS','ZY_SFDYBASY','ZY_SFDYJZD','ZY_FBZHXTYZ','ZY_SFMHEYJKD','ZY_NPYBCYJSXSYBZHZF','ZYSF_TDXMTDKS_YXQF','ZY_CRYTJSFAKS','ZY_PJWLYBNSY','ZY_PRINTBASYZDY','ZY_SFQYCZPJKPJK','ZY_KP_LJDLKPXTFS','ZY_KP_ZYFPDYPLBH','ZY_KP_FPZRDYMS','ZY_ZYFPSFXSFYBF','ZY_QDDYGJBMXSFS','ZY_JSBBSFXSJCJE','ZY_YYBRSFYWFY','BQ_YBCYSFBXLRCYZD','ZY_YBCYJSHZDCSBASY','ZY_JZSRKSSRSFCF','ZY_JZSRKSSRSFZDZTJKD','ZY_YBJKSFJHZHDK','ZY_YBCXJZRQ','ZY_YBFSKSMCZDHZS','ZYSF_RYDJMS','ZYSF_RYDJMRBQ','ZYSF_RYDJMRKS','ZY_WSZBRSFKYXGRYXX') 100 16:10:44 SQL Prepare: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 101 16:10:44 SQL Execute: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 102 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_SFYDDYJ' 103 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_SFYDDYJ' 104 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_LXBRSFKYYF' 105 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_LXBRSFKYYF' 106 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRQDHZSFTSDY' 107 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRQDHZSFTSDY' 108 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFPTCYHZRQDGS' 109 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFPTCYHZRQDGS' 110 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFABRFYDY' 111 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFABRFYDY' 112 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRNLSFXSDY' 113 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRNLSFXSDY' 114 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSJD' 115 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSJD' 116 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_KPYHDYFS' 117 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_KPYHDYFS' 118 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDBRPXFS' 119 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDBRPXFS' 120 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFMYDYYTYW' 121 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFMYDYYTYW' 122 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXS0XM' 123 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXS0XM' 124 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYKSZDYDY' 125 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYKSZDYDY' 126 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJZDY' 127 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJZDY' 128 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJTKZDY' 129 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJTKZDY' 130 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJDSFTD' 131 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJDSFTD' 132 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJTKDSFTD' 133 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJTKDSFTD' 134 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRCYJSSFXXCYSH' 135 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRCYJSSFXXCYSH' 136 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXSZFBL' 137 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXSZFBL' 138 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJFXJZFZDXE' 139 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJFXJZFZDXE' 140 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_JHFPSFTD' 141 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_JHFPSFTD' 142 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJJKZGXE' 143 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJJKZGXE' 144 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CXJSSFSPYCXJSFKCL' 145 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CXJSSFSPYCXJSFKCL' 146 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FZFPDYPJXHLX' 147 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FZFPDYPJXHLX' 148 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZDY_ZYBRWJSFYBB' 149 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZDY_ZYBRWJSFYBB' 150 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_SFQYHZYLJK' 151 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_SFQYHZYLJK' 152 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_DATAPATH' 153 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_DATAPATH' 154 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_HZYLBRFB' 155 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_HZYLBRFB' 156 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_CXZRSFZFYFP' 157 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_CXZRSFZFYFP' 158 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFTSDYZSFP' 159 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFTSDYZSFP' 160 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CYSFTSSRJBZD' 161 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CYSFTSSRJBZD' 162 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BASSMZXXSFSFCLR' 163 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BASSMZXXSFSFCLR' 164 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFSYFPXMZMYHJM' 165 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFSYFPXMZMYHJM' 166 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YYIDPDDLKS' 167 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YYIDPDDLKS' 168 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJDTOPLEFT' 169 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJDTOPLEFT' 170 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJTKDTOPLEFT' 171 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJTKDTOPLEFT' 172 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZZ0_FQYY' 173 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZZ0_FQYY' 174 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSXJ' 175 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSXJ' 176 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRDSFXSJMJE' 177 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRDSFXSJMJE' 178 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FPGE00' 179 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FPGE00' 180 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXQXRYDJ' 181 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXQXRYDJ' 182 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXLFYCY' 183 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXLFYCY' 184 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_MRNZYHFZSFYZ' 185 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_MRNZYHFZSFYZ' 186 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFCSSYFMBQBM' 187 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFCSSYFMBQBM' 188 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BDFPQDSFHBXTXM' 189 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BDFPQDSFHBXTXM' 190 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_NHSYBRSFAPTLBRY' 191 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_NHSYBRSFAPTLBRY' 192 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDZFBLSFYBBL' 193 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDZFBLSFYBBL' 194 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_LSCLSFXZ' 195 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_LSCLSFXZ' 196 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSYJSBZ' 197 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSYJSBZ' 198 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXMYBJK' 199 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXMYBJK' 200 16:10:44 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00='ZY_SBGSJZFYSPTS' 201 16:10:44 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00='ZY_SBGSJZFYSPTS' 202 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_GRZFSFBHSB' 203 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_GRZFSFBHSB' 204 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YLJGBH' 205 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YLJGBH' 206 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJSFPDTMBR' 207 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJSFPDTMBR' 208 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZFBLSFTXNJYY' 209 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZFBLSFTXNJYY' 210 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJZYYSSFYSR' 211 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJZYYSSFYSR' 212 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZFYJJSFXZDTZF' 213 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZFYJJSFXZDTZF' 214 16:10:44 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDSFDYZFJE' 215 16:10:44 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDSFDYZFJE' 216 16:10:44 SQL Prepare: ORACLE - select * from xt_yyxx00 where rownum=1 217 16:10:44 SQL Execute: ORACLE - select * from xt_yyxx00 where rownum=1 218 16:10:44 SQL Prepare: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL13' 219 16:10:44 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL13' 220 16:10:44 SQL Prepare: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('ZY_CSBSYBFPSFFKCL','ZY_PRINTYYFYMXZZDY','ZY_WCKSFYXCYJS','ZY_SFQYBASYCSJK','ZY_SFYJKTJ_SFCF','ZY_SFYJKTJLS','ZY_SFYJKTJHS','ZY_YXLFYZFBRCYJS','ZY_QDHZSHTSDY','ZY_ZYYSJZSRXSCYRS','ZY_NHBRSFCSJBZD','ZY_JKJHSFXSJKDH','ZY_ZYBRSFKYZHBRID','ZY_BASYNHBRSFCSICKH','ZY_FPRQDYSFXSDYRQ','ZY_XNHBRSFCSICKH','ZY_YJJYHKTCSFYXJTC','ZY_RYDJZDCSDBJE','ZY_YJJSKSFXSYLMXZ','ZY_SZCYBRSFKYRY','ZY_BRLDTJ_BQ_KS','ZY_YJJYEMXBTITLE','ZY_JKRQXSSFALNYYFS','ZY_NHBRSFFSCYDJRQ','ZY_NBBRXB','ZY_QDDYSFMRQTDYJ','ZY_YBJSRBBSFXSCZYB','ZY_ZFZYBXMTSSB','ZY_JKRQSFGBCXGJKRQ','ZY_ZFBRXB','ZY_BASY_LEFTPAGE','ZY_BASY_TOPPAGE','ZY_PJJHYJJSFXSCXLL','SF_MZFPPDSFXYBR','ZY_CYJSTKAYJJ','ZY_JKDYFWSFYZTYZDZ','ZY_FZFZYBSFXZ','ZY_FPTHBJXX','ZY_NHBRSFMRXM','ZY_FYGZJSSFTSJX','SF_SFSYSFXMZMYHJM','ZY_YBFBZHLBBTSFTS','ZY_YJJSKDJXSZLCK','ZY_SZCYBRTJDYFS','ZY_YJJCKDGS','ZY_ZYBRFBXGYB','ZY_FPSFDYGWYJE','ZY_XNHCSLX','ZY_JKDSFSYFR3XS','ZY_YBFSRYKSSFSYBQ','ZY_GFMZFYWJSSFYXRY','ZY_SFBKGFBR','ZY_BRCYJSTS','ZY_XNHFZXMC','ZY_ZYRQDHZJMJE','ZY_ZYBRXXWFSBASFBHXNH','ZY_XNHBRSFXSYBZHJE','ZY_HSFPJGS') 221 16:10:44 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('ZY_CSBSYBFPSFFKCL','ZY_PRINTYYFYMXZZDY','ZY_WCKSFYXCYJS','ZY_SFQYBASYCSJK','ZY_SFYJKTJ_SFCF','ZY_SFYJKTJLS','ZY_SFYJKTJHS','ZY_YXLFYZFBRCYJS','ZY_QDHZSHTSDY','ZY_ZYYSJZSRXSCYRS','ZY_NHBRSFCSJBZD','ZY_JKJHSFXSJKDH','ZY_ZYBRSFKYZHBRID','ZY_BASYNHBRSFCSICKH','ZY_FPRQDYSFXSDYRQ','ZY_XNHBRSFCSICKH','ZY_YJJYHKTCSFYXJTC','ZY_RYDJZDCSDBJE','ZY_YJJSKSFXSYLMXZ','ZY_SZCYBRSFKYRY','ZY_BRLDTJ_BQ_KS','ZY_YJJYEMXBTITLE','ZY_JKRQXSSFALNYYFS','ZY_NHBRSFFSCYDJRQ','ZY_NBBRXB','ZY_QDDYSFMRQTDYJ','ZY_YBJSRBBSFXSCZYB','ZY_ZFZYBXMTSSB','ZY_JKRQSFGBCXGJKRQ','ZY_ZFBRXB','ZY_BASY_LEFTPAGE','ZY_BASY_TOPPAGE','ZY_PJJHYJJSFXSCXLL','SF_MZFPPDSFXYBR','ZY_CYJSTKAYJJ','ZY_JKDYFWSFYZTYZDZ','ZY_FZFZYBSFXZ','ZY_FPTHBJXX','ZY_NHBRSFMRXM','ZY_FYGZJSSFTSJX','SF_SFSYSFXMZMYHJM','ZY_YBFBZHLBBTSFTS','ZY_YJJSKDJXSZLCK','ZY_SZCYBRTJDYFS','ZY_YJJCKDGS','ZY_ZYBRFBXGYB','ZY_FPSFDYGWYJE','ZY_XNHCSLX','ZY_JKDSFSYFR3XS','ZY_YBFSRYKSSFSYBQ','ZY_GFMZFYWJSSFYXRY','ZY_SFBKGFBR','ZY_BRCYJSTS','ZY_XNHFZXMC','ZY_ZYRQDHZJMJE','ZY_ZYBRXXWFSBASFBHXNH','ZY_XNHBRSFXSYBZHJE','ZY_HSFPJGS') 222 16:10:44 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='5' and (( 164= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='5' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=164)))) 223 16:10:44 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='5' and (( 164= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='5' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=164)))) 224 16:10:44 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '5$%' and A.XTDM00='5' and trim(A.MKDM00)='5$'||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 225 16:10:44 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '5$%' and A.XTDM00='5' and trim(A.MKDM00)='5$'||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 226 16:10:44 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 ((164= 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=164)))) 227 16:10:44 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 ((164= 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=164)))) 228 16:10:44 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 229 16:10:44 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 230 16:10:44 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 164= 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=164)))) 231 16:10:44 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 164= 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=164)))) 232 16:10:44 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 233 16:10:44 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 234 16:10:45 SQL Prepare: ORACLE - Update ZY_BRDB00 set SFYX00='N' where DBJSRQ||DBJSSJ <= to_char(sysdate,'yyyymmdd' )||to_char(sysdate,'HH24:MI:SS') and SFYX00 = 'Y' 235 16:10:45 SQL Execute: ORACLE - Update ZY_BRDB00 set SFYX00='N' where DBJSRQ||DBJSSJ <= to_char(sysdate,'yyyymmdd' )||to_char(sysdate,'HH24:MI:SS') and SFYX00 = 'Y' 236 16:10:45 SQL Prepare: ORACLE - Commit 237 16:10:45 SQL Execute: ORACLE - Commit 238 16:10:52 SQL Prepare: ORACLE - select * from ic_ybbrlb where yblb00 <> '0' 239 16:10:52 SQL Execute: ORACLE - select * from ic_ybbrlb where yblb00 <> '0' 240 16:10:52 SQL Prepare: ORACLE - select * from XT_YYXX00 where 1=1 241 16:10:52 SQL Execute: ORACLE - select * from XT_YYXX00 where 1=1 242 16:10:52 SQL Prepare: ORACLE - select YYID00 from xt_yyxx00 where rownum=1 243 16:10:52 SQL Execute: ORACLE - select YYID00 from xt_yyxx00 where rownum=1 244 16:11:00 SQL Prepare: ORACLE - select C.YBMC00,E.ZWXM00 CZYXM0,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00,sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00= K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' group by C.YBMC00,E.ZWXM00 245 16:11:00 SQL Execute: ORACLE - select C.YBMC00,E.ZWXM00 CZYXM0,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00,sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00= K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' group by C.YBMC00,E.ZWXM00 246 16:11:00 SQL Prepare: ORACLE - BEGIN "SP_ZY_YBBRJS_BB0000" (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_TJLB00 => :AS_TJLB00,AS_BQMC00 => :AS_BQMC00,AS_YYID00 => :AS_YYID00,AS_ZTJS00 => :AS_ZTJS00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 247 16:11:00 SQL Execute: ORACLE - BEGIN "SP_ZY_YBBRJS_BB0000" (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_TJLB00 => :AS_TJLB00,AS_BQMC00 => :AS_BQMC00,AS_YYID00 => :AS_YYID00,AS_ZTJS00 => :AS_ZTJS00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 248 16:11:10 SQL Prepare: ORACLE - select * from ( select substrb(SF_ZY_BRLXMC(GHKS18),1,20) BRLXMC,A.*,B.MRN000,B.YBKH00,B.BRXM00,B.BRXB00,C.ZWXM00,D.BMMC00,substr(SF_ZY_BRZYH0(GHKS18),1,20) YBZYH0,substrb(SF_ZY_BRJBMC(GHKS18),1,120)JBMC00,F.ZWXM00 JGYS00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,BM_YGBM00 F where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS10 = D.BMBH00(+) and a.ghks17=f.ygbh00(+) and C.YGBH00 <>0 and A.ID0000=:1 ) order by BMMC00,GHRQ00 249 16:11:10 SQL Execute: ORACLE - select * from ( select substrb(SF_ZY_BRLXMC(GHKS18),1,20) BRLXMC,A.*,B.MRN000,B.YBKH00,B.BRXM00,B.BRXB00,C.ZWXM00,D.BMMC00,substr(SF_ZY_BRZYH0(GHKS18),1,20) YBZYH0,substrb(SF_ZY_BRJBMC(GHKS18),1,120)JBMC00,F.ZWXM00 JGYS00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,BM_YGBM00 F where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS10 = D.BMBH00(+) and a.ghks17=f.ygbh00(+) and C.YGBH00 <>0 and A.ID0000=? ) order by BMMC00,GHRQ00 250 16:11:11 SQL Prepare: ORACLE - select D.BMMC00,A.GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1, NVL(GHKS04,0)+NVL(GHKS05,0),NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE, sum(GHKS08) JZJE00,sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS10 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 and B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =:1 group by D.BMMC00,A.GHRQ00 union all select ' 合计'BMMC00, NULL GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,NVL(GHKS04,0)+NVL(GHKS05,0), NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE,sum(GHKS08) JZJE00, sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS10 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 AND B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =:2 order by BMMC00 251 16:11:11 SQL Execute: ORACLE - select D.BMMC00,A.GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1, NVL(GHKS04,0)+NVL(GHKS05,0),NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE, sum(GHKS08) JZJE00,sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS10 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 and B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =? group by D.BMMC00,A.GHRQ00 union all select ' 合计'BMMC00, NULL GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,NVL(GHKS04,0)+NVL(GHKS05,0), NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE,sum(GHKS08) JZJE00, sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS10 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 AND B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =? order by BMMC00 252 16:11:11 SQL Prepare: ORACLE - select D.BMMC00,A.GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,NVL(GHKS04,0)+NVL(GHKS05,0), NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE, sum(GHKS08) JZJE00,sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS12 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 AND B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =:1 group by D.BMMC00,A.GHRQ00 union all select ' 合计'BMMC00, NULL GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,NVL(GHKS04,0)+NVL(GHKS05,0), NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE,sum(GHKS08) JZJE00, sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),'1',nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS12 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 AND B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =:2 order by BMMC00 253 16:11:11 SQL Execute: ORACLE - select D.BMMC00,A.GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,NVL(GHKS04,0)+NVL(GHKS05,0), NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE, sum(GHKS08) JZJE00,sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS12 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 AND B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =? group by D.BMMC00,A.GHRQ00 union all select ' 合计'BMMC00, NULL GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,NVL(GHKS04,0)+NVL(GHKS05,0), NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE,sum(GHKS08) JZJE00, sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),'1',nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS12 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 AND B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =? order by BMMC00 254 16:11:11 SQL Prepare: ORACLE - BEGIN "SP_ZY_YBBRJS_JSTJ00" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_BQMC00 => :AS_BQMC00,AS_YBMC00 => :AS_YBMC00,AS_JZR000 => :AS_JZR000,AS_YYID00 => :AS_YYID00,AS_ZTJS00 => :AS_ZTJS00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 255 16:11:11 SQL Execute: ORACLE - BEGIN "SP_ZY_YBBRJS_JSTJ00" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_BQMC00 => :AS_BQMC00,AS_YBMC00 => :AS_YBMC00,AS_JZR000 => :AS_JZR000,AS_YYID00 => :AS_YYID00,AS_ZTJS00 => :AS_ZTJS00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 256 16:11:27 SQL Prepare: ORACLE - select * from ( select G.BMMC00 BQMC00,H.BMMC00 KSMC00,E.YBMC00,D.MRN000,C.ZYH000,D.YBKH00,(select pjxh00 from zy_pjsyqk k where k.fzpjh0=b.pjh000 and pjzt00='0' and rownum=1) PJXH00 ,DECODE(C.RYLB00,'生育',D.BRXM00||'(生育)','工伤',D.BRXM00||'(工伤)',D.BRXM00) BRXM00, D.BRXB00,D.TYDWMC,C.RYRQ00,C.CYDJRQ,A.SFXM02 ZYTS00, (B.HJJE00/decode(nvl(A.SFXM02,1),0,1,nvl(A.SFXM02,1))) PJFY00 ,B.HJJE00,B.JZJE00, B.GFJE00,B.GRZHZF,B.TCJJZF,B.ZFJE00,B.SBGRZH,B.SBTCJJ,B.JJZFE0,B.SYBXZF,B.SBZFE0,B.BJZFE0,B.GWYBZ0,F.ZWXM00, A.ID0000,A.BMBH00,A.XMHJ00,A.YPHJ00,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.SFXM79,A.SFXM80,A.SFXM81,A.SFXM82,A.SFXM83,A.SFXM84,A.SFXM85,A.SFXM86, A.SFXM87,A.SFXM88,A.SFXM89,A.SFXM90,A.SFXM91,A.SFXM92,A.SFXM93,A.SFXM94,A.SFXM95,A.SFXM96, A.SFXM97,A.SFXM98,A.SFXM99,A.BMMC00,A.SJYSXM from BM_YYSFTJ A,ZY_JZB000 B,ZY_BRXXB0 C,BM_BRXXB0 D,IC_YBBRLB E,BM_YGBM00 F,BM_BMBM00 G,BM_BMBM00 H where A.BMBH00=B.JZDH00 AND B.ZYID00=C.ZYID00 AND C.BRID00=D.BRID00 AND B.YBLB00=E.YBLB00 and B.FBBH00=E.FBBH00 and B.JZY000=F.YGBH00 AND A.SFXM01=G.BMBH00 AND C.DQKS00=H.BMBH00 AND A.ID0000=:1 order by D.YBKH00 ) union all select '合 计','合计记录数:'||to_char(count(B.ZYID00)), '合计病人数:'||to_char(count(distinct B.ZYID00)),null,null,null,null,null,null,NULL,NULL,NULL,sum(nvl(A.SFXM02,0)),sum(B.HJJE00)/decode(sum(nvl(A.SFXM02,1)),0,1,sum(nvl(A.SFXM02,1))),sum(B.HJJE00),sum(B.JZJE00), sum(B.GFJE00),sum(B.GRZHZF),sum(B.TCJJZF),sum(B.ZFJE00),sum(B.SBGRZH),sum(B.SBTCJJ),sum(B.JJZFE0),sum(B.SYBXZF),SUM(B.SBZFE0),SUM(B.BJZFE0),SUM(B.GWYBZ0),NULL,0,0,0,0,0,0, sum(A.SFXM03),sum(A.SFXM04),sum(A.SFXM05),sum(A.SFXM06), sum(A.SFXM07),sum(A.SFXM08),sum(A.SFXM09),sum(A.SFXM10),sum(A.SFXM11),sum(A.SFXM12),sum(A.SFXM13),sum(A.SFXM14),sum(A.SFXM15),sum(A.SFXM16), sum(A.SFXM17),sum(A.SFXM18),sum(A.SFXM19),sum(A.SFXM20), sum(A.SFXM21),sum(A.SFXM22),sum(A.SFXM23),sum(A.SFXM24),sum(A.SFXM25),sum(A.SFXM26),sum(A.SFXM27),sum(A.SFXM28),sum(A.SFXM29),sum(A.SFXM30),sum(A.SFXM31), sum(A.SFXM32),sum(A.SFXM33),sum(A.SFXM34),sum(A.SFXM35),sum(A.SFXM36),sum(A.SFXM37),sum(A.SFXM38),sum(A.SFXM39),sum(A.SFXM40),sum(A.SFXM41),sum(A.SFXM42), sum(A.SFXM43),sum(A.SFXM44),sum(A.SFXM45),sum(A.SFXM46),sum(A.SFXM47),sum(A.SFXM48),sum(A.SFXM49),sum(A.SFXM50),sum(A.SFXM51),sum(A.SFXM52),sum(A.SFXM53), sum(A.SFXM54),sum(A.SFXM55),sum(A.SFXM56),sum(A.SFXM57),sum(A.SFXM58),sum(A.SFXM59),sum(A.SFXM60),sum(A.SFXM61),sum(A.SFXM62),sum(A.SFXM63),sum(A.SFXM64), sum(A.SFXM65),sum(A.SFXM66),sum(A.SFXM67),sum(A.SFXM68),sum(A.SFXM69),sum(A.SFXM70),sum(A.SFXM71),sum(A.SFXM72),sum(A.SFXM73),sum(A.SFXM74),sum(A.SFXM75), sum(A.SFXM76),sum(A.SFXM77),sum(A.SFXM78),sum(A.SFXM79),sum(A.SFXM80),SUM(A.SFXM81),SUM(A.SFXM82),SUM(A.SFXM83),SUM(A.SFXM84),SUM(A.SFXM85),SUM(A.SFXM86), sum(A.SFXM87),sum(A.SFXM88),sum(A.SFXM89),sum(A.SFXM90),sum(A.SFXM91),SUM(A.SFXM92),SUM(A.SFXM93),SUM(A.SFXM94),SUM(A.SFXM95),SUM(A.SFXM96),SUM(A.SFXM97),SUM(A.SFXM98),SUM(A.SFXM99),null,null from BM_YYSFTJ A,ZY_JZB000 B,ZY_BRXXB0 C,IC_YBBRLB E,BM_YGBM00 F,BM_BMBM00 G where A.BMBH00=B.JZDH00 AND B.ZYID00=C.ZYID00 AND B.YBLB00=E.YBLB00 and B.FBBH00=E.FBBH00 and B.JZY000=F.YGBH00 AND A.SFXM01=G.BMBH00 AND A.ID0000=:2 257 16:11:27 SQL Execute: ORACLE - select * from ( select G.BMMC00 BQMC00,H.BMMC00 KSMC00,E.YBMC00,D.MRN000,C.ZYH000,D.YBKH00,(select pjxh00 from zy_pjsyqk k where k.fzpjh0=b.pjh000 and pjzt00='0' and rownum=1) PJXH00 ,DECODE(C.RYLB00,'生育',D.BRXM00||'(生育)','工伤',D.BRXM00||'(工伤)',D.BRXM00) BRXM00, D.BRXB00,D.TYDWMC,C.RYRQ00,C.CYDJRQ,A.SFXM02 ZYTS00, (B.HJJE00/decode(nvl(A.SFXM02,1),0,1,nvl(A.SFXM02,1))) PJFY00 ,B.HJJE00,B.JZJE00, B.GFJE00,B.GRZHZF,B.TCJJZF,B.ZFJE00,B.SBGRZH,B.SBTCJJ,B.JJZFE0,B.SYBXZF,B.SBZFE0,B.BJZFE0,B.GWYBZ0,F.ZWXM00, A.ID0000,A.BMBH00,A.XMHJ00,A.YPHJ00,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.SFXM79,A.SFXM80,A.SFXM81,A.SFXM82,A.SFXM83,A.SFXM84,A.SFXM85,A.SFXM86, A.SFXM87,A.SFXM88,A.SFXM89,A.SFXM90,A.SFXM91,A.SFXM92,A.SFXM93,A.SFXM94,A.SFXM95,A.SFXM96, A.SFXM97,A.SFXM98,A.SFXM99,A.BMMC00,A.SJYSXM from BM_YYSFTJ A,ZY_JZB000 B,ZY_BRXXB0 C,BM_BRXXB0 D,IC_YBBRLB E,BM_YGBM00 F,BM_BMBM00 G,BM_BMBM00 H where A.BMBH00=B.JZDH00 AND B.ZYID00=C.ZYID00 AND C.BRID00=D.BRID00 AND B.YBLB00=E.YBLB00 and B.FBBH00=E.FBBH00 and B.JZY000=F.YGBH00 AND A.SFXM01=G.BMBH00 AND C.DQKS00=H.BMBH00 AND A.ID0000=? order by D.YBKH00 ) union all select '合 计','合计记录数:'||to_char(count(B.ZYID00)), '合计病人数:'||to_char(count(distinct B.ZYID00)),null,null,null,null,null,null,NULL,NULL,NULL,sum(nvl(A.SFXM02,0)),sum(B.HJJE00)/decode(sum(nvl(A.SFXM02,1)),0,1,sum(nvl(A.SFXM02,1))),sum(B.HJJE00),sum(B.JZJE00), sum(B.GFJE00),sum(B.GRZHZF),sum(B.TCJJZF),sum(B.ZFJE00),sum(B.SBGRZH),sum(B.SBTCJJ),sum(B.JJZFE0),sum(B.SYBXZF),SUM(B.SBZFE0),SUM(B.BJZFE0),SUM(B.GWYBZ0),NULL,0,0,0,0,0,0, sum(A.SFXM03),sum(A.SFXM04),sum(A.SFXM05),sum(A.SFXM06), sum(A.SFXM07),sum(A.SFXM08),sum(A.SFXM09),sum(A.SFXM10),sum(A.SFXM11),sum(A.SFXM12),sum(A.SFXM13),sum(A.SFXM14),sum(A.SFXM15),sum(A.SFXM16), sum(A.SFXM17),sum(A.SFXM18),sum(A.SFXM19),sum(A.SFXM20), sum(A.SFXM21),sum(A.SFXM22),sum(A.SFXM23),sum(A.SFXM24),sum(A.SFXM25),sum(A.SFXM26),sum(A.SFXM27),sum(A.SFXM28),sum(A.SFXM29),sum(A.SFXM30),sum(A.SFXM31), sum(A.SFXM32),sum(A.SFXM33),sum(A.SFXM34),sum(A.SFXM35),sum(A.SFXM36),sum(A.SFXM37),sum(A.SFXM38),sum(A.SFXM39),sum(A.SFXM40),sum(A.SFXM41),sum(A.SFXM42), sum(A.SFXM43),sum(A.SFXM44),sum(A.SFXM45),sum(A.SFXM46),sum(A.SFXM47),sum(A.SFXM48),sum(A.SFXM49),sum(A.SFXM50),sum(A.SFXM51),sum(A.SFXM52),sum(A.SFXM53), sum(A.SFXM54),sum(A.SFXM55),sum(A.SFXM56),sum(A.SFXM57),sum(A.SFXM58),sum(A.SFXM59),sum(A.SFXM60),sum(A.SFXM61),sum(A.SFXM62),sum(A.SFXM63),sum(A.SFXM64), sum(A.SFXM65),sum(A.SFXM66),sum(A.SFXM67),sum(A.SFXM68),sum(A.SFXM69),sum(A.SFXM70),sum(A.SFXM71),sum(A.SFXM72),sum(A.SFXM73),sum(A.SFXM74),sum(A.SFXM75), sum(A.SFXM76),sum(A.SFXM77),sum(A.SFXM78),sum(A.SFXM79),sum(A.SFXM80),SUM(A.SFXM81),SUM(A.SFXM82),SUM(A.SFXM83),SUM(A.SFXM84),SUM(A.SFXM85),SUM(A.SFXM86), sum(A.SFXM87),sum(A.SFXM88),sum(A.SFXM89),sum(A.SFXM90),sum(A.SFXM91),SUM(A.SFXM92),SUM(A.SFXM93),SUM(A.SFXM94),SUM(A.SFXM95),SUM(A.SFXM96),SUM(A.SFXM97),SUM(A.SFXM98),SUM(A.SFXM99),null,null from BM_YYSFTJ A,ZY_JZB000 B,ZY_BRXXB0 C,IC_YBBRLB E,BM_YGBM00 F,BM_BMBM00 G where A.BMBH00=B.JZDH00 AND B.ZYID00=C.ZYID00 AND B.YBLB00=E.YBLB00 and B.FBBH00=E.FBBH00 and B.JZY000=F.YGBH00 AND A.SFXM01=G.BMBH00 AND A.ID0000=? 258 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-19 259 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-19 260 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-18 261 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-18 262 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-17 263 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-17 264 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-16 265 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-16 266 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-15 267 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-15 268 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-14 269 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-14 270 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-13 271 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-13 272 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-12 273 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-12 274 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-11 275 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-11 276 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-10 277 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-10 278 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-9 279 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-9 280 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-8 281 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-8 282 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-7 283 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-7 284 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-6 285 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-6 286 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-5 287 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-5 288 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-4 289 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-4 290 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-3 291 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-3 292 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-2 293 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-2 294 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-1 295 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-1 296 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=0 297 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=0 298 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=1 299 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=1 300 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=2 301 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=2 302 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=3 303 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=3 304 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=4 305 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=4 306 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=5 307 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=5 308 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=6 309 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=6 310 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=7 311 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=7 312 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=8 313 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=8 314 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=9 315 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=9 316 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=10 317 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=10 318 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=11 319 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=11 320 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=12 321 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=12 322 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=13 323 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=13 324 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=14 325 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=14 326 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=15 327 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=15 328 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=16 329 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=16 330 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=17 331 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=17 332 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=18 333 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=18 334 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=19 335 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=19 336 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=20 337 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=20 338 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=21 339 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=21 340 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=22 341 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=22 342 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=23 343 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=23 344 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=24 345 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=24 346 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=25 347 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=25 348 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=26 349 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=26 350 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=27 351 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=27 352 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=28 353 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=28 354 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=29 355 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=29 356 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=30 357 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=30 358 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=31 359 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=31 360 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=32 361 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=32 362 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=33 363 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=33 364 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=34 365 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=34 366 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=35 367 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=35 368 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=36 369 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=36 370 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=37 371 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=37 372 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=38 373 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=38 374 16:11:27 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=39 375 16:11:27 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=39 376 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=40 377 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=40 378 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=41 379 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=41 380 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=42 381 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=42 382 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=43 383 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=43 384 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=44 385 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=44 386 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=45 387 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=45 388 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=46 389 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=46 390 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=47 391 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=47 392 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=48 393 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=48 394 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=49 395 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=49 396 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=50 397 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=50 398 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=51 399 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=51 400 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=52 401 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=52 402 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=53 403 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=53 404 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=54 405 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=54 406 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=55 407 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=55 408 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=56 409 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=56 410 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=57 411 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=57 412 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=58 413 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=58 414 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=59 415 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=59 416 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=60 417 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=60 418 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=61 419 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=61 420 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=62 421 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=62 422 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=63 423 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=63 424 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=64 425 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=64 426 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=65 427 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=65 428 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=66 429 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=66 430 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=67 431 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=67 432 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=68 433 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=68 434 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=69 435 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=69 436 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=70 437 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=70 438 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=71 439 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=71 440 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=72 441 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=72 442 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=73 443 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=73 444 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=74 445 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=74 446 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=75 447 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=75 448 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=76 449 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=76 450 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=77 451 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=77 452 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=78 453 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=78 454 16:11:28 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=79 455 16:11:28 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=79 456 16:11:28 SQL Prepare: ORACLE - select C.YBMC00,count(distinct F.ZYID00) RS0000,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00, sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(D.BRZJE0-D.ZFJE00) YBXJ00, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.YBBRLB<>'C' and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' group by C.YBMC00 having sum(D.BRZJE0)<>0 union all select '城镇医保',COUNT(*) RS0000,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00, sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(D.BRZJE0-D.ZFJE00) YBXJ00, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and D.FBBH00=3 and d.ybbrlb='C' and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' union all select '合计',COUNT(distinct f.zyid00) RS0000,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00, sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(D.BRZJE0-D.ZFJE00) YBXJ00, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' 457 16:11:28 SQL Execute: ORACLE - select C.YBMC00,count(distinct F.ZYID00) RS0000,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00, sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(D.BRZJE0-D.ZFJE00) YBXJ00, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.YBBRLB<>'C' and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' group by C.YBMC00 having sum(D.BRZJE0)<>0 union all select '城镇医保',COUNT(*) RS0000,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00, sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(D.BRZJE0-D.ZFJE00) YBXJ00, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and D.FBBH00=3 and d.ybbrlb='C' and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' union all select '合计',COUNT(distinct f.zyid00) RS0000,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00, sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(D.BRZJE0-D.ZFJE00) YBXJ00, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' 458 16:11:28 SQL Prepare: ORACLE - select C.YBMC00,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00,sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00, sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0, sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.RYLB00 IN ('生育','工伤') and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' group by C.YBMC00 459 16:11:28 SQL Execute: ORACLE - select C.YBMC00,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00,sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00, sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0, sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.RYLB00 IN ('生育','工伤') and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' group by C.YBMC00 460 16:12:30 SQL Prepare: ORACLE - select C.YBMC00,E.ZWXM00 CZYXM0,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00,sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00= K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' and C.YBMC00 = '长乐分中心' group by C.YBMC00,E.ZWXM00 461 16:12:30 SQL Execute: ORACLE - select C.YBMC00,E.ZWXM00 CZYXM0,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00,sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00= K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' and C.YBMC00 = '长乐分中心' group by C.YBMC00,E.ZWXM00 462 16:12:30 SQL Prepare: ORACLE - BEGIN "SP_ZY_YBBRJS_BB0000" (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_TJLB00 => :AS_TJLB00,AS_BQMC00 => :AS_BQMC00,AS_YYID00 => :AS_YYID00,AS_ZTJS00 => :AS_ZTJS00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 463 16:12:30 SQL Execute: ORACLE - BEGIN "SP_ZY_YBBRJS_BB0000" (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_TJLB00 => :AS_TJLB00,AS_BQMC00 => :AS_BQMC00,AS_YYID00 => :AS_YYID00,AS_ZTJS00 => :AS_ZTJS00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 464 16:12:34 SQL Prepare: ORACLE - select * from ( select substrb(SF_ZY_BRLXMC(GHKS18),1,20) BRLXMC,A.*,B.MRN000,B.YBKH00,B.BRXM00,B.BRXB00,C.ZWXM00,D.BMMC00,substr(SF_ZY_BRZYH0(GHKS18),1,20) YBZYH0,substrb(SF_ZY_BRJBMC(GHKS18),1,120)JBMC00,F.ZWXM00 JGYS00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,BM_YGBM00 F where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS10 = D.BMBH00(+) and a.ghks17=f.ygbh00(+) and C.YGBH00 <>0 and A.ID0000=:1 ) order by BMMC00,GHRQ00 465 16:12:34 SQL Execute: ORACLE - select * from ( select substrb(SF_ZY_BRLXMC(GHKS18),1,20) BRLXMC,A.*,B.MRN000,B.YBKH00,B.BRXM00,B.BRXB00,C.ZWXM00,D.BMMC00,substr(SF_ZY_BRZYH0(GHKS18),1,20) YBZYH0,substrb(SF_ZY_BRJBMC(GHKS18),1,120)JBMC00,F.ZWXM00 JGYS00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,BM_YGBM00 F where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS10 = D.BMBH00(+) and a.ghks17=f.ygbh00(+) and C.YGBH00 <>0 and A.ID0000=? ) order by BMMC00,GHRQ00 466 16:12:34 SQL Prepare: ORACLE - select D.BMMC00,A.GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1, NVL(GHKS04,0)+NVL(GHKS05,0),NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE, sum(GHKS08) JZJE00,sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS10 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 and B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =:1 group by D.BMMC00,A.GHRQ00 union all select ' 合计'BMMC00, NULL GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,NVL(GHKS04,0)+NVL(GHKS05,0), NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE,sum(GHKS08) JZJE00, sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS10 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 AND B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =:2 order by BMMC00 467 16:12:34 SQL Execute: ORACLE - select D.BMMC00,A.GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1, NVL(GHKS04,0)+NVL(GHKS05,0),NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE, sum(GHKS08) JZJE00,sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS10 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 and B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =? group by D.BMMC00,A.GHRQ00 union all select ' 合计'BMMC00, NULL GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,NVL(GHKS04,0)+NVL(GHKS05,0), NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE,sum(GHKS08) JZJE00, sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS10 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 AND B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =? order by BMMC00 468 16:12:34 SQL Prepare: ORACLE - select D.BMMC00,A.GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,NVL(GHKS04,0)+NVL(GHKS05,0), NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE, sum(GHKS08) JZJE00,sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS12 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 AND B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =:1 group by D.BMMC00,A.GHRQ00 union all select ' 合计'BMMC00, NULL GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,NVL(GHKS04,0)+NVL(GHKS05,0), NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE,sum(GHKS08) JZJE00, sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),'1',nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS12 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 AND B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =:2 order by BMMC00 469 16:12:34 SQL Execute: ORACLE - select D.BMMC00,A.GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,NVL(GHKS04,0)+NVL(GHKS05,0), NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE, sum(GHKS08) JZJE00,sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS12 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 AND B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =? group by D.BMMC00,A.GHRQ00 union all select ' 合计'BMMC00, NULL GHRQ00,count(*) RS0000,sum(GHKS03) ZFJE00, sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),1,NVL(GHKS04,0)+NVL(GHKS05,0), NVL(GHKS04,0)+NVL(GHKS05,0)+NVL(GHKS06,0)+NVL(GHKS07,0)+NVL(GHKS13,0)+NVL(GHKS14,0)+NVL(GHKS16,0)+NVL(GHKS19,0))) YBZFJE,sum(GHKS08) JZJE00, sum(GHKS09) JMJE00,sum(DECODE(sign(Instrb(','||Trim(E.YBBHSB)||',',',14,')),'1',nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0),XMHJ00)) HJJE00 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,bm_bmbm00 D,IC_YBBRLB E where A.GHKS01 = B.BRID00(+) and A.GHKS02 = C.YGBH00(+) and A.GHKS12 = D.BMBH00(+) AND B.YBLB00=E.YBLB00 AND B.FBBH00=E.FBBH00 and A.GHKS01 <> 0 and A.ID0000 =? order by BMMC00 470 16:12:34 SQL Prepare: ORACLE - BEGIN "SP_ZY_YBBRJS_JSTJ00" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_BQMC00 => :AS_BQMC00,AS_YBMC00 => :AS_YBMC00,AS_JZR000 => :AS_JZR000,AS_YYID00 => :AS_YYID00,AS_ZTJS00 => :AS_ZTJS00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 471 16:12:34 SQL Execute: ORACLE - BEGIN "SP_ZY_YBBRJS_JSTJ00" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_BQMC00 => :AS_BQMC00,AS_YBMC00 => :AS_YBMC00,AS_JZR000 => :AS_JZR000,AS_YYID00 => :AS_YYID00,AS_ZTJS00 => :AS_ZTJS00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 472 16:12:46 SQL Prepare: ORACLE - select * from ( select G.BMMC00 BQMC00,H.BMMC00 KSMC00,E.YBMC00,D.MRN000,C.ZYH000,D.YBKH00,(select pjxh00 from zy_pjsyqk k where k.fzpjh0=b.pjh000 and pjzt00='0' and rownum=1) PJXH00 ,DECODE(C.RYLB00,'生育',D.BRXM00||'(生育)','工伤',D.BRXM00||'(工伤)',D.BRXM00) BRXM00, D.BRXB00,D.TYDWMC,C.RYRQ00,C.CYDJRQ,A.SFXM02 ZYTS00, (B.HJJE00/decode(nvl(A.SFXM02,1),0,1,nvl(A.SFXM02,1))) PJFY00 ,B.HJJE00,B.JZJE00, B.GFJE00,B.GRZHZF,B.TCJJZF,B.ZFJE00,B.SBGRZH,B.SBTCJJ,B.JJZFE0,B.SYBXZF,B.SBZFE0,B.BJZFE0,B.GWYBZ0,F.ZWXM00, A.ID0000,A.BMBH00,A.XMHJ00,A.YPHJ00,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.SFXM79,A.SFXM80,A.SFXM81,A.SFXM82,A.SFXM83,A.SFXM84,A.SFXM85,A.SFXM86, A.SFXM87,A.SFXM88,A.SFXM89,A.SFXM90,A.SFXM91,A.SFXM92,A.SFXM93,A.SFXM94,A.SFXM95,A.SFXM96, A.SFXM97,A.SFXM98,A.SFXM99,A.BMMC00,A.SJYSXM from BM_YYSFTJ A,ZY_JZB000 B,ZY_BRXXB0 C,BM_BRXXB0 D,IC_YBBRLB E,BM_YGBM00 F,BM_BMBM00 G,BM_BMBM00 H where A.BMBH00=B.JZDH00 AND B.ZYID00=C.ZYID00 AND C.BRID00=D.BRID00 AND B.YBLB00=E.YBLB00 and B.FBBH00=E.FBBH00 and B.JZY000=F.YGBH00 AND A.SFXM01=G.BMBH00 AND C.DQKS00=H.BMBH00 AND A.ID0000=:1 order by D.YBKH00 ) union all select '合 计','合计记录数:'||to_char(count(B.ZYID00)), '合计病人数:'||to_char(count(distinct B.ZYID00)),null,null,null,null,null,null,NULL,NULL,NULL,sum(nvl(A.SFXM02,0)),sum(B.HJJE00)/decode(sum(nvl(A.SFXM02,1)),0,1,sum(nvl(A.SFXM02,1))),sum(B.HJJE00),sum(B.JZJE00), sum(B.GFJE00),sum(B.GRZHZF),sum(B.TCJJZF),sum(B.ZFJE00),sum(B.SBGRZH),sum(B.SBTCJJ),sum(B.JJZFE0),sum(B.SYBXZF),SUM(B.SBZFE0),SUM(B.BJZFE0),SUM(B.GWYBZ0),NULL,0,0,0,0,0,0, sum(A.SFXM03),sum(A.SFXM04),sum(A.SFXM05),sum(A.SFXM06), sum(A.SFXM07),sum(A.SFXM08),sum(A.SFXM09),sum(A.SFXM10),sum(A.SFXM11),sum(A.SFXM12),sum(A.SFXM13),sum(A.SFXM14),sum(A.SFXM15),sum(A.SFXM16), sum(A.SFXM17),sum(A.SFXM18),sum(A.SFXM19),sum(A.SFXM20), sum(A.SFXM21),sum(A.SFXM22),sum(A.SFXM23),sum(A.SFXM24),sum(A.SFXM25),sum(A.SFXM26),sum(A.SFXM27),sum(A.SFXM28),sum(A.SFXM29),sum(A.SFXM30),sum(A.SFXM31), sum(A.SFXM32),sum(A.SFXM33),sum(A.SFXM34),sum(A.SFXM35),sum(A.SFXM36),sum(A.SFXM37),sum(A.SFXM38),sum(A.SFXM39),sum(A.SFXM40),sum(A.SFXM41),sum(A.SFXM42), sum(A.SFXM43),sum(A.SFXM44),sum(A.SFXM45),sum(A.SFXM46),sum(A.SFXM47),sum(A.SFXM48),sum(A.SFXM49),sum(A.SFXM50),sum(A.SFXM51),sum(A.SFXM52),sum(A.SFXM53), sum(A.SFXM54),sum(A.SFXM55),sum(A.SFXM56),sum(A.SFXM57),sum(A.SFXM58),sum(A.SFXM59),sum(A.SFXM60),sum(A.SFXM61),sum(A.SFXM62),sum(A.SFXM63),sum(A.SFXM64), sum(A.SFXM65),sum(A.SFXM66),sum(A.SFXM67),sum(A.SFXM68),sum(A.SFXM69),sum(A.SFXM70),sum(A.SFXM71),sum(A.SFXM72),sum(A.SFXM73),sum(A.SFXM74),sum(A.SFXM75), sum(A.SFXM76),sum(A.SFXM77),sum(A.SFXM78),sum(A.SFXM79),sum(A.SFXM80),SUM(A.SFXM81),SUM(A.SFXM82),SUM(A.SFXM83),SUM(A.SFXM84),SUM(A.SFXM85),SUM(A.SFXM86), sum(A.SFXM87),sum(A.SFXM88),sum(A.SFXM89),sum(A.SFXM90),sum(A.SFXM91),SUM(A.SFXM92),SUM(A.SFXM93),SUM(A.SFXM94),SUM(A.SFXM95),SUM(A.SFXM96),SUM(A.SFXM97),SUM(A.SFXM98),SUM(A.SFXM99),null,null from BM_YYSFTJ A,ZY_JZB000 B,ZY_BRXXB0 C,IC_YBBRLB E,BM_YGBM00 F,BM_BMBM00 G where A.BMBH00=B.JZDH00 AND B.ZYID00=C.ZYID00 AND B.YBLB00=E.YBLB00 and B.FBBH00=E.FBBH00 and B.JZY000=F.YGBH00 AND A.SFXM01=G.BMBH00 AND A.ID0000=:2 473 16:12:46 SQL Execute: ORACLE - select * from ( select G.BMMC00 BQMC00,H.BMMC00 KSMC00,E.YBMC00,D.MRN000,C.ZYH000,D.YBKH00,(select pjxh00 from zy_pjsyqk k where k.fzpjh0=b.pjh000 and pjzt00='0' and rownum=1) PJXH00 ,DECODE(C.RYLB00,'生育',D.BRXM00||'(生育)','工伤',D.BRXM00||'(工伤)',D.BRXM00) BRXM00, D.BRXB00,D.TYDWMC,C.RYRQ00,C.CYDJRQ,A.SFXM02 ZYTS00, (B.HJJE00/decode(nvl(A.SFXM02,1),0,1,nvl(A.SFXM02,1))) PJFY00 ,B.HJJE00,B.JZJE00, B.GFJE00,B.GRZHZF,B.TCJJZF,B.ZFJE00,B.SBGRZH,B.SBTCJJ,B.JJZFE0,B.SYBXZF,B.SBZFE0,B.BJZFE0,B.GWYBZ0,F.ZWXM00, A.ID0000,A.BMBH00,A.XMHJ00,A.YPHJ00,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.SFXM79,A.SFXM80,A.SFXM81,A.SFXM82,A.SFXM83,A.SFXM84,A.SFXM85,A.SFXM86, A.SFXM87,A.SFXM88,A.SFXM89,A.SFXM90,A.SFXM91,A.SFXM92,A.SFXM93,A.SFXM94,A.SFXM95,A.SFXM96, A.SFXM97,A.SFXM98,A.SFXM99,A.BMMC00,A.SJYSXM from BM_YYSFTJ A,ZY_JZB000 B,ZY_BRXXB0 C,BM_BRXXB0 D,IC_YBBRLB E,BM_YGBM00 F,BM_BMBM00 G,BM_BMBM00 H where A.BMBH00=B.JZDH00 AND B.ZYID00=C.ZYID00 AND C.BRID00=D.BRID00 AND B.YBLB00=E.YBLB00 and B.FBBH00=E.FBBH00 and B.JZY000=F.YGBH00 AND A.SFXM01=G.BMBH00 AND C.DQKS00=H.BMBH00 AND A.ID0000=? order by D.YBKH00 ) union all select '合 计','合计记录数:'||to_char(count(B.ZYID00)), '合计病人数:'||to_char(count(distinct B.ZYID00)),null,null,null,null,null,null,NULL,NULL,NULL,sum(nvl(A.SFXM02,0)),sum(B.HJJE00)/decode(sum(nvl(A.SFXM02,1)),0,1,sum(nvl(A.SFXM02,1))),sum(B.HJJE00),sum(B.JZJE00), sum(B.GFJE00),sum(B.GRZHZF),sum(B.TCJJZF),sum(B.ZFJE00),sum(B.SBGRZH),sum(B.SBTCJJ),sum(B.JJZFE0),sum(B.SYBXZF),SUM(B.SBZFE0),SUM(B.BJZFE0),SUM(B.GWYBZ0),NULL,0,0,0,0,0,0, sum(A.SFXM03),sum(A.SFXM04),sum(A.SFXM05),sum(A.SFXM06), sum(A.SFXM07),sum(A.SFXM08),sum(A.SFXM09),sum(A.SFXM10),sum(A.SFXM11),sum(A.SFXM12),sum(A.SFXM13),sum(A.SFXM14),sum(A.SFXM15),sum(A.SFXM16), sum(A.SFXM17),sum(A.SFXM18),sum(A.SFXM19),sum(A.SFXM20), sum(A.SFXM21),sum(A.SFXM22),sum(A.SFXM23),sum(A.SFXM24),sum(A.SFXM25),sum(A.SFXM26),sum(A.SFXM27),sum(A.SFXM28),sum(A.SFXM29),sum(A.SFXM30),sum(A.SFXM31), sum(A.SFXM32),sum(A.SFXM33),sum(A.SFXM34),sum(A.SFXM35),sum(A.SFXM36),sum(A.SFXM37),sum(A.SFXM38),sum(A.SFXM39),sum(A.SFXM40),sum(A.SFXM41),sum(A.SFXM42), sum(A.SFXM43),sum(A.SFXM44),sum(A.SFXM45),sum(A.SFXM46),sum(A.SFXM47),sum(A.SFXM48),sum(A.SFXM49),sum(A.SFXM50),sum(A.SFXM51),sum(A.SFXM52),sum(A.SFXM53), sum(A.SFXM54),sum(A.SFXM55),sum(A.SFXM56),sum(A.SFXM57),sum(A.SFXM58),sum(A.SFXM59),sum(A.SFXM60),sum(A.SFXM61),sum(A.SFXM62),sum(A.SFXM63),sum(A.SFXM64), sum(A.SFXM65),sum(A.SFXM66),sum(A.SFXM67),sum(A.SFXM68),sum(A.SFXM69),sum(A.SFXM70),sum(A.SFXM71),sum(A.SFXM72),sum(A.SFXM73),sum(A.SFXM74),sum(A.SFXM75), sum(A.SFXM76),sum(A.SFXM77),sum(A.SFXM78),sum(A.SFXM79),sum(A.SFXM80),SUM(A.SFXM81),SUM(A.SFXM82),SUM(A.SFXM83),SUM(A.SFXM84),SUM(A.SFXM85),SUM(A.SFXM86), sum(A.SFXM87),sum(A.SFXM88),sum(A.SFXM89),sum(A.SFXM90),sum(A.SFXM91),SUM(A.SFXM92),SUM(A.SFXM93),SUM(A.SFXM94),SUM(A.SFXM95),SUM(A.SFXM96),SUM(A.SFXM97),SUM(A.SFXM98),SUM(A.SFXM99),null,null from BM_YYSFTJ A,ZY_JZB000 B,ZY_BRXXB0 C,IC_YBBRLB E,BM_YGBM00 F,BM_BMBM00 G where A.BMBH00=B.JZDH00 AND B.ZYID00=C.ZYID00 AND B.YBLB00=E.YBLB00 and B.FBBH00=E.FBBH00 and B.JZY000=F.YGBH00 AND A.SFXM01=G.BMBH00 AND A.ID0000=? 474 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-19 475 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-19 476 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-18 477 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-18 478 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-17 479 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-17 480 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-16 481 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-16 482 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-15 483 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-15 484 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-14 485 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-14 486 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-13 487 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-13 488 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-12 489 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-12 490 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-11 491 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-11 492 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-10 493 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-10 494 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-9 495 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-9 496 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-8 497 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-8 498 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-7 499 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-7 500 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-6 501 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-6 502 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-5 503 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-5 504 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-4 505 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-4 506 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-3 507 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-3 508 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-2 509 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-2 510 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-1 511 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=-1 512 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=0 513 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=0 514 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=1 515 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=1 516 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=2 517 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=2 518 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=3 519 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=3 520 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=4 521 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=4 522 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=5 523 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=5 524 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=6 525 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=6 526 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=7 527 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=7 528 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=8 529 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=8 530 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=9 531 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=9 532 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=10 533 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=10 534 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=11 535 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=11 536 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=12 537 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=12 538 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=13 539 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=13 540 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=14 541 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=14 542 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=15 543 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=15 544 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=16 545 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=16 546 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=17 547 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=17 548 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=18 549 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=18 550 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=19 551 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=19 552 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=20 553 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=20 554 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=21 555 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=21 556 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=22 557 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=22 558 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=23 559 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=23 560 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=24 561 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=24 562 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=25 563 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=25 564 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=26 565 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=26 566 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=27 567 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=27 568 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=28 569 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=28 570 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=29 571 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=29 572 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=30 573 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=30 574 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=31 575 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=31 576 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=32 577 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=32 578 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=33 579 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=33 580 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=34 581 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=34 582 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=35 583 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=35 584 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=36 585 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=36 586 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=37 587 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=37 588 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=38 589 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=38 590 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=39 591 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=39 592 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=40 593 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=40 594 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=41 595 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=41 596 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=42 597 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=42 598 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=43 599 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=43 600 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=44 601 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=44 602 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=45 603 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=45 604 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=46 605 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=46 606 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=47 607 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=47 608 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=48 609 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=48 610 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=49 611 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=49 612 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=50 613 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=50 614 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=51 615 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=51 616 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=52 617 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=52 618 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=53 619 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=53 620 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=54 621 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=54 622 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=55 623 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=55 624 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=56 625 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=56 626 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=57 627 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=57 628 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=58 629 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=58 630 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=59 631 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=59 632 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=60 633 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=60 634 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=61 635 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=61 636 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=62 637 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=62 638 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=63 639 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=63 640 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=64 641 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=64 642 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=65 643 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=65 644 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=66 645 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=66 646 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=67 647 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=67 648 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=68 649 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=68 650 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=69 651 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=69 652 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=70 653 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=70 654 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=71 655 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=71 656 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=72 657 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=72 658 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=73 659 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=73 660 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=74 661 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=74 662 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=75 663 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=75 664 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=76 665 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=76 666 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=77 667 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=77 668 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=78 669 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=78 670 16:12:47 SQL Prepare: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=79 671 16:12:47 SQL Execute: ORACLE - select * from BM_FPXM00 where SYBZ00 <> 1 and FPXMID=79 672 16:12:47 SQL Prepare: ORACLE - select C.YBMC00,count(distinct F.ZYID00) RS0000,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00, sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(D.BRZJE0-D.ZFJE00) YBXJ00, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.YBBRLB<>'C' and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' and C.YBMC00 = '长乐分中心' group by C.YBMC00 having sum(D.BRZJE0)<>0 union all select '城镇医保',COUNT(*) RS0000,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00, sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(D.BRZJE0-D.ZFJE00) YBXJ00, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and D.FBBH00=3 and d.ybbrlb='C' and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' and C.YBMC00 = '长乐分中心' union all select '合计',COUNT(distinct f.zyid00) RS0000,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00, sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(D.BRZJE0-D.ZFJE00) YBXJ00, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' and C.YBMC00 = '长乐分中心' 673 16:12:47 SQL Execute: ORACLE - select C.YBMC00,count(distinct F.ZYID00) RS0000,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00, sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(D.BRZJE0-D.ZFJE00) YBXJ00, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.YBBRLB<>'C' and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' and C.YBMC00 = '长乐分中心' group by C.YBMC00 having sum(D.BRZJE0)<>0 union all select '城镇医保',COUNT(*) RS0000,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00, sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(D.BRZJE0-D.ZFJE00) YBXJ00, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and D.FBBH00=3 and d.ybbrlb='C' and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' and C.YBMC00 = '长乐分中心' union all select '合计',COUNT(distinct f.zyid00) RS0000,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00, sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(D.BRZJE0-D.ZFJE00) YBXJ00, sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0,sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' and C.YBMC00 = '长乐分中心' 674 16:12:47 SQL Prepare: ORACLE - select C.YBMC00,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00,sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00, sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0, sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.RYLB00 IN ('生育','工伤') and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' and C.YBMC00 = '长乐分中心' group by C.YBMC00 675 16:12:47 SQL Execute: ORACLE - select C.YBMC00,SUM(D.ZFJE00)ZFJE00,sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.GRZHZF,D.GRZHZF+D.SBGRZH)) GRZHZF, sum(decode(sign(Instrb(','||Trim(C.YBBHSB)||',',',14,')),1,D.TCJJZF,D.SBTCJJ+D.TCJJZF)) TCJJZF,sum(JJZFE0) JJZFE0,sum(SYBXZF) SYBXZF,sum(D.BRZJE0) HJJE00,sum(D.JZJE00)JZJE00,sum(D.GFJE00) JMJE00, sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(SBZFE0) SBZFE0,sum(BJZFE0) BJZFE0, sum(D.GWYBZ0) GWYBZ0 from ic_ybbrlb C,zy_jzb000 D,BM_YGBM00 E,zy_brxxb0 F,BM_BMBM00 K,BM_BMBM00 G where D.yblb00 = C.yblb00 and D.FBBH00 = C.FBBH00 and C.FBBH00<>1 and D.JZY000 = E.YGBH00 and D.ZYID00 = F.ZYID00 AND D.CZYKS0 = G.BMBH00 and F.RYLB00 IN ('生育','工伤') and F.DQBQ00 = K.BMBH00 and D.JZRQ00 >= '20110301' and D.JZRQ00 <= '20110331' and D.JZRQ00||D.JZSJ00 >= '2011030100:00:00' and D.JZRQ00||D.JZSJ00 <= '2011033123:59:59' and C.YBMC00 = '长乐分中心' group by C.YBMC00