1       14:43:09  Log started for: Gysystem
2       14:43:09  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)

3       14:43:09  SQL Execute: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.1.29','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20100830','14:43:09','scott@7778:B0E0EFF8967C0EE31A949389ED7F46A0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

4       14:43:09  SQL Data In: ORACLE - Rows affected = 1
5       14:43:09  SQL Execute: ORACLE - Commit

6       14:43:09  SQL Data In: ORACLE - Rows affected = 0
7       14:43:09  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

8       14:43:09  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='7778' and CZBZ00 in ('1') 

9       14:43:09  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.1.29','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20100830','14:43:09','sd_hospital@7778:FE3E45984FBB5E0E80467F41BE17414E' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

10      14:43:09  SQL Data In: ORACLE - Rows affected = 1
11      14:43:09  SQL Execute: ORACLE - Commit

12      14:43:09  SQL Data In: ORACLE - Rows affected = 0
13      14:43:09  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='F'

14      14:43:09  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='7778' and CZBZ00 in ('1') 

15      14:43:09  SQL Execute: ORACLE - Select SYSDATE from Dual

16      14:43:09  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

17      14:43:09  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

18      14:43:09  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='F'

19      14:43:09  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

20      14:43:09  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

21      14:43:09  SQL Execute: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('a','0','1','2','3','4','5','6','8','9')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='F'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='7778'))
 order by BH0000

22      14:43:10  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'7778'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'F' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='7778'))

23      14:43:10  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=952

24      14:43:10  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

25      14:43:10  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

26      14:43:10  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

27      14:43:10  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

28      14:43:10  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'))

29      14:43:11  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(2074747,952,'电脑中心01','F',nvl('2640993',' '),'192.168.1.29#173:3703@GYSystem.exe+供应室管理子系统',131)

30      14:43:11  SQL Data In: ORACLE - Rows affected = 1
31      14:43:11  SQL Execute: ORACLE - Commit

32      14:43:11  SQL Data In: ORACLE - Rows affected = 0
33      14:43:11  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 131

34      14:43:11  SQL Execute: ORACLE -  Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 

35      14:43:11  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.1.29'

36      14:43:11  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y'

37      14:43:11  SQL Execute: ORACLE -  update XT_SQIPDZ set ZT0000='1' where JQBH00=0

38      14:43:11  SQL Data In: ORACLE - Rows affected = 0
39      14:43:11  SQL Execute: ORACLE - Commit

40      14:43:11  SQL Data In: ORACLE - Rows affected = 0
41      14:43:11  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
131 and FLAG00 like '%'
 order by decode(CKBH00,2,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

42      14:43:11  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('221094') 

43      14:43:11  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

44      14:43:11  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='F') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',131,')> 0) and YXQ000>='20100830'

45      14:43:11  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

46      14:43:11  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

47      14:43:11  SQL Execute: ORACLE - select sysdate from dual

48      14:43:11  SQL Execute: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS<>'VALID'

49      14:43:11  SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS='VALID'

50      14:43:11  SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_GY_%' AND STATUS<>'ENABLED'

51      14:43:11  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX'

52      14:43:11  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='F' and (( 
952= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='F' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=952))))

53      14:43:11  SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'F$%' and A.XTDM00='F' and trim(A.MKDM00)='F$'||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

54      14:43:11  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 ((952= 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=952))))  

55      14:43:11  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='+' and (( 
952= 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=952))))

56      14:43:11  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
952= 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=952))))

57      14:43:11  SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1

58      14:43:11  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM')
 and YGBH00 = 952

59      14:43:11  SQL Execute: ORACLE - Select value0,name00 from XT_XTCS00 where name00 in('GY_ZDYYCS','GY_HSQRDYSFAKSFL','GY_WPKCCXFS','GY_YJZWPLYSFZJFF','GY_WPCKTJFS','GY_WPCKTJHJXSSFWL','GY_WPRKSCCJSFYXZJLR','GY_WPHSSFHZ','WZ_SYDJJEBLSWXS','GY_WPLYSFYXBTLXTYD','GY_WPHSQRTHYYHSSFXSSZ', 
'GY_WPLYQRHZDY','GY_WPHSQRXSPCXX','GY_WPLYQRSFFKXX' 
)

60      14:43:11  SQL Execute: ORACLE - Select Name00,value0 from XT_XTCS00 where name00='GY_WLYYDY'

61      14:43:11  SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPXSFY'

62      14:43:11  SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYLB'

63      14:43:11  SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYZDYID'

64      14:43:11  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00=952 and name00='GY_QSBRLB'

65      14:43:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 131.000000
66      14:43:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100830
67      14:43:11  SQL Execute: ORACLE - SELECT 1 FLAG00 FROM vw_gy_wpgqgl A  Where gyksbh=? and yxq000<? 

68      14:43:19  Log started for: Gysystem
69      14:43:19  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)

70      14:43:19  SQL Execute: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.1.29','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20100830','14:43:19','scott@7778:B0E0EFF8967C0EE31A949389ED7F46A0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

71      14:43:19  SQL Data In: ORACLE - Rows affected = 1
72      14:43:19  SQL Execute: ORACLE - Commit

73      14:43:19  SQL Data In: ORACLE - Rows affected = 0
74      14:43:19  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

75      14:43:19  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='7778' and CZBZ00 in ('1') 

76      14:43:19  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.1.29','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20100830','14:43:19','sd_hospital@7778:FE3E45984FBB5E0E80467F41BE17414E' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

77      14:43:19  SQL Data In: ORACLE - Rows affected = 1
78      14:43:19  SQL Execute: ORACLE - Commit

79      14:43:19  SQL Data In: ORACLE - Rows affected = 0
80      14:43:19  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='F'

81      14:43:19  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='7778' and CZBZ00 in ('1') 

82      14:43:19  SQL Execute: ORACLE - Select SYSDATE from Dual

83      14:43:19  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

84      14:43:19  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

85      14:43:19  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='F'

86      14:43:19  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

87      14:43:19  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

88      14:43:19  SQL Execute: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('a','0','1','2','3','4','5','6','8','9')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='F'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='7778'))
 order by BH0000

89      14:43:21  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'7778'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'F' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='7778'))

90      14:43:21  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=952

91      14:43:21  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

92      14:43:21  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

93      14:43:21  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

94      14:43:21  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

95      14:43:21  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'))

96      14:43:22  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(2074748,952,'电脑中心01','F',nvl('2640995',' '),'192.168.1.29#217:6004@GYSystem.exe+供应室管理子系统',77)

97      14:43:22  SQL Data In: ORACLE - Rows affected = 1
98      14:43:22  SQL Execute: ORACLE - Commit

99      14:43:22  SQL Data In: ORACLE - Rows affected = 0
100     14:43:22  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 77

101     14:43:22  SQL Execute: ORACLE -  Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 

102     14:43:22  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.1.29'

103     14:43:22  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y'

104     14:43:22  SQL Execute: ORACLE -  update XT_SQIPDZ set ZT0000='1' where JQBH00=0

105     14:43:22  SQL Data In: ORACLE - Rows affected = 0
106     14:43:22  SQL Execute: ORACLE - Commit

107     14:43:22  SQL Data In: ORACLE - Rows affected = 0
108     14:43:22  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
77 and FLAG00 like '%'
 order by decode(CKBH00,2,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

109     14:43:22  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('221094') 

110     14:43:22  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

111     14:43:22  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='F') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',77,')> 0) and YXQ000>='20100830'

112     14:43:22  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

113     14:43:22  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

114     14:43:22  SQL Execute: ORACLE - select sysdate from dual

115     14:43:22  SQL Execute: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS<>'VALID'

116     14:43:22  SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS='VALID'

117     14:43:22  SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_GY_%' AND STATUS<>'ENABLED'

118     14:43:22  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX'

119     14:43:22  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='F' and (( 
952= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='F' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=952))))

120     14:43:22  SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'F$%' and A.XTDM00='F' and trim(A.MKDM00)='F$'||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

121     14:43:22  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 ((952= 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=952))))  

122     14:43:22  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='+' and (( 
952= 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=952))))

123     14:43:22  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
952= 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=952))))

124     14:43:22  SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1

125     14:43:22  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM')
 and YGBH00 = 952

126     14:43:22  SQL Execute: ORACLE - Select value0,name00 from XT_XTCS00 where name00 in('GY_ZDYYCS','GY_HSQRDYSFAKSFL','GY_WPKCCXFS','GY_YJZWPLYSFZJFF','GY_WPCKTJFS','GY_WPCKTJHJXSSFWL','GY_WPRKSCCJSFYXZJLR','GY_WPHSSFHZ','WZ_SYDJJEBLSWXS','GY_WPLYSFYXBTLXTYD','GY_WPHSQRTHYYHSSFXSSZ', 
'GY_WPLYQRHZDY','GY_WPHSQRXSPCXX','GY_WPLYQRSFFKXX' 
)

127     14:43:22  SQL Execute: ORACLE - Select Name00,value0 from XT_XTCS00 where name00='GY_WLYYDY'

128     14:43:22  SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPXSFY'

129     14:43:22  SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYLB'

130     14:43:22  SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYZDYID'

131     14:43:22  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00=952 and name00='GY_QSBRLB'

132     14:43:22  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 77.000000
133     14:43:22  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20100830
134     14:43:22  SQL Execute: ORACLE - SELECT 1 FLAG00 FROM vw_gy_wpgqgl A  Where gyksbh=? and yxq000<? 

135     14:43:26  SQL Execute: ORACLE - SELECT BMBH00,BMMC00 FROM vw_gy_gyxgks

136     14:43:27  SQL Execute: ORACLE - SELECT X.GYKSBH, (SELECT BMMC00 FROM BM_BMBM00 WHERE BMBH00 = X.GYKSBH) KSMC00,  
  SUM(X.QCJC00) QCJC00, SUM(X.BQZJ00) BQZJ00, SUM(X.BQJS00) BQJS00, SUM(X.BQJC00) BQJC00 FROM (
SELECT A.GYKSBH, A.WPBH00, B.WPMC00, B.WPGG00, SUM(QCJC00*B.WPDJ00) QCJC00, SUM(BQZJ00*B.WPDJ00) BQZJ00,
  SUM(BQJS00*B.WPDJ00) BQJS00, SUM(BQJC00*B.WPDJ00) BQJC00 FROM (
  SELECT GYKSBH, WPBH00, ROUND(NVL(SUM(decode(JZXZ00,'R', NVL(RKSL00,0))),0)- NVL(SUM(decode(JZXZ00,'C',NVL(CKSL00,0))),0),2) QCJC00,0 BQZJ00,0 BQJS00,0 BQJC00
    FROM VW_GY_WPMXZ0 A
  WHERE jzrq00 < '20100830'
  GROUP BY GYKSBH, WPBH00 
  UNION ALL
  SELECT GYKSBH, WPBH00, 0 QCJC00,ROUND(NVL(SUM(decode(JZXZ00,'R',NVL(RKSL00,0))),0),2) BQZJ00,ROUND(NVL(SUM(decode(JZXZ00,'C',NVL(CKSL00,0))),0),2) BQJS00,0 BQJC00
    FROM VW_GY_WPMXZ0
  WHERE jzrq00 BETWEEN '20100830' AND '20100830' 
  GROUP BY GYKSBH, WPBH00 
  UNION ALL
  SELECT GYKSBH, WPBH00,  0 QCJC00,0 BQZJ00,0 BQJS00,ROUND(NVL(SUM(decode(JZXZ00,'R',NVL(RKSL00,0))),0)-NVL(SUM(decode(JZXZ00,'C',NVL(CKSL00,0))),0),2) BQJC00
    FROM VW_GY_WPMXZ0
  WHERE jzrq00 <= '20100830' 
  GROUP BY GYKSBH, WPBH00 
 ) A, GY_WPBM00 B WHERE A.WPBH00 = B.WPBH00 GROUP BY A.GYKSBH, A.WPBH00, B.WPMC00, B.WPGG00
) X GROUP BY GYKSBH 

137     14:43:27  SQL Error: ORACLE - ORA-00979: 不是 GROUP BY 表达式

138     14:43:27  SQL Error: ORACLE - Unmapped SQL Error Code: 979
139     14:43:27  SQL Data In: ORACLE - Rows affected = 0