1 09:19:11 Log started for: SQL Navigator for Oracle 2 09:19:26 Log started for: 固定资产核算管理系统 3 09:19:26 SQL Prepare: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','442','25190' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:AA187611476484C390088D38B2ABCDDA' from dual 4 09:19:26 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','442','25190' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:AA187611476484C390088D38B2ABCDDA' from dual 5 09:19:26 SQL Prepare: ORACLE - Commit 6 09:19:26 SQL Execute: ORACLE - Commit 7 09:19:26 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 09:19:26 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 9 09:19:26 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 10 09:19:26 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 11 09:19:26 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 12 09:19:26 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 13 09:19:26 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 14 09:19:26 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 15 09:19:26 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','811','46705' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from dual 16 09:19:26 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','G','Prj_GDZC.exe'||'+'||'固定资产核算管理系统','811','46705' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from dual 17 09:19:26 SQL Prepare: ORACLE - Commit 18 09:19:26 SQL Execute: ORACLE - Commit 19 09:19:26 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='G' 20 09:19:26 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='G' 21 09:19:26 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 22 09:19:26 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 23 09:19:26 SQL Prepare: ORACLE - Select SYSDATE from Dual 24 09:19:26 SQL Execute: ORACLE - Select SYSDATE from Dual 25 09:19:26 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 26 09:19:26 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 27 09:19:26 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 28 09:19:26 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 29 09:19:26 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='G' 30 09:19:26 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='G' 31 09:19:26 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 32 09:19:26 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 33 09:19:26 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 34 09:19:26 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 35 09:19:26 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('a','b','9','8') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 36 09:19:26 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('a','b','9','8') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 37 09:19:28 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'G' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 38 09:19:28 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'G' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='G' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 39 09:19:28 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 40 09:19:28 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 41 09:19:28 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 42 09:19:28 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 43 09:19:28 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 44 09:19:28 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 45 09:19:28 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 46 09:19:28 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 47 09:19:28 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 48 09:19:28 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 49 09:19:28 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')) 50 09:19:28 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')) 51 09:19:28 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2920984,476,'wlzx-3','G',nvl('37856269',' '),'192.168.12.120#811:46705@Prj_GDZC.exe+固定资产核算管理系统',175) 52 09:19:28 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2920984,476,'wlzx-3','G',nvl('37856269',' '),'192.168.12.120#811:46705@Prj_GDZC.exe+固定资产核算管理系统',175) 53 09:19:28 SQL Prepare: ORACLE - Commit 54 09:19:28 SQL Execute: ORACLE - Commit 55 09:19:28 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 175 56 09:19:28 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 175 57 09:19:28 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 58 09:19:28 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 59 09:19:28 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 60 09:19:28 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 61 09:19:28 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 62 09:19:28 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 63 09:19:28 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 64 09:19:28 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 65 09:19:28 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 175 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 66 09:19:28 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 175 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 67 09:19:28 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 68 09:19:28 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 69 09:19:28 SQL Prepare: ORACLE - select owner, object_name, object_type, created from sys.dba_objects where object_type in ('TABLE', 'VIEW' ) and owner = 'SD_HOSPITAL' and object_name = 'XT_XTCS00' order by 1 ASC, 2 ASC 70 09:19:28 SQL Execute: ORACLE - select owner, object_name, object_type, created from sys.dba_objects where object_type in ('TABLE', 'VIEW' ) and owner = 'SD_HOSPITAL' and object_name = 'XT_XTCS00' order by 1 ASC, 2 ASC 71 09:19:28 SQL Prepare: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'XT_XTCS00' order by owner ASC, index_name ASC 72 09:19:28 SQL Execute: ORACLE - select owner, index_name, uniqueness from sys.dba_indexes where table_owner = 'SD_HOSPITAL' and table_name = 'XT_XTCS00' order by owner ASC, index_name ASC 73 09:19:28 SQL Prepare: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'PK_XT_XTCS00_NAME00' order by column_position ASC 74 09:19:28 SQL Execute: ORACLE - select column_name from sys.dba_ind_columns where index_owner = 'SD_HOSPITAL' and index_name = 'PK_XT_XTCS00_NAME00' order by column_position ASC 75 09:19:28 SQL Prepare: ORACLE - SELECT "NAME00" ,"VALUE0" ,"FLAG00" ,"BZ0000" ,"FL0000" FROM "XT_XTCS00" ORDER BY "NAME00" ASC 76 09:19:28 SQL Execute: ORACLE - SELECT "NAME00" ,"VALUE0" ,"FLAG00" ,"BZ0000" ,"FL0000" FROM "XT_XTCS00" ORDER BY "NAME00" ASC 77 09:19:29 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 78 09:19:29 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 79 09:19:29 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 80 09:19:29 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 81 09:19:29 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='G') and YXQ000>='20120217' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',175,' )>0 ) 82 09:19:29 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='G') and YXQ000>='20120217' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',175,' )>0 ) 83 09:19:29 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 84 09:19:29 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 85 09:19:29 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 86 09:19:29 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 87 09:19:29 SQL Prepare: ORACLE - select sysdate nowtime from dual 88 09:19:29 SQL Execute: ORACLE - select sysdate nowtime from dual 89 09:19:29 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 90 09:19:29 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 91 09:19:29 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_PRINTSCALE' 92 09:19:29 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_PRINTSCALE' 93 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageWidth' 94 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageWidth' 95 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBWidth' 96 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBWidth' 97 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBHeigh' 98 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBHeigh' 99 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBJ00' 100 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_ZBJ00' 101 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_YBJ00' 102 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_USER_YBJ00' 103 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageHeigh' 104 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PageHeigh' 105 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageDirect' 106 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_PageDirect' 107 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJKSSJ' 108 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJKSSJ' 109 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJJSSJ' 110 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_TJJSSJ' 111 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SlExperSBLB' 112 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SlExperSBLB' 113 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSC' 114 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSC' 115 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_LENGTH' 116 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_LENGTH' 117 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KCDWSFFK' 118 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KCDWSFFK' 119 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBRKGGXHSFGG' 120 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBRKGGXHSFGG' 121 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KPH000_SFZD' 122 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_KPH000_SFZD' 123 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageWidth' 124 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageWidth' 125 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageHeigh' 126 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SF_USER_PageHeigh' 127 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJGSCS' 128 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJGSCS' 129 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_RKDDYGSID' 130 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_RKDDYGSID' 131 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_CKDDYGSID' 132 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZDY_CKDDYGSID' 133 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'WZ_YYGXH' 134 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'WZ_YYGXH' 135 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPMZDLBQY2006' 136 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPMZDLBQY2006' 137 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSCLX' 138 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_SBBM_SFZDSCLX' 139 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_GZDJHDL' 140 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_GZDJHDL' 141 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RYGSCS' 142 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RYGSCS' 143 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RKDQR' 144 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_RKDQR' 145 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_JXZJDJBLZ' 146 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_JXZJDJBLZ' 147 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJHAZCKTJ' 148 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_DJHAZCKTJ' 149 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_PDDDYSFZJYZDZD' 150 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_PDDDYSFZJYZDZD' 151 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_ZCDAXGCJBQXS' 152 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_ZCDAXGCJBQXS' 153 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_XXGJBKZKHBZJ' 154 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_XXGJBKZKHBZJ' 155 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_DAKPDKDYGS' 156 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_DAKPDKDYGS' 157 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PDDYFJJESFTJ' 158 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_PDDYFJJESFTJ' 159 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_TJYSBFLSFACKFK' 160 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_TJYSBFLSFACKFK' 161 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_ZJJDSFZJZJ' 162 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'GDZC_ZJJDSFZJZJ' 163 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPLCKXS' 164 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_ZCPLCKXS' 165 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKMXHZCXSFBKTK' 166 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKMXHZCXSFBKTK' 167 09:19:29 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKBHSFKZCCBH' 168 09:19:29 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 = 'SB_CKBHSFKZCCBH' 169 09:19:29 SQL Prepare: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('SB_JTXGJJTJSFYBMBH','GDZC_WXPJSYZKZC','GDZC_BFQKTJZCLBTJ') 170 09:19:29 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('SB_JTXGJJTJSFYBMBH','GDZC_WXPJSYZKZC','GDZC_BFQKTJZCLBTJ') 171 09:19:29 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='G' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='G'))) 172 09:19:29 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='G' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='G'))) 173 09:19:29 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'G$%' and A.XTDM00='G' and trim(A.MKDM00)='G$'||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 174 09:19:29 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'G$%' and A.XTDM00='G' and trim(A.MKDM00)='G$'||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 175 09:19:29 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 176 09:19:29 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 177 09:19:29 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 178 09:19:29 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 179 09:19:29 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 180 09:19:29 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 181 09:19:34 SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=175 and DLXTMC='固定资产核算管理系统' and CTMC00='frmGDZC_XGJJ00_RBB000' 182 09:19:34 SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=476 and BMBH00=175 and DLXTMC='固定资产核算管理系统' and CTMC00='frmGDZC_XGJJ00_RBB000' 183 09:19:38 SQL Prepare: ORACLE - select sysdate N from dual 184 09:19:38 SQL Execute: ORACLE - select sysdate N from dual 185 09:19:43 SQL Prepare: ORACLE - select sysdate N from dual 186 09:19:43 SQL Execute: ORACLE - select sysdate N from dual 187 09:19:43 SQL Prepare: ORACLE - select 1 from dual where exists (select TQYF00 from SB_GDZCZJ where TQNF00 =2011 and TQYF00 =12) 188 09:19:43 SQL Execute: ORACLE - select 1 from dual where exists (select TQYF00 from SB_GDZCZJ where TQNF00 =2011 and TQYF00 =12) 189 09:19:43 SQL Prepare: ORACLE - select BMMC00,BMBH00,BH0000,SX,sum(YZ0000) YZ0000,sum(BYZJE0) BYZJE0,sum(BYBTJE) BYBTJE, sum(LJZJ00) LJZJ00,sum(JZ0000) JZ0000 from ( select ' 合计' BMMC00,0 BMBH00,'' BH0000, NVL(sum(D.TQYZ00),0) YZ0000, NVL(sum(D.BYZJE0),0) BYZJE0, NVL(sum(D.BYBTJE),0) BYBTJE, NVL(sum(D.LJZJJE),0) LJZJ00, NVL(sum(D.ZJHJZ0),0) JZ0000,'0' SX from SB_DA0000 A,BM_BMBM00 E,SB_GDZCZJ D where A.DAXXID=D.DAXXID and D.TQKS00=E.BMBH00 and D.TQNF00 =2011 and D.TQYF00 =12 and A.SHJSZJ = '1' and A.CKBH00= 175 union all select ' 合计' BMMC00,0 BMBH00,'' BH0000, NVL(sum(F.FTJE00),0) YZ0000,0 BYZJE0,0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00, NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000,'0' SX from SB_DA0000 A,BM_BMBM00 E,SB_SYKS00 F where A.DAXXID = F.DAXXID and E.BMBH00=F.BMBH00 and a.shjszj='2' and A.SFYX00='Y' and F.SYZT00='Y' and A.CKBH00= 175 union all select ' 合计' BMMC00 ,0 BMBH00,'' BH0000, NVL(sum(a.yz0000),0) YZ0000,0 BYZJE0,0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00, NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000,'0' SX from SB_DA0000 A,BM_BMBM00 E where a.syzt00='1' and a.sfyx00='Y' and A.CKBH00=E.BMBH00 and A.CKBH00= 175 and substr(A.RZRQ00,1,6)<='201112' union all select ' 合计' BMMC00,0 BMBH00,'' BH0000,sum(nvl(b.FTJE00,0)) YZ0000,0 BYZJE0,0 BYBTJE,sum(nvl(A.LJZJ00,0)) LJZJ00,sum(nvl(A.JZ0000,YZ0000)) JZ0000,'0' SX from SB_DA0000 a,SB_SYKS00 b,BM_BMBM00 e where a.DAXXID=b.DAXXID and a.SHJSZJ='1' and a.SFYX00='Y' and b.SYZT00='Y' and not exists(select 1 from SB_GDZCZJ where DAXXID=a.DAXXID and TQNF00='2011' and TQYF00='12') and e.BMBH00=b.BMBH00 and substr(a.RZRQ00,1,6)<='201112' and A.CKBH00= 175 )group by BMMC00,BMBH00,BH0000,SX union all select BMMC00,BMBH00,BH0000,SX,sum(YZ0000) YZ0000,sum(BYZJE0) BYZJE0,sum(BYBTJE) BYBTJE, sum(LJZJ00) LJZJ00,sum(JZ0000) JZ0000 from ( SELECT BMMC00, BMBH00,BH0000, YZ0000, BYZJE0, BYBTJE, LJZJ00, JZ0000, SX FROM ( select E.BMMC00,D.TQKS00 BMBH00,E.BH0000 BH0000, NVL(sum(D.TQYZ00),0) YZ0000, NVL(sum(D.BYZJE0),0) BYZJE0, NVL(sum(D.BYBTJE),0) BYBTJE, NVL(sum(D.LJZJJE),0) LJZJ00, NVL(sum(D.ZJHJZ0),0) JZ0000,E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_GDZCZJ D where A.DAXXID=D.DAXXID and D.TQKS00=E.BMBH00 and D.TQNF00 =2011 and D.TQYF00 =12 and A.SHJSZJ = '1' and A.CKBH00= 175 group by D.TQKS00,E.BMMC00,E.BH0000,E.BMXZ00 ) union all SELECT BMMC00, BMBH00,BH0000, YZ0000, BYZJE0, BYBTJE, LJZJ00, JZ0000, SX FROM ( select E.BMMC00,F.BMBH00 BMBH00,E.BH0000 BH0000, NVL(sum(F.FTJE00),0) YZ0000, 0 BYZJE0,0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00,NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000, E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_SYKS00 F where A.DAXXID = F.DAXXID and F.bmbh00=E.bmbh00 and A.SHJSZJ ='2' and A.SFYX00='Y' and F.SYZT00='Y' and A.CKBH00= 175 group by F.bmbh00,E.BMMC00,E.BH0000,E.BMXZ00 ) union all select BMMC00,e.BMBH00,BH0000,sum(nvl(b.FTJE00,0)) YZ0000,0 BYZJE0,0 BYBTJE,sum(nvl(A.LJZJ00,0)) LJZJ00,sum(nvl(A.JZ0000,YZ0000)) JZ0000,e.BMXZ00 SX from SB_DA0000 a,SB_SYKS00 b,BM_BMBM00 e where a.DAXXID=b.DAXXID and a.SHJSZJ='1' and a.SFYX00='Y' and b.SYZT00='Y' and not exists(select 1 from SB_GDZCZJ where DAXXID=a.DAXXID and TQNF00='2011' and TQYF00='12') and e.BMBH00=b.BMBH00 and substr(a.RZRQ00,1,6)<='201112' and A.CKBH00= 175 group by e.bmbh00,BMMC00,BH0000,BMXZ00 ) group by bmbh00,BMMC00,BH0000,SX union all select BMMC00,BMBH00,BH0000,SX,sum(YZ0000) YZ0000,sum(BYZJE0) BYZJE0,sum(BYBTJE) BYBTJE, sum(LJZJ00) LJZJ00,sum(JZ0000) JZ0000 from ( select ' 部门合计' BMMC00 ,1000 BMBH00,'' BH0000, NVL(sum(D.TQYZ00),0) YZ0000, NVL(sum(D.BYZJE0),0) BYZJE0, NVL(sum(D.BYBTJE),0) BYBTJE, NVL(sum(D.LJZJJE),0) LJZJ00, NVL(sum(D.ZJHJZ0),0) JZ0000, E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_GDZCZJ D where A.DAXXID=D.DAXXID and D.TQKS00=E.BMBH00 and D.TQNF00 =2011 and D.TQYF00 =12 and A.SHJSZJ ='1' and A.CKBH00= 175 group by E.BMXZ00 union all select ' 部门合计' BMMC00,1000 BMBH00,'' BH0000,NVL(sum(F.FTJE00),0) YZ0000,0 BYZJE0, 0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00,NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000,E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_SYKS00 F where A.DAXXID = F.DAXXID and F.bmbh00=E.bmbh00 and A.SHJSZJ = '2' and A.SFYX00='Y' and F.SYZT00='Y' and A.CKBH00= 175 group by E.BMXZ00 ) group by bmbh00,BMMC00,BH0000,SX union all select (select b.BMMC00 from BM_BMBM00 b where b.bmbh00=x.BMBH00 ) BMMC00, BMBH00,BH0000,SX,YZ0000,BYZJE0,BYBTJE,LJZJ00,JZ0000 from (select A.CKBH00 BMBH00,E.BH0000 BH0000, NVL(sum(a.yz0000),0) YZ0000,0 BYZJE0,0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00, NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000, 'x' SX from SB_DA0000 A,BM_BMBM00 E where A.CKBH00=E.BMBH00 and a.syzt00='1' and a.sfyx00='Y' and A.CKBH00= 175 and substr(A.RZRQ00,1,6)<='201112' group by A.CKBH00,E.BH0000 ) X order by SX,BMBH00 190 09:19:43 SQL Execute: ORACLE - select BMMC00,BMBH00,BH0000,SX,sum(YZ0000) YZ0000,sum(BYZJE0) BYZJE0,sum(BYBTJE) BYBTJE, sum(LJZJ00) LJZJ00,sum(JZ0000) JZ0000 from ( select ' 合计' BMMC00,0 BMBH00,'' BH0000, NVL(sum(D.TQYZ00),0) YZ0000, NVL(sum(D.BYZJE0),0) BYZJE0, NVL(sum(D.BYBTJE),0) BYBTJE, NVL(sum(D.LJZJJE),0) LJZJ00, NVL(sum(D.ZJHJZ0),0) JZ0000,'0' SX from SB_DA0000 A,BM_BMBM00 E,SB_GDZCZJ D where A.DAXXID=D.DAXXID and D.TQKS00=E.BMBH00 and D.TQNF00 =2011 and D.TQYF00 =12 and A.SHJSZJ = '1' and A.CKBH00= 175 union all select ' 合计' BMMC00,0 BMBH00,'' BH0000, NVL(sum(F.FTJE00),0) YZ0000,0 BYZJE0,0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00, NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000,'0' SX from SB_DA0000 A,BM_BMBM00 E,SB_SYKS00 F where A.DAXXID = F.DAXXID and E.BMBH00=F.BMBH00 and a.shjszj='2' and A.SFYX00='Y' and F.SYZT00='Y' and A.CKBH00= 175 union all select ' 合计' BMMC00 ,0 BMBH00,'' BH0000, NVL(sum(a.yz0000),0) YZ0000,0 BYZJE0,0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00, NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000,'0' SX from SB_DA0000 A,BM_BMBM00 E where a.syzt00='1' and a.sfyx00='Y' and A.CKBH00=E.BMBH00 and A.CKBH00= 175 and substr(A.RZRQ00,1,6)<='201112' union all select ' 合计' BMMC00,0 BMBH00,'' BH0000,sum(nvl(b.FTJE00,0)) YZ0000,0 BYZJE0,0 BYBTJE,sum(nvl(A.LJZJ00,0)) LJZJ00,sum(nvl(A.JZ0000,YZ0000)) JZ0000,'0' SX from SB_DA0000 a,SB_SYKS00 b,BM_BMBM00 e where a.DAXXID=b.DAXXID and a.SHJSZJ='1' and a.SFYX00='Y' and b.SYZT00='Y' and not exists(select 1 from SB_GDZCZJ where DAXXID=a.DAXXID and TQNF00='2011' and TQYF00='12') and e.BMBH00=b.BMBH00 and substr(a.RZRQ00,1,6)<='201112' and A.CKBH00= 175 )group by BMMC00,BMBH00,BH0000,SX union all select BMMC00,BMBH00,BH0000,SX,sum(YZ0000) YZ0000,sum(BYZJE0) BYZJE0,sum(BYBTJE) BYBTJE, sum(LJZJ00) LJZJ00,sum(JZ0000) JZ0000 from ( SELECT BMMC00, BMBH00,BH0000, YZ0000, BYZJE0, BYBTJE, LJZJ00, JZ0000, SX FROM ( select E.BMMC00,D.TQKS00 BMBH00,E.BH0000 BH0000, NVL(sum(D.TQYZ00),0) YZ0000, NVL(sum(D.BYZJE0),0) BYZJE0, NVL(sum(D.BYBTJE),0) BYBTJE, NVL(sum(D.LJZJJE),0) LJZJ00, NVL(sum(D.ZJHJZ0),0) JZ0000,E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_GDZCZJ D where A.DAXXID=D.DAXXID and D.TQKS00=E.BMBH00 and D.TQNF00 =2011 and D.TQYF00 =12 and A.SHJSZJ = '1' and A.CKBH00= 175 group by D.TQKS00,E.BMMC00,E.BH0000,E.BMXZ00 ) union all SELECT BMMC00, BMBH00,BH0000, YZ0000, BYZJE0, BYBTJE, LJZJ00, JZ0000, SX FROM ( select E.BMMC00,F.BMBH00 BMBH00,E.BH0000 BH0000, NVL(sum(F.FTJE00),0) YZ0000, 0 BYZJE0,0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00,NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000, E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_SYKS00 F where A.DAXXID = F.DAXXID and F.bmbh00=E.bmbh00 and A.SHJSZJ ='2' and A.SFYX00='Y' and F.SYZT00='Y' and A.CKBH00= 175 group by F.bmbh00,E.BMMC00,E.BH0000,E.BMXZ00 ) union all select BMMC00,e.BMBH00,BH0000,sum(nvl(b.FTJE00,0)) YZ0000,0 BYZJE0,0 BYBTJE,sum(nvl(A.LJZJ00,0)) LJZJ00,sum(nvl(A.JZ0000,YZ0000)) JZ0000,e.BMXZ00 SX from SB_DA0000 a,SB_SYKS00 b,BM_BMBM00 e where a.DAXXID=b.DAXXID and a.SHJSZJ='1' and a.SFYX00='Y' and b.SYZT00='Y' and not exists(select 1 from SB_GDZCZJ where DAXXID=a.DAXXID and TQNF00='2011' and TQYF00='12') and e.BMBH00=b.BMBH00 and substr(a.RZRQ00,1,6)<='201112' and A.CKBH00= 175 group by e.bmbh00,BMMC00,BH0000,BMXZ00 ) group by bmbh00,BMMC00,BH0000,SX union all select BMMC00,BMBH00,BH0000,SX,sum(YZ0000) YZ0000,sum(BYZJE0) BYZJE0,sum(BYBTJE) BYBTJE, sum(LJZJ00) LJZJ00,sum(JZ0000) JZ0000 from ( select ' 部门合计' BMMC00 ,1000 BMBH00,'' BH0000, NVL(sum(D.TQYZ00),0) YZ0000, NVL(sum(D.BYZJE0),0) BYZJE0, NVL(sum(D.BYBTJE),0) BYBTJE, NVL(sum(D.LJZJJE),0) LJZJ00, NVL(sum(D.ZJHJZ0),0) JZ0000, E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_GDZCZJ D where A.DAXXID=D.DAXXID and D.TQKS00=E.BMBH00 and D.TQNF00 =2011 and D.TQYF00 =12 and A.SHJSZJ ='1' and A.CKBH00= 175 group by E.BMXZ00 union all select ' 部门合计' BMMC00,1000 BMBH00,'' BH0000,NVL(sum(F.FTJE00),0) YZ0000,0 BYZJE0, 0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00,NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000,E.BMXZ00 SX from SB_DA0000 A,BM_BMBM00 E,SB_SYKS00 F where A.DAXXID = F.DAXXID and F.bmbh00=E.bmbh00 and A.SHJSZJ = '2' and A.SFYX00='Y' and F.SYZT00='Y' and A.CKBH00= 175 group by E.BMXZ00 ) group by bmbh00,BMMC00,BH0000,SX union all select (select b.BMMC00 from BM_BMBM00 b where b.bmbh00=x.BMBH00 ) BMMC00, BMBH00,BH0000,SX,YZ0000,BYZJE0,BYBTJE,LJZJ00,JZ0000 from (select A.CKBH00 BMBH00,E.BH0000 BH0000, NVL(sum(a.yz0000),0) YZ0000,0 BYZJE0,0 BYBTJE, NVL(sum(nvl(A.LJZJ00,0)),0) LJZJ00, NVL(sum(nvl(A.jz0000,YZ0000)),0) JZ0000, 'x' SX from SB_DA0000 A,BM_BMBM00 E where A.CKBH00=E.BMBH00 and a.syzt00='1' and a.sfyx00='Y' and A.CKBH00= 175 and substr(A.RZRQ00,1,6)<='201112' group by A.CKBH00,E.BH0000 ) X order by SX,BMBH00