1       09:50:29  Log started for: 门诊挂号收费管理系统
2       09:50:29  SQL Prepare: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.5.22','4','PrjMZ_MZSF.exe'||'+'||'门诊挂号收费管理系统','157','38725' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@343:E9F8590D659E1AC146B4AE8A94C8F11A' from dual

3       09:50:29  SQL Execute: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.5.22','4','PrjMZ_MZSF.exe'||'+'||'门诊挂号收费管理系统','157','38725' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@343:E9F8590D659E1AC146B4AE8A94C8F11A' from dual

4       09:50:29  SQL Data In: ORACLE - Rows affected = 1
5       09:50:29  SQL Prepare: ORACLE - Commit

6       09:50:29  SQL Execute: ORACLE - Commit

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

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

10      09:50:30  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

11      09:50:30  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

12      09:50:30  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 

13      09:50:30  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 

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

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

16      09:50:30  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.5.22','4','PrjMZ_MZSF.exe'||'+'||'门诊挂号收费管理系统','258','8402' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:22B92C467B2618E2A5E9AD7F90CF4AD6' from dual

17      09:50:30  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.5.22','4','PrjMZ_MZSF.exe'||'+'||'门诊挂号收费管理系统','258','8402' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:22B92C467B2618E2A5E9AD7F90CF4AD6' from dual

18      09:50:30  SQL Data In: ORACLE - Rows affected = 1
19      09:50:30  SQL Prepare: ORACLE - Commit

20      09:50:30  SQL Execute: ORACLE - Commit

21      09:50:30  SQL Data In: ORACLE - Rows affected = 0
22      09:50:30  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='4'

23      09:50:30  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='4'

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

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

26      09:50:30  SQL Prepare: ORACLE - Select SYSDATE from Dual

27      09:50:30  SQL Execute: ORACLE - Select SYSDATE from Dual

28      09:50:30  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

29      09:50:30  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

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

31      09:50:30  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

32      09:50:30  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='4'

33      09:50:30  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='4'

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

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

36      09:50:30  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:50:30  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:50:30  SQL Prepare: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='4'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) 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='4'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343'))
 order by b.PLXH00,a.BH0000

39      09:50:30  SQL Execute: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='4'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) 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='4'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343'))
 order by b.PLXH00,a.BH0000

40      09:50:30  SQL Prepare: ORACLE -  Select '0' as XTDM00 from dual where 
'343'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'4' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='4' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 

41      09:50:30  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'343'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'4' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='4' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 

42      09:50:30  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143

43      09:50:30  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143

44      09:50:30  SQL Prepare: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

45      09:50:30  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

46      09:50:30  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

47      09:50:30  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

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

49      09:50:30  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

50      09:50:30  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

51      09:50:30  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

52      09:50:30  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'))

53      09:50:30  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'))

54      09:50:30  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(3998947,1143,'wlzx-1','4',nvl('227207126',' '),'192.168.5.22#258:8402@PrjMZ_MZSF.exe+门诊挂号收费管理系统',44)

55      09:50:30  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(3998947,1143,'wlzx-1','4',nvl('227207126',' '),'192.168.5.22#258:8402@PrjMZ_MZSF.exe+门诊挂号收费管理系统',44)

56      09:50:30  SQL Data In: ORACLE - Rows affected = 1
57      09:50:30  SQL Prepare: ORACLE - Commit

58      09:50:30  SQL Execute: ORACLE - Commit

59      09:50:30  SQL Data In: ORACLE - Rows affected = 0
60      09:50:30  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 44

61      09:50:30  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 44

62      09:50:30  SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

63      09:50:30  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

64      09:50:30  SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

65      09:50:30  SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

66      09:50:30  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22'

67      09:50:30  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.22'

68      09:50:30  SQL Prepare: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

69      09:50:30  SQL Execute: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

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

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

72      09:50:30  SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

73      09:50:30  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

74      09:50:30  SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'4'||',')>0 

75      09:50:30  SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'4'||',')>0 

76      09:50:33  SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN'

77      09:50:33  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN'

78      09:50:33  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

79      09:50:33  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

80      09:50:33  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where  YXQ000>='20140225'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',44,' )>0 )
 and XXXZ00='1' and (XTDM00='-1' or XTDM00='4')

81      09:50:33  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where  YXQ000>='20140225'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',44,' )>0 )
 and XXXZ00='1' and (XTDM00='-1' or XTDM00='4')

82      09:50:33  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

83      09:50:33  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

84      09:50:33  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

85      09:50:33  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

86      09:50:33  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='4' and (( 
1143= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='4'))) 

87      09:50:33  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='4' and (( 
1143= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='4'))) 

88      09:50:34  SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '4$%' and A.XTDM00='4' and trim(A.MKDM00)='4$'||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      09:50:34  SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '4$%' and A.XTDM00='4' and trim(A.MKDM00)='4$'||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      09:50:34  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 ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 

91      09:50:34  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 ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 

92      09:50:34  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

93      09:50:34  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

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

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

96      09:50:34  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 

97      09:50:34  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 

98      09:50:36  SQL Prepare: ORACLE -  Update  SF_BRDB00  set  SFYX00='N' where  DBJSRQ < to_char(sysdate,'yyyymmdd') and SFYX00 = 'Y'

99      09:50:36  SQL Execute: ORACLE -  Update  SF_BRDB00  set  SFYX00='N' where  DBJSRQ < to_char(sysdate,'yyyymmdd') and SFYX00 = 'Y'

100     09:50:36  SQL Data In: ORACLE - Rows affected = 0
101     09:50:36  SQL Prepare: ORACLE - Commit

102     09:50:36  SQL Execute: ORACLE - Commit

103     09:50:36  SQL Data In: ORACLE - Rows affected = 0
104     09:50:36  SQL Prepare: ORACLE - select count(*) NUM from  user_triggers  where  1 = 1 
 and trigger_name in ('TR_SF_SF_BRFY00_INSERT','TR_SF_SF_BRJFB0_INSERT',
'TR_SF_SF_BRDB00_UPDATE','TR_SF_SF_PJSYQK_INSERT',
'TR_SF_SF_BRJFB0_UPDATE','TR_SF_SF_BRXXB0_INSERT','TR_SF_SF_PJSYQK_INSERT')
 and STATUS = 'ENABLED'

105     09:50:36  SQL Execute: ORACLE - select count(*) NUM from  user_triggers  where  1 = 1 
 and trigger_name in ('TR_SF_SF_BRFY00_INSERT','TR_SF_SF_BRJFB0_INSERT',
'TR_SF_SF_BRDB00_UPDATE','TR_SF_SF_PJSYQK_INSERT',
'TR_SF_SF_BRJFB0_UPDATE','TR_SF_SF_BRXXB0_INSERT','TR_SF_SF_PJSYQK_INSERT')
 and STATUS = 'ENABLED'

106     09:50:36  SQL Prepare: ORACLE -  select   *  from  bm_brzffs where  ZFFSMC = '现金'

107     09:50:36  SQL Execute: ORACLE -  select   *  from  bm_brzffs where  ZFFSMC = '现金'

108     09:50:36  SQL Prepare: ORACLE - select count(*) NUM  from  bm_brjflb  where  jflbid=0  or  sybz00 = '0' or sybz00 = '1'

109     09:50:36  SQL Execute: ORACLE - select count(*) NUM  from  bm_brjflb  where  jflbid=0  or  sybz00 = '0' or sybz00 = '1'

110     09:50:36  SQL Prepare: ORACLE -  select sysdate nowtime  from dual  

111     09:50:36  SQL Execute: ORACLE -  select sysdate nowtime  from dual  

112     09:50:36  SQL Prepare: ORACLE -  select  *  from  XT_YHCS00  where  YGBH00 = 1143

113     09:50:36  SQL Execute: ORACLE -  select  *  from  XT_YHCS00  where  YGBH00 = 1143

114     09:50:36  SQL Prepare: ORACLE -  select name00,value0 from XT_XTCS00 where NAME00 in ('SF_YBSFYGSSYLB','SF_MZFPSFDYYJJYE','SF_YBJSSAZTSBZ','SF_FYJSWSFTSWJSFY','MZSF_SFTSDYZSFP','SF_CJFY','SF_PRINTGHHFZDXZDY','SF_MZQDSFXSJMJE','SF_MZJSSFKYCZTYDW','SF_YHKLB','SF_GHXXSFTXJT','SF_FYJSSFXXZTSBZ','SF_GHLBBH','SF_GHXMBH','SF_PJQKSFDYFS','SF_SFSYFPXMZMYHJM','SF_FPGS00','SF_YYIDPDDLKS','SF_TSBZ_SFMRSCJZTSBZ','SF_TSBZ_SFZJSBTSBZFY','SF_FYDJSFXSGQGH','SF_YBFYDJSFZDBSDJF','SF_MZFPSFXSTSBZ','SF_MZRQDSFXSZHYE','SF_MZLSCFSFCSMFH','SF_LSCLSFXZ','SF_SFQYAKYYGH','SF_YJJDLEFTTOP','SF_TYJJDLEFTTOP','SF_DYBRXX_TOPLEFT','MZSF_YJJGHFB','SF_GHCKNLDYS','SF_GHCKSFTSZFCK','SF_SFKYQZTKCZ','SF_KP_SFQDZRXDTS','SF_BRGKSFXSMMK','SF_GRZFSFBHSB','SF_SFYJXGSJQY','SF_SFYXSFCDLYJXM','SF_PJWLYBNSY','SF_SFYXCKDQPJH','SF_YJXMYXTS','SF_CSBSYBFPSFFKCL','SF_RQDZFBLSFTXNJYY','SF_YBZGTJHSFYZMTJJK','MZSF_SFJSTXJKYCX','SF_MZFPSFXSQYXX','SF_SFHANHTSBZBR','SF_YBJKSFXDYNK','SF_FPBDJSRQSFXSQSRQ','SF_BJJESFBKKQFJE','SF_JSJZTKFPSFXSQZQYJJYE','SF_LSTDBRFB','SF_GHJFYCLXJBRZYXYXJZFFS','SF_YBGRZHZWYXQFJE','SF_PJGDZS')

115     09:50:36  SQL Execute: ORACLE -  select name00,value0 from XT_XTCS00 where NAME00 in ('SF_YBSFYGSSYLB','SF_MZFPSFDYYJJYE','SF_YBJSSAZTSBZ','SF_FYJSWSFTSWJSFY','MZSF_SFTSDYZSFP','SF_CJFY','SF_PRINTGHHFZDXZDY','SF_MZQDSFXSJMJE','SF_MZJSSFKYCZTYDW','SF_YHKLB','SF_GHXXSFTXJT','SF_FYJSSFXXZTSBZ','SF_GHLBBH','SF_GHXMBH','SF_PJQKSFDYFS','SF_SFSYFPXMZMYHJM','SF_FPGS00','SF_YYIDPDDLKS','SF_TSBZ_SFMRSCJZTSBZ','SF_TSBZ_SFZJSBTSBZFY','SF_FYDJSFXSGQGH','SF_YBFYDJSFZDBSDJF','SF_MZFPSFXSTSBZ','SF_MZRQDSFXSZHYE','SF_MZLSCFSFCSMFH','SF_LSCLSFXZ','SF_SFQYAKYYGH','SF_YJJDLEFTTOP','SF_TYJJDLEFTTOP','SF_DYBRXX_TOPLEFT','MZSF_YJJGHFB','SF_GHCKNLDYS','SF_GHCKSFTSZFCK','SF_SFKYQZTKCZ','SF_KP_SFQDZRXDTS','SF_BRGKSFXSMMK','SF_GRZFSFBHSB','SF_SFYJXGSJQY','SF_SFYXSFCDLYJXM','SF_PJWLYBNSY','SF_SFYXCKDQPJH','SF_YJXMYXTS','SF_CSBSYBFPSFFKCL','SF_RQDZFBLSFTXNJYY','SF_YBZGTJHSFYZMTJJK','MZSF_SFJSTXJKYCX','SF_MZFPSFXSQYXX','SF_SFHANHTSBZBR','SF_YBJKSFXDYNK','SF_FPBDJSRQSFXSQSRQ','SF_BJJESFBKKQFJE','SF_JSJZTKFPSFXSQZQYJJYE','SF_LSTDBRFB','SF_GHJFYCLXJBRZYXYXJZFFS','SF_YBGRZHZWYXQFJE','SF_PJGDZS')

116     09:50:36  SQL Prepare: ORACLE -  select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_JSSRTDXXTJBBSFCF','ZY_JSSRTDXXTJBBCFLS','ZY_JSSRTDXXTJBBCFHS','GHYXTS','YJ_XMYXTS','SF_PJHSC0','SF_DYYBFP','SF_MZBLH0','XT_JEQZ00','XT_YBJEQZ','SF_ZHTYJE','SF_ZHBJJE','SF_PJDKDY','YF_CFZJE_SRWS_YB','YF_CFZJE_CZFS_YB','YF_CFMXJE_SRWS','YF_YZMXJE_SRWS','YF_CFZJE_SRWS','YF_CFZJE_CZFS','YF_CFMXJE_CZFS','YF_YZMXJE_CZFS','SF_SFYJS0_BZ0000','SF_GHD000_PRINT0','SF_PRINTSCALE','SF_TKPAR0_CZY000','SF_PARAMS_GHYXTS','ZY_RQDZZ0_SETUP0','SF_RQDZZ0_SETUP0','SF_PageWidth','SF_PageHeigh','SF_PageDirect','SF_GHDLX0','SF_GHDSFTD','SF_JHFPSFTD','SF_SFSYJZK','SF_TJKSSJ','SF_TJJSSJ','SF_SFGLGZGHD','SF_YBGHFJF','SF_YBBRXB','SF_FPWidth','SF_FPHeigh','SF_NEWFPWidth','SF_NEWFPHeigh','SF_GHDWidth','SF_GHDHeigh','YF_ZYFJF_YPNM00','ZY_PJLYXYLYQR','SF_GHXGSFBRCZ','SF_JKDSFTD','SF_JKDJSFZDJS','SF_JKSFAJJBSJ','SF_NEWFPGS','SF_MZSFJJBSJ','SF_SYDJSBBGBF','SF_FYBXMSFSYYBBH','SF_GHCZSBBGBF','SF_MZJKDGS0','SF_YJJDGS0','SF_FYJSMR0','IC_YBYYJKLM','SF_COMMIT_READICK','SF_YBDJSLJE','SF_SFSYICK','SF_FPLXBZ0','XT_YBFSJK','XT_SGLRKH','XT_XYCYTCF','SF_XJGHSK','SF_BLHSFZDSC','SF_MZBLSYGS','SF_SFDYMZBL','XT_GZYJJYXTJK','SF_KHBLHXT','SF_SSWUTSCL','SF_SFCYSSWR','SF_HKSFTF0','SF_SFTKZDSP','SF_SFDYQD','SF_GHSSFSBLDGGH','SF_SFCFFP','SF_DYQBFP','SF_SFPDYB_CF0000','SF_ZY_SFZDXS','ZY_YJJPJ0','SF_SFSYYBYKT','SF_XJJSSFDYZHYE','SF_SFSYYGKJ','SF_KFSFKQ','SF_YBSFYXQF','ZY_YBFPBH','SF_CKBRSYGHD','IC_SFDM','SF_SFTSWF','SF_YBSFAGHDJS','SF_SFYDDYJ','SFYBZHYE','SF_MZYJJXZ','SF_SFDYTSJKD','SF_MZJSTSNY','SF_SFZDTJYJD','SF_TYJJDYYE','SF_SFDYZLD','SF_SFSYJZSX','SF_EJBBSFCF','SF_EJBBCFLS','SF_EJBBCFHS','SF_FPLEFT','SF_FPTOP','SF_TKAZFFS','SF_MZJKCZKZ','XT_JKTQSJ','SF_YJJGHZXJ','SF_SFCKJDDW','SF_DKZDDW','SF_ZY_FFJJ','SF_LSCFHJBRYF','SF_LSCFSFNFSRBRXM','SF_SFXMCGSXSFCF','SF_BRJKSFYXXDZ','SF_FYYFNFAZEYF','SF_YBFYDJSFLJJS','SF_YJJDSFDYPJH','SF_FYDJYSSFWK','SF_MZFPSFDYYBGRZHYE','SF_DEFAULT_HKSQKF','SF_YBBRJSSFTSDTJSFY','SF_YJJFXJZFZDXE','SF_YSXDHGHKSSFYXXG','SF_GHSYSXMSFYXWK','SF_BRNLSFXSDY','SF_SFYXXGBRBLH','SF_JZBRDTFPXZZS','SF_GHAXJYSXZLB','SF_SFQYCZPJKPJK','SF_KP_MZFPDYPLBH','SF_KP_FPZRDYMS','SF_KP_LJDLKPXTFS','XT_BRBYKFB','MZSF_FYBXJJZYXQC','SF_NNGHDTL','SF_RQDTOPLEFT','SF_RQDBOTTOMRIGHT','SF_YBJSSFYXQZHTK','SF_YBBNCZSSFZXJJZ','SF_SFYXTZZJE','SF_PRINTBLSYZDY','SF_PTBRSFAGHHJS','SF_YJJGHFYDJQDQYBZH','SF_GHFTC','SF_YJJTKQKYSPZSZ','SF_NLXDYSBSFXTLXR','SF_CKBRABLHJS','SF_FPDYGHRQ','SF_FYDJSSFBSYFYGH','SF_YJJDSFTD','SF_YJJTKDSFTD','SF_GYBRDTGHXDCS','SF_CGXESFYXQR','SF_LRSFXMSFABHPX','TJ_GRTJYXTS','SF_FZFPSFDYFYQZRQ','SF_PRINTYJJPJZDY','SF_PRINTYJJPJTKZDY','SF_FZFPDYPJXHLX','SF_HKSFKXZSQKF','XT_TJGHLB','SF_KP_CXZRSFZFYFP','SF_PRINTTJDWPJZDY','YS_SFYXPTBRTQGH','SF_MZFPSFXSFYBF','SF_XMFPSFXSYJJZE','SF_QSJDYJJZELB','SF_XMFPQDSFXSZLXM','MZ_FPGS00','SF_SFXMYBJK','IC_SFDM','SF_KP_ICKFSFDDLC','SF_SFCGHYSTHSQBZ','SF_XMYBFYDJSFKXZHLX','SF_GYZHPDBZ','SF_FPDYXS','SF_YJJPJ0','SF_XMYBZLFID','SF_MZSFYSZJHM','SF_YBSFFSGHKSBM')

117     09:50:36  SQL Execute: ORACLE -  select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_JSSRTDXXTJBBSFCF','ZY_JSSRTDXXTJBBCFLS','ZY_JSSRTDXXTJBBCFHS','GHYXTS','YJ_XMYXTS','SF_PJHSC0','SF_DYYBFP','SF_MZBLH0','XT_JEQZ00','XT_YBJEQZ','SF_ZHTYJE','SF_ZHBJJE','SF_PJDKDY','YF_CFZJE_SRWS_YB','YF_CFZJE_CZFS_YB','YF_CFMXJE_SRWS','YF_YZMXJE_SRWS','YF_CFZJE_SRWS','YF_CFZJE_CZFS','YF_CFMXJE_CZFS','YF_YZMXJE_CZFS','SF_SFYJS0_BZ0000','SF_GHD000_PRINT0','SF_PRINTSCALE','SF_TKPAR0_CZY000','SF_PARAMS_GHYXTS','ZY_RQDZZ0_SETUP0','SF_RQDZZ0_SETUP0','SF_PageWidth','SF_PageHeigh','SF_PageDirect','SF_GHDLX0','SF_GHDSFTD','SF_JHFPSFTD','SF_SFSYJZK','SF_TJKSSJ','SF_TJJSSJ','SF_SFGLGZGHD','SF_YBGHFJF','SF_YBBRXB','SF_FPWidth','SF_FPHeigh','SF_NEWFPWidth','SF_NEWFPHeigh','SF_GHDWidth','SF_GHDHeigh','YF_ZYFJF_YPNM00','ZY_PJLYXYLYQR','SF_GHXGSFBRCZ','SF_JKDSFTD','SF_JKDJSFZDJS','SF_JKSFAJJBSJ','SF_NEWFPGS','SF_MZSFJJBSJ','SF_SYDJSBBGBF','SF_FYBXMSFSYYBBH','SF_GHCZSBBGBF','SF_MZJKDGS0','SF_YJJDGS0','SF_FYJSMR0','IC_YBYYJKLM','SF_COMMIT_READICK','SF_YBDJSLJE','SF_SFSYICK','SF_FPLXBZ0','XT_YBFSJK','XT_SGLRKH','XT_XYCYTCF','SF_XJGHSK','SF_BLHSFZDSC','SF_MZBLSYGS','SF_SFDYMZBL','XT_GZYJJYXTJK','SF_KHBLHXT','SF_SSWUTSCL','SF_SFCYSSWR','SF_HKSFTF0','SF_SFTKZDSP','SF_SFDYQD','SF_GHSSFSBLDGGH','SF_SFCFFP','SF_DYQBFP','SF_SFPDYB_CF0000','SF_ZY_SFZDXS','ZY_YJJPJ0','SF_SFSYYBYKT','SF_XJJSSFDYZHYE','SF_SFSYYGKJ','SF_KFSFKQ','SF_YBSFYXQF','ZY_YBFPBH','SF_CKBRSYGHD','IC_SFDM','SF_SFTSWF','SF_YBSFAGHDJS','SF_SFYDDYJ','SFYBZHYE','SF_MZYJJXZ','SF_SFDYTSJKD','SF_MZJSTSNY','SF_SFZDTJYJD','SF_TYJJDYYE','SF_SFDYZLD','SF_SFSYJZSX','SF_EJBBSFCF','SF_EJBBCFLS','SF_EJBBCFHS','SF_FPLEFT','SF_FPTOP','SF_TKAZFFS','SF_MZJKCZKZ','XT_JKTQSJ','SF_YJJGHZXJ','SF_SFCKJDDW','SF_DKZDDW','SF_ZY_FFJJ','SF_LSCFHJBRYF','SF_LSCFSFNFSRBRXM','SF_SFXMCGSXSFCF','SF_BRJKSFYXXDZ','SF_FYYFNFAZEYF','SF_YBFYDJSFLJJS','SF_YJJDSFDYPJH','SF_FYDJYSSFWK','SF_MZFPSFDYYBGRZHYE','SF_DEFAULT_HKSQKF','SF_YBBRJSSFTSDTJSFY','SF_YJJFXJZFZDXE','SF_YSXDHGHKSSFYXXG','SF_GHSYSXMSFYXWK','SF_BRNLSFXSDY','SF_SFYXXGBRBLH','SF_JZBRDTFPXZZS','SF_GHAXJYSXZLB','SF_SFQYCZPJKPJK','SF_KP_MZFPDYPLBH','SF_KP_FPZRDYMS','SF_KP_LJDLKPXTFS','XT_BRBYKFB','MZSF_FYBXJJZYXQC','SF_NNGHDTL','SF_RQDTOPLEFT','SF_RQDBOTTOMRIGHT','SF_YBJSSFYXQZHTK','SF_YBBNCZSSFZXJJZ','SF_SFYXTZZJE','SF_PRINTBLSYZDY','SF_PTBRSFAGHHJS','SF_YJJGHFYDJQDQYBZH','SF_GHFTC','SF_YJJTKQKYSPZSZ','SF_NLXDYSBSFXTLXR','SF_CKBRABLHJS','SF_FPDYGHRQ','SF_FYDJSSFBSYFYGH','SF_YJJDSFTD','SF_YJJTKDSFTD','SF_GYBRDTGHXDCS','SF_CGXESFYXQR','SF_LRSFXMSFABHPX','TJ_GRTJYXTS','SF_FZFPSFDYFYQZRQ','SF_PRINTYJJPJZDY','SF_PRINTYJJPJTKZDY','SF_FZFPDYPJXHLX','SF_HKSFKXZSQKF','XT_TJGHLB','SF_KP_CXZRSFZFYFP','SF_PRINTTJDWPJZDY','YS_SFYXPTBRTQGH','SF_MZFPSFXSFYBF','SF_XMFPSFXSYJJZE','SF_QSJDYJJZELB','SF_XMFPQDSFXSZLXM','MZ_FPGS00','SF_SFXMYBJK','IC_SFDM','SF_KP_ICKFSFDDLC','SF_SFCGHYSTHSQBZ','SF_XMYBFYDJSFKXZHLX','SF_GYZHPDBZ','SF_FPDYXS','SF_YJJPJ0','SF_XMYBZLFID','SF_MZSFYSZJHM','SF_YBSFFSGHKSBM')

118     09:50:36  SQL Prepare: ORACLE -  select  *  from  IC_YBBRLB WHERE YBLB00='Z'

119     09:50:36  SQL Execute: ORACLE -  select  *  from  IC_YBBRLB WHERE YBLB00='Z'

120     09:50:36  SQL Prepare: ORACLE -  select * from bm_yysfxm where sfxmid=8000000218

121     09:50:36  SQL Execute: ORACLE -  select * from bm_yysfxm where sfxmid=8000000218

122     09:50:36  SQL Prepare: ORACLE -  select  name00,bz0000  from  xt_xtcs00 WHERE name00 in ('SF_XZXGTBLBCS','SF_FYQDBZXXNR')

123     09:50:36  SQL Execute: ORACLE -  select  name00,bz0000  from  xt_xtcs00 WHERE name00 in ('SF_XZXGTBLBCS','SF_FYQDBZXXNR')

124     09:50:36  SQL Prepare: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('SF_YCZYBKDYBFZX','SF_SFQYPYYBJK','SF_PYYBSFSFJYYBDY','SF_XEXMHZMXBZDY','SF_GFBRXJJSSFKXFB','SF_GFBRXJJSSFKXGZFBL','SF_GFBRSFKAZFGH','SF_HFLJCYBJSDZDY','SF_FYQDBZXXNR','SF_GHSFZNCLBYYS','SF_MZPBGLSFZNCLBYYS','SF_MZHBGLSFZNCLBYYS','SF_SRYSSFXSBYYS','SF_FYDJXZCFD','SF_XZXGTBLBCS','SF_SFXYBFSJMJE','YJ_XMZJYSWSSKS','SF_FPJHJZYHKPTSFXS','SF_JMYBYFCS','SF_JMYBSCJG','SF_JMYBSCJEXZ','SF_JMYBMNJEXZ','SF_JMYBMYYSCCSXZ','SF_JMYBCXESFSF','SF_JMYBNFCS','SF_MZBRJKYJJW0','SF_FPSFXSDYRQ','SF_SFYJSGNZDQY','SF_MZBRZHWHTKMM','SF_BRZFFSXS','SF_MZRSRBBSFXSJZKYJ','SF_SFDYGEDZBB','SF_SFQYGTYBJK','SF_GTYBSFSFJYYBDY','SF_GTYBBRTKSFDYJK','SF_MZJSSFXSBFSYB','SF_BRCFQDSFXSTXM','SF_YJKTKZYXTSTK','SF_YJJCLCESFAZFJS','SF_ZCNHBRFYSFCSGYB','SF_SFQYPYJMYBJK','SF_PYJMYBSFSFJYYBDY','SF_TYDWBRSFJYJJJK','TJ_ZEJMXMID','SF_TJFYDZHSFKYTK','SF_TJPJDYSFTSXS','SF_ICKSFCYJS','SF_LEDDISPJK','SF_ZFJSSFYXQZHTK','SF_MZFPPDSFXYBR','SF_YBTKSFSYYGH','SF_HKSFSH','SF_YJJTKJESFXSFS','SF_JKRQSFGBCXGJKRQ','SF_ZFBRXB','SF_BBTJSFJQZDS','SF_ZZSRSFNYXJTC','SF_JKDYFWSFYZTYZDZ','SF_JYJJSFTSJFCG','SF_MZBKMZFSFSQKF','SF_MZRQDSFXSJFJE','SF_MZQZTKMRWZ','SF_MZQDSFXSZFJE','SF_PJJHPJSFYZSFPQF','SF_PYMTJSDZDY','SF_JKDJNLSFBT','SF_SFCLYBJKDFS','SF_SFSYSFXMZMYHJM','SF_SFCLYBJKDFS_BC','SF_JKDSFSYFR3XS','SF_SFXMJKYL','SF_MZBRQXJSSFYDK','SF_SFYJKRBBASFYHZ','SF_BRGHDJDKYJJ','SF_YBJSRBBZJYS','SF_YJJ_ZYJTDZWKSFTS','SF_FPSFDYGWYJE','SF_YBBRTSBZSFXSYJXM','ZY_XNHCSLX','SF_TSBRFYDJXMWH','ZY_XNHFZXMC','SF_YJJPZXS','SF_SFQYXFP_GZ','SF_TSBRFYDJ','SF_MZYSGZLTJ_KS','SF_MZYSGZLTJ_YS','SF_SFQYDZQB','SF_DZQBTKFS','SF_XNHBRBXSYBZHJE','SF_DZQBJKXSYE','SF_YJJFPSFSYXGS','SF_MZFYGZTFCL','SF_ZGFBJLKKHXZ','SF_YJJYEQKBSTFK','SF_FYJSQZGNSFQY','YJ_XMAPSFAKSCX','YJ_XMYXTS','XT_ZYXTGBDW','YJ_XMAPDYZDYID','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XMCXZJTF','BQ_YJ_BQXMCXSQ','YJ_YXCXTS','YJ_YJCXD_ZDY','YS_SFTHHCCX','SF_YJCXDYMBID','SF_MZQDXJSFXSZDYH','SF_MZYJJJKSYBLH','SF_ZZJESFYXJTK','ZY_QDDYSFGJNRCDZDHH','SF_ZHWHQX','SF_JKRBBSFXSGHF','SF_SFMRDYFW','SF_SFQYPOSJK','SF_FYJSFPDYLX','SST_ZZJSFY','SF_YBBRCYJSSFBCWJ')

125     09:50:36  SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('SF_YCZYBKDYBFZX','SF_SFQYPYYBJK','SF_PYYBSFSFJYYBDY','SF_XEXMHZMXBZDY','SF_GFBRXJJSSFKXFB','SF_GFBRXJJSSFKXGZFBL','SF_GFBRSFKAZFGH','SF_HFLJCYBJSDZDY','SF_FYQDBZXXNR','SF_GHSFZNCLBYYS','SF_MZPBGLSFZNCLBYYS','SF_MZHBGLSFZNCLBYYS','SF_SRYSSFXSBYYS','SF_FYDJXZCFD','SF_XZXGTBLBCS','SF_SFXYBFSJMJE','YJ_XMZJYSWSSKS','SF_FPJHJZYHKPTSFXS','SF_JMYBYFCS','SF_JMYBSCJG','SF_JMYBSCJEXZ','SF_JMYBMNJEXZ','SF_JMYBMYYSCCSXZ','SF_JMYBCXESFSF','SF_JMYBNFCS','SF_MZBRJKYJJW0','SF_FPSFXSDYRQ','SF_SFYJSGNZDQY','SF_MZBRZHWHTKMM','SF_BRZFFSXS','SF_MZRSRBBSFXSJZKYJ','SF_SFDYGEDZBB','SF_SFQYGTYBJK','SF_GTYBSFSFJYYBDY','SF_GTYBBRTKSFDYJK','SF_MZJSSFXSBFSYB','SF_BRCFQDSFXSTXM','SF_YJKTKZYXTSTK','SF_YJJCLCESFAZFJS','SF_ZCNHBRFYSFCSGYB','SF_SFQYPYJMYBJK','SF_PYJMYBSFSFJYYBDY','SF_TYDWBRSFJYJJJK','TJ_ZEJMXMID','SF_TJFYDZHSFKYTK','SF_TJPJDYSFTSXS','SF_ICKSFCYJS','SF_LEDDISPJK','SF_ZFJSSFYXQZHTK','SF_MZFPPDSFXYBR','SF_YBTKSFSYYGH','SF_HKSFSH','SF_YJJTKJESFXSFS','SF_JKRQSFGBCXGJKRQ','SF_ZFBRXB','SF_BBTJSFJQZDS','SF_ZZSRSFNYXJTC','SF_JKDYFWSFYZTYZDZ','SF_JYJJSFTSJFCG','SF_MZBKMZFSFSQKF','SF_MZRQDSFXSJFJE','SF_MZQZTKMRWZ','SF_MZQDSFXSZFJE','SF_PJJHPJSFYZSFPQF','SF_PYMTJSDZDY','SF_JKDJNLSFBT','SF_SFCLYBJKDFS','SF_SFSYSFXMZMYHJM','SF_SFCLYBJKDFS_BC','SF_JKDSFSYFR3XS','SF_SFXMJKYL','SF_MZBRQXJSSFYDK','SF_SFYJKRBBASFYHZ','SF_BRGHDJDKYJJ','SF_YBJSRBBZJYS','SF_YJJ_ZYJTDZWKSFTS','SF_FPSFDYGWYJE','SF_YBBRTSBZSFXSYJXM','ZY_XNHCSLX','SF_TSBRFYDJXMWH','ZY_XNHFZXMC','SF_YJJPZXS','SF_SFQYXFP_GZ','SF_TSBRFYDJ','SF_MZYSGZLTJ_KS','SF_MZYSGZLTJ_YS','SF_SFQYDZQB','SF_DZQBTKFS','SF_XNHBRBXSYBZHJE','SF_DZQBJKXSYE','SF_YJJFPSFSYXGS','SF_MZFYGZTFCL','SF_ZGFBJLKKHXZ','SF_YJJYEQKBSTFK','SF_FYJSQZGNSFQY','YJ_XMAPSFAKSCX','YJ_XMYXTS','XT_ZYXTGBDW','YJ_XMAPDYZDYID','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XMCXZJTF','BQ_YJ_BQXMCXSQ','YJ_YXCXTS','YJ_YJCXD_ZDY','YS_SFTHHCCX','SF_YJCXDYMBID','SF_MZQDXJSFXSZDYH','SF_MZYJJJKSYBLH','SF_ZZJESFYXJTK','ZY_QDDYSFGJNRCDZDHH','SF_ZHWHQX','SF_JKRBBSFXSGHF','SF_SFMRDYFW','SF_SFQYPOSJK','SF_FYJSFPDYLX','SST_ZZJSFY','SF_YBBRCYJSSFBCWJ')

126     09:50:36  SQL Prepare: ORACLE -  select * from BM_YBBCLX where  YBYLZD>='YBYL01' and YBYLZD<='YBYL30' order by YBYLZD  

127     09:50:36  SQL Execute: ORACLE -  select * from BM_YBBCLX where  YBYLZD>='YBYL01' and YBYLZD<='YBYL30' order by YBYLZD  

128     09:50:36  SQL Prepare: ORACLE -  select * from BM_YBBCLX where  YBYLZD>='YBSM01' and YBYLZD<='YBSM08' order by YBYLZD  

129     09:50:36  SQL Execute: ORACLE -  select * from BM_YBBCLX where  YBYLZD>='YBSM01' and YBYLZD<='YBSM08' order by YBYLZD  

130     09:50:36  SQL Prepare: ORACLE - select VALUE0,BZ0000,to_date(substrb(VALUE0,1,8),'YYYYMMDD') SQRQ00,sysdate DTRQ00 from XT_XTCS00 where name00='SF_XNHFK'

131     09:50:36  SQL Execute: ORACLE - select VALUE0,BZ0000,to_date(substrb(VALUE0,1,8),'YYYYMMDD') SQRQ00,sysdate DTRQ00 from XT_XTCS00 where name00='SF_XNHFK'

132     09:50:46  SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44
 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000'

133     09:50:46  SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44
 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000'

134     09:50:46  SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44
 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000'

135     09:50:46  SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44
 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000'

136     09:50:46  SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44
 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000'

137     09:50:46  SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44
 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000'

138     09:50:46  SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44
 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000'

139     09:50:46  SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44
 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000'

140     09:50:46  SQL Prepare: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44
 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000'

141     09:50:46  SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=1143 and BMBH00=44
 and DLXTMC='门诊挂号收费管理系统' and CTMC00='frmZYSF_YBBRJS_RBB000'

142     09:50:46  SQL Prepare: ORACLE -  select  YYID00,YYJC00  from  XT_YYXX00 

143     09:50:46  SQL Execute: ORACLE -  select  YYID00,YYJC00  from  XT_YYXX00 

144     09:50:46  SQL Prepare: ORACLE - select  *  from  ic_ybbrlb  where  yblb00 <> '0'

145     09:50:46  SQL Execute: ORACLE - select  *  from  ic_ybbrlb  where  yblb00 <> '0'

146     09:50:46  SQL Prepare: ORACLE -  select YYID00 from xt_yyxx00 where rownum=1

147     09:50:46  SQL Execute: ORACLE -  select YYID00 from xt_yyxx00 where rownum=1

148     09:51:03  SQL Prepare: ORACLE - BEGIN "SP_SF_MZSRYB_RBB000" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_CZYXM0 => :AS_CZYXM0,AS_YBZXMC => :AS_YBZXMC,AS_TJBZ00 => :AS_TJBZ00,AD_ID0000 => :AD_ID0000,AS_SFRQYS => :AS_SFRQYS,as_BRYBZX => :as_BRYBZX,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_YYID00 => :as_YYID00,as_TJFS00 => :as_TJFS00); END;
149     09:51:03  SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140225
150     09:51:03  SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140225
151     09:51:03  SQL Data In: ORACLE - Param = 3, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00
152     09:51:03  SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59
153     09:51:03  SQL Data In: ORACLE - Param = 5, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
154     09:51:03  SQL Data In: ORACLE - Param = 6, Name = AS_YBZXMC, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
155     09:51:03  SQL Data In: ORACLE - Param = 7, Name = AS_TJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
156     09:51:03  SQL Data In: ORACLE - Param = 8, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
157     09:51:03  SQL Data In: ORACLE - Param = 9, Name = AS_SFRQYS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
158     09:51:03  SQL Data In: ORACLE - Param = 10, Name = as_BRYBZX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1
159     09:51:03  SQL Data In: ORACLE - Param = 11, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
160     09:51:03  SQL Data In: ORACLE - Param = 12, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
161     09:51:03  SQL Data In: ORACLE - Param = 13, Name = as_YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 222137
162     09:51:03  SQL Data In: ORACLE - Param = 14, Name = as_TJFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
163     09:51:03  SQL Execute: ORACLE - BEGIN "SP_SF_MZSRYB_RBB000" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_CZYXM0 => :AS_CZYXM0,AS_YBZXMC => :AS_YBZXMC,AS_TJBZ00 => :AS_TJBZ00,AD_ID0000 => :AD_ID0000,AS_SFRQYS => :AS_SFRQYS,as_BRYBZX => :as_BRYBZX,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_YYID00 => :as_YYID00,as_TJFS00 => :as_TJFS00); END;
164     09:51:51  SQL Prepare: ORACLE -  select  C.ZWXM00,A.GHRQ00,A.BEIZHU FZXMC0,sum(A.GHKS03) GHKS03,sum(A.GHKS04) GHKS04,sum(A.GHKS05) GHKS05,sum(A.GHKS06) GHKS06,sum(A.GHKS07) GHKS07,sum(A.GHKS08) GHKS08,sum(GHKS09) GHKS09,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0))) XMHJ00,nvl(sum(GHKS10),0) GHKS10,
 NVL((sum(XMHJ00)-nvl(sum(GHKS10),0)),0) GHKS11,sum(A.GHKS12) GHKS12,sum(A.GHKS13) GHKS13,sum(A.GHKS14) GHKS14,sum(A.GHKS15) GHKS15,sum(A.GHKS16) GHKS16
 ,sum(A.GHKS51) GHKS51,sum(A.GHKS52) GHKS52
 from  BM_GHKSTJ A
,BM_YGBM00 C  where  A.GHKS02 = C.YGBH00(+)  and  ID0000=:1 and A.XMHJ00<>0
 group by  A.GHRQ00,C.ZWXM00,A.BEIZHU 
 order  by  A.GHRQ00 

165     09:51:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1692593.000000
166     09:51:51  SQL Execute: ORACLE -  select  C.ZWXM00,A.GHRQ00,A.BEIZHU FZXMC0,sum(A.GHKS03) GHKS03,sum(A.GHKS04) GHKS04,sum(A.GHKS05) GHKS05,sum(A.GHKS06) GHKS06,sum(A.GHKS07) GHKS07,sum(A.GHKS08) GHKS08,sum(GHKS09) GHKS09,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0))) XMHJ00,nvl(sum(GHKS10),0) GHKS10,
 NVL((sum(XMHJ00)-nvl(sum(GHKS10),0)),0) GHKS11,sum(A.GHKS12) GHKS12,sum(A.GHKS13) GHKS13,sum(A.GHKS14) GHKS14,sum(A.GHKS15) GHKS15,sum(A.GHKS16) GHKS16
 ,sum(A.GHKS51) GHKS51,sum(A.GHKS52) GHKS52
 from  BM_GHKSTJ A
,BM_YGBM00 C  where  A.GHKS02 = C.YGBH00(+)  and  ID0000=? and A.XMHJ00<>0
 group by  A.GHRQ00,C.ZWXM00,A.BEIZHU 
 order  by  A.GHRQ00 

167     09:51:51  SQL Prepare: ORACLE -  select  A.GHRQ00,DECODE(trim(A.GHRQ00),'合计','',b.BRBLH0) BRBLH0,B.YBKH00,DECODE(trim(A.GHRQ00),'合计','',B.BRXM00) BRXM00
,DECODE(trim(A.GHRQ00),'合计','',B.BRXB00) BRXB00,DECODE(trim(A.GHRQ00),'合计','',C.ZWXM00) ZWXM00,sum(A.GHKS03) GHKS03,
sum(A.GHKS04)GHKS04,sum(A.GHKS05)GHKS05,sum(A.GHKS06)GHKS06,sum(A.GHKS07)GHKS07,sum(A.GHKS08)GHKS08,sum(A.GHKS09)GHKS09,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0))) XMHJ00,nvl(sum(GHKS10),0) GHKS10,
NVL((sum(XMHJ00)-nvl(sum(GHKS10),0)),0) GHKS11,sum(A.GHKS12) GHKS12,sum(A.GHKS13) GHKS13,sum(A.GHKS14) GHKS14,sum(A.GHKS15) GHKS15
,B.BRZTQK,B.TYDWMC,sum(GHKS16)GHKS16,sum(GHKS17)GHKS17,sum(GHKS18)GHKS18,sum(GHKS19)GHKS19,sum(GHKS20)GHKS20,sum(GHKS21)GHKS21,sum(GHKS22)GHKS22,sum(GHKS23)GHKS23,sum(GHKS24)GHKS24,sum(GHKS25)GHKS25,sum(GHKS26)GHKS26,sum(GHKS27)GHKS27,sum(GHKS28)GHKS28
,sum(GHKS29)GHKS29,sum(GHKS30)GHKS30,sum(GHKS31)GHKS31,sum(GHKS32)GHKS32,sum(GHKS33)GHKS33,sum(GHKS34)GHKS34,sum(GHKS35)GHKS35,sum(GHKS36)GHKS36,sum(GHKS37)GHKS37
,sum(A.GHKS51) GHKS51,sum(A.GHKS52) GHKS52
,A.BEIZHU FZXMC0
,' ' GHKS99 
,' ' BMMC00 
 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,BM_BMBM00 D where A.GHKS01=B.BRID00(+) and A.GHKS02=C.YGBH00(+) and A.GHKS98=D.BMBH00(+) and ID0000=:1
 group by A.GHRQ00,B.BRBLH0,B.YBKH00,B.BRXM00,B.BRXB00,C.ZWXM00,B.BRZTQK,B.TYDWMC,A.BEIZHU
 order by A.GHRQ00

168     09:51:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1692593.000000
169     09:51:51  SQL Execute: ORACLE -  select  A.GHRQ00,DECODE(trim(A.GHRQ00),'合计','',b.BRBLH0) BRBLH0,B.YBKH00,DECODE(trim(A.GHRQ00),'合计','',B.BRXM00) BRXM00
,DECODE(trim(A.GHRQ00),'合计','',B.BRXB00) BRXB00,DECODE(trim(A.GHRQ00),'合计','',C.ZWXM00) ZWXM00,sum(A.GHKS03) GHKS03,
sum(A.GHKS04)GHKS04,sum(A.GHKS05)GHKS05,sum(A.GHKS06)GHKS06,sum(A.GHKS07)GHKS07,sum(A.GHKS08)GHKS08,sum(A.GHKS09)GHKS09,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0))) XMHJ00,nvl(sum(GHKS10),0) GHKS10,
NVL((sum(XMHJ00)-nvl(sum(GHKS10),0)),0) GHKS11,sum(A.GHKS12) GHKS12,sum(A.GHKS13) GHKS13,sum(A.GHKS14) GHKS14,sum(A.GHKS15) GHKS15
,B.BRZTQK,B.TYDWMC,sum(GHKS16)GHKS16,sum(GHKS17)GHKS17,sum(GHKS18)GHKS18,sum(GHKS19)GHKS19,sum(GHKS20)GHKS20,sum(GHKS21)GHKS21,sum(GHKS22)GHKS22,sum(GHKS23)GHKS23,sum(GHKS24)GHKS24,sum(GHKS25)GHKS25,sum(GHKS26)GHKS26,sum(GHKS27)GHKS27,sum(GHKS28)GHKS28
,sum(GHKS29)GHKS29,sum(GHKS30)GHKS30,sum(GHKS31)GHKS31,sum(GHKS32)GHKS32,sum(GHKS33)GHKS33,sum(GHKS34)GHKS34,sum(GHKS35)GHKS35,sum(GHKS36)GHKS36,sum(GHKS37)GHKS37
,sum(A.GHKS51) GHKS51,sum(A.GHKS52) GHKS52
,A.BEIZHU FZXMC0
,' ' GHKS99 
,' ' BMMC00 
 from BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,BM_BMBM00 D where A.GHKS01=B.BRID00(+) and A.GHKS02=C.YGBH00(+) and A.GHKS98=D.BMBH00(+) and ID0000=?
 group by A.GHRQ00,B.BRBLH0,B.YBKH00,B.BRXM00,B.BRXB00,C.ZWXM00,B.BRZTQK,B.TYDWMC,A.BEIZHU
 order by A.GHRQ00

170     09:51:52  SQL Prepare: ORACLE -  select  A.GHRQ00,sum(A.GHKS03) GHKS03,sum(A.GHKS04) GHKS04,sum(A.GHKS05) GHKS05,sum(A.GHKS06) GHKS06,sum(A.GHKS07) GHKS07,sum(A.GHKS08) GHKS08,sum(GHKS09) GHKS09,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0))) XMHJ00,nvl(sum(GHKS10),0) GHKS10,
 NVL((sum(XMHJ00)-nvl(sum(GHKS10),0)),0) GHKS11,sum(A.GHKS12) GHKS12,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0)))-nvl(SUM(GHKS03),0) YBFY00,sum(A.GHKS13) GHKS13,sum(A.GHKS14) GHKS14,sum(A.GHKS15) GHKS15,sum(A.GHKS16) GHKS16 
 ,sum(A.GHKS51) GHKS51,sum(A.GHKS52) GHKS52
,A.BEIZHU FZXMC0
 from  BM_GHKSTJ A,BM_YGBM00 C  where  A.GHKS02 = C.YGBH00(+)  and  ID0000=:1 
 group by  A.GHRQ00,A.BEIZHU 
 order  by  A.GHRQ00 

171     09:51:52  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1692593.000000
172     09:51:52  SQL Execute: ORACLE -  select  A.GHRQ00,sum(A.GHKS03) GHKS03,sum(A.GHKS04) GHKS04,sum(A.GHKS05) GHKS05,sum(A.GHKS06) GHKS06,sum(A.GHKS07) GHKS07,sum(A.GHKS08) GHKS08,sum(GHKS09) GHKS09,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0))) XMHJ00,nvl(sum(GHKS10),0) GHKS10,
 NVL((sum(XMHJ00)-nvl(sum(GHKS10),0)),0) GHKS11,sum(A.GHKS12) GHKS12,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0)))-nvl(SUM(GHKS03),0) YBFY00,sum(A.GHKS13) GHKS13,sum(A.GHKS14) GHKS14,sum(A.GHKS15) GHKS15,sum(A.GHKS16) GHKS16 
 ,sum(A.GHKS51) GHKS51,sum(A.GHKS52) GHKS52
,A.BEIZHU FZXMC0
 from  BM_GHKSTJ A,BM_YGBM00 C  where  A.GHKS02 = C.YGBH00(+)  and  ID0000=? 
 group by  A.GHRQ00,A.BEIZHU 
 order  by  A.GHRQ00 

173     09:51:52  SQL Prepare: ORACLE -  select  A.GHRQ00,DECODE(trim(A.GHRQ00),'合计','',b.BRBLH0) BRBLH0,B.YBKH00,DECODE(trim(A.GHRQ00),'合计','',B.BRXM00) BRXM00
,DECODE(trim(A.GHRQ00),'合计','',B.BRXB00) BRXB00,sum(A.GHKS03) GHKS03,
 sum(A.GHKS04) GHKS04,sum(A.GHKS05) GHKS05,sum(A.GHKS06) GHKS06,sum(A.GHKS07) GHKS07,sum(A.GHKS08) GHKS08,sum(A.GHKS09) GHKS09,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0))) XMHJ00,nvl(sum(GHKS10),0) GHKS10,
 NVL((sum(XMHJ00)-nvl(sum(GHKS10),0)),0) GHKS11,sum(A.GHKS12) GHKS12,sum(A.GHKS13) GHKS13,sum(A.GHKS14) GHKS14,sum(A.GHKS15) GHKS15 
,sum(A.GHKS16) GHKS16,sum(A.GHKS17) GHKS17,sum(A.GHKS18) GHKS18,sum(A.GHKS19) GHKS19,sum(A.GHKS20) GHKS20,sum(A.GHKS21) GHKS21,sum(A.GHKS22) GHKS22,sum(A.GHKS23) GHKS23
,sum(A.GHKS24) GHKS24,sum(A.GHKS25) GHKS25,sum(A.GHKS26) GHKS26,sum(A.GHKS27) GHKS27,sum(A.GHKS28) GHKS28,sum(A.GHKS29) GHKS29,sum(A.GHKS30) GHKS30,sum(A.GHKS31) GHKS31
,sum(A.GHKS32) GHKS32,sum(A.GHKS33) GHKS33,sum(A.GHKS34) GHKS34,sum(A.GHKS35) GHKS35,sum(A.GHKS36) GHKS36,sum(A.GHKS37) GHKS37
 ,sum(A.GHKS51) GHKS51,sum(A.GHKS52) GHKS52
,A.BEIZHU FZXMC0
,' ' BMMC00 
 from  BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,BM_BMBM00 D  where  A.GHKS01 = B.BRID00(+) and  A.GHKS02 = C.YGBH00(+) and A.GHKS98=D.BMBH00(+)  and  ID0000=:1 
 group by  A.GHRQ00,B.BRBLH0,B.YBKH00,B.BRXM00,B.BRXB00,A.BEIZHU 
 order  by  A.GHRQ00 

174     09:51:52  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1692593.000000
175     09:51:52  SQL Execute: ORACLE -  select  A.GHRQ00,DECODE(trim(A.GHRQ00),'合计','',b.BRBLH0) BRBLH0,B.YBKH00,DECODE(trim(A.GHRQ00),'合计','',B.BRXM00) BRXM00
,DECODE(trim(A.GHRQ00),'合计','',B.BRXB00) BRXB00,sum(A.GHKS03) GHKS03,
 sum(A.GHKS04) GHKS04,sum(A.GHKS05) GHKS05,sum(A.GHKS06) GHKS06,sum(A.GHKS07) GHKS07,sum(A.GHKS08) GHKS08,sum(A.GHKS09) GHKS09,DECODE('Y','Y',sum(XMHJ00),sum(nvl(XMHJ00,0)-NVL(GHKS06,0)-NVL(GHKS07,0))) XMHJ00,nvl(sum(GHKS10),0) GHKS10,
 NVL((sum(XMHJ00)-nvl(sum(GHKS10),0)),0) GHKS11,sum(A.GHKS12) GHKS12,sum(A.GHKS13) GHKS13,sum(A.GHKS14) GHKS14,sum(A.GHKS15) GHKS15 
,sum(A.GHKS16) GHKS16,sum(A.GHKS17) GHKS17,sum(A.GHKS18) GHKS18,sum(A.GHKS19) GHKS19,sum(A.GHKS20) GHKS20,sum(A.GHKS21) GHKS21,sum(A.GHKS22) GHKS22,sum(A.GHKS23) GHKS23
,sum(A.GHKS24) GHKS24,sum(A.GHKS25) GHKS25,sum(A.GHKS26) GHKS26,sum(A.GHKS27) GHKS27,sum(A.GHKS28) GHKS28,sum(A.GHKS29) GHKS29,sum(A.GHKS30) GHKS30,sum(A.GHKS31) GHKS31
,sum(A.GHKS32) GHKS32,sum(A.GHKS33) GHKS33,sum(A.GHKS34) GHKS34,sum(A.GHKS35) GHKS35,sum(A.GHKS36) GHKS36,sum(A.GHKS37) GHKS37
 ,sum(A.GHKS51) GHKS51,sum(A.GHKS52) GHKS52
,A.BEIZHU FZXMC0
,' ' BMMC00 
 from  BM_GHKSTJ A,bm_brxxb0 B,bm_ygbm00 C,BM_BMBM00 D  where  A.GHKS01 = B.BRID00(+) and  A.GHKS02 = C.YGBH00(+) and A.GHKS98=D.BMBH00(+)  and  ID0000=? 
 group by  A.GHRQ00,B.BRBLH0,B.YBKH00,B.BRXM00,B.BRXB00,A.BEIZHU 
 order  by  A.GHRQ00 

176     09:51:52  SQL Prepare: ORACLE -  select  C.YBMC00,sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GRZHZF) GRZHZF,SUM(A.TCJJZF) TCJJZF,SUM(A.SBGRZH) SBGRZH,SUM(A.SBTCJJ) SBTCJJ,SUM(A.GFJE00) GFJE00,SUM(A.SYBXZF) SYBXZF,SUM(A.BRZJE0) BRZJE0,SUM(A.SBZFE0) SBZFE0,SUM(A.BJZFE0) BJZFE0, 
 sum(A.GWYBZ0) GWYBZ0 
,sum(a.YBYL11)GHKS51,sum(a.YBYL13)GHKS52
from  SF_JZB000 A,IC_YBBRLB C,BM_YGBM00 E ,SF_BRXXB0 B,bm_ybbrlb F 
 where  A.YBLB00  = C.YBLB00 and  A.FBBH00  = C.FBBH00 and  C.YBLB00 <> '0' 
 and   a.fbbh00 = f.fbbh00  and a.ybbrlb = f.ybbrlb  and c.ybzxlb = f.ybzxlb 
 and  A.JZRQ00 >= :1 and  A.JZRQ00 <= :2  
 and  A.JZRQ00||A.JZSJ00 >= :3
 and  A.JZRQ00||A.JZSJ00 <= :4
 and  A.JZY000  = E.YGBH00 and A.MZID00=B.GHID00 
 and B.BXLB00 IN ('生育','工伤')
 AND A.CZYKS0  in (select d.bmbh00 from BM_BMBM00 D where d.yyid00=:5)
 GROUP  BY  C.YBMC00
 union all 
 select  '合计',sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GRZHZF) GRZHZF,SUM(A.TCJJZF) TCJJZF,SUM(A.SBGRZH) SBGRZH,SUM(A.SBTCJJ) SBTCJJ,SUM(A.GFJE00) GFJE00,SUM(A.SYBXZF) SYBXZF,SUM(A.BRZJE0) BRZJE0,SUM(A.SBZFE0) SBZFE0,SUM(A.BJZFE0) BJZFE0, 
 SUM(A.GWYBZ0) GWYBZ0
,sum(a.YBYL11)GHKS51,sum(a.YBYL13)GHKS52
 from  SF_JZB000 A,IC_YBBRLB C,BM_YGBM00 E ,SF_BRXXB0 B,bm_ybbrlb F  
 where  A.YBLB00  = C.YBLB00 and  A.FBBH00  = C.FBBH00 and  C.YBLB00 <> '0' 
 and   a.fbbh00 = f.fbbh00  and a.ybbrlb = f.ybbrlb  and c.ybzxlb = f.ybzxlb 
 and  A.JZRQ00 >= :6 and  A.JZRQ00 <= :7  
 and  A.JZRQ00||A.JZSJ00 >= :8
 and  A.JZRQ00||A.JZSJ00 <= :9
 and  A.JZY000  = E.YGBH00 and A.MZID00=B.GHID00 
 and B.BXLB00 IN ('生育','工伤')
 AND A.CZYKS0  in (select d.bmbh00 from BM_BMBM00 D where d.yyid00=:10)

177     09:51:52  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140225
178     09:51:52  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140225
179     09:51:52  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2014022500:00:00
180     09:51:52  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2014022523:59:59
181     09:51:52  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 222137
182     09:51:52  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140225
183     09:51:52  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140225
184     09:51:52  SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2014022500:00:00
185     09:51:52  SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2014022523:59:59
186     09:51:52  SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 222137
187     09:51:52  SQL Execute: ORACLE -  select  C.YBMC00,sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GRZHZF) GRZHZF,SUM(A.TCJJZF) TCJJZF,SUM(A.SBGRZH) SBGRZH,SUM(A.SBTCJJ) SBTCJJ,SUM(A.GFJE00) GFJE00,SUM(A.SYBXZF) SYBXZF,SUM(A.BRZJE0) BRZJE0,SUM(A.SBZFE0) SBZFE0,SUM(A.BJZFE0) BJZFE0, 
 sum(A.GWYBZ0) GWYBZ0 
,sum(a.YBYL11)GHKS51,sum(a.YBYL13)GHKS52
from  SF_JZB000 A,IC_YBBRLB C,BM_YGBM00 E ,SF_BRXXB0 B,bm_ybbrlb F 
 where  A.YBLB00  = C.YBLB00 and  A.FBBH00  = C.FBBH00 and  C.YBLB00 <> '0' 
 and   a.fbbh00 = f.fbbh00  and a.ybbrlb = f.ybbrlb  and c.ybzxlb = f.ybzxlb 
 and  A.JZRQ00 >= ? and  A.JZRQ00 <= ?  
 and  A.JZRQ00||A.JZSJ00 >= ?
 and  A.JZRQ00||A.JZSJ00 <= ?
 and  A.JZY000  = E.YGBH00 and A.MZID00=B.GHID00 
 and B.BXLB00 IN ('生育','工伤')
 AND A.CZYKS0  in (select d.bmbh00 from BM_BMBM00 D where d.yyid00=?)
 GROUP  BY  C.YBMC00
 union all 
 select  '合计',sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GRZHZF) GRZHZF,SUM(A.TCJJZF) TCJJZF,SUM(A.SBGRZH) SBGRZH,SUM(A.SBTCJJ) SBTCJJ,SUM(A.GFJE00) GFJE00,SUM(A.SYBXZF) SYBXZF,SUM(A.BRZJE0) BRZJE0,SUM(A.SBZFE0) SBZFE0,SUM(A.BJZFE0) BJZFE0, 
 SUM(A.GWYBZ0) GWYBZ0
,sum(a.YBYL11)GHKS51,sum(a.YBYL13)GHKS52
 from  SF_JZB000 A,IC_YBBRLB C,BM_YGBM00 E ,SF_BRXXB0 B,bm_ybbrlb F  
 where  A.YBLB00  = C.YBLB00 and  A.FBBH00  = C.FBBH00 and  C.YBLB00 <> '0' 
 and   a.fbbh00 = f.fbbh00  and a.ybbrlb = f.ybbrlb  and c.ybzxlb = f.ybzxlb 
 and  A.JZRQ00 >= ? and  A.JZRQ00 <= ?  
 and  A.JZRQ00||A.JZSJ00 >= ?
 and  A.JZRQ00||A.JZSJ00 <= ?
 and  A.JZY000  = E.YGBH00 and A.MZID00=B.GHID00 
 and B.BXLB00 IN ('生育','工伤')
 AND A.CZYKS0  in (select d.bmbh00 from BM_BMBM00 D where d.yyid00=?)

188     09:52:50  SQL Prepare: ORACLE - BEGIN "SP_SF_MZSRYB_JZBRMX" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_CZYXM0 => :AS_CZYXM0,AS_YBZXMC => :AS_YBZXMC,AS_TJBZ00 => :AS_TJBZ00,AD_ID0000 => :AD_ID0000,AS_SFRQYS => :AS_SFRQYS,as_BRYBZX => :as_BRYBZX,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_YYID00 => :as_YYID00,as_TJFS00 => :as_TJFS00); END;
189     09:52:50  SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140225
190     09:52:50  SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140225
191     09:52:50  SQL Data In: ORACLE - Param = 3, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00
192     09:52:50  SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59
193     09:52:50  SQL Data In: ORACLE - Param = 5, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
194     09:52:50  SQL Data In: ORACLE - Param = 6, Name = AS_YBZXMC, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
195     09:52:50  SQL Data In: ORACLE - Param = 7, Name = AS_TJBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
196     09:52:50  SQL Data In: ORACLE - Param = 8, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
197     09:52:50  SQL Data In: ORACLE - Param = 9, Name = AS_SFRQYS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
198     09:52:50  SQL Data In: ORACLE - Param = 10, Name = as_BRYBZX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1
199     09:52:50  SQL Data In: ORACLE - Param = 11, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
200     09:52:50  SQL Data In: ORACLE - Param = 12, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
201     09:52:50  SQL Data In: ORACLE - Param = 13, Name = as_YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 222137
202     09:52:50  SQL Data In: ORACLE - Param = 14, Name = as_TJFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
203     09:52:50  SQL Execute: ORACLE - BEGIN "SP_SF_MZSRYB_JZBRMX" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_CZYXM0 => :AS_CZYXM0,AS_YBZXMC => :AS_YBZXMC,AS_TJBZ00 => :AS_TJBZ00,AD_ID0000 => :AD_ID0000,AS_SFRQYS => :AS_SFRQYS,as_BRYBZX => :as_BRYBZX,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,as_YYID00 => :as_YYID00,as_TJFS00 => :as_TJFS00); END;