1       10:56:57  Log started for: 药房管理系统
2       10:56:57  SQL Prepare: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.0.100','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20091019','10:56:57','scott@9999:920DDF175205ABA3953E75BA4B816D64' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

3       10:56:57  SQL Execute: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.0.100','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20091019','10:56:57','scott@9999:920DDF175205ABA3953E75BA4B816D64' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

4       10:56:57  SQL Data In: ORACLE - Rows affected = 1
5       10:56:57  SQL Prepare: ORACLE - Commit

6       10:56:57  SQL Execute: ORACLE - Commit

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

9       10:56:57  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

10      10:56:57  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 

11      10:56:57  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 

12      10:56:57  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.0.100','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20091019','10:56:57','sd_hospital@9999:15B76592AFE9786B1FDA5730FEF0304F' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

13      10:56:57  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.0.100','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20091019','10:56:57','sd_hospital@9999:15B76592AFE9786B1FDA5730FEF0304F' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

14      10:56:57  SQL Data In: ORACLE - Rows affected = 1
15      10:56:57  SQL Prepare: ORACLE - Commit

16      10:56:57  SQL Execute: ORACLE - Commit

17      10:56:57  SQL Data In: ORACLE - Rows affected = 0
18      10:56:57  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2'

19      10:56:57  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2'

20      10:56:57  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 

21      10:56:57  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00 in ('1') 

22      10:56:57  SQL Prepare: ORACLE - Select SYSDATE from Dual

23      10:56:57  SQL Execute: ORACLE - Select SYSDATE from Dual

24      10:56:57  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

25      10:56:57  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

26      10:56:57  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2'

27      10:56:57  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2'

28      10:56:57  SQL Prepare: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

29      10:56:57  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

30      10:56:57  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

31      10:56:57  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

32      10:56:57  SQL Prepare: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('2','3')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999'))
 order by BH0000

33      10:56:57  SQL Execute: ORACLE -  Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and 
 BMXZ00 in ('2','3')
 and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999'))
 order by BH0000

34      10:56:57  SQL Prepare: ORACLE -  Select '0' as XTDM00 from dual where 
'9999'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'2' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999'))

35      10:56:57  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'9999'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'2' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999'))

36      10:56:57  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=636

37      10:56:57  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=636

38      10:56:57  SQL Prepare: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

39      10:56:57  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

40      10:56:57  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

41      10:56:57  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

42      10:56:57  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

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

44      10:56:57  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

45      10:56:57  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

46      10:56:57  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'))

47      10:56:57  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'))

48      10:56:57  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(484173,636,'3E03347A1BE045A','2',nvl('352597',' '),'192.168.0.100#24:35904@appYP_YF.exe+药房管理系统',479)

49      10:56:57  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(484173,636,'3E03347A1BE045A','2',nvl('352597',' '),'192.168.0.100#24:35904@appYP_YF.exe+药房管理系统',479)

50      10:56:57  SQL Data In: ORACLE - Rows affected = 1
51      10:56:57  SQL Prepare: ORACLE - Commit

52      10:56:57  SQL Execute: ORACLE - Commit

53      10:56:57  SQL Data In: ORACLE - Rows affected = 0
54      10:56:57  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 479

55      10:56:57  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 479

56      10:56:57  SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222142'

57      10:56:57  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222142'

58      10:56:57  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.0.100'

59      10:56:57  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.0.100'

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

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

62      10:56:57  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
479 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

63      10:56:57  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
479 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

64      10:56:57  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20091019'

65      10:56:57  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20091019'

66      10:56:57  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

67      10:56:57  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

68      10:56:57  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

69      10:56:57  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

70      10:56:58  SQL Prepare: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID'

71      10:56:58  SQL Execute: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID'

72      10:56:58  SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID'

73      10:56:58  SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID'

74      10:56:58  SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED'

75      10:56:58  SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers
 where  TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED'

76      10:56:58  SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=479

77      10:56:58  SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=479

78      10:56:58  SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual

79      10:56:58  SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual

80      10:56:58  SQL Prepare: ORACLE - select * from XT_XTCS00

81      10:56:58  SQL Execute: ORACLE - select * from XT_XTCS00

82      10:56:59  SQL Prepare: ORACLE - select * from BM_YPLB00

83      10:56:59  SQL Execute: ORACLE - select * from BM_YPLB00

84      10:56:59  SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=636

85      10:56:59  SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=636

86      10:56:59  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='2' and (( 
636= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=636))))

87      10:56:59  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='2' and (( 
636= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=636))))

88      10:57:00  SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||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

89      10:57:00  SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||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

90      10:57:00  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 ((636= 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=636))))  

91      10:57:00  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 ((636= 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=636))))  

92      10:57:00  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

93      10:57:00  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

94      10:57:00  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
636= 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=636))))

95      10:57:00  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 
636= 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=636))))

96      10:57:00  SQL Prepare: ORACLE - SELECT SFXMMC FROM BM_YPLB00 where LBBH00='3' 

97      10:57:00  SQL Execute: ORACLE - SELECT SFXMMC FROM BM_YPLB00 where LBBH00='3' 

98      10:57:00  SQL Prepare: ORACLE - SELECT 'X' FROM VW_YF_YPKCXX 
 WHERE YFBMBH=479
 AND YKKCSL<KCXX00 AND PDXH00<>'0'

99      10:57:00  SQL Execute: ORACLE - SELECT 'X' FROM VW_YF_YPKCXX 
 WHERE YFBMBH=479
 AND YKKCSL<KCXX00 AND PDXH00<>'0'

100     10:57:01  SQL Prepare: ORACLE - Select 'X' 
 From YK_YPTJMX X,YK_YPTJ00 T
 Where X.YPTJPC=T.YPTJPC AND X.YXBMBH=479
 and X.SFQR00='N'
 and T.SFQR00='Y'

101     10:57:01  SQL Execute: ORACLE - Select 'X' 
 From YK_YPTJMX X,YK_YPTJ00 T
 Where X.YPTJPC=T.YPTJPC AND X.YXBMBH=479
 and X.SFQR00='N'
 and T.SFQR00='Y'

102     10:57:06  SQL Prepare: ORACLE - SELECT BMBH00,BMMC00 FROM BM_BMBM00 
 WHERE BMXZ00='9' AND FLAG00='1'
 ORDER BY BH0000

103     10:57:06  SQL Execute: ORACLE - SELECT BMBH00,BMMC00 FROM BM_BMBM00 
 WHERE BMXZ00='9' AND FLAG00='1'
 ORDER BY BH0000

104     10:57:06  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=c.brid00) BRZJBH,
C.CFLSH0,C.ZYH000,C.BRXM00,C.CH0000,C.XB0000,C.DQKS00,C.BRID00,
C.CSRQ00,C.YSXM00,C.ZYTS00,C.BZMC00,C.BRDZ00,C.SFKSLY,C.DQBQ00,
C.SRRQ00,C.JZRQ00,C.CFZJE0,C.CFZT00,C.YPDLBH,C.CFSRBZ,G.ZWXM00 AS LRY000,C.ZYID00
 FROM YF_ZYCF00 C,BM_YGBM00 G
 WHERE C.CZY000=G.YGBH00
 AND C.SRRQ00>='20091012'
 AND C.DQBQ00=481
 AND C.YFBMBH=479
 AND C.CFZT00 in ('0','1')
 AND C.CFXZ00<>'0'
 AND C.CZY000=G.YGBH00

105     10:57:06  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=c.brid00) BRZJBH,
C.CFLSH0,C.ZYH000,C.BRXM00,C.CH0000,C.XB0000,C.DQKS00,C.BRID00,
C.CSRQ00,C.YSXM00,C.ZYTS00,C.BZMC00,C.BRDZ00,C.SFKSLY,C.DQBQ00,
C.SRRQ00,C.JZRQ00,C.CFZJE0,C.CFZT00,C.YPDLBH,C.CFSRBZ,G.ZWXM00 AS LRY000,C.ZYID00
 FROM YF_ZYCF00 C,BM_YGBM00 G
 WHERE C.CZY000=G.YGBH00
 AND C.SRRQ00>='20091012'
 AND C.DQBQ00=481
 AND C.YFBMBH=479
 AND C.CFZT00 in ('0','1')
 AND C.CFXZ00<>'0'
 AND C.CZY000=G.YGBH00

106     10:57:06  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424027) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424027'
 and X.ZYID00='68408'
 order by X.ZYID00 desc

107     10:57:06  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424027) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424027'
 and X.ZYID00='68408'
 order by X.ZYID00 desc

108     10:57:06  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

109     10:57:06  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

110     10:57:06  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

111     10:57:06  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

112     10:57:06  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

113     10:57:06  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

114     10:57:06  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=423739) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='423739'
 and X.ZYID00='68303'
 order by X.ZYID00 desc

115     10:57:06  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=423739) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='423739'
 and X.ZYID00='68303'
 order by X.ZYID00 desc

116     10:57:06  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091017) AS NL FROM DUAL

117     10:57:06  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091017) AS NL FROM DUAL

118     10:57:06  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

119     10:57:06  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

120     10:57:06  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

121     10:57:06  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

122     10:57:06  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

123     10:57:06  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

124     10:57:06  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

125     10:57:06  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

126     10:57:06  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424027) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424027'
 and X.ZYID00='68408'
 order by X.ZYID00 desc

127     10:57:06  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424027) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424027'
 and X.ZYID00='68408'
 order by X.ZYID00 desc

128     10:57:06  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

129     10:57:06  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

130     10:57:06  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424027) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424027'
 and X.ZYID00='68408'
 order by X.ZYID00 desc

131     10:57:06  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424027) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424027'
 and X.ZYID00='68408'
 order by X.ZYID00 desc

132     10:57:06  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

133     10:57:06  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

134     10:57:06  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

135     10:57:06  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

136     10:57:06  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

137     10:57:06  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

138     10:57:06  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=423739) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='423739'
 and X.ZYID00='68303'
 order by X.ZYID00 desc

139     10:57:06  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=423739) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='423739'
 and X.ZYID00='68303'
 order by X.ZYID00 desc

140     10:57:06  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091017) AS NL FROM DUAL

141     10:57:06  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091017) AS NL FROM DUAL

142     10:57:06  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

143     10:57:06  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

144     10:57:06  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

145     10:57:06  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

146     10:57:06  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

147     10:57:06  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

148     10:57:06  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

149     10:57:06  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

150     10:57:06  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424027) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424027'
 and X.ZYID00='68408'
 order by X.ZYID00 desc

151     10:57:06  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424027) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424027'
 and X.ZYID00='68408'
 order by X.ZYID00 desc

152     10:57:06  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

153     10:57:06  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

154     10:57:06  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424027) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424027'
 and X.ZYID00='68408'
 order by X.ZYID00 desc

155     10:57:06  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424027) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424027'
 and X.ZYID00='68408'
 order by X.ZYID00 desc

156     10:57:06  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

157     10:57:06  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

158     10:57:06  SQL Prepare: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 
  AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
       YYSJ00*ZQCD00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,
       HSKPPH,ZFBL00,YBLB00,ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=:1 AND SFZBY0='N'


159     10:57:06  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 060870
160     10:57:06  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 
  AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
       YYSJ00*ZQCD00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,
       HSKPPH,ZFBL00,YBLB00,ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


161     10:57:15  SQL Prepare: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 
  AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
       YYSJ00*ZQCD00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,
       HSKPPH,ZFBL00,YBLB00,ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=:1 AND SFZBY0='N'


162     10:57:15  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 060846
163     10:57:15  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 
  AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
       YYSJ00*ZQCD00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,
       HSKPPH,ZFBL00,YBLB00,ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


164     10:57:15  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

165     10:57:15  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

166     10:57:15  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

167     10:57:15  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

168     10:57:18  SQL Prepare: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 
  AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
       YYSJ00*ZQCD00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,
       HSKPPH,ZFBL00,YBLB00,ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=:1 AND SFZBY0='N'


169     10:57:18  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 060870
170     10:57:18  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 
  AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
       YYSJ00*ZQCD00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,
       HSKPPH,ZFBL00,YBLB00,ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


171     10:57:18  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424027) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424027'
 and X.ZYID00='68408'
 order by X.ZYID00 desc

172     10:57:18  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424027) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424027'
 and X.ZYID00='68408'
 order by X.ZYID00 desc

173     10:57:18  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

174     10:57:18  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

175     10:59:33  SQL Prepare: ORACLE - Commit

176     10:59:33  SQL Execute: ORACLE - Commit

177     10:59:33  SQL Data In: ORACLE - Rows affected = 0
178     10:59:34  SQL Prepare: ORACLE - BEGIN "SP_YF_ZYCFCL" (P_CFLSH0 => :P_CFLSH0,P_CFJSZT => :P_CFJSZT,P_YFBMBH => :P_YFBMBH,P_CZYBH0 => :P_CZYBH0,P_DJH000 => :P_DJH000); END;
179     10:59:34  SQL Data In: ORACLE - Param = 1, Name = P_CFLSH0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 060870
180     10:59:34  SQL Data In: ORACLE - Param = 2, Name = P_CFJSZT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
181     10:59:34  SQL Data In: ORACLE - Param = 3, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 479.000000
182     10:59:34  SQL Data In: ORACLE - Param = 4, Name = P_CZYBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 636.000000
183     10:59:34  SQL Data In: ORACLE - Param = 5, Name = P_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
184     10:59:34  SQL Execute: ORACLE - BEGIN "SP_YF_ZYCFCL" (P_CFLSH0 => :P_CFLSH0,P_CFJSZT => :P_CFJSZT,P_YFBMBH => :P_YFBMBH,P_CZYBH0 => :P_CZYBH0,P_DJH000 => :P_DJH000); END;
185     10:59:35  SQL Prepare: ORACLE - select CFZT00 from YF_MZCF00 where CFLSH0='060870'

186     10:59:35  SQL Execute: ORACLE - select CFZT00 from YF_MZCF00 where CFLSH0='060870'

187     10:59:35  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=c.brid00) BRZJBH,
C.CFLSH0,C.ZYH000,C.BRXM00,C.CH0000,C.XB0000,C.DQKS00,C.BRID00,
C.CSRQ00,C.YSXM00,C.ZYTS00,C.BZMC00,C.BRDZ00,C.SFKSLY,C.DQBQ00,
C.SRRQ00,C.JZRQ00,C.CFZJE0,C.CFZT00,C.YPDLBH,C.CFSRBZ,G.ZWXM00 AS LRY000,C.ZYID00
 FROM YF_ZYCF00 C,BM_YGBM00 G
 WHERE C.CZY000=G.YGBH00
 AND C.SRRQ00>='20091012' AND C.SRRQ00<='20091019'
 AND C.DQBQ00=481
 AND C.YFBMBH=479
 AND C.CFZT00 in ('0','1')
 AND C.CFXZ00<>'0'
 AND C.CZY000=G.YGBH00

188     10:59:35  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=c.brid00) BRZJBH,
C.CFLSH0,C.ZYH000,C.BRXM00,C.CH0000,C.XB0000,C.DQKS00,C.BRID00,
C.CSRQ00,C.YSXM00,C.ZYTS00,C.BZMC00,C.BRDZ00,C.SFKSLY,C.DQBQ00,
C.SRRQ00,C.JZRQ00,C.CFZJE0,C.CFZT00,C.YPDLBH,C.CFSRBZ,G.ZWXM00 AS LRY000,C.ZYID00
 FROM YF_ZYCF00 C,BM_YGBM00 G
 WHERE C.CZY000=G.YGBH00
 AND C.SRRQ00>='20091012' AND C.SRRQ00<='20091019'
 AND C.DQBQ00=481
 AND C.YFBMBH=479
 AND C.CFZT00 in ('0','1')
 AND C.CFXZ00<>'0'
 AND C.CZY000=G.YGBH00

189     10:59:35  SQL Prepare: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 
  AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
       YYSJ00*ZQCD00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,
       HSKPPH,ZFBL00,YBLB00,ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=:1 AND SFZBY0='N'


190     10:59:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 060846
191     10:59:35  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 
  AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
       YYSJ00*ZQCD00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,
       HSKPPH,ZFBL00,YBLB00,ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


192     10:59:35  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

193     10:59:35  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

194     10:59:35  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

195     10:59:35  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

196     10:59:35  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=423739) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='423739'
 and X.ZYID00='68303'
 order by X.ZYID00 desc

197     10:59:35  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=423739) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='423739'
 and X.ZYID00='68303'
 order by X.ZYID00 desc

198     10:59:35  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091017) AS NL FROM DUAL

199     10:59:35  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091017) AS NL FROM DUAL

200     10:59:35  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

201     10:59:35  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

202     10:59:35  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

203     10:59:35  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

204     10:59:35  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

205     10:59:35  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

206     10:59:35  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

207     10:59:35  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

208     10:59:35  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

209     10:59:35  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

210     10:59:35  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

211     10:59:35  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

212     10:59:35  SQL Prepare: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 
  AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
       YYSJ00*ZQCD00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,
       HSKPPH,ZFBL00,YBLB00,ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=:1 AND SFZBY0='N'


213     10:59:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 060846
214     10:59:35  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 
  AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
       YYSJ00*ZQCD00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,
       HSKPPH,ZFBL00,YBLB00,ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


215     10:59:35  SQL Prepare: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

216     10:59:35  SQL Execute: ORACLE - SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=424000) BRZJBH,
 X.XM0000,X.XB0000,X.CSRQ00,X.FBMC00,X.ZYE000,X.YKZYE0,
X.YXQFJE,BRID00,ZYH000,CH0000
 FROM VW_YF_ZYBRZH X
 WHERE X.BRID00='424000'
 and X.ZYID00='68403'
 order by X.ZYID00 desc

217     10:59:35  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

218     10:59:35  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20091018) AS NL FROM DUAL

219     10:59:35  SQL Prepare: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 
  AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
       YYSJ00*ZQCD00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,
       HSKPPH,ZFBL00,YBLB00,ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=:1 AND SFZBY0='N'


220     10:59:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 060846
221     10:59:35  SQL Execute: ORACLE - SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 
  AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,
       YYSJ00*ZQCD00||YYSJDW AS YYTS00,YPSCCJ,YPSCPH,KPHSS0,
       HSKPPH,ZFBL00,YBLB00,ZB0000
FROM YF_ZYCFMX
WHERE  CFLSH0=? AND SFZBY0='N'


222     10:59:40  SQL Prepare: ORACLE -  Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
 where LSH000=484173

223     10:59:40  SQL Execute: ORACLE -  Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS')
 where LSH000=484173

224     10:59:40  SQL Data In: ORACLE - Rows affected = 1
225     10:59:40  SQL Prepare: ORACLE - Commit

226     10:59:40  SQL Execute: ORACLE - Commit

227     10:59:40  SQL Data In: ORACLE - Rows affected = 0
228     10:59:40  SQL Prepare: ORACLE -  update XT_SQIPDZ set ZT0000='0' where JQBH00=0

229     10:59:40  SQL Execute: ORACLE -  update XT_SQIPDZ set ZT0000='0' where JQBH00=0

230     10:59:40  SQL Data In: ORACLE - Rows affected = 0
231     10:59:40  SQL Prepare: ORACLE - Commit

232     10:59:40  SQL Execute: ORACLE - Commit

233     10:59:40  SQL Data In: ORACLE - Rows affected = 0