1 08:41:46 Log started for: 药库管理系统 2 08:41:46 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.86','3','appYP_YK.exe'||'+'||'药库管理系统','1149','6210' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual 3 08:41:46 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.86','3','appYP_YK.exe'||'+'||'药库管理系统','1149','6210' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from dual 4 08:41:46 SQL Prepare: ORACLE - Commit 5 08:41:46 SQL Execute: ORACLE - Commit 6 08:41:46 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 7 08:41:46 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 08:41:46 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 9 08:41:46 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 10 08:41:46 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 11 08:41:46 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 12 08:41:46 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 13 08:41:46 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 14 08:41:46 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.86','3','appYP_YK.exe'||'+'||'药库管理系统','750','15096' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual 15 08:41:46 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.86','3','appYP_YK.exe'||'+'||'药库管理系统','750','15096' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from dual 16 08:41:46 SQL Prepare: ORACLE - Commit 17 08:41:46 SQL Execute: ORACLE - Commit 18 08:41:46 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='3' 19 08:41:46 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='3' 20 08:41:46 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 21 08:41:46 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 22 08:41:46 SQL Prepare: ORACLE - Select SYSDATE from Dual 23 08:41:46 SQL Execute: ORACLE - Select SYSDATE from Dual 24 08:41:46 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 25 08:41:46 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 26 08:41:46 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 27 08:41:46 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 28 08:41:46 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='3' 29 08:41:46 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='3' 30 08:41:46 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 31 08:41:46 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 32 08:41:46 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 08:41:46 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 08:41:46 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='3' 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 ('6') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='3' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 35 08:41:46 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='3' 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 ('6') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='3' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 36 08:41:47 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '3' 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='3' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 37 08:41:47 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '3' 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='3' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 38 08:41:47 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 39 08:41:47 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 40 08:41:47 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 41 08:41:47 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 42 08:41:47 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 43 08:41:47 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 44 08:41:48 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 45 08:41:48 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 46 08:41:48 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 47 08:41:48 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 48 08:41:48 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 08:41:48 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 08:41:52 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4856433,476,'wlzx-8','3',nvl('232585418',' '),'192.168.5.86#750:15096@appYP_YK.exe+药库管理系统',12) 51 08:41:52 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4856433,476,'wlzx-8','3',nvl('232585418',' '),'192.168.5.86#750:15096@appYP_YK.exe+药库管理系统',12) 52 08:41:52 SQL Prepare: ORACLE - Commit 53 08:41:52 SQL Execute: ORACLE - Commit 54 08:41:52 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 12 55 08:41:52 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 12 56 08:41:52 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 57 08:41:52 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 58 08:41:52 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 59 08:41:52 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 60 08:41:52 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.86' 61 08:41:52 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.86' 62 08:41:52 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 63 08:41:52 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 64 08:41:52 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 12 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 65 08:41:52 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 12 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 66 08:41:52 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 67 08:41:52 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 68 08:41:52 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'3'||',')>0 69 08:41:52 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'3'||',')>0 70 08:41:53 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 71 08:41:53 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 72 08:41:53 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 73 08:41:53 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 74 08:41:53 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20151106' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',12,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='3') 75 08:41:53 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20151106' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',12,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='3') 76 08:41:53 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 77 08:41:53 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 78 08:41:53 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 79 08:41:53 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 80 08:41:53 SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=12 81 08:41:53 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=12 82 08:41:53 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS<>'VALID' 83 08:41:53 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS<>'VALID' 84 08:41:53 SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS='VALID' 85 08:41:53 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS='VALID' 86 08:41:53 SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME= 'TR_BM_YD0000_BFUPDDET' AND STATUS='VALID' 87 08:41:53 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME= 'TR_BM_YD0000_BFUPDDET' AND STATUS='VALID' 88 08:41:53 SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YK_%' AND STATUS<>'ENABLED' 89 08:41:53 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YK_%' AND STATUS<>'ENABLED' 90 08:41:53 SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_triggers where TRIGGER_NAME='TR_BM_YD0000_BFUPDDET' AND STATUS='ENABLED' 91 08:41:53 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_triggers where TRIGGER_NAME='TR_BM_YD0000_BFUPDDET' AND STATUS='ENABLED' 92 08:41:54 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 like 'YK_%' or NAME00 like 'YF_%' or NAME00 like 'ZS_%' 93 08:41:54 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 like 'YK_%' or NAME00 like 'YF_%' or NAME00 like 'ZS_%' 94 08:41:54 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=476 95 08:41:54 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=476 96 08:41:54 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='3' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='3'))) 97 08:41:54 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='3' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='3'))) 98 08:41:54 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '3$%' and A.XTDM00='3' and trim(A.MKDM00)='3$'||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 99 08:41:54 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '3$%' and A.XTDM00='3' and trim(A.MKDM00)='3$'||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 100 08:41:54 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 '))) 101 08:41:54 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 '))) 102 08:41:54 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 103 08:41:54 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 104 08:41:54 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='+ '))) 105 08:41:54 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='+ '))) 106 08:41:54 SQL Prepare: ORACLE - SELECT LBMC00 FROM BM_YPLB00 where LBBH00='3' 107 08:41:54 SQL Execute: ORACLE - SELECT LBMC00 FROM BM_YPLB00 where LBBH00='3' 108 08:41:54 SQL Prepare: ORACLE - SELECT 'X' FROM VW_YK_YPKCXX WHERE YKBMBH=12 AND KCSL00=:2 AND R.JHBZRQ<=:3 AND R.SFQR00 IN ('N','Y','2') AND R.CZYBH0=Y.YGBH00(+) AND R.GHDWNM=W.GHDWNM(+) ORDER BY R.CGJHDH DESC 117 08:42:06 SQL Execute: ORACLE - SELECT R.CGJHDH,Y.ZWXM00,R.QRRQ00,R.SFQR00,R.JHBZRQ,W.GHDWMC,R.CGDBH0,R.YKBMBH, (SELECT Z.ZWXM00 FROM BM_YGBM00 Z WHERE R.QRRBH0=Z.YGBH00) QRR000,R.BZ0000 FROM YK_YPCGJH R,BM_YGBM00 Y,BM_YPGHDW W WHERE R.YKBMBH=? AND R.JHBZRQ>=? AND R.JHBZRQ<=? AND R.SFQR00 IN ('N','Y','2') AND R.CZYBH0=Y.YGBH00(+) AND R.GHDWNM=W.GHDWNM(+) ORDER BY R.CGJHDH DESC 118 08:42:08 SQL Prepare: ORACLE - SELECT R.CGJHDH,Y.ZWXM00,R.QRRQ00,R.SFQR00,R.JHBZRQ,W.GHDWMC,R.CGDBH0,R.YKBMBH, (SELECT Z.ZWXM00 FROM BM_YGBM00 Z WHERE R.QRRBH0=Z.YGBH00) QRR000,R.BZ0000 FROM YK_YPCGJH R,BM_YGBM00 Y,BM_YPGHDW W WHERE R.YKBMBH=:1 AND R.JHBZRQ>=:2 AND R.JHBZRQ<=:3 AND R.SFQR00 IN ('N','Y','2') AND R.CZYBH0=Y.YGBH00(+) AND R.GHDWNM=W.GHDWNM(+) ORDER BY R.CGJHDH DESC 119 08:42:08 SQL Execute: ORACLE - SELECT R.CGJHDH,Y.ZWXM00,R.QRRQ00,R.SFQR00,R.JHBZRQ,W.GHDWMC,R.CGDBH0,R.YKBMBH, (SELECT Z.ZWXM00 FROM BM_YGBM00 Z WHERE R.QRRBH0=Z.YGBH00) QRR000,R.BZ0000 FROM YK_YPCGJH R,BM_YGBM00 Y,BM_YPGHDW W WHERE R.YKBMBH=? AND R.JHBZRQ>=? AND R.JHBZRQ<=? AND R.SFQR00 IN ('N','Y','2') AND R.CZYBH0=Y.YGBH00(+) AND R.GHDWNM=W.GHDWNM(+) ORDER BY R.CGJHDH DESC 120 08:42:12 SQL Prepare: ORACLE - SELECT R.CGJHDH,Y.ZWXM00,R.QRRQ00,R.SFQR00,R.JHBZRQ,W.GHDWMC,R.CGDBH0,R.YKBMBH, (SELECT Z.ZWXM00 FROM BM_YGBM00 Z WHERE R.QRRBH0=Z.YGBH00) QRR000,R.BZ0000 FROM YK_YPCGJH R,BM_YGBM00 Y,BM_YPGHDW W WHERE R.YKBMBH=:1 AND R.JHBZRQ>=:2 AND R.JHBZRQ<=:3 AND R.SFQR00 IN ('N','Y','2') AND R.CZYBH0=Y.YGBH00(+) AND R.GHDWNM=W.GHDWNM(+) ORDER BY R.CGJHDH DESC 121 08:42:12 SQL Execute: ORACLE - SELECT R.CGJHDH,Y.ZWXM00,R.QRRQ00,R.SFQR00,R.JHBZRQ,W.GHDWMC,R.CGDBH0,R.YKBMBH, (SELECT Z.ZWXM00 FROM BM_YGBM00 Z WHERE R.QRRBH0=Z.YGBH00) QRR000,R.BZ0000 FROM YK_YPCGJH R,BM_YGBM00 Y,BM_YPGHDW W WHERE R.YKBMBH=? AND R.JHBZRQ>=? AND R.JHBZRQ<=? AND R.SFQR00 IN ('N','Y','2') AND R.CZYBH0=Y.YGBH00(+) AND R.GHDWNM=W.GHDWNM(+) ORDER BY R.CGJHDH DESC 122 08:42:12 SQL Prepare: ORACLE - SELECT TO_CHAR(TRUNC(TRUNC(TO_DATE('20151104','YYYYMMDD'),'MM')-1,'MM'),'YYYYMMDD') FIRSTDAY1, TO_CHAR(LAST_DAY(TRUNC(TO_DATE('20151104','YYYYMMDD'),'MM')-1),'YYYYMMDD') LASTDAY1 FROM DUAL 123 08:42:12 SQL Execute: ORACLE - SELECT TO_CHAR(TRUNC(TRUNC(TO_DATE('20151104','YYYYMMDD'),'MM')-1,'MM'),'YYYYMMDD') FIRSTDAY1, TO_CHAR(LAST_DAY(TRUNC(TO_DATE('20151104','YYYYMMDD'),'MM')-1),'YYYYMMDD') LASTDAY1 FROM DUAL 124 08:42:12 SQL Prepare: ORACLE - select * from( select nvl(C.CGMXXH,1) CGMXXH,C.CGJHDH,C.YPMC00,C.YPGG00,C.CGDW00,to_char(C.JHCGSL) JHCGSL, to_char(C.GJDJ00) GJDJ00,C.SCCJBH,C.SCCJZW,C.GMP000,to_char(C.JHSYSL) JHSYSL, to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,C.YFZSL0 YFZSL1, (SELECT ROUND(SUM(NVL(SJKCSL,0)/F.K2J000),3) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=C.YPNM00) YFZSL0, NULL YFSYL0, to_char(C.KCSL00) AS KCSL00,D.ZBXH00,D.ZBQMC0,D.YPTYM0,D.YPBM00,D.YPMLBZ, (select W.GHDWMC from BM_YPGHDW W where C.GHDWNM=W.GHDWNM) GHDWMC,D.LBBH00,D.YLBH00,D.JXBH00, (SELECT E.SXH000 FROM BM_YPJX00 E WHERE D.LBBH00=E.LBBH00 AND D.JXBH00=E.JXBH00) SXH000 from YK_CGJHMX C,VW_YK_YPKCXX D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=12 AND C.CGJHDH=:1 union all select M.CGMXXH,M.CGJHDH,M.YPMC00,M.YPGG00,M.CGDW00,M.JHCGSL,M.GJDJ00,M.SCCJBH,M.SCCJZW,M.GMP000,M.JHSYSL,M.GJJE00,M.GHDWNM,YFZSL1, (select ROUND(SUM(NVL(SJKCSL,0)/F.K2J000),3) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F,YK_CGJHMX G WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=G.YPNM00 AND G.CGJHDH=:2) YFZSL0, ' ' YFSYL0,M.KCSL00,M.ZBXH00,M.ZBQMC0,M.YPTYM0,M.YPBM00,M.YPMLBZ,M.GHDWMC,M.LBBH00,M.YLBH00,M.JXBH00,M.SXH000 from ( select 9999999999999 CGMXXH,' ' CGJHDH,'合 计' YPMC00,to_char(count(1)) YPGG00,' ' CGDW00,' ' JHCGSL, ' ' GJDJ00,' ' SCCJBH,' ' SCCJZW,' ' GMP000,' ' JHSYSL,to_char(sum(round(C.GJDJ00*C.JHCGSL,2))) GJJE00,999999999 GHDWNM,SUM(C.YFZSL0) YFZSL1, ' ' KCSL00,' ' ZBXH00,' ' ZBQMC0,' ' YPTYM0,' ' YPBM00,' ' YPMLBZ,' ' GHDWMC,' ' LBBH00,' ' YLBH00,' ' JXBH00,99999 SXH000 from YK_CGJHMX C,VW_YK_YPKCXX D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=12 AND C.CGJHDH=:3) M )ORDER BY GHDWNM,CGMXXH 125 08:42:12 SQL Execute: ORACLE - select * from( select nvl(C.CGMXXH,1) CGMXXH,C.CGJHDH,C.YPMC00,C.YPGG00,C.CGDW00,to_char(C.JHCGSL) JHCGSL, to_char(C.GJDJ00) GJDJ00,C.SCCJBH,C.SCCJZW,C.GMP000,to_char(C.JHSYSL) JHSYSL, to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,C.YFZSL0 YFZSL1, (SELECT ROUND(SUM(NVL(SJKCSL,0)/F.K2J000),3) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=C.YPNM00) YFZSL0, NULL YFSYL0, to_char(C.KCSL00) AS KCSL00,D.ZBXH00,D.ZBQMC0,D.YPTYM0,D.YPBM00,D.YPMLBZ, (select W.GHDWMC from BM_YPGHDW W where C.GHDWNM=W.GHDWNM) GHDWMC,D.LBBH00,D.YLBH00,D.JXBH00, (SELECT E.SXH000 FROM BM_YPJX00 E WHERE D.LBBH00=E.LBBH00 AND D.JXBH00=E.JXBH00) SXH000 from YK_CGJHMX C,VW_YK_YPKCXX D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=12 AND C.CGJHDH=? union all select M.CGMXXH,M.CGJHDH,M.YPMC00,M.YPGG00,M.CGDW00,M.JHCGSL,M.GJDJ00,M.SCCJBH,M.SCCJZW,M.GMP000,M.JHSYSL,M.GJJE00,M.GHDWNM,YFZSL1, (select ROUND(SUM(NVL(SJKCSL,0)/F.K2J000),3) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F,YK_CGJHMX G WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=G.YPNM00 AND G.CGJHDH=?) YFZSL0, ' ' YFSYL0,M.KCSL00,M.ZBXH00,M.ZBQMC0,M.YPTYM0,M.YPBM00,M.YPMLBZ,M.GHDWMC,M.LBBH00,M.YLBH00,M.JXBH00,M.SXH000 from ( select 9999999999999 CGMXXH,' ' CGJHDH,'合 计' YPMC00,to_char(count(1)) YPGG00,' ' CGDW00,' ' JHCGSL, ' ' GJDJ00,' ' SCCJBH,' ' SCCJZW,' ' GMP000,' ' JHSYSL,to_char(sum(round(C.GJDJ00*C.JHCGSL,2))) GJJE00,999999999 GHDWNM,SUM(C.YFZSL0) YFZSL1, ' ' KCSL00,' ' ZBXH00,' ' ZBQMC0,' ' YPTYM0,' ' YPBM00,' ' YPMLBZ,' ' GHDWMC,' ' LBBH00,' ' YLBH00,' ' JXBH00,99999 SXH000 from YK_CGJHMX C,VW_YK_YPKCXX D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=12 AND C.CGJHDH=?) M )ORDER BY GHDWNM,CGMXXH 126 08:42:12 SQL Prepare: ORACLE - select * from (select a.CGDBH0,a.YPNM00,a.YPMC00,a.JXMC00,a.YPGG00, a.KCDW00,a.JLDW00,a.ZHL000,a.SCCJBH,a.SCCJMC,a.YKBMMC, a.YKBMBH,a.ZBJ000,a.GJJ000,a.LSJ000,a.JHSL00, a.GHDWNM,a.GHDWMC,b.LBBH00,b.YLBH00,b.JXBH00,c.SXH000, (select nvl(CGMXXH,1) CGMXXH from YK_CGJHMX c, YK_YPCGJH d WHERE c.CGJHDH=d.CGJHDH and d.cgdbh0=a.CGDBH0 and c.ypnm00=b.YPNM00 and ROWNUM=1) CGMXXH from YK_YPCGD0 a,bm_yd0000 b,BM_YPJX00 c where a.CGDBH0=:1 and a.YKBMBH=:2 and a.ypnm00=b.ypnm00 and b.lbbh00=c.lbbh00 and b.jxbh00=c.jxbh00) ORDER BY GHDWNM,CGMXXH 127 08:42:12 SQL Execute: ORACLE - select * from (select a.CGDBH0,a.YPNM00,a.YPMC00,a.JXMC00,a.YPGG00, a.KCDW00,a.JLDW00,a.ZHL000,a.SCCJBH,a.SCCJMC,a.YKBMMC, a.YKBMBH,a.ZBJ000,a.GJJ000,a.LSJ000,a.JHSL00, a.GHDWNM,a.GHDWMC,b.LBBH00,b.YLBH00,b.JXBH00,c.SXH000, (select nvl(CGMXXH,1) CGMXXH from YK_CGJHMX c, YK_YPCGJH d WHERE c.CGJHDH=d.CGJHDH and d.cgdbh0=a.CGDBH0 and c.ypnm00=b.YPNM00 and ROWNUM=1) CGMXXH from YK_YPCGD0 a,bm_yd0000 b,BM_YPJX00 c where a.CGDBH0=? and a.YKBMBH=? and a.ypnm00=b.ypnm00 and b.lbbh00=c.lbbh00 and b.jxbh00=c.jxbh00) ORDER BY GHDWNM,CGMXXH 128 08:42:12 SQL Prepare: ORACLE - select * from (select a.CGDBH0,a.YPNM00,a.YPMC00,a.JXMC00,a.YPGG00, a.KCDW00,a.JLDW00,a.ZHL000,a.SCCJBH,a.SCCJMC,a.YKBMMC, a.YKBMBH,a.ZBJ000,a.GJJ000,a.LSJ000,a.JHSL00, a.GHDWNM,a.GHDWMC,b.LBBH00,b.YLBH00,b.JXBH00,c.SXH000, (select nvl(CGMXXH,1) CGMXXH from YK_CGJHMX c, YK_YPCGJH d WHERE c.CGJHDH=d.CGJHDH and d.cgdbh0=a.CGDBH0 and c.ypnm00=b.YPNM00 and ROWNUM=1) CGMXXH from YK_YPCGD0 a,bm_yd0000 b,BM_YPJX00 c where a.CGDBH0=:1 and a.YKBMBH=:2 and a.ypnm00=b.ypnm00 and b.lbbh00=c.lbbh00 and b.jxbh00=c.jxbh00) ORDER BY GHDWNM,CGMXXH 129 08:42:12 SQL Execute: ORACLE - select * from (select a.CGDBH0,a.YPNM00,a.YPMC00,a.JXMC00,a.YPGG00, a.KCDW00,a.JLDW00,a.ZHL000,a.SCCJBH,a.SCCJMC,a.YKBMMC, a.YKBMBH,a.ZBJ000,a.GJJ000,a.LSJ000,a.JHSL00, a.GHDWNM,a.GHDWMC,b.LBBH00,b.YLBH00,b.JXBH00,c.SXH000, (select nvl(CGMXXH,1) CGMXXH from YK_CGJHMX c, YK_YPCGJH d WHERE c.CGJHDH=d.CGJHDH and d.cgdbh0=a.CGDBH0 and c.ypnm00=b.YPNM00 and ROWNUM=1) CGMXXH from YK_YPCGD0 a,bm_yd0000 b,BM_YPJX00 c where a.CGDBH0=? and a.YKBMBH=? and a.ypnm00=b.ypnm00 and b.lbbh00=c.lbbh00 and b.jxbh00=c.jxbh00) ORDER BY GHDWNM,CGMXXH 130 08:42:12 SQL Prepare: ORACLE - select * from( select nvl(C.CGMXXH,1) CGMXXH,C.CGJHDH,C.YPMC00,C.YPGG00,C.CGDW00,to_char(C.JHCGSL) JHCGSL, to_char(C.GJDJ00) GJDJ00,C.SCCJBH,C.SCCJZW,C.GMP000,to_char(C.JHSYSL) JHSYSL, to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,C.YFZSL0 YFZSL1, (SELECT ROUND(SUM(NVL(SJKCSL,0)/F.K2J000),3) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=C.YPNM00) YFZSL0, NULL YFSYL0, to_char(C.KCSL00) AS KCSL00,D.ZBXH00,D.ZBQMC0,D.YPTYM0,D.YPBM00,D.YPMLBZ, (select W.GHDWMC from BM_YPGHDW W where C.GHDWNM=W.GHDWNM) GHDWMC,D.LBBH00,D.YLBH00,D.JXBH00, (SELECT E.SXH000 FROM BM_YPJX00 E WHERE D.LBBH00=E.LBBH00 AND D.JXBH00=E.JXBH00) SXH000 from YK_CGJHMX C,VW_YK_YPKCXX D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=12 AND C.CGJHDH=:1 union all select M.CGMXXH,M.CGJHDH,M.YPMC00,M.YPGG00,M.CGDW00,M.JHCGSL,M.GJDJ00,M.SCCJBH,M.SCCJZW,M.GMP000,M.JHSYSL,M.GJJE00,M.GHDWNM,YFZSL1, (select ROUND(SUM(NVL(SJKCSL,0)/F.K2J000),3) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F,YK_CGJHMX G WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=G.YPNM00 AND G.CGJHDH=:2) YFZSL0, ' ' YFSYL0,M.KCSL00,M.ZBXH00,M.ZBQMC0,M.YPTYM0,M.YPBM00,M.YPMLBZ,M.GHDWMC,M.LBBH00,M.YLBH00,M.JXBH00,M.SXH000 from ( select 9999999999999 CGMXXH,' ' CGJHDH,'合 计' YPMC00,to_char(count(1)) YPGG00,' ' CGDW00,' ' JHCGSL, ' ' GJDJ00,' ' SCCJBH,' ' SCCJZW,' ' GMP000,' ' JHSYSL,to_char(sum(round(C.GJDJ00*C.JHCGSL,2))) GJJE00,999999999 GHDWNM,SUM(C.YFZSL0) YFZSL1, ' ' KCSL00,' ' ZBXH00,' ' ZBQMC0,' ' YPTYM0,' ' YPBM00,' ' YPMLBZ,' ' GHDWMC,' ' LBBH00,' ' YLBH00,' ' JXBH00,99999 SXH000 from YK_CGJHMX C,VW_YK_YPKCXX D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=12 AND C.CGJHDH=:3) M )ORDER BY GHDWNM,CGMXXH 131 08:42:12 SQL Execute: ORACLE - select * from( select nvl(C.CGMXXH,1) CGMXXH,C.CGJHDH,C.YPMC00,C.YPGG00,C.CGDW00,to_char(C.JHCGSL) JHCGSL, to_char(C.GJDJ00) GJDJ00,C.SCCJBH,C.SCCJZW,C.GMP000,to_char(C.JHSYSL) JHSYSL, to_char(round(C.GJDJ00*C.JHCGSL,2)) GJJE00,nvl(C.GHDWNM,1) GHDWNM,C.YFZSL0 YFZSL1, (SELECT ROUND(SUM(NVL(SJKCSL,0)/F.K2J000),3) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=C.YPNM00) YFZSL0, NULL YFSYL0, to_char(C.KCSL00) AS KCSL00,D.ZBXH00,D.ZBQMC0,D.YPTYM0,D.YPBM00,D.YPMLBZ, (select W.GHDWMC from BM_YPGHDW W where C.GHDWNM=W.GHDWNM) GHDWMC,D.LBBH00,D.YLBH00,D.JXBH00, (SELECT E.SXH000 FROM BM_YPJX00 E WHERE D.LBBH00=E.LBBH00 AND D.JXBH00=E.JXBH00) SXH000 from YK_CGJHMX C,VW_YK_YPKCXX D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=12 AND C.CGJHDH=? union all select M.CGMXXH,M.CGJHDH,M.YPMC00,M.YPGG00,M.CGDW00,M.JHCGSL,M.GJDJ00,M.SCCJBH,M.SCCJZW,M.GMP000,M.JHSYSL,M.GJJE00,M.GHDWNM,YFZSL1, (select ROUND(SUM(NVL(SJKCSL,0)/F.K2J000),3) SJKCSL FROM YF_YPKCXX E,BM_YD0000 F,YK_CGJHMX G WHERE E.YPNM00=F.YPNM00 AND E.YPNM00=G.YPNM00 AND G.CGJHDH=?) YFZSL0, ' ' YFSYL0,M.KCSL00,M.ZBXH00,M.ZBQMC0,M.YPTYM0,M.YPBM00,M.YPMLBZ,M.GHDWMC,M.LBBH00,M.YLBH00,M.JXBH00,M.SXH000 from ( select 9999999999999 CGMXXH,' ' CGJHDH,'合 计' YPMC00,to_char(count(1)) YPGG00,' ' CGDW00,' ' JHCGSL, ' ' GJDJ00,' ' SCCJBH,' ' SCCJZW,' ' GMP000,' ' JHSYSL,to_char(sum(round(C.GJDJ00*C.JHCGSL,2))) GJJE00,999999999 GHDWNM,SUM(C.YFZSL0) YFZSL1, ' ' KCSL00,' ' ZBXH00,' ' ZBQMC0,' ' YPTYM0,' ' YPBM00,' ' YPMLBZ,' ' GHDWMC,' ' LBBH00,' ' YLBH00,' ' JXBH00,99999 SXH000 from YK_CGJHMX C,VW_YK_YPKCXX D WHERE C.YPNM00=D.YPNM00 AND D.YKBMBH=12 AND C.CGJHDH=?) M )ORDER BY GHDWNM,CGMXXH