1       11:00:52  Log started for: Gysystem
2       11:00:53  SQL Prepare: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20120731','11:00:50','scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

3       11:00:53  SQL Execute: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20120731','11:00:50','scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

4       11:00:53  SQL Data In: ORACLE - Rows affected = 1
5       11:00:53  SQL Prepare: ORACLE - Commit

6       11:00:53  SQL Execute: ORACLE - Commit

7       11:00:53  SQL Data In: ORACLE - Rows affected = 0
8       11:00:53  SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

9       11:00:53  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

10      11:00:53  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

11      11:00:53  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

12      11:00:53  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

13      11:00:53  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

14      11:00:53  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20120731','11:00:50','sd_hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

15      11:00:53  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.12.120','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20120731','11:00:50','sd_hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

16      11:00:53  SQL Data In: ORACLE - Rows affected = 1
17      11:00:53  SQL Prepare: ORACLE - Commit

18      11:00:53  SQL Execute: ORACLE - Commit

19      11:00:53  SQL Data In: ORACLE - Rows affected = 0
20      11:00:53  SQL Prepare: ORACLE -  delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 

21      11:00:53  SQL Execute: ORACLE -  delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 

22      11:00:53  SQL Data In: ORACLE - Rows affected = 0
23      11:00:53  SQL Prepare: ORACLE - Commit

24      11:00:53  SQL Execute: ORACLE - Commit

25      11:00:53  SQL Data In: ORACLE - Rows affected = 0
26      11:00:53  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='F'

27      11:00:53  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='F'

28      11:00:53  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

29      11:00:53  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 

30      11:00:53  SQL Prepare: ORACLE - Select SYSDATE from Dual

31      11:00:53  SQL Execute: ORACLE - Select SYSDATE from Dual

32      11:00:53  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

33      11:00:53  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

34      11:00:53  SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

35      11:00:53  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

36      11:00:53  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='F'

37      11:00:53  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='F'

38      11:00:53  SQL Prepare: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

39      11:00:53  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

40      11:00:53  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

41      11:00:53  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

42      11:00:53  SQL Prepare: 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)='9998'))
 order by BH0000

43      11:00:53  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)='9998'))
 order by BH0000

44      11:01:36  SQL Prepare: ORACLE -  Select '0' as XTDM00 from dual where 
'9998'='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)='9998'))

45      11:01:36  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'9998'='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)='9998'))

46      11:01:36  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476

47      11:01:36  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476

48      11:01:36  SQL Prepare: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

49      11:01:36  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

50      11:01:36  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

51      11:01:36  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

52      11:01:36  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

53      11:01:36  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

54      11:01:36  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

55      11:01:36  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

56      11:01:36  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'))

57      11:01:36  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'))

58      11:01:36  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(3140216,476,'wlzx-3','F',nvl('38889243',' '),'192.168.12.120#906:5364@GYSystem.exe+供应室管理子系统',150)

59      11:01:36  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(3140216,476,'wlzx-3','F',nvl('38889243',' '),'192.168.12.120#906:5364@GYSystem.exe+供应室管理子系统',150)

60      11:01:36  SQL Data In: ORACLE - Rows affected = 1
61      11:01:36  SQL Prepare: ORACLE - Commit

62      11:01:36  SQL Execute: ORACLE - Commit

63      11:01:36  SQL Data In: ORACLE - Rows affected = 0
64      11:01:36  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 150

65      11:01:36  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 150

66      11:01:36  SQL Prepare: ORACLE -  Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 

67      11:01:36  SQL Execute: ORACLE -  Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 

68      11:01:36  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120'

69      11:01:36  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120'

70      11:01:36  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y'

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

72      11:01:36  SQL Prepare: ORACLE -  update XT_SQIPDZ set ZT0000='1' where JQBH00=0

73      11:01:36  SQL Execute: ORACLE -  update XT_SQIPDZ set ZT0000='1' where JQBH00=0

74      11:01:36  SQL Data In: ORACLE - Rows affected = 0
75      11:01:36  SQL Prepare: ORACLE - Commit

76      11:01:36  SQL Execute: ORACLE - Commit

77      11:01:36  SQL Data In: ORACLE - Rows affected = 0
78      11:01:36  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
150 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

79      11:01:36  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
150 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

80      11:01:36  SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

81      11:01:36  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

82      11:01:36  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 

83      11:01:36  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 

84      11:01:37  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

85      11:01:37  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

86      11:01:37  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='F') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',150,')> 0) and YXQ000>='20120731'

87      11:01:37  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 ||',', ',150,')> 0) and YXQ000>='20120731'

88      11:01:37  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

89      11:01:37  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

90      11:01:37  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

91      11:01:37  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

92      11:01:38  SQL Prepare: ORACLE - select sysdate from dual

93      11:01:38  SQL Execute: ORACLE - select sysdate from dual

94      11:01:38  SQL Prepare: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS<>'VALID'

95      11:01:38  SQL Execute: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS<>'VALID'

96      11:01:38  SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS='VALID'

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

98      11:01:38  SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_GY_%' AND STATUS<>'ENABLED'

99      11:01:38  SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_GY_%' AND STATUS<>'ENABLED'

100     11:01:38  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX'

101     11:01:38  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX'

102     11:01:38  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='F' and (( 
476= 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=476))))

103     11:01:38  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='F' and (( 
476= 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=476))))

104     11:01:38  SQL Prepare: 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

105     11:01:38  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

106     11:01:38  SQL Prepare: ORACLE - select count(*)  from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where  A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0'  and  MKDM00 in (select MKDM00 from XT_ZBQX00  where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476))))  

107     11:01:38  SQL Execute: ORACLE - select count(*)  from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where  A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0'  and  MKDM00 in (select MKDM00 from XT_ZBQX00  where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476))))  

108     11:01:38  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='+' and (( 
476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=476))))

109     11:01:38  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='+' and (( 
476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=476))))

110     11:01:38  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=476))))

111     11:01:38  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=476))))

112     11:01:38  SQL Prepare: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1

113     11:01:38  SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1

114     11:01:38  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM')
 and YGBH00 = 476

115     11:01:38  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM')
 and YGBH00 = 476

116     11:01:38  SQL Prepare: 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','GY_WPDBXDYXQTS','GY_WPCKTJXSSZ','GY_LYWPHSCXSFXSWPTJ' 
)

117     11:01:38  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','GY_WPDBXDYXQTS','GY_WPCKTJXSSZ','GY_LYWPHSCXSFXSWPTJ' 
)

118     11:01:38  SQL Prepare: ORACLE - Select Name00,value0 from XT_XTCS00 where name00='GY_WLYYDY'

119     11:01:38  SQL Execute: ORACLE - Select Name00,value0 from XT_XTCS00 where name00='GY_WLYYDY'

120     11:01:38  SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPXSFY'

121     11:01:38  SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPXSFY'

122     11:01:38  SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYLB'

123     11:01:38  SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYLB'

124     11:01:38  SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYZDYID'

125     11:01:38  SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYZDYID'

126     11:01:38  SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00=476 and name00='GY_QSBRLB'

127     11:01:38  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00=476 and name00='GY_QSBRLB'

128     11:01:38  SQL Prepare: ORACLE - SELECT 1 FLAG00 FROM vw_gy_wpgqgl A  Where gyksbh=:1 and yxq000<:2 

129     11:01:38  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 150.000000
130     11:01:38  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120731
131     11:01:38  SQL Execute: ORACLE - SELECT 1 FLAG00 FROM vw_gy_wpgqgl A  Where gyksbh=? and yxq000<? 

132     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprk00  
 where  QLRQ00 BETWEEN :1 AND :2
 AND QLKSBH LIKE :3 

133     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120724
134     11:01:47  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120731
135     11:01:47  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150
136     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprk00  
 where  QLRQ00 BETWEEN ? AND ?
 AND QLKSBH LIKE ? 

137     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

138     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 871
139     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

140     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

141     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 873
142     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

143     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

144     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 868
145     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

146     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

147     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 867
148     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

149     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

150     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 875
151     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

152     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

153     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 869
154     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

155     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

156     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 869
157     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

158     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

159     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 871
160     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

161     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

162     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 871
163     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

164     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

165     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 871
166     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

167     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

168     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 873
169     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

170     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

171     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 868
172     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

173     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

174     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 867
175     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

176     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

177     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 875
178     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

179     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

180     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 869
181     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

182     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

183     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 869
184     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

185     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

186     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 871
187     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

188     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

189     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 871
190     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

191     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

192     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 871
193     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

194     11:01:47  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0 in  (select rkdid0 from vw_gy_wprk00  
 where  QLRQ00 BETWEEN :1 AND :2
 AND QLKSBH LIKE :3 
  ) order by RKRQ00,wpxz00

195     11:01:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120724
196     11:01:47  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120731
197     11:01:47  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150
198     11:01:47  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0 in  (select rkdid0 from vw_gy_wprk00  
 where  QLRQ00 BETWEEN ? AND ?
 AND QLKSBH LIKE ? 
  ) order by RKRQ00,wpxz00

199     11:01:52  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

200     11:01:52  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 871
201     11:01:52  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

202     11:01:52  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

203     11:01:52  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 869
204     11:01:52  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

205     11:01:55  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

206     11:01:55  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 869
207     11:01:55  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

208     11:01:55  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

209     11:01:55  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 875
210     11:01:55  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

211     11:01:58  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

212     11:01:58  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 875
213     11:01:58  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

214     11:01:58  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

215     11:01:58  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 869
216     11:01:58  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

217     11:01:59  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

218     11:01:59  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 869
219     11:01:59  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

220     11:01:59  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

221     11:01:59  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 875
222     11:01:59  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

223     11:01:59  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

224     11:01:59  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 875
225     11:01:59  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

226     11:01:59  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

227     11:01:59  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 869
228     11:01:59  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

229     11:02:01  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

230     11:02:01  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 869
231     11:02:01  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

232     11:02:01  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

233     11:02:01  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 875
234     11:02:01  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

235     11:02:02  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

236     11:02:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 875
237     11:02:02  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

238     11:02:02  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

239     11:02:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 869
240     11:02:02  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

241     11:02:02  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

242     11:02:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 869
243     11:02:02  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00

244     11:02:02  SQL Prepare: ORACLE - select * from vw_gy_wprkmx where rkdid0=:1
order by wpxz00

245     11:02:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 875
246     11:02:02  SQL Execute: ORACLE - select * from vw_gy_wprkmx where rkdid0=?
order by wpxz00