1 08:53:27 Log started for: 药库管理系统 2 08:53:27 SQL Prepare: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','3','appYP_YK.exe'||'+'||'药库管理系统','739','60417' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:6C39C4C40CEF0EADC9E7E36DFDDA63E5' from dual 3 08:53:27 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','3','appYP_YK.exe'||'+'||'药库管理系统','739','60417' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:6C39C4C40CEF0EADC9E7E36DFDDA63E5' from dual 4 08:53:27 SQL Prepare: ORACLE - Commit 5 08:53:27 SQL Execute: ORACLE - Commit 6 08:53:27 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 7 08:53:27 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 08:53:28 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 9 08:53:28 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 10 08:53:28 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 11 08:53:28 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 12 08:53:28 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 13 08:53:28 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 14 08:53:28 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','3','appYP_YK.exe'||'+'||'药库管理系统','471','9424' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@9998:B93164D4EEB89441C4CD7187817B4183' from dual 15 08:53:28 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','3','appYP_YK.exe'||'+'||'药库管理系统','471','9424' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@9998:B93164D4EEB89441C4CD7187817B4183' from dual 16 08:53:28 SQL Prepare: ORACLE - Commit 17 08:53:28 SQL Execute: ORACLE - Commit 18 08:53:28 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='3' 19 08:53:28 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='3' 20 08:53:28 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 21 08:53:28 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 22 08:53:31 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 23 08:53:31 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 24 08:53:31 SQL Prepare: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','3','appYP_YK.exe'||'+'||'药库管理系统','471','9460' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:AA187611476484C390088D38B2ABCDDA' from dual 25 08:53:31 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','3','appYP_YK.exe'||'+'||'药库管理系统','471','9460' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@9998:AA187611476484C390088D38B2ABCDDA' from dual 26 08:53:31 SQL Prepare: ORACLE - Commit 27 08:53:31 SQL Execute: ORACLE - Commit 28 08:53:31 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 29 08:53:31 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 30 08:53:31 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 31 08:53:31 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 32 08:53:31 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 33 08:53:31 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 34 08:53:31 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 35 08:53:31 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 36 08:53:31 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','3','appYP_YK.exe'||'+'||'药库管理系统','497','47307' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from dual 37 08:53:31 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','3','appYP_YK.exe'||'+'||'药库管理系统','497','47307' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from dual 38 08:53:31 SQL Prepare: ORACLE - Commit 39 08:53:31 SQL Execute: ORACLE - Commit 40 08:53:31 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='3' 41 08:53:31 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='3' 42 08:53:31 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 43 08:53:31 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 44 08:53:31 SQL Prepare: ORACLE - Select SYSDATE from Dual 45 08:53:31 SQL Execute: ORACLE - Select SYSDATE from Dual 46 08:53:31 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 47 08:53:31 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 48 08:53:31 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 49 08:53:31 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 50 08:53:31 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='3' 51 08:53:31 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='3' 52 08:53:31 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 53 08:53:31 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 54 08:53:31 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 55 08:53:31 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 56 08:53:31 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 57 08:53:31 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 58 08:53:32 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') 59 08:53:32 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') 60 08:53:32 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 61 08:53:32 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 62 08:53:32 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 63 08:53:32 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 64 08:53:32 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 65 08:53:32 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 66 08:53:32 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 67 08:53:32 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 68 08:53:32 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 69 08:53:32 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 70 08:53:32 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')) 71 08:53:32 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')) 72 08:53:32 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2938491,476,'wlzx-3','3',nvl('37972949',' '),'192.168.12.120#497:47307@appYP_YK.exe+药库管理系统',12) 73 08:53:32 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2938491,476,'wlzx-3','3',nvl('37972949',' '),'192.168.12.120#497:47307@appYP_YK.exe+药库管理系统',12) 74 08:53:32 SQL Prepare: ORACLE - Commit 75 08:53:32 SQL Execute: ORACLE - Commit 76 08:53:32 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 12 77 08:53:32 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 12 78 08:53:32 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 79 08:53:32 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 80 08:53:32 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 81 08:53:32 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 82 08:53:32 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 83 08:53:32 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 84 08:53:32 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 85 08:53:32 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 86 08:53:32 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 87 08:53:32 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 88 08:53:32 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 89 08:53:32 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 90 08:53:32 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 91 08:53:32 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 92 08:53:33 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 93 08:53:33 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 94 08:53:33 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 95 08:53:33 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 96 08:53:33 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='3') and YXQ000>='20120301' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',12,' )>0 ) 97 08:53:33 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='3') and YXQ000>='20120301' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',12,' )>0 ) 98 08:53:33 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 99 08:53:33 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 100 08:53:33 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 101 08:53:33 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 102 08:53:33 SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=12 103 08:53:33 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=12 104 08:53:33 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS<>'VALID' 105 08:53:33 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS<>'VALID' 106 08:53:33 SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS='VALID' 107 08:53:33 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YK_%' AND STATUS='VALID' 108 08:53:33 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' 109 08:53:33 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' 110 08:53:33 SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YK_%' AND STATUS<>'ENABLED' 111 08:53:33 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YK_%' AND STATUS<>'ENABLED' 112 08:53:33 SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_triggers where TRIGGER_NAME='TR_BM_YD0000_BFUPDDET' AND STATUS='ENABLED' 113 08:53:33 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_triggers where TRIGGER_NAME='TR_BM_YD0000_BFUPDDET' AND STATUS='ENABLED' 114 08:53:33 SQL Prepare: ORACLE - select * from XT_XTCS00 where NAME00 like 'YK_%' or NAME00 like 'YF_%' or NAME00 like 'ZS_%' 115 08:53:33 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 like 'YK_%' or NAME00 like 'YF_%' or NAME00 like 'ZS_%' 116 08:53:33 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=476 117 08:53:33 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=476 118 08:53:34 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'))) 119 08:53:34 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'))) 120 08:53:34 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 121 08:53:34 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 122 08:53: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 ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 123 08:53: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 ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 124 08:53:34 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 125 08:53:34 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 126 08:53:34 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='+ '))) 127 08:53:34 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='+ '))) 128 08:53:34 SQL Prepare: ORACLE - SELECT LBMC00 FROM BM_YPLB00 where LBBH00='3' 129 08:53:34 SQL Execute: ORACLE - SELECT LBMC00 FROM BM_YPLB00 where LBBH00='3' 130 08:53:34 SQL Prepare: ORACLE - SELECT 'X' FROM VW_YK_YPKCXX WHERE YKBMBH=12 AND KCSL00='20120301' AND T.QRRQ00<='20120301' AND T.QRRQ00||T.QRSJ00>='2012030108:00:00' AND T.QRRQ00||T.QRSJ00<='2012030117:00:00' AND T.YKBMBH='12' ORDER BY T.YPTJPC 143 08:53:49 SQL Execute: ORACLE - SELECT T.YPTJPC,T.YKBMBH,T.TJDWH0,T.SWRQ00,T.TJRQ00, G.ZWXM00,T.BZ0000,T.QRRQ00,T.QRSJ00 FROM YK_YPTJ00 T,BM_YGBM00 G WHERE T.SFQR00='Y' AND T.CZYBH0=G.YGBH00(+) AND T.QRRQ00>='20120301' AND T.QRRQ00<='20120301' AND T.QRRQ00||T.QRSJ00>='2012030108:00:00' AND T.QRRQ00||T.QRSJ00<='2012030117:00:00' AND T.YKBMBH='12' ORDER BY T.YPTJPC 144 08:53:49 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=:1 145 08:53:49 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=? 146 08:53:49 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=:1 147 08:53:49 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=? 148 08:53:49 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=:1 149 08:53:49 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=? 150 08:53:49 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=:1 151 08:53:49 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=? 152 08:53:49 SQL Prepare: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=:1 and a.YXBMBH=:2 ORDER BY a.TJMXPC 153 08:53:49 SQL Execute: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=? and a.YXBMBH=? ORDER BY a.TJMXPC 154 08:53:49 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=:1 155 08:53:49 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=? 156 08:53:49 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=:1 157 08:53:49 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=? 158 08:53:49 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=:1 159 08:53:49 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=? 160 08:53:49 SQL Prepare: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=:1 and a.YXBMBH=:2 ORDER BY a.TJMXPC 161 08:53:49 SQL Execute: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=? and a.YXBMBH=? ORDER BY a.TJMXPC 162 08:53:50 SQL Prepare: ORACLE - SELECT T.YPTJPC,T.YKBMBH,T.TJDWH0,T.SWRQ00,T.TJRQ00, G.ZWXM00,T.BZ0000,T.QRRQ00,T.QRSJ00 FROM YK_YPTJ00 T,BM_YGBM00 G WHERE T.SFQR00='Y' AND T.CZYBH0=G.YGBH00(+) AND T.QRRQ00>='20120301' AND T.QRRQ00<='20120301' AND T.QRRQ00||T.QRSJ00>='2012030108:00:00' AND T.QRRQ00||T.QRSJ00<='2012030117:00:00' AND T.YKBMBH='12' ORDER BY T.YPTJPC 163 08:53:50 SQL Execute: ORACLE - SELECT T.YPTJPC,T.YKBMBH,T.TJDWH0,T.SWRQ00,T.TJRQ00, G.ZWXM00,T.BZ0000,T.QRRQ00,T.QRSJ00 FROM YK_YPTJ00 T,BM_YGBM00 G WHERE T.SFQR00='Y' AND T.CZYBH0=G.YGBH00(+) AND T.QRRQ00>='20120301' AND T.QRRQ00<='20120301' AND T.QRRQ00||T.QRSJ00>='2012030108:00:00' AND T.QRRQ00||T.QRSJ00<='2012030117:00:00' AND T.YKBMBH='12' ORDER BY T.YPTJPC 164 08:53:50 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=:1 165 08:53:50 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=? 166 08:53:50 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=:1 167 08:53:50 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=? 168 08:53:50 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=:1 169 08:53:50 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=? 170 08:53:50 SQL Prepare: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=:1 and a.YXBMBH=:2 ORDER BY a.TJMXPC 171 08:53:50 SQL Execute: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=? and a.YXBMBH=? ORDER BY a.TJMXPC 172 08:53:50 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=:1 173 08:53:50 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=? 174 08:53:50 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=:1 175 08:53:50 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=? 176 08:53:50 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=:1 177 08:53:50 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='' AND a.YXBMBH=? 178 08:53:51 SQL Prepare: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=:1 and a.YXBMBH=:2 ORDER BY a.TJMXPC 179 08:53:51 SQL Execute: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=? and a.YXBMBH=? ORDER BY a.TJMXPC 180 08:53:55 SQL Prepare: ORACLE - SELECT T.YPTJPC,T.YKBMBH,T.TJDWH0,T.SWRQ00,T.TJRQ00, G.ZWXM00,T.BZ0000,T.QRRQ00,T.QRSJ00 FROM YK_YPTJ00 T,BM_YGBM00 G WHERE T.SFQR00='Y' AND T.CZYBH0=G.YGBH00(+) AND T.QRRQ00>='20120201' AND T.QRRQ00<='20120301' AND T.QRRQ00||T.QRSJ00>='2012020108:00:00' AND T.QRRQ00||T.QRSJ00<='2012030117:00:00' AND T.YKBMBH='12' ORDER BY T.YPTJPC 181 08:53:55 SQL Execute: ORACLE - SELECT T.YPTJPC,T.YKBMBH,T.TJDWH0,T.SWRQ00,T.TJRQ00, G.ZWXM00,T.BZ0000,T.QRRQ00,T.QRSJ00 FROM YK_YPTJ00 T,BM_YGBM00 G WHERE T.SFQR00='Y' AND T.CZYBH0=G.YGBH00(+) AND T.QRRQ00>='20120201' AND T.QRRQ00<='20120301' AND T.QRRQ00||T.QRSJ00>='2012020108:00:00' AND T.QRRQ00||T.QRSJ00<='2012030117:00:00' AND T.YKBMBH='12' ORDER BY T.YPTJPC 182 08:53:55 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004159' AND a.YXBMBH=:1 183 08:53:55 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004159' AND a.YXBMBH=? 184 08:53:55 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004159' AND a.YXBMBH=:1 185 08:53:55 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004159' AND a.YXBMBH=? 186 08:53:55 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004159' AND a.YXBMBH=:1 187 08:53:55 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004159' AND a.YXBMBH=? 188 08:53:55 SQL Prepare: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=:1 and a.YXBMBH=:2 ORDER BY a.TJMXPC 189 08:53:55 SQL Execute: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=? and a.YXBMBH=? ORDER BY a.TJMXPC 190 08:53:55 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004159' AND a.YXBMBH=:1 191 08:53:55 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004159' AND a.YXBMBH=? 192 08:53:55 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004159' AND a.YXBMBH=:1 193 08:53:55 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004159' AND a.YXBMBH=? 194 08:53:55 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004159' AND a.YXBMBH=:1 195 08:53:55 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004159' AND a.YXBMBH=? 196 08:53:55 SQL Prepare: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=:1 and a.YXBMBH=:2 ORDER BY a.TJMXPC 197 08:53:55 SQL Execute: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=? and a.YXBMBH=? ORDER BY a.TJMXPC 198 08:53:56 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004162' AND a.YXBMBH=:1 199 08:53:56 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004162' AND a.YXBMBH=? 200 08:53:56 SQL Prepare: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=:1 and a.YXBMBH=:2 ORDER BY a.TJMXPC 201 08:53:56 SQL Execute: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=? and a.YXBMBH=? ORDER BY a.TJMXPC 202 08:53:58 SQL Prepare: ORACLE - select * from vw_yk_tjddy where yptjpc='004162' and yxbmbh=12 203 08:53:58 SQL Execute: ORACLE - select * from vw_yk_tjddy where yptjpc='004162' and yxbmbh=12 204 08:54:05 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004164' AND a.YXBMBH=:1 205 08:54:05 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004164' AND a.YXBMBH=? 206 08:54:05 SQL Prepare: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=:1 and a.YXBMBH=:2 ORDER BY a.TJMXPC 207 08:54:05 SQL Execute: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=? and a.YXBMBH=? ORDER BY a.TJMXPC 208 08:54:07 SQL Prepare: ORACLE - SELECT T.YPTJPC,X.YPMC00,X.YPGG00,X.TJDW00,X.ZMKC00,X.SJKC00,X.KL0000, X.YPFDJ0,X.XPFDJ0,X.GJPJDJ,X.YLSDJ0,X.XLSDJ0,X.QRRQ00,X.QRSJ00, X.BZ0000 AS MXBZ00,T.QRRQ00,T.QRSJ00,T.BZ0000,D.YPJCL0+1 YPJCL0, X.XLSDJ0-X.YLSDJ0 AS C_LSCJ, X.XPFDJ0-X.YPFDJ0 AS C_GJCJ, (select GJSLJE+GJFCJE from YK_YPMXZ0 where djh000=x.YPTJPC and ypnm00=d.ypnm00 ) AS C_GJSY, ROUND(X.SJKC00*(X.XLSDJ0-X.YLSDJ0),2) AS C_TJSY FROM YK_YPTJ00 T,YK_YPTJMX X,BM_YD0000 D WHERE T.YPTJPC=X.YPTJPC AND X.YPNM00=D.YPNM00 AND T.YPTJPC='004164' AND X.YXBMBH='12' ORDER BY TJMXPC 209 08:54:07 SQL Execute: ORACLE - SELECT T.YPTJPC,X.YPMC00,X.YPGG00,X.TJDW00,X.ZMKC00,X.SJKC00,X.KL0000, X.YPFDJ0,X.XPFDJ0,X.GJPJDJ,X.YLSDJ0,X.XLSDJ0,X.QRRQ00,X.QRSJ00, X.BZ0000 AS MXBZ00,T.QRRQ00,T.QRSJ00,T.BZ0000,D.YPJCL0+1 YPJCL0, X.XLSDJ0-X.YLSDJ0 AS C_LSCJ, X.XPFDJ0-X.YPFDJ0 AS C_GJCJ, (select GJSLJE+GJFCJE from YK_YPMXZ0 where djh000=x.YPTJPC and ypnm00=d.ypnm00 ) AS C_GJSY, ROUND(X.SJKC00*(X.XLSDJ0-X.YLSDJ0),2) AS C_TJSY FROM YK_YPTJ00 T,YK_YPTJMX X,BM_YD0000 D WHERE T.YPTJPC=X.YPTJPC AND X.YPNM00=D.YPNM00 AND T.YPTJPC='004164' AND X.YXBMBH='12' ORDER BY TJMXPC 210 08:54:17 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 211 08:54:17 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 212 08:54:41 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004167' AND a.YXBMBH=:1 213 08:54:41 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004167' AND a.YXBMBH=? 214 08:54:41 SQL Prepare: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=:1 and a.YXBMBH=:2 ORDER BY a.TJMXPC 215 08:54:41 SQL Execute: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=? and a.YXBMBH=? ORDER BY a.TJMXPC 216 08:54:41 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004168' AND a.YXBMBH=:1 217 08:54:41 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004168' AND a.YXBMBH=? 218 08:54:41 SQL Prepare: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=:1 and a.YXBMBH=:2 ORDER BY a.TJMXPC 219 08:54:41 SQL Execute: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=? and a.YXBMBH=? ORDER BY a.TJMXPC 220 08:54:42 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004170' AND a.YXBMBH=:1 221 08:54:42 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004170' AND a.YXBMBH=? 222 08:54:42 SQL Prepare: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=:1 and a.YXBMBH=:2 ORDER BY a.TJMXPC 223 08:54:42 SQL Execute: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=? and a.YXBMBH=? ORDER BY a.TJMXPC 224 08:54:42 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004171' AND a.YXBMBH=:1 225 08:54:42 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004171' AND a.YXBMBH=? 226 08:54:42 SQL Prepare: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=:1 and a.YXBMBH=:2 ORDER BY a.TJMXPC 227 08:54:42 SQL Execute: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=? and a.YXBMBH=? ORDER BY a.TJMXPC 228 08:54:42 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004174' AND a.YXBMBH=:1 229 08:54:42 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004174' AND a.YXBMBH=? 230 08:54:42 SQL Prepare: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=:1 and a.YXBMBH=:2 ORDER BY a.TJMXPC 231 08:54:42 SQL Execute: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=? and a.YXBMBH=? ORDER BY a.TJMXPC 232 08:54:42 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004175' AND a.YXBMBH=:1 233 08:54:42 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004175' AND a.YXBMBH=? 234 08:54:42 SQL Prepare: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=:1 and a.YXBMBH=:2 ORDER BY a.TJMXPC 235 08:54:42 SQL Execute: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=? and a.YXBMBH=? ORDER BY a.TJMXPC 236 08:54:42 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004178' AND a.YXBMBH=:1 237 08:54:42 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004178' AND a.YXBMBH=? 238 08:54:42 SQL Prepare: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=:1 and a.YXBMBH=:2 ORDER BY a.TJMXPC 239 08:54:42 SQL Execute: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=? and a.YXBMBH=? ORDER BY a.TJMXPC 240 08:54:42 SQL Prepare: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004179' AND a.YXBMBH=:1 241 08:54:42 SQL Execute: ORACLE - select a.*,b.YPBM00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004179' AND a.YXBMBH=? 242 08:54:42 SQL Prepare: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=:1 and a.YXBMBH=:2 ORDER BY a.TJMXPC 243 08:54:42 SQL Execute: ORACLE - select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=? and a.YXBMBH=? ORDER BY a.TJMXPC 244 08:57:03 Log started for: SQL Navigator for Oracle 245 08:57:05 SQL Execute: select version from SYS.PRODUCT_COMPONENT_VERSION where upper(product) like '%ORACLE%' 246 08:57:05 SQL Execute: SELECT table_name, table_owner FROM all_synonyms WHERE owner = 'PUBLIC' AND synonym_name = 'QUEST_COM_TEAM_CODING' 247 08:57:05 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 248 08:57:05 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 249 08:57:05 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'N' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.dba_objects a,sys.dba_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' and b.dropped='NO' 250 08:57:05 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 251 08:57:05 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 252 08:57:05 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'Y' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.dba_objects a,sys.dba_object_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 253 08:57:05 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 254 08:57:05 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 255 08:57:05 SQL Execute: select /*+ QCO9i QCOALL */ :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,'N' partitioned,'N' object_table,'Y' external_table,'N' nested,0 IOT_Type,'' IOT_Name,'N' temporary from sys.dba_objects a,sys.dba_external_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 256 08:57:05 SQL Execute: ALTER SESSION SET NLS_DATE_FORMAT='DD-Mon-RRRR' 257 08:57:05 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 258 08:57:05 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 259 08:57:05 SQL Execute: select USER owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from user_objects a where object_name like :object_name and object_type=:object_type 260 08:57:12 SQL Execute: select version from SYS.PRODUCT_COMPONENT_VERSION where upper(product) like '%ORACLE%' 261 08:57:12 SQL Execute: SELECT table_name, table_owner FROM all_synonyms WHERE owner = 'PUBLIC' AND synonym_name = 'QUEST_COM_TEAM_CODING' 262 08:57:14 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 263 08:57:14 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 264 08:57:14 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'N' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.dba_objects a,sys.dba_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' and b.dropped='NO' 265 08:57:14 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 266 08:57:14 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 267 08:57:14 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'Y' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.dba_objects a,sys.dba_object_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 268 08:57:14 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 269 08:57:14 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 270 08:57:14 SQL Execute: select /*+ QCO9i QCOALL */ :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,'N' partitioned,'N' object_table,'Y' external_table,'N' nested,0 IOT_Type,'' IOT_Name,'N' temporary from sys.dba_objects a,sys.dba_external_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 271 08:57:14 SQL Execute: ALTER SESSION SET NLS_DATE_FORMAT='DD-Mon-RRRR' 272 08:57:14 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 273 08:57:14 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 274 08:57:14 SQL Execute: select USER owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from user_objects a where object_name like :object_name and object_type=:object_type 275 08:57:32 SQL Prepare: select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=004179 and a.YXBMBH=12 ORDER BY a.TJMXPC 276 08:57:32 SQL Execute: select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC=004179 and a.YXBMBH=12 ORDER BY a.TJMXPC 277 08:57:43 SQL Prepare: select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004179' and a.YXBMBH=12 ORDER BY a.TJMXPC 278 08:57:43 SQL Execute: select a.*,b.ypbm00 from YK_YPTJMX a,BM_YD0000 b where A.YPNM00=B.YPNM00 and a.YPTJPC='004179' and a.YXBMBH=12 ORDER BY a.TJMXPC 279 08:58:40 SQL Prepare: SELECT T.YPTJPC,X.YPMC00,X.YPGG00,X.TJDW00,X.ZMKC00,X.SJKC00,X.KL0000, X.YPFDJ0,X.XPFDJ0,X.GJPJDJ,X.YLSDJ0,X.XLSDJ0,X.QRRQ00,X.QRSJ00, X.BZ0000 AS MXBZ00,T.QRRQ00,T.QRSJ00,T.BZ0000,D.YPJCL0+1 YPJCL0, X.XLSDJ0-X.YLSDJ0 AS C_LSCJ, X.XPFDJ0-X.YPFDJ0 AS C_GJCJ, (select GJSLJE+GJFCJE from YK_YPMXZ0 where djh000=x.YPTJPC and ypnm00=d.ypnm00 ) AS C_GJSY, ROUND(X.SJKC00*(X.XLSDJ0-X.YLSDJ0),2) AS C_TJSY FROM YK_YPTJ00 T,YK_YPTJMX X,BM_YD0000 D WHERE T.YPTJPC=X.YPTJPC AND X.YPNM00=D.YPNM00 AND T.YPTJPC='004164' AND X.YXBMBH='12' ORDER BY TJMXPC 280 08:58:40 SQL Execute: SELECT T.YPTJPC,X.YPMC00,X.YPGG00,X.TJDW00,X.ZMKC00,X.SJKC00,X.KL0000, X.YPFDJ0,X.XPFDJ0,X.GJPJDJ,X.YLSDJ0,X.XLSDJ0,X.QRRQ00,X.QRSJ00, X.BZ0000 AS MXBZ00,T.QRRQ00,T.QRSJ00,T.BZ0000,D.YPJCL0+1 YPJCL0, X.XLSDJ0-X.YLSDJ0 AS C_LSCJ, X.XPFDJ0-X.YPFDJ0 AS C_GJCJ, (select GJSLJE+GJFCJE from YK_YPMXZ0 where djh000=x.YPTJPC and ypnm00=d.ypnm00 ) AS C_GJSY, ROUND(X.SJKC00*(X.XLSDJ0-X.YLSDJ0),2) AS C_TJSY FROM YK_YPTJ00 T,YK_YPTJMX X,BM_YD0000 D WHERE T.YPTJPC=X.YPTJPC AND X.YPNM00=D.YPNM00 AND T.YPTJPC='004164' AND X.YXBMBH='12' ORDER BY TJMXPC 281 08:59:45 SQL Prepare: SELECT T.YPTJPC,X.YPMC00,X.YPGG00,X.TJDW00,X.ZMKC00,X.SJKC00,X.KL0000, X.YPFDJ0,X.XPFDJ0,X.GJPJDJ,X.YLSDJ0,X.XLSDJ0,X.QRRQ00,X.QRSJ00, X.BZ0000 AS MXBZ00,T.QRRQ00,T.QRSJ00,T.BZ0000,D.YPJCL0+1 YPJCL0, X.XLSDJ0-X.YLSDJ0 AS C_LSCJ, X.XPFDJ0-X.YPFDJ0 AS C_GJCJ, (select GJSLJE+GJFCJE from YK_YPMXZ0 where djh000=x.YPTJPC and ypnm00=d.ypnm00 ) AS C_GJSY, ROUND(X.SJKC00*(X.XLSDJ0-X.YLSDJ0),2) AS C_TJSY FROM YK_YPTJ00 T,YK_YPTJMX X,BM_YD0000 D WHERE T.YPTJPC=X.YPTJPC AND X.YPNM00=D.YPNM00 AND T.YPTJPC='004179' AND X.YXBMBH='12' ORDER BY TJMXPC 282 08:59:45 SQL Execute: SELECT T.YPTJPC,X.YPMC00,X.YPGG00,X.TJDW00,X.ZMKC00,X.SJKC00,X.KL0000, X.YPFDJ0,X.XPFDJ0,X.GJPJDJ,X.YLSDJ0,X.XLSDJ0,X.QRRQ00,X.QRSJ00, X.BZ0000 AS MXBZ00,T.QRRQ00,T.QRSJ00,T.BZ0000,D.YPJCL0+1 YPJCL0, X.XLSDJ0-X.YLSDJ0 AS C_LSCJ, X.XPFDJ0-X.YPFDJ0 AS C_GJCJ, (select GJSLJE+GJFCJE from YK_YPMXZ0 where djh000=x.YPTJPC and ypnm00=d.ypnm00 ) AS C_GJSY, ROUND(X.SJKC00*(X.XLSDJ0-X.YLSDJ0),2) AS C_TJSY FROM YK_YPTJ00 T,YK_YPTJMX X,BM_YD0000 D WHERE T.YPTJPC=X.YPTJPC AND X.YPNM00=D.YPNM00 AND T.YPTJPC='004179' AND X.YXBMBH='12' ORDER BY TJMXPC