1 11:02:17 SQL Prepare: ORACLE - select '0' CHECK0,A.*,B.YPJCL0,B.YPBM00, (select d.SCCJZW from BM_YPSCCJ d where b.SCCJBH=d.SCCJBH) SCCJ00, (select c.GHDWMC from BM_YPGHDW c where b.GHDWNM=c.GHDWNM) GHDWMC,B.YPMLBZ from YK_YPTJMX A,BM_YD0000 B WHERE A.YPNM00=B.YPNM00 AND A.YPTJPC='' AND A.YXBMBH=12 order by A.TJMXPC 2 11:02:17 SQL Execute: ORACLE - select '0' CHECK0,A.*,B.YPJCL0,B.YPBM00, (select d.SCCJZW from BM_YPSCCJ d where b.SCCJBH=d.SCCJBH) SCCJ00, (select c.GHDWMC from BM_YPGHDW c where b.GHDWNM=c.GHDWNM) GHDWMC,B.YPMLBZ from YK_YPTJMX A,BM_YD0000 B WHERE A.YPNM00=B.YPNM00 AND A.YPTJPC='' AND A.YXBMBH=12 order by A.TJMXPC 3 11:02:20 SQL Prepare: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 4 11:02:20 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 5 11:02:20 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like :1) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 6 11:02:20 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like ?) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 7 11:02:20 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like :1) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 8 11:02:20 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like ?) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 9 11:02:23 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like :1) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 10 11:02:23 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like ?) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 11 11:02:24 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like :1) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 12 11:02:24 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like ?) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 13 11:02:26 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like :1) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 14 11:02:26 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like ?) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 15 11:02:28 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like :1) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 16 11:02:28 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like ?) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 17 11:02:29 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like :1) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 18 11:02:29 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like ?) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 19 11:02:30 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like :1) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 20 11:02:30 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like ?) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 21 11:02:31 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like :1) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 22 11:02:31 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like ?) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 23 11:02:32 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like :1) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 24 11:02:32 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like ?) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 25 11:02:37 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like :1) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 26 11:02:37 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like ?) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 27 11:02:41 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like :1) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 28 11:02:41 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like ?) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 29 11:02:49 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like :1) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 30 11:02:49 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like ?) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 31 11:02:53 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like :1) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 32 11:02:53 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like ?) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 33 11:03:21 SQL Prepare: ORACLE - select ZFZGDJ from BM_YD0000 where YPNM00=8309 34 11:03:21 SQL Execute: ORACLE - select ZFZGDJ from BM_YD0000 where YPNM00=8309 35 11:06:43 SQL Prepare: ORACLE - SELECT * FROM BM_YPLB00 36 11:06:43 SQL Execute: ORACLE - SELECT * FROM BM_YPLB00 37 11:06:43 SQL Prepare: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 38 11:06:43 SQL Execute: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 39 11:06:43 SQL Prepare: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 40 11:06:43 SQL Execute: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 41 11:06:43 SQL Prepare: ORACLE - select a.YPNM00,a.YPBM00,a.YPMC00,a.YPGG00,a.KCDW00,a.PYSM00,a.WBSM00,a.LSJ000,a.PYSMTY, a.YPTYM0,a.ZFZGDJ,a.SCCJBH,a.SFYBML,a.EYPTYM,a.EYPMC0,a.EKCDW0,a.EYPGG0,a.BZ0000,a.YPMLBZ,b.* from bm_yd0000 a,BM_YPSCCJ b where a.LBBH00 like '0%' and a.YLBH00 like '%' and a.JXBH00 like '%' and a.YKBMBH=12 and a.TZRQ00 IS NULL and a.SCCJBH=b.SCCJBH(+) order by a.YPBM00 42 11:06:43 SQL Execute: ORACLE - select a.YPNM00,a.YPBM00,a.YPMC00,a.YPGG00,a.KCDW00,a.PYSM00,a.WBSM00,a.LSJ000,a.PYSMTY, a.YPTYM0,a.ZFZGDJ,a.SCCJBH,a.SFYBML,a.EYPTYM,a.EYPMC0,a.EKCDW0,a.EYPGG0,a.BZ0000,a.YPMLBZ,b.* from bm_yd0000 a,BM_YPSCCJ b where a.LBBH00 like '0%' and a.YLBH00 like '%' and a.JXBH00 like '%' and a.YKBMBH=12 and a.TZRQ00 IS NULL and a.SCCJBH=b.SCCJBH(+) order by a.YPBM00 43 11:07:06 SQL Prepare: ORACLE - select a.YPNM00,a.YPBM00,a.YPMC00,a.YPGG00,a.KCDW00,a.PYSM00,a.WBSM00,a.LSJ000,a.PYSMTY, a.YPTYM0,a.ZFZGDJ,a.SCCJBH,a.SFYBML,a.EYPTYM,a.EYPMC0,a.EKCDW0,a.EYPGG0,a.BZ0000,a.YPMLBZ,b.* from bm_yd0000 a,BM_YPSCCJ b where a.LBBH00 like '0%' and a.YLBH00 like '%' and a.JXBH00 like '%' and a.YKBMBH=12 and a.TZRQ00 IS NULL and a.SCCJBH=b.SCCJBH(+) order by a.YPBM00 44 11:07:06 SQL Execute: ORACLE - select a.YPNM00,a.YPBM00,a.YPMC00,a.YPGG00,a.KCDW00,a.PYSM00,a.WBSM00,a.LSJ000,a.PYSMTY, a.YPTYM0,a.ZFZGDJ,a.SCCJBH,a.SFYBML,a.EYPTYM,a.EYPMC0,a.EKCDW0,a.EYPGG0,a.BZ0000,a.YPMLBZ,b.* from bm_yd0000 a,BM_YPSCCJ b where a.LBBH00 like '0%' and a.YLBH00 like '%' and a.JXBH00 like '%' and a.YKBMBH=12 and a.TZRQ00 IS NULL and a.SCCJBH=b.SCCJBH(+) order by a.YPBM00 45 11:07:38 SQL Prepare: ORACLE - select a.YPNM00,a.YPBM00,a.YPMC00,a.YPGG00,a.KCDW00,a.PYSM00,a.WBSM00,a.LSJ000,a.PYSMTY, a.YPTYM0,a.ZFZGDJ,a.SCCJBH,a.SFYBML,a.EYPTYM,a.EYPMC0,a.EKCDW0,a.EYPGG0,a.BZ0000,a.YPMLBZ,b.* from bm_yd0000 a,BM_YPSCCJ b where a.LBBH00 like '0%' and a.YLBH00 like '%' and a.JXBH00 like '%' and a.YKBMBH=12 and a.TZRQ00 IS NULL and a.SCCJBH=b.SCCJBH(+) order by a.YPBM00 46 11:07:38 SQL Execute: ORACLE - select a.YPNM00,a.YPBM00,a.YPMC00,a.YPGG00,a.KCDW00,a.PYSM00,a.WBSM00,a.LSJ000,a.PYSMTY, a.YPTYM0,a.ZFZGDJ,a.SCCJBH,a.SFYBML,a.EYPTYM,a.EYPMC0,a.EKCDW0,a.EYPGG0,a.BZ0000,a.YPMLBZ,b.* from bm_yd0000 a,BM_YPSCCJ b where a.LBBH00 like '0%' and a.YLBH00 like '%' and a.JXBH00 like '%' and a.YKBMBH=12 and a.TZRQ00 IS NULL and a.SCCJBH=b.SCCJBH(+) order by a.YPBM00 47 11:08:59 SQL Prepare: ORACLE - update bm_yd0000 set ZFZGDJ = :1, BZ0000 = :2 where YPNM00 = :3 48 11:08:59 SQL Execute: ORACLE - update bm_yd0000 set ZFZGDJ = ?, BZ0000 = ? where YPNM00 = ? 49 11:08:59 SQL Prepare: ORACLE - commit 50 11:08:59 SQL Execute: ORACLE - commit 51 11:09:23 SQL Prepare: ORACLE - select a.YPNM00,a.YPBM00,a.YPMC00,a.YPGG00,a.KCDW00,a.PYSM00,a.WBSM00,a.LSJ000,a.PYSMTY, a.YPTYM0,a.ZFZGDJ,a.SCCJBH,a.SFYBML,a.EYPTYM,a.EYPMC0,a.EKCDW0,a.EYPGG0,a.BZ0000,a.YPMLBZ,b.* from bm_yd0000 a,BM_YPSCCJ b where a.LBBH00 like '0%' and a.YLBH00 like '%' and a.JXBH00 like '%' and a.YKBMBH=12 and a.TZRQ00 IS NULL and a.SCCJBH=b.SCCJBH(+) order by a.YPBM00 52 11:09:23 SQL Execute: ORACLE - select a.YPNM00,a.YPBM00,a.YPMC00,a.YPGG00,a.KCDW00,a.PYSM00,a.WBSM00,a.LSJ000,a.PYSMTY, a.YPTYM0,a.ZFZGDJ,a.SCCJBH,a.SFYBML,a.EYPTYM,a.EYPMC0,a.EKCDW0,a.EYPGG0,a.BZ0000,a.YPMLBZ,b.* from bm_yd0000 a,BM_YPSCCJ b where a.LBBH00 like '0%' and a.YLBH00 like '%' and a.JXBH00 like '%' and a.YKBMBH=12 and a.TZRQ00 IS NULL and a.SCCJBH=b.SCCJBH(+) order by a.YPBM00 53 11:09:33 SQL Prepare: ORACLE - select ZFZGDJ from BM_YD0000 where YPNM00=8309 54 11:09:33 SQL Execute: ORACLE - select ZFZGDJ from BM_YD0000 where YPNM00=8309 55 11:09:33 SQL Prepare: ORACLE - BEGIN :Result := "SF_YK_GETLSH" (P_LSH => :P_LSH); END; 56 11:09:33 SQL Execute: ORACLE - BEGIN :Result := "SF_YK_GETLSH" (P_LSH => :P_LSH); END; 57 11:09:33 SQL Prepare: ORACLE - INSERT INTO YK_YPTJ00 (YPTJPC,YKBMBH,CZYBH0,BZ0000,TJRQ00,TJSJ00,ZTYFJG,YYTJRQ,YYTJSJ) VALUES(:1,:2,:3,:4 ,TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS'),:5,:6,:7) 58 11:09:33 SQL Execute: ORACLE - INSERT INTO YK_YPTJ00 (YPTJPC,YKBMBH,CZYBH0,BZ0000,TJRQ00,TJSJ00,ZTYFJG,YYTJRQ,YYTJSJ) VALUES(?,?,?,? ,TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS'),?,?,?) 59 11:09:33 SQL Prepare: ORACLE - insert into YK_YPTJMX (YPTJPC, YXBMBH, YPNM00, YPMC00, YPGG00, TJDW00, ZHL000, ZMKC00, SJKC00,KL0000, YPFDJ0, XPFDJ0, GJPJDJ, YLSDJ0, XLSDJ0, BZ0000, TJMXPC,ZFZGDJ) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, SQ_YK_YPTJMX_TJMXPC.NEXTVAL,:17) 60 11:09:33 SQL Execute: ORACLE - insert into YK_YPTJMX (YPTJPC, YXBMBH, YPNM00, YPMC00, YPGG00, TJDW00, ZHL000, ZMKC00, SJKC00,KL0000, YPFDJ0, XPFDJ0, GJPJDJ, YLSDJ0, XLSDJ0, BZ0000, TJMXPC,ZFZGDJ) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, SQ_YK_YPTJMX_TJMXPC.NEXTVAL,?) 61 11:09:34 SQL Prepare: ORACLE - BEGIN "SP_YK_YPTJYFSY" (P_YPTJPC => :P_YPTJPC,P_YKBMBH => :P_YKBMBH); END; 62 11:09:34 SQL Execute: ORACLE - BEGIN "SP_YK_YPTJYFSY" (P_YPTJPC => :P_YPTJPC,P_YKBMBH => :P_YKBMBH); END; 63 11:09:34 SQL Prepare: ORACLE - COMMIT WORK 64 11:09:34 SQL Execute: ORACLE - COMMIT WORK 65 11:09:34 SQL Prepare: ORACLE - Commit 66 11:09:34 SQL Execute: ORACLE - Commit 67 11:10:42 SQL Prepare: ORACLE - SELECT * FROM YK_YPTJ00 WHERE YKBMBH=12 AND SFQR00='N' AND YPTJPC='004474' 68 11:10:42 SQL Execute: ORACLE - SELECT * FROM YK_YPTJ00 WHERE YKBMBH=12 AND SFQR00='N' AND YPTJPC='004474' 69 11:10:42 SQL Prepare: ORACLE - select '0' CHECK0,A.*,B.YPJCL0,B.YPBM00, (select d.SCCJZW from BM_YPSCCJ d where b.SCCJBH=d.SCCJBH) SCCJ00, (select c.GHDWMC from BM_YPGHDW c where b.GHDWNM=c.GHDWNM) GHDWMC,B.YPMLBZ from YK_YPTJMX A,BM_YD0000 B WHERE A.YPNM00=B.YPNM00 AND A.YPTJPC='004474' AND A.YXBMBH=12 order by A.TJMXPC 70 11:10:42 SQL Execute: ORACLE - select '0' CHECK0,A.*,B.YPJCL0,B.YPBM00, (select d.SCCJZW from BM_YPSCCJ d where b.SCCJBH=d.SCCJBH) SCCJ00, (select c.GHDWMC from BM_YPGHDW c where b.GHDWNM=c.GHDWNM) GHDWMC,B.YPMLBZ from YK_YPTJMX A,BM_YD0000 B WHERE A.YPNM00=B.YPNM00 AND A.YPTJPC='004474' AND A.YXBMBH=12 order by A.TJMXPC 71 11:10:42 SQL Prepare: ORACLE - SELECT distinct B.BMBH00,B.BMMC00 FROM BM_BMBM00 B,YK_YPTJMX T WHERE B.BMBH00=T.YXBMBH AND B.BMXZ00 IN ('2','3') AND B.FLAG00='1' AND T.YPTJPC='004474' 72 11:10:42 SQL Execute: ORACLE - SELECT distinct B.BMBH00,B.BMMC00 FROM BM_BMBM00 B,YK_YPTJMX T WHERE B.BMBH00=T.YXBMBH AND B.BMXZ00 IN ('2','3') AND B.FLAG00='1' AND T.YPTJPC='004474' 73 11:12:10 SQL Prepare: ORACLE - SELECT * FROM BM_YPLB00 74 11:12:10 SQL Execute: ORACLE - SELECT * FROM BM_YPLB00 75 11:12:10 SQL Prepare: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 76 11:12:10 SQL Execute: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 77 11:12:10 SQL Prepare: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 78 11:12:10 SQL Execute: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 79 11:12:10 SQL Prepare: ORACLE - select a.YPNM00,a.YPBM00,a.YPMC00,a.YPGG00,a.KCDW00,a.PYSM00,a.WBSM00,a.LSJ000,a.PYSMTY, a.YPTYM0,a.ZFZGDJ,a.SCCJBH,a.SFYBML,a.EYPTYM,a.EYPMC0,a.EKCDW0,a.EYPGG0,a.BZ0000,a.YPMLBZ,b.* from bm_yd0000 a,BM_YPSCCJ b where a.LBBH00 like '0%' and a.YLBH00 like '%' and a.JXBH00 like '%' and a.YKBMBH=12 and a.TZRQ00 IS NULL and a.SCCJBH=b.SCCJBH(+) order by a.YPBM00 80 11:12:10 SQL Execute: ORACLE - select a.YPNM00,a.YPBM00,a.YPMC00,a.YPGG00,a.KCDW00,a.PYSM00,a.WBSM00,a.LSJ000,a.PYSMTY, a.YPTYM0,a.ZFZGDJ,a.SCCJBH,a.SFYBML,a.EYPTYM,a.EYPMC0,a.EKCDW0,a.EYPGG0,a.BZ0000,a.YPMLBZ,b.* from bm_yd0000 a,BM_YPSCCJ b where a.LBBH00 like '0%' and a.YLBH00 like '%' and a.JXBH00 like '%' and a.YKBMBH=12 and a.TZRQ00 IS NULL and a.SCCJBH=b.SCCJBH(+) order by a.YPBM00 81 11:20:50 SQL Prepare: ORACLE - select BMMC00,BMBH00 from BM_BMBM00 where BMXZ00 in ('2','3') and FLAG00='1' order by BMXZ00,BMBH00 82 11:20:50 SQL Execute: ORACLE - select BMMC00,BMBH00 from BM_BMBM00 where BMXZ00 in ('2','3') and FLAG00='1' order by BMXZ00,BMBH00 83 11:20:50 SQL Prepare: ORACLE - SELECT T.YPTJPC,T.YKBMBH,T.TJDWH0,T.SWRQ00,T.TJRQ00, G.ZWXM00,T.BZ0000,T.QRRQ00,T.QRSJ00,T.YYTJRQ,T.YYTJSJ, T.YYSHRQ,T.YYSHSJ,T.QXSHRQ,T.QXSHSJ, (select ZWXM00 from BM_YGBM00 where YGBH00=T.YYSHY0) YYSHY0, (select ZWXM00 from BM_YGBM00 where YGBH00=T.QXSHY0) QXSHY0 FROM YK_YPTJ00 T,BM_YGBM00 G WHERE T.SFQR00='Y' AND T.CZYBH0=G.YGBH00(+) AND T.QRRQ00>='20140515' AND T.QRRQ00<='20140515' AND T.QRRQ00||T.QRSJ00>='2014051508:00:00' AND T.QRRQ00||T.QRSJ00<='2014051517:00:00' AND T.YKBMBH='12' ORDER BY T.YPTJPC 84 11:20:50 SQL Execute: ORACLE - SELECT T.YPTJPC,T.YKBMBH,T.TJDWH0,T.SWRQ00,T.TJRQ00, G.ZWXM00,T.BZ0000,T.QRRQ00,T.QRSJ00,T.YYTJRQ,T.YYTJSJ, T.YYSHRQ,T.YYSHSJ,T.QXSHRQ,T.QXSHSJ, (select ZWXM00 from BM_YGBM00 where YGBH00=T.YYSHY0) YYSHY0, (select ZWXM00 from BM_YGBM00 where YGBH00=T.QXSHY0) QXSHY0 FROM YK_YPTJ00 T,BM_YGBM00 G WHERE T.SFQR00='Y' AND T.CZYBH0=G.YGBH00(+) AND T.QRRQ00>='20140515' AND T.QRRQ00<='20140515' AND T.QRRQ00||T.QRSJ00>='2014051508:00:00' AND T.QRRQ00||T.QRSJ00<='2014051517:00:00' AND T.YKBMBH='12' ORDER BY T.YPTJPC 85 11:20: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 86 11:20: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=? 87 11:20: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 88 11:20: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=? 89 11:20: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 90 11:20: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=? 91 11:20: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 92 11:20: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=? 93 11:20: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 94 11:20: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 95 11:20: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 96 11:20: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=? 97 11:20: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 98 11:20: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=? 99 11:20: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 100 11:20: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=? 101 11:20: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 102 11:20: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 103 11:21:12 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 104 11:21:12 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=? 105 11:21:12 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 106 11:21:12 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 107 11:21:12 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 108 11:21:12 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=? 109 11:21:12 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 110 11:21:12 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 111 11:21:35 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 112 11:21:35 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=? 113 11:21:35 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 114 11:21:35 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 115 11:21:35 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 116 11:21:35 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=? 117 11:21:35 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 118 11:21:35 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 119 11:21:39 SQL Prepare: ORACLE - SELECT T.YPTJPC,T.YKBMBH,T.TJDWH0,T.SWRQ00,T.TJRQ00, G.ZWXM00,T.BZ0000,T.QRRQ00,T.QRSJ00,T.YYTJRQ,T.YYTJSJ, T.YYSHRQ,T.YYSHSJ,T.QXSHRQ,T.QXSHSJ, (select ZWXM00 from BM_YGBM00 where YGBH00=T.YYSHY0) YYSHY0, (select ZWXM00 from BM_YGBM00 where YGBH00=T.QXSHY0) QXSHY0 FROM YK_YPTJ00 T,BM_YGBM00 G WHERE T.SFQR00='Y' AND T.CZYBH0=G.YGBH00(+) AND T.QRRQ00>='20140515' AND T.QRRQ00<='20140515' AND T.QRRQ00||T.QRSJ00>='2014051508:00:00' AND T.QRRQ00||T.QRSJ00<='2014051517:00:00' AND T.YKBMBH='12' ORDER BY T.YPTJPC 120 11:21:39 SQL Execute: ORACLE - SELECT T.YPTJPC,T.YKBMBH,T.TJDWH0,T.SWRQ00,T.TJRQ00, G.ZWXM00,T.BZ0000,T.QRRQ00,T.QRSJ00,T.YYTJRQ,T.YYTJSJ, T.YYSHRQ,T.YYSHSJ,T.QXSHRQ,T.QXSHSJ, (select ZWXM00 from BM_YGBM00 where YGBH00=T.YYSHY0) YYSHY0, (select ZWXM00 from BM_YGBM00 where YGBH00=T.QXSHY0) QXSHY0 FROM YK_YPTJ00 T,BM_YGBM00 G WHERE T.SFQR00='Y' AND T.CZYBH0=G.YGBH00(+) AND T.QRRQ00>='20140515' AND T.QRRQ00<='20140515' AND T.QRRQ00||T.QRSJ00>='2014051508:00:00' AND T.QRRQ00||T.QRSJ00<='2014051517:00:00' AND T.YKBMBH='12' ORDER BY T.YPTJPC 121 11:21:39 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 122 11:21:39 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=? 123 11:21:39 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 124 11:21:39 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=? 125 11:21:39 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 126 11:21:39 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=? 127 11:21:39 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 128 11:21:39 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 129 11:21:39 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 130 11:21:39 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=? 131 11:21:39 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 132 11:21:39 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=? 133 11:21:39 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 134 11:21:39 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=? 135 11:21:39 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 136 11:21:39 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 137 11:21:58 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 138 11:21:58 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=? 139 11:21:58 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 140 11:21:58 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 141 11:21:58 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 142 11:21:58 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=? 143 11:21:58 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 144 11:21:58 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 145 11:22:30 SQL Prepare: ORACLE - select '0' CHECK0,A.*,B.YPJCL0,B.YPBM00, (select d.SCCJZW from BM_YPSCCJ d where b.SCCJBH=d.SCCJBH) SCCJ00, (select c.GHDWMC from BM_YPGHDW c where b.GHDWNM=c.GHDWNM) GHDWMC,B.YPMLBZ from YK_YPTJMX A,BM_YD0000 B WHERE A.YPNM00=B.YPNM00 AND A.YPTJPC='' AND A.YXBMBH=12 order by A.TJMXPC 146 11:22:30 SQL Execute: ORACLE - select '0' CHECK0,A.*,B.YPJCL0,B.YPBM00, (select d.SCCJZW from BM_YPSCCJ d where b.SCCJBH=d.SCCJBH) SCCJ00, (select c.GHDWMC from BM_YPGHDW c where b.GHDWNM=c.GHDWNM) GHDWMC,B.YPMLBZ from YK_YPTJMX A,BM_YD0000 B WHERE A.YPNM00=B.YPNM00 AND A.YPTJPC='' AND A.YXBMBH=12 order by A.TJMXPC 147 11:23:04 SQL Prepare: ORACLE - select '0' CHECK0,A.*,B.YPJCL0,B.YPBM00, (select d.SCCJZW from BM_YPSCCJ d where b.SCCJBH=d.SCCJBH) SCCJ00, (select c.GHDWMC from BM_YPGHDW c where b.GHDWNM=c.GHDWNM) GHDWMC,B.YPMLBZ from YK_YPTJMX A,BM_YD0000 B WHERE A.YPNM00=B.YPNM00 AND A.YPTJPC='' AND A.YXBMBH=12 order by A.TJMXPC 148 11:23:04 SQL Execute: ORACLE - select '0' CHECK0,A.*,B.YPJCL0,B.YPBM00, (select d.SCCJZW from BM_YPSCCJ d where b.SCCJBH=d.SCCJBH) SCCJ00, (select c.GHDWMC from BM_YPGHDW c where b.GHDWNM=c.GHDWNM) GHDWMC,B.YPMLBZ from YK_YPTJMX A,BM_YD0000 B WHERE A.YPNM00=B.YPNM00 AND A.YPTJPC='' AND A.YXBMBH=12 order by A.TJMXPC 149 11:23:06 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like :1) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 150 11:23:06 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like ?) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 151 11:23:07 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like :1) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 152 11:23:07 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like ?) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 153 11:23:08 SQL Prepare: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like :1) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10 154 11:23:08 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,KCDW00,K2J000,LSJ000,Z2J000,M2J000,GJJ000,KCSL00,YPJCL0,KC0000,PFJ000,SPM000,SCCJ00,GHDWMC,ZFZGDJ,YPMLBZ from VW_YK_YXYPXX where (PYSM00 Like ?) and( YKBMBH=12 ) Order By PYSM00) where Rownum<=10