1       10:19:34  Log started for: 住院收费管理系统
2       10:19:34  SQL Prepare: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '172.17.193.65','5',trim(PROGRAM)||'+'||'住院收费管理系统',SID,serial# ,'20100111','10:19:34','scott@3077:BDA5ED27AF78E6AA46BB62A5223098CD' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

3       10:19:34  SQL Execute: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '172.17.193.65','5',trim(PROGRAM)||'+'||'住院收费管理系统',SID,serial# ,'20100111','10:19:34','scott@3077:BDA5ED27AF78E6AA46BB62A5223098CD' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

4       10:19:34  SQL Prepare: ORACLE - Commit

5       10:19:34  SQL Execute: ORACLE - Commit

6       10:19:34  SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

7       10:19:34  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

8       10:19:34  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

9       10:19:34  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

10      10:19:34  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='3077' and CZBZ00 in ('1') 

11      10:19:34  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='3077' and CZBZ00 in ('1') 

12      10:19:34  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '172.17.193.65','5',trim(PROGRAM)||'+'||'住院收费管理系统',SID,serial# ,'20100111','10:19:34','sd_Hospital@3077:BFC984A21B1B77B0763915224C4A6239' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

13      10:19:34  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '172.17.193.65','5',trim(PROGRAM)||'+'||'住院收费管理系统',SID,serial# ,'20100111','10:19:34','sd_Hospital@3077:BFC984A21B1B77B0763915224C4A6239' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

14      10:19:34  SQL Prepare: ORACLE - Commit

15      10:19:34  SQL Execute: ORACLE - Commit

16      10:19:34  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='5'

17      10:19:34  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='5'

18      10:19:34  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='3077' and CZBZ00 in ('1') 

19      10:19:34  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='3077' and CZBZ00 in ('1') 

20      10:19:34  SQL Prepare: ORACLE - Select SYSDATE from Dual

21      10:19:34  SQL Execute: ORACLE - Select SYSDATE from Dual

22      10:19:34  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

23      10:19:34  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

24      10:19:34  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='5'

25      10:19:34  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='5'

26      10:19:34  SQL Prepare: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

27      10:19:34  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

28      10:19:34  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 = 'YB-FZYB'

29      10:19:34  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 = 'YB-FZYB'

30      10:19:34  SQL Prepare: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('4')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='5'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3077'))
 order by BH0000

31      10:19:34  SQL Execute: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('4')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='5'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3077'))
 order by BH0000

32      10:19:34  SQL Prepare: ORACLE -  Select '0' as XTDM00 from dual where 
'3077'='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)='3077'))

33      10:19:34  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'3077'='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)='3077'))

34      10:19:34  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=697

35      10:19:34  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=697

36      10:19:34  SQL Prepare: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

37      10:19:34  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

38      10:19:34  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

39      10:19:34  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

40      10:19:34  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

41      10:19:34  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

42      10:19:34  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

43      10:19:34  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

44      10:19:34  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'))

45      10:19:34  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'))

46      10:19:34  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(2016796,697,'user','5',nvl('886920',' '),'172.17.193.65#485:14594@PRJZY_ZYSF.EXE+住院收费管理系统',43)

47      10:19:34  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(2016796,697,'user','5',nvl('886920',' '),'172.17.193.65#485:14594@PRJZY_ZYSF.EXE+住院收费管理系统',43)

48      10:19:34  SQL Prepare: ORACLE - Commit

49      10:19:34  SQL Execute: ORACLE - Commit

50      10:19:34  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 43

51      10:19:34  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 43

52      10:19:34  SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137'

53      10:19:34  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137'

54      10:19:34  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='172.17.193.65'

55      10:19:34  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='172.17.193.65'

56      10:19:34  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG')

57      10:19:34  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG')

58      10:19:34  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
43 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

59      10:19:34  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
43 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

60      10:19:34  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='5') and YXQ000>='20100111'

61      10:19:34  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='5') and YXQ000>='20100111'

62      10:19:35  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

63      10:19:35  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

64      10:19:35  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

65      10:19:35  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

66      10:19:35  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'

67      10:19:35  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'

68      10:19:35  SQL Prepare: ORACLE -  select sysdate nowtime  from dual  

69      10:19:35  SQL Execute: ORACLE -  select sysdate nowtime  from dual  

70      10:19:35  SQL Prepare: ORACLE -  select  *  from  XT_YHCS00  where  YGBH00 = 697

71      10:19:35  SQL Execute: ORACLE -  select  *  from  XT_YHCS00  where  YGBH00 = 697

72      10:19:35  SQL Prepare: ORACLE -  select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_PJHSC0','ZY_MRNZYH','ZY_DYYBFP','XT_JEQZ00','SF_ZHTYJE','SF_ZHBJJE','ZY_YBJSTKD','ZY_SFYJS0_BZ0000','ZY_WJZBNCY','ZY_PRINTSCALE','ZY_XTDBQX','ZY_XTQFQX','ZY_QXCYQX','ZY_TKPAR0_CZY000','ZY_RQDZZ0_SETUP0','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_YTFSFYXCY','SF_SFSYJZK','ZY_TJKSSJ','ZY_TJJSSJ','SF_YBBRXB','ZY_FPWidth','ZY_FPHeigh','ZY_ZYSFJJBSJ','ZY_SYDJKYDBQF','ZY_PJLYXYLYQR','XT_QDXXZHYE','XT_QDXXZHYE_LX','ZY_JKDSFTD','ZY_JKSFAJJBSJ','ZY_ZYJKDGS0','ZY_YJJDJGS','ZY_YBRQDFS','IC_YBYYJKLM','ZY_RYDJSFFZ','ZY_YBBRZFXMFS','SF_ZY_SFZDXS','SF_SFCFFP','ZY_FPTOP','ZY_SFFSXM','ZY_YBFPBH','ZY_SFQZGSYB','ZY_RQDGSCS','YF_ZYFJF_YPNM00','YF_CFMXJE_CZFS','XT_XYCYTCF','ZY_JMXMFS','ZY_EJBBSFCF','ZY_EJBBCFLS','ZY_EJBBCFHS','ZY_CYBRQFMXBB_SFCF','ZY_CYBRQFMXBBLS','ZY_CYBRQFMXBBHS','YF_CFMXJE_SRWS','YF_CFZJE_CZFS','ZY_RQDFPXMSFDY','SF_GFBRJKBXSRDW','YF_CFZJE_SRWS_YB','YF_CFZJE_SRWS','XT_ZYXTSFSYZLK',+'YF_CFZJE_CZFS_YB','ZY_RQDMX0_ZFHB','ZY_ZYDJBLHPB','ZY_ZYHSFZDSC','XT_JKTQSJ','ZY_CXJSSFDYDJ','ZY_YBRYSFSYDT','ZY_DYQBFP','ZY_FPLEFT','ZY_SFDYZLD','XT_TFXYSHBZ','ZY_RYDJTCTS','ZY_YJJGS0_SFDYYE','YF_AutoMatch','ZY_SFHHXMMX','ZY_SFDYTKTZS','ZY_JSTKAYJJFS','ZY_JSSRTDXXTJBBSFCF','ZY_JSSRTDXXTJBBCFLS','ZY_JSSRTDXXTJBBCFHS','ZY_SFDYBASY','ZY_SFDYJZD','ZY_FBZHXTYZ','ZY_SFMHEYJKD','ZY_NPYBCYJSXSYBZHZF','ZYSF_TDXMTDKS_YXQF','ZY_CRYTJSFAKS','ZY_PJWLYBNSY','ZY_PRINTBASYZDY','ZY_SFQYCZPJKPJK','ZY_KP_LJDLKPXTFS','ZY_KP_ZYFPDYPLBH','ZY_KP_FPZRDYMS','ZY_ZYFPSFXSFYBF','ZY_QDDYGJBMXSFS','ZY_JSBBSFXSJCJE','ZY_YYBRSFYWFY','BQ_YBCYSFBXLRCYZD','ZY_YBCYJSHZDCSBASY','ZY_JZSRKSSRSFCF','ZY_JZSRKSSRSFZDZTJKD','ZY_YBJKSFJHZHDK','ZY_YBCXJZRQ','ZY_YBFSKSMCZDHZS','ZYSF_RYDJMS','ZYSF_RYDJMRBQ','ZYSF_RYDJMRKS','ZY_WSZBRSFKYXGRYXX')

73      10:19:35  SQL Execute: ORACLE -  select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_PJHSC0','ZY_MRNZYH','ZY_DYYBFP','XT_JEQZ00','SF_ZHTYJE','SF_ZHBJJE','ZY_YBJSTKD','ZY_SFYJS0_BZ0000','ZY_WJZBNCY','ZY_PRINTSCALE','ZY_XTDBQX','ZY_XTQFQX','ZY_QXCYQX','ZY_TKPAR0_CZY000','ZY_RQDZZ0_SETUP0','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_YTFSFYXCY','SF_SFSYJZK','ZY_TJKSSJ','ZY_TJJSSJ','SF_YBBRXB','ZY_FPWidth','ZY_FPHeigh','ZY_ZYSFJJBSJ','ZY_SYDJKYDBQF','ZY_PJLYXYLYQR','XT_QDXXZHYE','XT_QDXXZHYE_LX','ZY_JKDSFTD','ZY_JKSFAJJBSJ','ZY_ZYJKDGS0','ZY_YJJDJGS','ZY_YBRQDFS','IC_YBYYJKLM','ZY_RYDJSFFZ','ZY_YBBRZFXMFS','SF_ZY_SFZDXS','SF_SFCFFP','ZY_FPTOP','ZY_SFFSXM','ZY_YBFPBH','ZY_SFQZGSYB','ZY_RQDGSCS','YF_ZYFJF_YPNM00','YF_CFMXJE_CZFS','XT_XYCYTCF','ZY_JMXMFS','ZY_EJBBSFCF','ZY_EJBBCFLS','ZY_EJBBCFHS','ZY_CYBRQFMXBB_SFCF','ZY_CYBRQFMXBBLS','ZY_CYBRQFMXBBHS','YF_CFMXJE_SRWS','YF_CFZJE_CZFS','ZY_RQDFPXMSFDY','SF_GFBRJKBXSRDW','YF_CFZJE_SRWS_YB','YF_CFZJE_SRWS','XT_ZYXTSFSYZLK',+'YF_CFZJE_CZFS_YB','ZY_RQDMX0_ZFHB','ZY_ZYDJBLHPB','ZY_ZYHSFZDSC','XT_JKTQSJ','ZY_CXJSSFDYDJ','ZY_YBRYSFSYDT','ZY_DYQBFP','ZY_FPLEFT','ZY_SFDYZLD','XT_TFXYSHBZ','ZY_RYDJTCTS','ZY_YJJGS0_SFDYYE','YF_AutoMatch','ZY_SFHHXMMX','ZY_SFDYTKTZS','ZY_JSTKAYJJFS','ZY_JSSRTDXXTJBBSFCF','ZY_JSSRTDXXTJBBCFLS','ZY_JSSRTDXXTJBBCFHS','ZY_SFDYBASY','ZY_SFDYJZD','ZY_FBZHXTYZ','ZY_SFMHEYJKD','ZY_NPYBCYJSXSYBZHZF','ZYSF_TDXMTDKS_YXQF','ZY_CRYTJSFAKS','ZY_PJWLYBNSY','ZY_PRINTBASYZDY','ZY_SFQYCZPJKPJK','ZY_KP_LJDLKPXTFS','ZY_KP_ZYFPDYPLBH','ZY_KP_FPZRDYMS','ZY_ZYFPSFXSFYBF','ZY_QDDYGJBMXSFS','ZY_JSBBSFXSJCJE','ZY_YYBRSFYWFY','BQ_YBCYSFBXLRCYZD','ZY_YBCYJSHZDCSBASY','ZY_JZSRKSSRSFCF','ZY_JZSRKSSRSFZDZTJKD','ZY_YBJKSFJHZHDK','ZY_YBCXJZRQ','ZY_YBFSKSMCZDHZS','ZYSF_RYDJMS','ZYSF_RYDJMRBQ','ZYSF_RYDJMRKS','ZY_WSZBRSFKYXGRYXX')

74      10:19:35  SQL Prepare: ORACLE -  select  *  from  IC_YBBRLB WHERE YBLB00='Z'

75      10:19:35  SQL Execute: ORACLE -  select  *  from  IC_YBBRLB WHERE YBLB00='Z'

76      10:19:35  SQL Prepare: ORACLE - select  VALUE0 from  xt_xtcs00  where  name00 = 'ZY_SFYDDYJ'

77      10:19:35  SQL Execute: ORACLE - select  VALUE0 from  xt_xtcs00  where  name00 = 'ZY_SFYDDYJ'

78      10:19:35  SQL Prepare: ORACLE - select  VALUE0 from  xt_xtcs00  where  name00 = 'ZY_LXBRSFKYYF'

79      10:19:35  SQL Execute: ORACLE - select  VALUE0 from  xt_xtcs00  where  name00 = 'ZY_LXBRSFKYYF'

80      10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRQDHZSFTSDY'

81      10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRQDHZSFTSDY'

82      10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFPTCYHZRQDGS'

83      10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFPTCYHZRQDGS'

84      10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFABRFYDY'

85      10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFABRFYDY'

86      10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRNLSFXSDY'

87      10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRNLSFXSDY'

88      10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSJD'

89      10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSJD'

90      10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_KPYHDYFS'

91      10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_KPYHDYFS'

92      10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDBRPXFS'

93      10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDBRPXFS'

94      10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFMYDYYTYW'

95      10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFMYDYYTYW'

96      10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXS0XM'

97      10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXS0XM'

98      10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYKSZDYDY'

99      10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYKSZDYDY'

100     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJZDY'

101     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJZDY'

102     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJTKZDY'

103     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJTKZDY'

104     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJDSFTD'

105     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJDSFTD'

106     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJTKDSFTD'

107     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJTKDSFTD'

108     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRCYJSSFXXCYSH'

109     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRCYJSSFXXCYSH'

110     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXSZFBL'

111     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXSZFBL'

112     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJFXJZFZDXE'

113     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJFXJZFZDXE'

114     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_JHFPSFTD'

115     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_JHFPSFTD'

116     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJJKZGXE'

117     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJJKZGXE'

118     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CXJSSFSPYCXJSFKCL'

119     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CXJSSFSPYCXJSFKCL'

120     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FZFPDYPJXHLX'

121     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FZFPDYPJXHLX'

122     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZDY_ZYBRWJSFYBB'

123     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZDY_ZYBRWJSFYBB'

124     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_SFQYHZYLJK'

125     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_SFQYHZYLJK'

126     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_DATAPATH'

127     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_DATAPATH'

128     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_HZYLBRFB'

129     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_HZYLBRFB'

130     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_CXZRSFZFYFP'

131     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_CXZRSFZFYFP'

132     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFTSDYZSFP'

133     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFTSDYZSFP'

134     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CYSFTSSRJBZD'

135     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CYSFTSSRJBZD'

136     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BASSMZXXSFSFCLR'

137     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BASSMZXXSFSFCLR'

138     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFSYFPXMZMYHJM'

139     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFSYFPXMZMYHJM'

140     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YYIDPDDLKS'

141     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YYIDPDDLKS'

142     10:19:35  SQL Prepare: ORACLE - select  VALUE0 from  xt_xtcs00  where  name00 = 'ZY_YJJDTOPLEFT'

143     10:19:35  SQL Execute: ORACLE - select  VALUE0 from  xt_xtcs00  where  name00 = 'ZY_YJJDTOPLEFT'

144     10:19:35  SQL Prepare: ORACLE - select  VALUE0 from  xt_xtcs00  where  name00 = 'ZY_YJJTKDTOPLEFT'

145     10:19:35  SQL Execute: ORACLE - select  VALUE0 from  xt_xtcs00  where  name00 = 'ZY_YJJTKDTOPLEFT'

146     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZZ0_FQYY'

147     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZZ0_FQYY'

148     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSXJ'

149     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSXJ'

150     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRDSFXSJMJE'

151     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRDSFXSJMJE'

152     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FPGE00'

153     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FPGE00'

154     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXQXRYDJ'

155     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXQXRYDJ'

156     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXLFYCY'

157     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXLFYCY'

158     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_MRNZYHFZSFYZ'

159     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_MRNZYHFZSFYZ'

160     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFCSSYFMBQBM'

161     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFCSSYFMBQBM'

162     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BDFPQDSFHBXTXM'

163     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BDFPQDSFHBXTXM'

164     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_NHSYBRSFAPTLBRY'

165     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_NHSYBRSFAPTLBRY'

166     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDZFBLSFYBBL'

167     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDZFBLSFYBBL'

168     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_LSCLSFXZ'

169     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_LSCLSFXZ'

170     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSYJSBZ'

171     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSYJSBZ'

172     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXMYBJK'

173     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXMYBJK'

174     10:19:35  SQL Prepare: ORACLE - select  *  from XT_XTCS00   where  NAME00='ZY_SBGSJZFYSPTS'

175     10:19:35  SQL Execute: ORACLE - select  *  from XT_XTCS00   where  NAME00='ZY_SBGSJZFYSPTS'

176     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_GRZFSFBHSB'

177     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_GRZFSFBHSB'

178     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YLJGBH'

179     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YLJGBH'

180     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJSFPDTMBR'

181     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJSFPDTMBR'

182     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZFBLSFTXNJYY'

183     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZFBLSFTXNJYY'

184     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJZYYSSFYSR'

185     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJZYYSSFYSR'

186     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZFYJJSFXZDTZF'

187     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZFYJJSFXZDTZF'

188     10:19:35  SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDSFDYZFJE'

189     10:19:35  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDSFDYZFJE'

190     10:19:35  SQL Prepare: ORACLE -  select * from xt_yyxx00 where rownum=1

191     10:19:35  SQL Execute: ORACLE -  select * from xt_yyxx00 where rownum=1

192     10:19:35  SQL Prepare: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('ZY_CSBSYBFPSFFKCL','ZY_PRINTYYFYMXZZDY','ZY_WCKSFYXCYJS','ZY_SFQYBASYCSJK','ZY_SFYJKTJ_SFCF','ZY_SFYJKTJLS','ZY_SFYJKTJHS','ZY_YXLFYZFBRCYJS','ZY_QDHZSHTSDY','ZY_ZYYSJZSRXSCYRS','ZY_NHBRSFCSJBZD','ZY_JKJHSFXSJKDH','ZY_ZYBRSFKYZHBRID','ZY_BASYNHBRSFCSICKH','ZY_FPRQDYSFXSDYRQ','ZY_XNHBRSFCSICKH','ZY_YJJYHKTCSFYXJTC','ZY_RYDJZDCSDBJE','ZY_YJJSKSFXSYLMXZ','ZY_SZCYBRSFKYRY','ZY_BRLDTJ_BQ_KS','ZY_YJJYEMXBTITLE','ZY_JKRQXSSFALNYYFS','ZY_NHBRSFFSCYDJRQ','ZY_NBBRXB','ZY_QDDYSFMRQTDYJ','ZY_YBJSRBBSFXSCZYB','ZY_ZFZYBXMTSSB','ZY_JKRQSFGBCXGJKRQ','ZY_ZFBRXB','ZY_BASY_LEFTPAGE','ZY_BASY_TOPPAGE','ZY_PJJHYJJSFXSCXLL','SF_MZFPPDSFXYBR','ZY_CYJSTKAYJJ','ZY_JKDYFWSFYZTYZDZ','ZY_FZFZYBSFXZ','ZY_FPTHBJXX','ZY_NHBRSFMRXM','ZY_FYGZJSSFTSJX','SF_SFSYSFXMZMYHJM')

193     10:19:35  SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('ZY_CSBSYBFPSFFKCL','ZY_PRINTYYFYMXZZDY','ZY_WCKSFYXCYJS','ZY_SFQYBASYCSJK','ZY_SFYJKTJ_SFCF','ZY_SFYJKTJLS','ZY_SFYJKTJHS','ZY_YXLFYZFBRCYJS','ZY_QDHZSHTSDY','ZY_ZYYSJZSRXSCYRS','ZY_NHBRSFCSJBZD','ZY_JKJHSFXSJKDH','ZY_ZYBRSFKYZHBRID','ZY_BASYNHBRSFCSICKH','ZY_FPRQDYSFXSDYRQ','ZY_XNHBRSFCSICKH','ZY_YJJYHKTCSFYXJTC','ZY_RYDJZDCSDBJE','ZY_YJJSKSFXSYLMXZ','ZY_SZCYBRSFKYRY','ZY_BRLDTJ_BQ_KS','ZY_YJJYEMXBTITLE','ZY_JKRQXSSFALNYYFS','ZY_NHBRSFFSCYDJRQ','ZY_NBBRXB','ZY_QDDYSFMRQTDYJ','ZY_YBJSRBBSFXSCZYB','ZY_ZFZYBXMTSSB','ZY_JKRQSFGBCXGJKRQ','ZY_ZFBRXB','ZY_BASY_LEFTPAGE','ZY_BASY_TOPPAGE','ZY_PJJHYJJSFXSCXLL','SF_MZFPPDSFXYBR','ZY_CYJSTKAYJJ','ZY_JKDYFWSFYZTYZDZ','ZY_FZFZYBSFXZ','ZY_FPTHBJXX','ZY_NHBRSFMRXM','ZY_FYGZJSSFTSJX','SF_SFSYSFXMZMYHJM')

194     10:19:35  SQL Prepare: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='3077'

195     10:19:35  SQL Execute: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='3077'

196     10:19:36  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='5' and (( 
697= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='5' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=697))))

197     10:19:36  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='5' and (( 
697= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='5' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=697))))

198     10:19:37  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

199     10:19:37  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

200     10:19:37  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 ((697= 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=697))))  

201     10:19:37  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 ((697= 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=697))))  

202     10:19:37  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

203     10:19:37  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

204     10:19:37  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
697= 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=697))))

205     10:19:37  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
697= 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=697))))

206     10:19:37  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'

207     10:19:37  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'

208     10:19:37  SQL Prepare: ORACLE - Commit

209     10:19:37  SQL Execute: ORACLE - Commit

210     10:19:39  SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')

211     10:19:39  SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')

212     10:19:39  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

213     10:19:39  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

214     10:19:43  SQL Prepare: ORACLE -  select * from  VW_ZY_BRZY00  where  1 = 1 
 and  ZYH000  like '175808%'
 and BRZT00 <> '9'
 and CYRQ00 is  NULL  

215     10:19:43  SQL Execute: ORACLE -  select * from  VW_ZY_BRZY00  where  1 = 1 
 and  ZYH000  like '175808%'
 and BRZT00 <> '9'
 and CYRQ00 is  NULL  

216     10:19:45  SQL Prepare: ORACLE - select  *  from  BM_PJLYQK  where PJLXBM = 3  and  PJSYR0 = :1
 and  SYBZ00 = 'Y'

217     10:19:45  SQL Execute: ORACLE - select  *  from  BM_PJLYQK  where PJLXBM = 3  and  PJSYR0 = ?
 and  SYBZ00 = 'Y'

218     10:19:45  SQL Prepare: ORACLE -  select A.*,SF_SF_JZDH00(B.DJH000)JZDH00,D.ZWXM00 from  YF_ZYCF00 A,
 zy_brfy00 B,yf_zycf00 C,BM_YGBM00 D where A.CZY000 = D.YGBH00 
 and A.ZYID00 = :1
 and A.CFZT00 in ('0','5')  and  A.BCCFH0 = C.CFLSH0  and  B.DJH000 = C.DJH000  and  B.JZDH00+0 <> 0  
 order by  A.SRRQ00  desc  

219     10:19:45  SQL Execute: ORACLE -  select A.*,SF_SF_JZDH00(B.DJH000)JZDH00,D.ZWXM00 from  YF_ZYCF00 A,
 zy_brfy00 B,yf_zycf00 C,BM_YGBM00 D where A.CZY000 = D.YGBH00 
 and A.ZYID00 = ?
 and A.CFZT00 in ('0','5')  and  A.BCCFH0 = C.CFLSH0  and  B.DJH000 = C.DJH000  and  B.JZDH00+0 <> 0  
 order by  A.SRRQ00  desc  

220     10:19:45  SQL Prepare: ORACLE -  select * from YF_ZYCFMX  where CFLSH0= :1

221     10:19:45  SQL Execute: ORACLE -  select * from YF_ZYCFMX  where CFLSH0= ?

222     10:19:45  SQL Prepare: ORACLE -  select * from YF_ZYCFMX  where CFLSH0= :1

223     10:19:45  SQL Execute: ORACLE -  select * from YF_ZYCFMX  where CFLSH0= ?

224     10:19:45  SQL Prepare: ORACLE -  select * from YF_ZYCFMX  where CFLSH0= :1

225     10:19:45  SQL Execute: ORACLE -  select * from YF_ZYCFMX  where CFLSH0= ?

226     10:19:45  SQL Prepare: ORACLE -  select A.*,SF_SF_JZDH00(B.DJH000)JZDH00 from  VW_ZY_YJYW00 A,YJ_YW0000 C,ZY_BRFY00 B  where  A.ZYID00 = :1
 and  A.CXDJH0 = C.YJDJH0  and  C.SFDJH0 = B.DJH000  and  B.JZDH00+0 <> 0  and  A.SFDJH0+0 = 0 
 order by  A.KDRQ00  desc  

227     10:19:45  SQL Execute: ORACLE -  select A.*,SF_SF_JZDH00(B.DJH000)JZDH00 from  VW_ZY_YJYW00 A,YJ_YW0000 C,ZY_BRFY00 B  where  A.ZYID00 = ?
 and  A.CXDJH0 = C.YJDJH0  and  C.SFDJH0 = B.DJH000  and  B.JZDH00+0 <> 0  and  A.SFDJH0+0 = 0 
 order by  A.KDRQ00  desc  

228     10:19:45  SQL Prepare: ORACLE - select *  from VW_ZY_YJYWMX
where YJDJH0=:1

229     10:19:45  SQL Execute: ORACLE - select *  from VW_ZY_YJYWMX
where YJDJH0=?

230     10:19:45  SQL Prepare: ORACLE - select A.CZYXM0,SF_SF_JZDH00(A.DJH000)JZDH00,A.YBDJH0,A.XM0000,A.BRID00,A.JFLBID,A.ZYH000,B.*  from  
 ZY_PJSYQK D,ZY_JZB000 C,zy_fymx00 B,zy_brfy00 A where 1=1 
 and  B.SFYDJ0 = '1' and  B.CXBZ00 = 'Z'
 and  D.PLBH00 = 3 and  C.PJH000=D.PJH000 and  A.JZDH00 = C.JZDH00 and B.JMBZ00<>'2'
 and A.DJH000 = B.DJH000  and  A.brid00 =:1  and A.ZYID00 = :2
 and b.xmbh00<9999999990 order  by  A.CZRQ00  desc  

231     10:19:45  SQL Execute: ORACLE - select A.CZYXM0,SF_SF_JZDH00(A.DJH000)JZDH00,A.YBDJH0,A.XM0000,A.BRID00,A.JFLBID,A.ZYH000,B.*  from  
 ZY_PJSYQK D,ZY_JZB000 C,zy_fymx00 B,zy_brfy00 A where 1=1 
 and  B.SFYDJ0 = '1' and  B.CXBZ00 = 'Z'
 and  D.PLBH00 = 3 and  C.PJH000=D.PJH000 and  A.JZDH00 = C.JZDH00 and B.JMBZ00<>'2'
 and A.DJH000 = B.DJH000  and  A.brid00 =?  and A.ZYID00 = ?
 and b.xmbh00<9999999990 order  by  A.CZRQ00  desc  

232     10:19:45  SQL Prepare: ORACLE - select * from  zy_jzb000 A,zy_jzmx00 B
where A.JZDH00 = B.JZDH00   
  and A.JZDH00=:1

233     10:19:45  SQL Execute: ORACLE - select * from  zy_jzb000 A,zy_jzmx00 B
where A.JZDH00 = B.JZDH00   
  and A.JZDH00=?

234     10:19:45  SQL Prepare: ORACLE - select * from  zy_jzb000 A,zy_jzmx00 B
where A.JZDH00 = B.JZDH00   
  and A.JZDH00=:1

235     10:19:45  SQL Execute: ORACLE - select * from  zy_jzb000 A,zy_jzmx00 B
where A.JZDH00 = B.JZDH00   
  and A.JZDH00=?

236     10:19:45  SQL Prepare: ORACLE - select * from  zy_jzb000 A,zy_jzmx00 B
where A.JZDH00 = B.JZDH00   
  and A.JZDH00=:1

237     10:19:45  SQL Execute: ORACLE - select * from  zy_jzb000 A,zy_jzmx00 B
where A.JZDH00 = B.JZDH00   
  and A.JZDH00=?

238     10:19:45  SQL Prepare: ORACLE -  select SF_SF_JZDH00(C.DJH000)JZDH00,B.ZWXM00,A.*  from YF_YZYPSQ A,BM_YGBM00 B,zy_brfy00 C,YF_YZYPSQ D where  A.ZYID00 = :1
 and A.CZY000=B.YGBH00 and A.CXPCID = D.YPQLPC  and  D.DJH000 = C.DJH000  and  C.JZDH00+0 <> 0  and  A.QLZT00 in ('0','5')
 order  by  A.SRRQ00  desc  

239     10:19:45  SQL Execute: ORACLE -  select SF_SF_JZDH00(C.DJH000)JZDH00,B.ZWXM00,A.*  from YF_YZYPSQ A,BM_YGBM00 B,zy_brfy00 C,YF_YZYPSQ D where  A.ZYID00 = ?
 and A.CZY000=B.YGBH00 and A.CXPCID = D.YPQLPC  and  D.DJH000 = C.DJH000  and  C.JZDH00+0 <> 0  and  A.QLZT00 in ('0','5')
 order  by  A.SRRQ00  desc  

240     10:19:45  SQL Prepare: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='3077'

241     10:19:45  SQL Execute: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='3077'

242     10:19:45  SQL Prepare: ORACLE - select GSDJH0 from ZY_BRXXB0 where ZYID00= :1

243     10:19:45  SQL Execute: ORACLE - select GSDJH0 from ZY_BRXXB0 where ZYID00= ?

244     10:19:48  SQL Prepare: ORACLE -  select count(*) NUM from yf_zycf00 d where d.cfzt00 in ('0','5') and d.zyid00=:1 
   and d.bccfh0 in (select a.cflsh0 from yf_zycf00 a,zy_brfy00 b where a.djh000=b.djh000 and b.jzdh00+0=0 and b.zyid00=d.zyid00) 

245     10:19:48  SQL Execute: ORACLE -  select count(*) NUM from yf_zycf00 d where d.cfzt00 in ('0','5') and d.zyid00=? 
   and d.bccfh0 in (select a.cflsh0 from yf_zycf00 a,zy_brfy00 b where a.djh000=b.djh000 and b.jzdh00+0=0 and b.zyid00=d.zyid00) 

246     10:19:48  SQL Prepare: ORACLE -  select count(*) NUM from vw_zy_yjyw00 d where  d.sfdjh0+0=0 and d.zyid00=:1 
   and d.cxdjh0 in (select a.yjdjh0 from yj_yw0000 a,zy_brfy00 b where a.sfdjh0=b.djh000 and b.jzdh00+0=0 and b.zyid00=d.zyid00) 

247     10:19:48  SQL Execute: ORACLE -  select count(*) NUM from vw_zy_yjyw00 d where  d.sfdjh0+0=0 and d.zyid00=? 
   and d.cxdjh0 in (select a.yjdjh0 from yj_yw0000 a,zy_brfy00 b where a.sfdjh0=b.djh000 and b.jzdh00+0=0 and b.zyid00=d.zyid00) 

248     10:19:48  SQL Prepare: ORACLE -  select * from zy_brxxb0 b,zy_jzb000 a where 
 exists (select 1 from zy_pjsyqk c where a.pjh000=c.fzpjh0 and c.pjzt00='0') 
 and a.ZYID00=b.ZYID00 and b.zyid00=299832

249     10:19:48  SQL Execute: ORACLE -  select * from zy_brxxb0 b,zy_jzb000 a where 
 exists (select 1 from zy_pjsyqk c where a.pjh000=c.fzpjh0 and c.pjzt00='0') 
 and a.ZYID00=b.ZYID00 and b.zyid00=299832

250     10:22:36  SQL Prepare: ORACLE -  select count(*) NUM from yf_zycf00 d where d.cfzt00 in ('0','5') and d.zyid00=:1 
   and d.bccfh0 in (select a.cflsh0 from yf_zycf00 a,zy_brfy00 b where a.djh000=b.djh000 and b.jzdh00+0=0 and b.zyid00=d.zyid00) 

251     10:22:36  SQL Execute: ORACLE -  select count(*) NUM from yf_zycf00 d where d.cfzt00 in ('0','5') and d.zyid00=? 
   and d.bccfh0 in (select a.cflsh0 from yf_zycf00 a,zy_brfy00 b where a.djh000=b.djh000 and b.jzdh00+0=0 and b.zyid00=d.zyid00) 

252     10:22:36  SQL Prepare: ORACLE -  select count(*) NUM from vw_zy_yjyw00 d where  d.sfdjh0+0=0 and d.zyid00=:1 
   and d.cxdjh0 in (select a.yjdjh0 from yj_yw0000 a,zy_brfy00 b where a.sfdjh0=b.djh000 and b.jzdh00+0=0 and b.zyid00=d.zyid00) 

253     10:22:36  SQL Execute: ORACLE -  select count(*) NUM from vw_zy_yjyw00 d where  d.sfdjh0+0=0 and d.zyid00=? 
   and d.cxdjh0 in (select a.yjdjh0 from yj_yw0000 a,zy_brfy00 b where a.sfdjh0=b.djh000 and b.jzdh00+0=0 and b.zyid00=d.zyid00) 

254     10:22:36  SQL Prepare: ORACLE -  select * from zy_brxxb0 b,zy_jzb000 a where 
 exists (select 1 from zy_pjsyqk c where a.pjh000=c.fzpjh0 and c.pjzt00='0') 
 and a.ZYID00=b.ZYID00 and b.zyid00=299832

255     10:22:36  SQL Execute: ORACLE -  select * from zy_brxxb0 b,zy_jzb000 a where 
 exists (select 1 from zy_pjsyqk c where a.pjh000=c.fzpjh0 and c.pjzt00='0') 
 and a.ZYID00=b.ZYID00 and b.zyid00=299832