1 10:30:18 Log started for: 药房管理系统 2 10:30:18 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 10:30:18 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 4 10:30:18 SQL Prepare: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.14.226','2','appYP_YF.exe'||'+'||'药房管理系统','145','37909' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:593A26A69DD9EF0DCCFF382663D064F0' from dual 5 10:30:18 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.14.226','2','appYP_YF.exe'||'+'||'药房管理系统','145','37909' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:593A26A69DD9EF0DCCFF382663D064F0' from dual 6 10:30:18 SQL Prepare: ORACLE - Commit 7 10:30:18 SQL Execute: ORACLE - Commit 8 10:30:18 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 9 10:30:18 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 10 10:30:18 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 11 10:30:18 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 12 10:30:18 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 13 10:30:18 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 14 10:30:18 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.14.226','2','appYP_YF.exe'||'+'||'药房管理系统','159','4505' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@9998:1E8C9DF382D550C78EA821B3F1AE0DFA' from dual 15 10:30:18 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.14.226','2','appYP_YF.exe'||'+'||'药房管理系统','159','4505' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@9998:1E8C9DF382D550C78EA821B3F1AE0DFA' from dual 16 10:30:18 SQL Prepare: ORACLE - Commit 17 10:30:18 SQL Execute: ORACLE - Commit 18 10:30:18 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 19 10:30:18 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 20 10:30:18 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 21 10:30:18 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 22 10:30:18 SQL Prepare: ORACLE - Select SYSDATE from Dual 23 10:30:18 SQL Execute: ORACLE - Select SYSDATE from Dual 24 10:30:18 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 25 10:30:18 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 26 10:30:18 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 27 10:30:18 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 28 10:30:18 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2' 29 10:30:18 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2' 30 10:30:18 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 31 10:30:18 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 32 10:30:18 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 33 10:30:18 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 34 10:30:18 SQL Prepare: 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)='9998')) 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)='9998')) order by b.PLXH00,a.BH0000 35 10:30:18 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)='9998')) 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)='9998')) order by b.PLXH00,a.BH0000 36 10:30:20 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='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)='9998')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 37 10:30:20 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='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)='9998')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 38 10:30:20 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 39 10:30:20 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 40 10:30:20 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 41 10:30:20 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 42 10:30:20 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 43 10:30:20 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 44 10:30:20 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 45 10:30:20 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 46 10:30:20 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 47 10:30:20 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 48 10:30:20 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')) 49 10:30:20 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')) 50 10:30:20 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2837989,476,'BZ1UQZZXW8GF5WB','2',nvl('1714742',' '),'192.168.14.226#159:4505@appYP_YF.exe+药房管理系统',45) 51 10:30:20 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2837989,476,'BZ1UQZZXW8GF5WB','2',nvl('1714742',' '),'192.168.14.226#159:4505@appYP_YF.exe+药房管理系统',45) 52 10:30:20 SQL Prepare: ORACLE - Commit 53 10:30:20 SQL Execute: ORACLE - Commit 54 10:30:20 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 45 55 10:30:20 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 45 56 10:30:20 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 57 10:30:20 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 58 10:30:20 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 59 10:30:20 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 60 10:30:20 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.14.226' 61 10:30:20 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.14.226' 62 10:30:20 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 63 10:30:20 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 64 10:30:20 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 45 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 65 10:30:20 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 45 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 66 10:30:21 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 67 10:30:21 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 68 10:30:21 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 69 10:30:21 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 70 10:30:22 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 71 10:30:22 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 72 10:30:22 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 73 10:30:22 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 74 10:30:22 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20120903' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',45,' )>0 ) 75 10:30:22 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20120903' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',45,' )>0 ) 76 10:30:22 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 77 10:30:22 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 78 10:30:22 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 79 10:30:22 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 80 10:30:22 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID' 81 10:30:22 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID' 82 10:30:22 SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID' 83 10:30:22 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID' 84 10:30:22 SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED' 85 10:30:22 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED' 86 10:30:22 SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=45 87 10:30:22 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=45 88 10:30:22 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual 89 10:30:22 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual 90 10:30:22 SQL Prepare: ORACLE - select * from XT_XTCS00 91 10:30:22 SQL Execute: ORACLE - select * from XT_XTCS00 92 10:30:24 SQL Prepare: ORACLE - select * from BM_YPLB00 93 10:30:24 SQL Execute: ORACLE - select * from BM_YPLB00 94 10:30:24 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=476 95 10:30:24 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=476 96 10:30:24 SQL Prepare: ORACLE - SELECT SFXMMC FROM BM_YPLB00 where LBBH00='3' 97 10:30:24 SQL Execute: ORACLE - SELECT SFXMMC FROM BM_YPLB00 where LBBH00='3' 98 10:30:24 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='2' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='2'))) 99 10:30:24 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='2' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='2'))) 100 10:30:24 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 101 10:30:24 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 102 10:30:24 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 ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 103 10:30:24 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 ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 104 10:30:24 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 105 10:30:24 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 106 10:30:24 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 107 10:30:24 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 108 10:30:24 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 109 10:30:24 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 110 10:30:24 SQL Prepare: ORACLE - SELECT B.BMBH00,B.BMMC00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 111 10:30:24 SQL Execute: ORACLE - SELECT B.BMBH00,B.BMMC00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 112 10:30:25 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 113 10:30:25 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 114 10:30:25 SQL Prepare: ORACLE - SELECT 'X' FROM VW_YF_YPKCXX WHERE YFBMBH=45 AND YKKCSL'0' 115 10:30:25 SQL Execute: ORACLE - SELECT 'X' FROM VW_YF_YPKCXX WHERE YFBMBH=45 AND YKKCSL'0' 116 10:30:26 SQL Prepare: ORACLE - Select 'X' From YK_YPTJMX X,YK_YPTJ00 T Where X.YPTJPC=T.YPTJPC AND X.YXBMBH=45 and X.SFQR00='N' and T.SFQR00='Y' 117 10:30:26 SQL Execute: ORACLE - Select 'X' From YK_YPTJMX X,YK_YPTJ00 T Where X.YPTJPC=T.YPTJPC AND X.YXBMBH=45 and X.SFQR00='N' and T.SFQR00='Y' 118 10:30:34 SQL Prepare: ORACLE - SELECT DISTINCT BMBH00,BMMC00 FROM BM_BMBM00 B,VW_YF_KSCFLY V WHERE B.BMBH00=V.KDKS00 AND YFBMBH=:1 AND V.CFZT00='1' 119 10:30:34 SQL Execute: ORACLE - SELECT DISTINCT BMBH00,BMMC00 FROM BM_BMBM00 B,VW_YF_KSCFLY V WHERE B.BMBH00=V.KDKS00 AND YFBMBH=? AND V.CFZT00='1' 120 10:30:34 SQL Prepare: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00='0' AND YFBMBH=45 AND KDKS00=55 GROUP BY KDKS00,YPNM00,ZHL000,YPMC00,YPGG00,CFDW00,LSDJ00 121 10:30:34 SQL Execute: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00='0' AND YFBMBH=45 AND KDKS00=55 GROUP BY KDKS00,YPNM00,ZHL000,YPMC00,YPGG00,CFDW00,LSDJ00 122 10:30:34 SQL Prepare: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00<>'0' AND YFBMBH=45 AND KDKS00=55 GROUP BY KDKS00,ZHL000,YPNM00,YPMC00,YPGG00,CFDW00,LSDJ00 123 10:30:34 SQL Execute: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00<>'0' AND YFBMBH=45 AND KDKS00=55 GROUP BY KDKS00,ZHL000,YPNM00,YPMC00,YPGG00,CFDW00,LSDJ00 124 10:30:35 SQL Prepare: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00='0' AND YFBMBH=45 AND KDKS00=55 GROUP BY KDKS00,YPNM00,ZHL000,YPMC00,YPGG00,CFDW00,LSDJ00 125 10:30:35 SQL Execute: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00='0' AND YFBMBH=45 AND KDKS00=55 GROUP BY KDKS00,YPNM00,ZHL000,YPMC00,YPGG00,CFDW00,LSDJ00 126 10:30:35 SQL Prepare: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00<>'0' AND YFBMBH=45 AND KDKS00=55 GROUP BY KDKS00,ZHL000,YPNM00,YPMC00,YPGG00,CFDW00,LSDJ00 127 10:30:35 SQL Execute: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00<>'0' AND YFBMBH=45 AND KDKS00=55 GROUP BY KDKS00,ZHL000,YPNM00,YPMC00,YPGG00,CFDW00,LSDJ00 128 10:30:35 SQL Prepare: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00='0' AND YFBMBH=45 AND KDKS00=55 GROUP BY KDKS00,YPNM00,ZHL000,YPMC00,YPGG00,CFDW00,LSDJ00 129 10:30:35 SQL Execute: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00='0' AND YFBMBH=45 AND KDKS00=55 GROUP BY KDKS00,YPNM00,ZHL000,YPMC00,YPGG00,CFDW00,LSDJ00 130 10:30:35 SQL Prepare: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00<>'0' AND YFBMBH=45 AND KDKS00=55 GROUP BY KDKS00,ZHL000,YPNM00,YPMC00,YPGG00,CFDW00,LSDJ00 131 10:30:35 SQL Execute: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00<>'0' AND YFBMBH=45 AND KDKS00=55 GROUP BY KDKS00,ZHL000,YPNM00,YPMC00,YPGG00,CFDW00,LSDJ00 132 10:30:36 SQL Prepare: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00='0' AND YFBMBH=45 AND KDKS00=77 GROUP BY KDKS00,YPNM00,ZHL000,YPMC00,YPGG00,CFDW00,LSDJ00 133 10:30:36 SQL Execute: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00='0' AND YFBMBH=45 AND KDKS00=77 GROUP BY KDKS00,YPNM00,ZHL000,YPMC00,YPGG00,CFDW00,LSDJ00 134 10:30:36 SQL Prepare: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00<>'0' AND YFBMBH=45 AND KDKS00=77 GROUP BY KDKS00,ZHL000,YPNM00,YPMC00,YPGG00,CFDW00,LSDJ00 135 10:30:36 SQL Execute: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00<>'0' AND YFBMBH=45 AND KDKS00=77 GROUP BY KDKS00,ZHL000,YPNM00,YPMC00,YPGG00,CFDW00,LSDJ00 136 10:30:36 SQL Prepare: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00='0' AND YFBMBH=45 AND KDKS00=54 GROUP BY KDKS00,YPNM00,ZHL000,YPMC00,YPGG00,CFDW00,LSDJ00 137 10:30:36 SQL Execute: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00='0' AND YFBMBH=45 AND KDKS00=54 GROUP BY KDKS00,YPNM00,ZHL000,YPMC00,YPGG00,CFDW00,LSDJ00 138 10:30:36 SQL Prepare: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00<>'0' AND YFBMBH=45 AND KDKS00=54 GROUP BY KDKS00,ZHL000,YPNM00,YPMC00,YPGG00,CFDW00,LSDJ00 139 10:30:36 SQL Execute: ORACLE - SELECT YPNM00,ZHL000,KDKS00,YPMC00,YPGG00,CFDW00,LSDJ00,SUM(YPZSL0) AS LYSL00, SUM(ROUND(YPZSL0*LSDJ00,2)) LYJE00,0 JCSL00,'1' FLAG00 FROM VW_YF_KSCFLY WHERE CFZT00='1' AND CFXZ00<>'0' AND YFBMBH=45 AND KDKS00=54 GROUP BY KDKS00,ZHL000,YPNM00,YPMC00,YPGG00,CFDW00,LSDJ00