1 15:33:56 Log started for: 药房管理系统 2 15:33:56 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 15:33:57 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.6.108','2','appYP_YF.exe'||'+'||'药房管理系统','219','63249' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@1502:1ED9A5CF107209CDC359C45FDC360796' from dual 4 15:33:57 SQL Data In: ORACLE - Rows affected = 1 5 15:33:57 SQL Execute: ORACLE - Commit 6 15:33:57 SQL Data In: ORACLE - Rows affected = 0 7 15:33:57 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 15:33:57 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='226884' 9 15:33:57 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='1502' and CZBZ00 in ('1') 10 15:33:57 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 11 15:33:57 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.6.108','2','appYP_YF.exe'||'+'||'药房管理系统','353','64141' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@1502:8E701C8FE2522365996EF704B9BBA278' from dual 12 15:33:57 SQL Data In: ORACLE - Rows affected = 1 13 15:33:57 SQL Execute: ORACLE - Commit 14 15:33:57 SQL Data In: ORACLE - Rows affected = 0 15 15:33:57 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 16 15:33:57 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='1502' and CZBZ00 in ('1') 17 15:33:57 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='XT_SFKQCADLYZ' 18 15:33:57 SQL Execute: ORACLE - select nvl(SFSDYH,'0') from BM_YGBM00 where XKH000='1502' 19 15:33:57 SQL Execute: ORACLE - Select SYSDATE from Dual 20 15:33:57 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 21 15:33:57 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 22 15:33:57 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2' 23 15:33:57 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 24 15:33: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 25 15:33: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') and KLDH00 = 'SLE4442' 26 15:33: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') and KLDH00 = 'YB-SBK' 27 15:33:57 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='1502')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('2','3') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='1502')) order by b.PLXH00,a.BH0000 28 15:33:57 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '1502'='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)='1502')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='1502') 29 15:33:57 SQL Execute: ORACLE - select ZWXM00,XKH000,YBYGDM,YBZSBH from BM_YGBM00 where YGBH00=554 30 15:33:57 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 31 15:33:57 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 32 15:33:57 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 33 15:33:57 SQL Execute: ORACLE - select SID,SERIAL# from V$session where AUDSID='3481082' 34 15:33:57 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 35 15:33:57 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where SID000='353' and SERIAL='64141' and LJRQ00=to_char(sysdate,'YYYYMMDD') 36 15:33:57 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3417319,554,'西药房02','2',nvl('3481082',' '),'192.168.6.108#353:64141@appYP_YF.exe+药房管理系统',28) 37 15:33:57 SQL Data In: ORACLE - Rows affected = 1 38 15:33:57 SQL Execute: ORACLE - Commit 39 15:33:57 SQL Data In: ORACLE - Rows affected = 0 40 15:33:57 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 28 41 15:33:57 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '226884' 42 15:33:57 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 43 15:33:57 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.6.108' 44 15:33:57 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 45 15:33:57 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 28 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 46 15:33:57 SQL Execute: ORACLE - select FSBYJ0 from BM_CKBM00 where BMBH00= 28 and FLAG00 like '%' and CKBH00='' 47 15:33:57 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('226884') 48 15:33:57 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'2'||',')>0 49 15:33:58 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='554' and name00='SYSTEMSKIN' 50 15:33:58 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 51 15:33:58 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_XTXXCKSIZE' 52 15:33:58 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20250213' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',28,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='2') 53 15:33:58 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') and (SYXT00='999' or instr(','||SYXT00||',',',2,')>0 ) 54 15:33:58 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 55 15:33:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 电子虚拟健康卡 56 15:33:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ 57 15:33:58 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 58 15:33:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 电子虚拟健康卡 59 15:33:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = XT_QYDZXNJKKXT 60 15:33:58 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 61 15:33:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 电子虚拟健康卡 62 15:33:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = XT_SFQYDZJKK_XNGN 63 15:33:58 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 64 15:33:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置 65 15:33:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ 66 15:33:58 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 67 15:33:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 电子虚拟健康卡 68 15:33:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = XT_XZDKFS 69 15:33:58 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 70 15:33:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 电子虚拟健康卡 71 15:33:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = XT_XZDKFS_TS 72 15:33:59 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 73 15:33:59 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00='XT_SQLPLUSSECURLEVEL' 74 15:33:59 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='SQL注入关键字配置' order by XSXH00 75 15:33:59 SQL Execute: ORACLE - select trim(VALUE0) VALUE0 from XT_XTCS00 where name00='XT_YBKDKFS' 76 15:33:59 SQL Execute: ORACLE - select trim(VALUE0) VALUE0 from XT_XTCS00 where name00='XT_SRKHSFBHQZ' 77 15:33:59 SQL Execute: ORACLE - select trim(VALUE0) VALUE0 from XT_XTCS00 where name00='XT_SFQYXBDK' 78 15:33:59 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID' 79 15:33:59 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID' 80 15:33:59 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED' 81 15:33:59 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=28 82 15:33:59 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual 83 15:33:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 一卡通平台参数 84 15:33:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYYKTPT 85 15:33:59 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 86 15:33:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 发送外部接口数据 87 15:33:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = Open 88 15:33:59 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 89 15:33:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 福建预交金统一平台 90 15:33:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ 91 15:33:59 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 92 15:33:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 移动医保结算参数 93 15:33:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ 94 15:33:59 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 95 15:33:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 代煎平台配置 96 15:33:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = YF_ZYDJCJJKCJ 97 15:33:59 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 98 15:33:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 医保追溯码配置 99 15:33:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = YBZSMSFQY 100 15:33:59 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 101 15:33:59 SQL Execute: ORACLE - select * from XT_XTCS00 102 15:34:04 SQL Execute: ORACLE - select * from BM_YPLB00 103 15:34:04 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=554 104 15:34:04 SQL Execute: ORACLE - select MC0000,BZ0000,BH0000 from BM_TYZD00 where ZDMC00='合理用药' AND YXBZ00='1' order by XSXH00 105 15:34:04 SQL Execute: ORACLE - SELECT LBMC00 FROM BM_YPLB00 where LBBH00='3' 106 15:34:04 SQL Execute: ORACLE - select count(*) COU from BM_TYCJBM where CJBM00='YF00_H360_0001' and SFQY00='1' 107 15:34:04 SQL Execute: ORACLE - select count(*) COU from BM_TYCJBM where CJBM00='YF00_MZBL_0001' and SFQY00='1' 108 15:34:04 SQL Execute: ORACLE - select 1 from BM_TYZD00 where ZDMC00='启用门诊处方配药人的药房配置' and YXBZ00='1' and BH0000='28' 109 15:34:04 SQL Execute: ORACLE - select BH0000,MC0000,WBSM00 from BM_TYZD00 where ZDMC00='系统登录版本设置' and BH0000 in('2') and YXBZ00='1' 110 15:34:04 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='2' and (( 554= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=554 and XTDM00='2'))) 111 15:34:04 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 112 15:34:04 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 ((554= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=554 and XTDM00='0 '))) 113 15:34:04 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 114 15:34:04 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 554= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=554 and XTDM00='+ '))) 115 15:34:04 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 116 15:34:04 SQL Execute: ORACLE - SELECT 'X' FROM VW_YF_YPKCXX WHERE YFBMBH=28 AND YKKCSL'0' 117 15:34:04 SQL Execute: ORACLE - SELECT * FROM BM_YPLB00 118 15:34:04 SQL Execute: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 119 15:34:04 SQL Execute: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 120 15:34:04 SQL Execute: ORACLE - select YPNM00,YPBM00,YPMC00,YPGG00,KCDW00,LSJ000,SJKCSL,YKKCSL,KCSX00,KCXX00,YPMLBZ from VW_YF_YPKCXX where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=28 and YKKCSL'0' order by YPBM00 121 15:34:04 SQL Execute: ORACLE - SELECT * FROM YF_TJLXB0 WHERE YFBMBH=28 122 15:34:04 SQL Execute: ORACLE - select distinct DBGRIN,YGBH00 from XT_ZDYLXS where (YGBH00=0 or YGBH00=554) and (BMBH00=0 or BMBH00=28) and DLXTMC='药房管理系统' and CTMC00='frmYF_YPKQYJ' order by YGBH00 123 15:34:04 SQL Execute: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS from XT_ZDYLXS where YGBH00=554 and (BMBH00=0 or BMBH00=28) and DLXTMC='药房管理系统' and CTMC00='frmYF_YPKQYJ' and DBGRIN='DBGridEh1' order by LS0000 124 15:34:04 SQL Execute: ORACLE - select YPNM00,YPBM00,YPMC00,YPGG00,KCDW00,LSJ000,SJKCSL,YKKCSL,KCSX00,KCXX00,YPMLBZ from VW_YF_YPKCXX where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=28 and YKKCSL'0' order by YPBM00 125 15:34:04 SQL Execute: ORACLE - Select 'X' From YK_YPTJMX X,YK_YPTJ00 T Where X.YPTJPC=T.YPTJPC AND X.YXBMBH=28 and X.SFQR00='N' and T.SFQR00='Y' 126 15:34:04 SQL Execute: ORACLE - select BH0000 as FHJG00 from BM_TYZD00 where ZDMC00='药房登入提醒未确认的申领单天数' and YXBZ00='1' order by XSXH00 127 15:34:04 SQL Execute: ORACLE - select DISTINCT Q.YPQLDH,B.ZWXM00,Q.QLRQ00,QRRQ00 from YK_YPQLD0 Q,BM_YGBM00 B,YK_YPQLMX X where Q.CKQXBH=28 AND Q.QLZT00='1' and Q.QRRQ00>=to_char(sysdate-0,'YYYYMMDD') AND Q.YPQLDH=X.YPQLDH AND X.CXBZ00='Z' AND Q.LYRBH0=B.YGBH00(+) 128 15:34:04 SQL Execute: ORACLE - SELECT R.RKDH00,G.BMMC00,Y.ZWXM00,R.JHRQ00 FROM YK_YPRKD0 R,BM_BMBM00 G,BM_YGBM00 Y WHERE R.GHDWNM=28 AND (R.RKZT00 in ('3','1')) AND R.YKBMBH=G.BMBH00 AND R.RKLXBH='06' AND NOT EXISTS(SELECT 1 FROM YF_YPCKD0 C WHERE C.QRRQ00>=R.JHRQ00 AND C.YFBMBH=28 AND Trim(C.BZ0000)=Trim(R.RKDH00)) AND R.CZYBH0=Y.YGBH00 129 15:34:06 SQL Execute: ORACLE - SELECT B.BMBH00,B.BMMC00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=28 AND B.BMXZ00='9' AND B.FLAG00='1' and B.CZBZ00<>'2' and exists(select 1 from XT_YPFWFX where YFBMBH=F.YFBMBH and SLBMBH=F.BQBMBH) ORDER BY B.PXXH00,B.BH0000 130 15:34:06 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=28 AND B.BMXZ00='9' AND B.FLAG00='1' and exists(select 1 from XT_YPFWFX where YFBMBH=F.YFBMBH and SLBMBH=F.BQBMBH) and B.CZBZ00<>'2' ORDER BY B.PXXH00,B.BH0000 131 15:34:08 SQL Execute: ORACLE - SELECT 1 FROM YF_YZYPSQ WHERE YFBMBH=28 AND BQBMBH=345 AND QLZT00 IN ('0','1')AND THBZ00='0' AND HZBZ00='1' 132 15:34:08 SQL Execute: ORACLE - SELECT 'X' FROM YF_YZYPSQ WHERE YFBMBH=28 AND BQBMBH=345 AND QLZT00 IN ('0','1') AND THBZ00='0' AND HZBZ00='0' 133 15:34:08 SQL Execute: ORACLE - UPDATE BM_BQFYZT SET FYZT00='2' WHERE YFBMBH=28 AND BQBMBH=345 134 15:34:08 SQL Data In: ORACLE - Rows affected = 1 135 15:34:08 SQL Execute: ORACLE - UPDATE YF_YZYPSQ a SET FYBZ00='1' WHERE YFBMBH=28 AND BQBMBH=345 AND QLZT00 IN('0','1') AND FYBZ00='0' AND THBZ00='0' AND CXBZ00='Z' 136 15:34:08 SQL Data In: ORACLE - Rows affected = 2 137 15:34:08 SQL Execute: ORACLE - COMMIT 138 15:34:08 SQL Data In: ORACLE - Rows affected = 0 139 15:34:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 345.000000 140 15:34:09 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 141 15:34:09 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 142 15:34:09 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 143 15:34:09 SQL Execute: ORACLE - SELECT Y.YPNM00,Y.YPMC00,Y.YPGG00,Y.LSDJ00,SUM(Y.YPZSL0) AS YPZSL0, Y.QLDW00,Y.BQBMBH,Y.YFBMBH,D.DXSYBZ,X.GZDJ00,0 JCSL00,Y.ZHL000,Y.HZBZ00, decode('N','N','%','Y',decode(nvl(Y.SHBZ00,'0'),'0','%',Y.SHBZ00)) SHBZ00 FROM YF_YZYPSQ Y,BM_YD0000 D,YF_YPKCXX X WHERE Y.BQBMBH=? AND Y.YFBMBH=? AND Y.CLBZ00 LIKE '%' AND Y.QLZT00 IN ('0','1') AND Y.HZBZ00=? AND Y.FYBZ00='1' AND Y.YPNM00=D.YPNM00 AND nvl(SHBZ00,'0') like ? AND Y.YPNM00=X.YPNM00 AND Y.YFBMBH=X.YFBMBH AND CXBZ00='Z' GROUP BY D.DXSYBZ,X.GZDJ00,D.JXBH00,D.YLBH00,Y.YPNM00,Y.YPMC00,Y.YPGG00,Y.LSDJ00,Y.QLDW00,Y.BQBMBH,Y.YFBMBH,Y.ZHL000,Y.HZBZ00, decode('N','N','%','Y',decode(nvl(Y.SHBZ00,'0'),'0','%',Y.SHBZ00)) order by D.DXSYBZ,Y.YPNM00 desc 144 15:34:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13394.000000 145 15:34:09 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 345.000000 146 15:34:09 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 147 15:34:09 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 148 15:34:09 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 149 15:34:09 SQL Execute: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00, YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000,decode(SRCS00,-1,null,SRCS00) SRCS00,YEXM00 ,(select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00,a.SFZSL0,a.DKSL00 FROM YF_YZYPSQ a WHERE YPNM00=? AND BQBMBH=? AND YFBMBH=? AND QLZT00 IN ('0','1') AND HZBZ00=? AND FYBZ00='1' AND CXBZ00='Z' AND nvl(SHBZ00,'0') LIKE ? AND CLBZ00 LIKE '%' ORDER BY CH0000 150 15:34:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13394.000000 151 15:34:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 345.000000 152 15:34:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 153 15:34:10 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 154 15:34:10 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 155 15:34:10 SQL Execute: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00, YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000,decode(SRCS00,-1,null,SRCS00) SRCS00,YEXM00 ,(select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00,a.SFZSL0,a.DKSL00 FROM YF_YZYPSQ a WHERE YPNM00=? AND BQBMBH=? AND YFBMBH=? AND QLZT00 IN ('0','1') AND HZBZ00=? AND FYBZ00='1' AND CXBZ00='Z' AND nvl(SHBZ00,'0') LIKE ? AND CLBZ00 LIKE '%' ORDER BY CH0000 156 15:34:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13394.000000 157 15:34:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 345.000000 158 15:34:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 159 15:34:10 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 160 15:34:10 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 161 15:34:10 SQL Execute: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00, YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000,decode(SRCS00,-1,null,SRCS00) SRCS00,YEXM00 ,(select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00,a.SFZSL0,a.DKSL00 FROM YF_YZYPSQ a WHERE YPNM00=? AND BQBMBH=? AND YFBMBH=? AND QLZT00 IN ('0','1') AND HZBZ00=? AND FYBZ00='1' AND CXBZ00='Z' AND nvl(SHBZ00,'0') LIKE ? AND CLBZ00 LIKE '%' ORDER BY CH0000 162 15:34:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 795.000000 163 15:34:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 345.000000 164 15:34:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 165 15:34:10 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 166 15:34:10 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 167 15:34:10 SQL Execute: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00, YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000,decode(SRCS00,-1,null,SRCS00) SRCS00,YEXM00 ,(select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00,a.SFZSL0,a.DKSL00 FROM YF_YZYPSQ a WHERE YPNM00=? AND BQBMBH=? AND YFBMBH=? AND QLZT00 IN ('0','1') AND HZBZ00=? AND FYBZ00='1' AND CXBZ00='Z' AND nvl(SHBZ00,'0') LIKE ? AND CLBZ00 LIKE '%' ORDER BY CH0000 168 15:34:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13394.000000 169 15:34:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 345.000000 170 15:34:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 171 15:34:10 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 172 15:34:10 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 173 15:34:10 SQL Execute: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00, YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000,decode(SRCS00,-1,null,SRCS00) SRCS00,YEXM00 ,(select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00,a.SFZSL0,a.DKSL00 FROM YF_YZYPSQ a WHERE YPNM00=? AND BQBMBH=? AND YFBMBH=? AND QLZT00 IN ('0','1') AND HZBZ00=? AND FYBZ00='1' AND CXBZ00='Z' AND nvl(SHBZ00,'0') LIKE ? AND CLBZ00 LIKE '%' ORDER BY CH0000 174 15:34:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 795.000000 175 15:34:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 345.000000 176 15:34:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 177 15:34:10 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 178 15:34:10 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 179 15:34:10 SQL Execute: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00, YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000,decode(SRCS00,-1,null,SRCS00) SRCS00,YEXM00 ,(select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00,a.SFZSL0,a.DKSL00 FROM YF_YZYPSQ a WHERE YPNM00=? AND BQBMBH=? AND YFBMBH=? AND QLZT00 IN ('0','1') AND HZBZ00=? AND FYBZ00='1' AND CXBZ00='Z' AND nvl(SHBZ00,'0') LIKE ? AND CLBZ00 LIKE '%' ORDER BY CH0000 180 15:34:10 SQL Execute: ORACLE - Commit 181 15:34:10 SQL Data In: ORACLE - Rows affected = 0 182 15:34:10 SQL Execute: ORACLE - select SQ_YF_KSJY00_JYDH00.NEXTVAL JYDH00 from DUAL 183 15:34:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13394.000000 184 15:34:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 345.000000 185 15:34:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 186 15:34:10 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 187 15:34:10 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 188 15:34:10 SQL Execute: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00, YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000,decode(SRCS00,-1,null,SRCS00) SRCS00,YEXM00 ,(select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00,a.SFZSL0,a.DKSL00 FROM YF_YZYPSQ a WHERE YPNM00=? AND BQBMBH=? AND YFBMBH=? AND QLZT00 IN ('0','1') AND HZBZ00=? AND FYBZ00='1' AND CXBZ00='Z' AND nvl(SHBZ00,'0') LIKE ? AND CLBZ00 LIKE '%' ORDER BY CH0000 189 15:34:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 795.000000 190 15:34:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 345.000000 191 15:34:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 192 15:34:10 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 193 15:34:10 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 194 15:34:10 SQL Execute: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00, YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000,decode(SRCS00,-1,null,SRCS00) SRCS00,YEXM00 ,(select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00,a.SFZSL0,a.DKSL00 FROM YF_YZYPSQ a WHERE YPNM00=? AND BQBMBH=? AND YFBMBH=? AND QLZT00 IN ('0','1') AND HZBZ00=? AND FYBZ00='1' AND CXBZ00='Z' AND nvl(SHBZ00,'0') LIKE ? AND CLBZ00 LIKE '%' ORDER BY CH0000 195 15:34:10 SQL Data In: ORACLE - Param = 1, Name = P_YPNM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 13394*795* 196 15:34:10 SQL Data In: ORACLE - Param = 2, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 197 15:34:10 SQL Data In: ORACLE - Param = 3, Name = P_BQBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 345.000000 198 15:34:10 SQL Data In: ORACLE - Param = 4, Name = P_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 199 15:34:10 SQL Data In: ORACLE - Param = 5, Name = P_CLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 200 15:34:10 SQL Data In: ORACLE - Param = 6, Name = P_HZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 201 15:34:10 SQL Data In: ORACLE - Param = 7, Name = P_CZYBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 554.000000 202 15:34:10 SQL Data In: ORACLE - Param = 8, Name = P_LYRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000 203 15:34:10 SQL Data In: ORACLE - Param = 9, Name = P_FHRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000 204 15:34:10 SQL Data In: ORACLE - Param = 10, Name = P_CKDH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 205 15:34:10 SQL Data In: ORACLE - Param = 11, Name = P_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 206 15:34:10 SQL Data In: ORACLE - Param = 12, Name = P_PYR000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 554.000000 207 15:34:10 SQL Data In: ORACLE - Param = 13, Name = P_SHBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 208 15:34:10 SQL Execute: ORACLE - BEGIN "SP_YF_BQYZFY" (P_YPNM00 => :P_YPNM00,P_YFBMBH => :P_YFBMBH,P_BQBMBH => :P_BQBMBH,P_ZYID00 => :P_ZYID00,P_CLBZ00 => :P_CLBZ00,P_HZBZ00 => :P_HZBZ00,P_CZYBH0 => :P_CZYBH0,P_LYRBH0 => :P_LYRBH0,P_FHRBH0 => :P_FHRBH0,P_CKDH00 => :P_CKDH00,P_MESSAGE => :P_MESSAGE,P_PYR000 => :P_PYR000,P_SHBZ00 => :P_SHBZ00); END; 209 15:34:10 SQL Execute: ORACLE - UPDATE YF_KSJY00 SET BZ0000='769104' WHERE JYDH00='2038' 210 15:34:10 SQL Data In: ORACLE - Rows affected = 0 211 15:34:10 SQL Execute: ORACLE - commit 212 15:34:10 SQL Data In: ORACLE - Rows affected = 0 213 15:34:12 SQL Execute: ORACLE - SELECT trim(C.YPMC00)||'/'||trim(C.YPGG00) as YPMC00, C.LSDJ00,sum(C.CKSL00)||TRIM(C.CKDW00) as LYSL00,sum(C.CKSL00) CKSL00,TRIM(C.CKDW00) CKDW00, K.BZ0000,D.DXSYBZ,D.JXBH00,D.YLBH00,K.QRRQ00,D.YPBM00, C.CKDH00,K.QRSJ00, D.GZDJ00,SF_YF_GWGZDJFL(D.GZDJ00,D.GWYPFL) GWYPFL, SF_YF_EXROUND(sum(C.CKSL00)*C.LSDJ00,0,2) AS C_YPJE FROM YF_YPCKMX C,YF_YPCKD0 K,BM_YD0000 D,YF_YPKCXX X WHERE C.CKDH00 ='769104' AND C.YPNM00=D.YPNM00 AND C.CKDH00=K.CKDH00 AND C.YPNM00=X.YPNM00 AND X.YFBMBH=28 GROUP BY D.DXSYBZ,D.GZDJ00,D.JXBH00,D.YLBH00,D.YPTYM0,D.Lbbh00,SF_YF_GWGZDJFL(D.GZDJ00,D.GWYPFL), C.YPNM00,C.YPMC00,C.YPGG00,K.BZ0000, C.LSDJ00,C.CKDW00,X.YFBMBH,K.QRRQ00,D.YPBM00 ,C.CKDH00,K.QRSJ00 ORDER BY D.DXSYBZ,D.GZDJ00,GWYPFL,D.YPBM00,D.Lbbh00 214 15:34:12 SQL Execute: ORACLE - SELECT trim(C.YPMC00)||'/'||trim(C.YPGG00) as YPMC00, C.LSDJ00,sum(C.CKSL00)||TRIM(C.CKDW00) as LYSL00,sum(C.CKSL00) CKSL00,TRIM(C.CKDW00) CKDW00, K.BZ0000,D.DXSYBZ,D.JXBH00,D.YLBH00,K.QRRQ00,D.YPBM00, C.CKDH00,K.QRSJ00, D.GZDJ00,SF_YF_GWGZDJFL(D.GZDJ00,D.GWYPFL) GWYPFL, SF_YF_EXROUND(sum(C.CKSL00)*C.LSDJ00,0,2) AS C_YPJE FROM YF_YPCKMX C,YF_YPCKD0 K,BM_YD0000 D,YF_YPKCXX X WHERE C.CKDH00 ='769104' AND C.YPNM00=D.YPNM00 AND C.CKDH00=K.CKDH00 AND C.YPNM00=X.YPNM00 AND X.YFBMBH=28 GROUP BY D.DXSYBZ,D.GZDJ00,D.JXBH00,D.YLBH00,D.YPTYM0,D.Lbbh00,SF_YF_GWGZDJFL(D.GZDJ00,D.GWYPFL), C.YPNM00,C.YPMC00,C.YPGG00,K.BZ0000, C.LSDJ00,C.CKDW00,X.YFBMBH,K.QRRQ00,D.YPBM00 ,C.CKDH00,K.QRSJ00 ORDER BY D.DXSYBZ,D.GZDJ00,GWYPFL,D.YPBM00,D.Lbbh00 215 15:34:12 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 216 15:34:12 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 217 15:34:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 769104 218 15:34:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 219 15:34:12 SQL Execute: ORACLE - select SF_YF_CHECKSFZSM(?,?) as FHXX00 from dual 220 15:34:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 医保追溯码配置 221 15:34:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = YBZSMSFQY_ZY 222 15:34:12 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 223 15:34:12 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'YBZSMSFQY_ZY' 224 15:34:17 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'YF_YBZSMXSYP' 225 15:34:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 226 15:34:17 SQL Execute: ORACLE - select A.* from VW_YF_YZZSYP A where A.PZBSM0 is not null aND A.CKDH00 = '769091' and A.YFBMBH = ? and > 0 order by ZYH000 227 15:34:17 SQL Error: ORACLE - ORA-00936: 缺失表达式 228 15:34:17 SQL Error: ORACLE - Unmapped SQL Error Code: 936 229 15:34:17 SQL Data In: ORACLE - Rows affected = 0 230 15:34:32 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'YF_YBZSMXSYP' 231 15:34:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 232 15:34:32 SQL Execute: ORACLE - select A.* from VW_YF_YZZSYP A where A.PZBSM0 is not null aND A.CKDH00 = '769091' and A.YFBMBH = ? and ZSMSL1 > 0 order by ZYH000 233 15:34:32 SQL Execute: ORACLE - select ZYH000,CH0000,BRXM00 from VW_YF_YZZSYP where ZSMSL1 > 0 and CKDH00 ='769091' group by ZYH000,CH0000,BRXM00 234 15:34:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 769091 235 15:34:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12983099.000000 236 15:34:32 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21748.000000 237 15:34:32 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2289822.000000 238 15:34:32 SQL Execute: ORACLE - select A.* from YF_CFZSMX A where MZZYBZ = '1' and YZLB00 = '1' and CFLSH0 = ? and YPQLPC = ? and YPNM00 = ? and YPCKPC = ? 239 15:34:33 SQL Data In: ORACLE - Param = 1, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 240 15:34:33 SQL Data In: ORACLE - Param = 2, Name = PCFLSH0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 769091 241 15:34:33 SQL Data In: ORACLE - Param = 3, Name = PCZY000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 554 242 15:34:33 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 243 15:34:33 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 244 15:34:33 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 245 15:34:33 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 246 15:34:33 SQL Data In: ORACLE - Param = 8, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 247 15:34:33 SQL Data In: ORACLE - Param = 9, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 248 15:34:33 SQL Data In: ORACLE - Param = 10, Name = PYPQLPC, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 249 15:34:33 SQL Execute: ORACLE - BEGIN "SP_YF_RKZSM0_BACK" (PMZZYBZ => :PMZZYBZ,PCFLSH0 => :PCFLSH0,PCZY000 => :PCZY000,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PCZYKS0 => :PCZYKS0,PZYID00 => :PZYID00,PYPQLPC => :PYPQLPC); END; 250 15:34:34 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'YF_YBZSMXSYP' 251 15:34:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 28.000000 252 15:34:34 SQL Execute: ORACLE - select A.* from VW_YF_YZZSYP A where A.PZBSM0 is not null aND A.CKDH00 = '769091' and A.YFBMBH = ? and ZSMSL1 > 0 order by ZYH000 253 15:34:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 769091 254 15:34:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12983099.000000 255 15:34:34 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21748.000000 256 15:34:34 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2289822.000000 257 15:34:34 SQL Execute: ORACLE - select A.* from YF_CFZSMX A where MZZYBZ = '1' and YZLB00 = '1' and CFLSH0 = ? and YPQLPC = ? and YPNM00 = ? and YPCKPC = ? 258 15:34:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 769091 259 15:34:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12983099.000000 260 15:34:34 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21748.000000 261 15:34:34 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2289822.000000 262 15:34:34 SQL Execute: ORACLE - select A.* from YF_CFZSMX A where MZZYBZ = '1' and YZLB00 = '1' and CFLSH0 = ? and YPQLPC = ? and YPNM00 = ? and YPCKPC = ? 263 15:34:34 SQL Execute: ORACLE - select ZYH000,CH0000,BRXM00 from VW_YF_YZZSYP where ZSMSL1 > 0 and CKDH00 ='769091' group by ZYH000,CH0000,BRXM00