1       09:40:43  Log started for: 住院农村合作医疗接口
2       09:40:43  SQL Prepare: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.9.254','5','PrjZY_NBJK.exe'||'+'||'住院农村合作医疗接口','583','44844' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@3065:D614B46C0A26064218B70FD4A3BB940D' from dual

3       09:40:43  SQL Execute: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.9.254','5','PrjZY_NBJK.exe'||'+'||'住院农村合作医疗接口','583','44844' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@3065:D614B46C0A26064218B70FD4A3BB940D' from dual

4       09:40:43  SQL Data In: ORACLE - Rows affected = 1
5       09:40:43  SQL Prepare: ORACLE - Commit

6       09:40:43  SQL Execute: ORACLE - Commit

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

9       09:40:43  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

10      09:40:43  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

11      09:40:43  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

12      09:40:43  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='3065' and CZBZ00 in ('1') 

13      09:40:43  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='3065' and CZBZ00 in ('1') 

14      09:40:43  SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

15      09:40:43  SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

16      09:40:43  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.9.254','5','PrjZY_NBJK.exe'||'+'||'住院农村合作医疗接口','376','9970' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@3065:72A143B3DBA2629EC8E1E864B3E8ECD1' from dual

17      09:40:43  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.9.254','5','PrjZY_NBJK.exe'||'+'||'住院农村合作医疗接口','376','9970' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@3065:72A143B3DBA2629EC8E1E864B3E8ECD1' from dual

18      09:40:43  SQL Data In: ORACLE - Rows affected = 1
19      09:40:43  SQL Prepare: ORACLE - Commit

20      09:40:43  SQL Execute: ORACLE - Commit

21      09:40:43  SQL Data In: ORACLE - Rows affected = 0
22      09:40:43  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='5'

23      09:40:43  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='5'

24      09:40:43  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='3065' and CZBZ00 in ('1') 

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

26      09:40:43  SQL Prepare: ORACLE - Select SYSDATE from Dual

27      09:40:43  SQL Execute: ORACLE - Select SYSDATE from Dual

28      09:40:43  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

29      09:40:43  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

30      09:40:43  SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

31      09:40:43  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

32      09:40:43  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='5'

33      09:40:43  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='5'

34      09:40:43  SQL Prepare: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

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

36      09:40: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

37      09:40: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

38      09:40: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 = ''

39      09:40: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 = ''

40      09:40: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)='3065')) 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)='3065'))
 order by b.PLXH00,a.BH0000

41      09:40: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)='3065')) 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)='3065'))
 order by b.PLXH00,a.BH0000

42      09:40:43  SQL Prepare: ORACLE -  Select '0' as XTDM00 from dual where 
'3065'='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)='3065'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='5' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3065') 

43      09:40:43  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'3065'='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)='3065'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='5' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3065') 

44      09:40:43  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=634

45      09:40:43  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=634

46      09:40:43  SQL Prepare: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

47      09:40:43  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

48      09:40:43  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

49      09:40:43  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

50      09:40:43  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

51      09:40:43  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

52      09:40:43  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

53      09:40:43  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

54      09:40: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'))

55      09:40: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'))

56      09:40:43  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(3048524,634,'门诊三楼农合-3','5',nvl('38378485',' '),'192.168.9.254#376:9970@PrjZY_NBJK.exe+住院农村合作医疗接口',43)

57      09:40:43  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(3048524,634,'门诊三楼农合-3','5',nvl('38378485',' '),'192.168.9.254#376:9970@PrjZY_NBJK.exe+住院农村合作医疗接口',43)

58      09:40:43  SQL Data In: ORACLE - Rows affected = 1
59      09:40:43  SQL Prepare: ORACLE - Commit

60      09:40:43  SQL Execute: ORACLE - Commit

61      09:40:43  SQL Data In: ORACLE - Rows affected = 0
62      09:40:43  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 43

63      09:40:43  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 43

64      09:40:43  SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

65      09:40:43  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

66      09:40:43  SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

67      09:40:43  SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

68      09:40:44  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.254'

69      09:40:44  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.254'

70      09:40:44  SQL Prepare: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

71      09:40:44  SQL Execute: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

72      09:40:44  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
43 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

73      09:40:44  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
43 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

74      09:40:44  SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

75      09:40:44  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

76      09:40:44  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 

77      09:40:44  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 

78      09:40:45  SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='634' and name00='SYSTEMSKIN'

79      09:40:45  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='634' and name00='SYSTEMSKIN'

80      09:40:45  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

81      09:40:45  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

82      09:40:45  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='5') and YXQ000>='20120521'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',43,' )>0 )

83      09:40:45  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='5') and YXQ000>='20120521'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',43,' )>0 )

84      09:40:45  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

85      09:40:45  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

86      09:40:45  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

87      09:40:45  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

88      09:40:45  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'

89      09:40:45  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'

90      09:40:45  SQL Prepare: ORACLE -  select sysdate nowtime  from dual  

91      09:40:45  SQL Execute: ORACLE -  select sysdate nowtime  from dual  

92      09:40:45  SQL Prepare: ORACLE -  select  *  from  XT_YHCS00  where  YGBH00 = 634

93      09:40:45  SQL Execute: ORACLE -  select  *  from  XT_YHCS00  where  YGBH00 = 634

94      09:40:45  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')

95      09:40:45  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')

96      09:40:45  SQL Prepare: ORACLE -  select  *  from  IC_YBBRLB WHERE YBLB00='Z'

97      09:40:45  SQL Execute: ORACLE -  select  *  from  IC_YBBRLB WHERE YBLB00='Z'

98      09:40:45  SQL Prepare: ORACLE - select  VALUE0 from  xt_xtcs00  where  name00 = 'ZY_SFYDDYJ'

99      09:40:45  SQL Execute: ORACLE - select  VALUE0 from  xt_xtcs00  where  name00 = 'ZY_SFYDDYJ'

100     09:40:45  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSJD'

101     09:40:45  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSJD'

102     09:40:45  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_KPYHDYFS'

103     09:40:45  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_KPYHDYFS'

104     09:40:45  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_SFQYHZYLJK'

105     09:40:45  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_SFQYHZYLJK'

106     09:40:45  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_DATAPATH'

107     09:40:45  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_DATAPATH'

108     09:40:45  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_HZYLBRFB'

109     09:40:45  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_HZYLBRFB'

110     09:40:45  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_CXZRSFZFYFP'

111     09:40:45  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_CXZRSFZFYFP'

112     09:40:45  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YYIDPDDLKS'

113     09:40:45  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YYIDPDDLKS'

114     09:40:45  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXLFYCY'

115     09:40:45  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXLFYCY'

116     09:40:45  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFCSSYFMBQBM'

117     09:40:45  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFCSSYFMBQBM'

118     09:40:45  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_NHSYBRSFAPTLBRY'

119     09:40:45  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_NHSYBRSFAPTLBRY'

120     09:40:45  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDZFBLSFYBBL'

121     09:40:45  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDZFBLSFYBBL'

122     09:40:45  SQL Prepare: ORACLE -  select * from xt_yyxx00 where rownum=1

123     09:40:45  SQL Execute: ORACLE -  select * from xt_yyxx00 where rownum=1

124     09:40:45  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','NH_BRCYSFFSCYDJRQ')

125     09:40:45  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','NH_BRCYSFFSCYDJRQ')

126     09:40:45  SQL Prepare: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='3065'

127     09:40:45  SQL Execute: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='3065'

128     09:40:48  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='5' and (( 
634= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=634 and XTDM00='5'))) 

129     09:40:48  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='5' and (( 
634= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=634 and XTDM00='5'))) 

130     09:40:49  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

131     09:40:49  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

132     09:40:49  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 ((634= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=634 and XTDM00='0 '))) 

133     09:40:49  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 ((634= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=634 and XTDM00='0 '))) 

134     09:40:49  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

135     09:40:49  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

136     09:40:49  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 
634= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=634 and XTDM00='+ '))) 

137     09:40:49  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 
634= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=634 and XTDM00='+ '))) 

138     09:40:49  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'

139     09:40:49  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'

140     09:40:49  SQL Data In: ORACLE - Rows affected = 0
141     09:40:49  SQL Prepare: ORACLE - Commit

142     09:40:49  SQL Execute: ORACLE - Commit

143     09:40:49  SQL Data In: ORACLE - Rows affected = 0
144     09:41:12  SQL Prepare: ORACLE -  select * from VW_NH_ZFJZB0  where  CYRQ00 >= :1
 and  CYRQ00 <= :2
 and  ZYH000 like :3
 and  BRZT00  in ('4','5' ) 

145     09:41:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120501
146     09:41:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120521
147     09:41:12  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 232889%
148     09:41:12  SQL Execute: ORACLE -  select * from VW_NH_ZFJZB0  where  CYRQ00 >= ?
 and  CYRQ00 <= ?
 and  ZYH000 like ?
 and  BRZT00  in ('4','5' ) 

149     09:41:13  SQL Prepare: ORACLE - select * from VW_NH_JZB000 where JZDH00=:1

150     09:41:13  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 459662.000000
151     09:41:13  SQL Execute: ORACLE - select * from VW_NH_JZB000 where JZDH00=?

152     09:41:18  SQL Prepare: ORACLE -  select * from VW_NH_ZFJZB0  where  CYRQ00 >= :1
 and  CYRQ00 <= :2
 and  ZYH000 like :3
 and  BRZT00  in ('4','5' ) 

153     09:41:18  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120501
154     09:41:18  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120521
155     09:41:18  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 232889%
156     09:41:18  SQL Execute: ORACLE -  select * from VW_NH_ZFJZB0  where  CYRQ00 >= ?
 and  CYRQ00 <= ?
 and  ZYH000 like ?
 and  BRZT00  in ('4','5' ) 

157     09:41:18  SQL Prepare: ORACLE - select * from VW_NH_JZB000 where JZDH00=:1

158     09:41:18  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 459662.000000
159     09:41:18  SQL Execute: ORACLE - select * from VW_NH_JZB000 where JZDH00=?