1 15:21:08 Log started for: 易联众医院信息综合管理平台 2 15:21:08 SQL Execute: ORACLE - Select * from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 3 15:21:08 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,BZ0000) select '192.168.202.163','99',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 15:21:08 SQL Data In: ORACLE - Rows affected = 1 5 15:21:08 SQL Execute: ORACLE - Commit 6 15:21:08 SQL Data In: ORACLE - Rows affected = 0 7 15:21:08 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 8 15:21:08 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='300199' and CZBZ00 in ('0','1') 9 15:21:08 SQL Execute: ORACLE - select count(*) COUNT0 from XT_XTYCRZ where XKH000 = '300199' and YCLBBZ ='0' and CLBZ00 = '0' 10 15:21:08 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_YHMMZDCSCS' 11 15:21:08 SQL Execute: ORACLE - select distinct XTDM00,XTMC00,XTBMXZ,DLFS00,TPSYH0,BJTP00,XTBB00,BBXH00 from VW_XT_YHBMQX_EXT where YGBH00=1305 and XTDM00 not in ('OE','MC') order by XTDM00 12 15:21:08 SQL Execute: ORACLE - Select SYSDATE from Dual 13 15:21:08 SQL Execute: ORACLE - Select SYSDATE from Dual 14 15:21:08 SQL Execute: ORACLE - select XKH000,ZWXM00,BMBH00,BMMC00,BMYYID,BMYYMC,YBYGDM,YBYGDM_EX from VW_BM_YGBM00_EXT where YGBH00= 1305 15 15:21:08 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where YGBH00 = 1305 16 15:21:08 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where DECODE(SYXT00,NULL,'-1',SYXT00) in ('999','-1') 17 15:21:08 SQL Execute: ORACLE - select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 18 15:21:08 SQL Execute: ORACLE - select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 19 15:21:08 SQL Execute: ORACLE - select SJKYH0,DBBB00 from XT_DBMS00 where upper(SJKYH0) = upper('sd_hospital') 20 15:21:08 SQL Execute: ORACLE - select INSTANCE_NAME,HOST_NAME from V$INSTANCE 21 15:21:08 SQL Execute: ORACLE - select ZBDM00 from XT_YHZB00 where YGBH00 = 1305 22 15:21:08 SQL Execute: ORACLE - select YGBH00,YGXKH0,YGXM00,JSID00,JSMC00,JSDESC,JSLX00 from VW_PT_YGJSB0 where YGBH00 = 1305 23 15:21:08 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000= '192.168.202.163' 24 15:21:08 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_MMQDYZTSDJ' 25 15:21:08 SQL Execute: ORACLE - select YGBH00,XKH000,ZWXM00,XTDM00,XTMC00,DLKS00,BMMC00,DLRQSJ from VW_XT_XTDLRZ where YGBH00 = 1305 and RowNum <= 10 order by DLRQSJ DESC 26 15:21:08 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 1305 and XTDM00='2' order by BMPLXH,BMBH00 27 15:21:10 SQL Execute: ORACLE - select MKNBMC from VW_XT_XTKJMK where XTDM00='2' and KJLB00 ='3' 28 15:21:10 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKWBJC,KJLB00,KJJ000,XH0000,TBSYH0,KJQDFS from VW_XT_XTKJMK where XTDM00 = '2' and KJLB00 < '3' order by XH0000 29 15:21:10 SQL Execute: ORACLE - select * from XT_XTCS00 where instr(','||SYXT00||',',','||'2'||',')>0 30 15:21:10 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKDLL0,TBSYH0 from VW_PT_YHGNMK where YGBH00 = 1305 and XTDM00 = '2' 31 15:21:10 SQL Execute: ORACLE - select XTDM00,JHGNID,RQLMC0,KJNAME,KJLMC0,KJMS00,MKNBMC,MKDLL0 from VW_XT_XTGNKJ where XTDM00 = '2' 32 15:21:10 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 495 and FLAG00 like '0' order by decode(CKBH00,862,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 33 15:21:10 SQL Execute: ORACLE - select * from XT_XTLJ00 where (SID000,SERIAL) in (select to_char(SID),to_char(serial#) from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)) 34 15:21:10 SQL Execute: ORACLE - update XT_XTLJ00 set XTDM00='2' where (SID000,SERIAL) in (select to_char(SID),to_char(serial#) from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)) 35 15:21:10 SQL Data In: ORACLE - Rows affected = 1 36 15:21:10 SQL Execute: ORACLE - Commit 37 15:21:10 SQL Data In: ORACLE - Rows affected = 0 38 15:21:10 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 39 15:21:10 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 to_char(SID),to_char(SERIAL#) from V$session where AUDSID= userenv('SESSIONID')) 40 15:21:10 SQL Execute: ORACLE - insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00,IP0000) values(4095073,1305,'MZYF-202-163','2',nvl('19387802',' '),'192.168.30.11#4127:52575@PrjLIS_ZZQD.exe+检验自助取单',495,'192.168.202.163') 41 15:21:10 SQL Data In: ORACLE - Rows affected = 1 42 15:21:10 SQL Execute: ORACLE - Commit 43 15:21:10 SQL Data In: ORACLE - Rows affected = 0 44 15:21:10 SQL Execute: ORACLE - select count(*) from VW_XT_YHKJMK where YGBH00=1305 and XTDM00='2' 45 15:21:10 SQL Execute: ORACLE - select * from XT_BJCS00 where IP0000 = '192.168.202.163' and NAME00 = 'QDXTJZ' 46 15:21:10 SQL Execute: ORACLE - select JGID00,MKNBMC,MKWBMC,XTDM00,MKDLL0,JGLB00,FJGID0,XH0000,MKFGF0,XSLB00,TBSYH0 from ( select a.JGID00,a.MKNBMC,a.MKWBMC,a.XTDM00,a.MKDLL0,a.JGLB00,a.FJGID0,a.XH0000,a.MKFGF0,a.XSLB00, -1 as TBSYH0 from XT_MKJG00 a where a.JGLB00+0 =0 and a.XTDM00 = '2' union all select a.JGID00,a.MKNBMC,a.MKWBMC,a.XTDM00,a.MKDLL0,a.JGLB00,a.FJGID0,a.XH0000,a.MKFGF0,a.XSLB00,a.TBSYH0 from VW_PT_YHCDMK_JG a where YGBH00 = 1305 and XTDM00 = '2') c order by c.XH0000,c.JGLB00,c.FJGID0,c.JGID00 47 15:21:10 SQL Execute: ORACLE - select MKNBMC,MKWBMC,XTDM00,MKDLL0,TBSYH0 from VW_PT_YHCDMK where YGBH00 = 1305 and XTDM00= '+' and MKDLL0 in ('DLL_GGMK_ZHYW.dll','DLL_GGMK_CXTJ.dll') 48 15:21:10 SQL Execute: ORACLE - select KJID00,YGBH00,XTDM00,MKNBMC,MKWBMC,MKDLL0,XH0000,TBSYH0 from VW_XT_YHKJMK where YGBH00=1305 and XTDM00='2' order by XH0000 49 15:21:10 SQL Misc: ORACLE - Set stored procedure on or off 50 15:21:10 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1305.000000 51 15:21:10 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 52 15:21:10 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 53 15:21:10 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 54 15:21:10 SQL Misc: ORACLE - Set stored procedure on or off 55 15:21:10 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1305.000000 56 15:21:10 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 57 15:21:10 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21252242.000000 58 15:21:10 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 59 15:21:10 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1305 and CZXH00 = 21252242.00) 60 15:21:12 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 61 15:21:12 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 62 15:21:12 SQL Execute: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=495 63 15:21:12 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=495 64 15:21:12 SQL Execute: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='220035' 65 15:21:12 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL 66 15:21:12 SQL Execute: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual 67 15:21:12 SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(495) as SFBZDJ from dual 68 15:21:12 SQL Execute: ORACLE - select * from VW_XT_BGSZJY where MKDLL0 = 'DLL_YF_ZHYW.dll' and YGBH00 = 1305 69 15:21:12 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 in ('YF_CFMXJE_SRWS','YF_YZMXJE_SRWS','YF_CFZJE_SRWS','YF_CFMXJE_CZFS','YF_YZMXJE_CZFS','YF_MZCFSFTD','YF_SFXSGJJ','YK_RCKTJDDYHS','YF_SFDLSJGL','YF_LYDQBKGS','YF_ZJKFDDDYGS','YF_LYDSFFR3DY','YF_ZYCFFYSFCYSFYZ') 70 15:21:12 SQL Execute: ORACLE - select * from BM_YPLB00 71 15:21:12 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=1305 72 15:21:12 SQL Execute: ORACLE - SELECT SFXMMC FROM BM_YPLB00 where LBBH00='3' 73 15:21:12 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 = '审方退回原因' and LBBZ00='0' order by XSXH00 74 15:21:12 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 = '代煎标签药品名称' and LBBZ00='0' order by XSXH00 75 15:21:12 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 = '住院片剂包药机编号名称' and LBBZ00='0' order by XSXH00 76 15:21:12 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '福建预交金统一平台' and BH0000 = 'Open_MZ' 77 15:21:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 78 15:21:13 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220315 79 15:21:13 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220315 80 15:21:13 SQL Execute: ORACLE - select * from (SELECT 'N' XZ0000,R.CKDH00,Y.ZWXM00,R.QRRQ00||R.QRSJ00 QRRQSJ,R.CKBMBH, (select BMMC00 from VW_YF_YPCKFX where R.CKBMBH=BMBH00) BMMC00, (SELECT L.ZWXM00 FROM BM_YGBM00 L WHERE R.LYR000=L.YGBH00) LYR000, (SELECT I.ZWXM00 FROM BM_YGBM00 I WHERE R.JYR000=I.YGBH00) JYR000, (SELECT I.ZWXM00 FROM BM_YGBM00 I WHERE R.QRR000=I.YGBH00) QRRXM0, R.JYSFYK,R.YFBMBH FROM YF_YPCKD0 R,BM_YGBM00 Y WHERE R.YFBMBH=? AND R.QRRQ00 between ? and ? AND R.CKZT00='1' AND R.CKLXBH='08' AND R.JYSFGH='N' AND R.CZY000=Y.YGBH00(+) ) order by QRRQSJ 81 15:21:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 82 15:21:13 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 83 15:21:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 84 15:21:13 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 85 15:21:13 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '取药队列字典' and BH0000 = 'DSFBYJK_ZY' 86 15:21:13 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1305,'柯珊','192.168.202.163','00-23-24-D4-04-01','2','ACT_YF_JYGH','19387802') 87 15:21:13 SQL Data In: ORACLE - Rows affected = 1 88 15:21:13 SQL Execute: ORACLE - Commit 89 15:21:13 SQL Data In: ORACLE - Rows affected = 0 90 15:21:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 91 15:21:16 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 92 15:21:51 SQL Execute: ORACLE - Select YGBH00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='310366' and CZBZ00<>'2' and BMBH00 in (495,794) 93 15:21:51 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 94 15:21:51 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='310366' and CZBZ00 in ('0','1') 95 15:21:51 SQL Execute: ORACLE - SELECT SF_YK_GETLSH('YFYPRKDH') RKDH00 FROM DUAL 96 15:21:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 178470 97 15:21:51 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 98 15:21:51 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 505 99 15:21:51 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 11 100 15:21:51 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 101 15:21:51 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1305.000000 102 15:21:51 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 103 15:21:51 SQL Execute: ORACLE - INSERT INTO YF_YPRKD0 (RKDH00,YFBMBH,RKBMBH,RKLXBH,RKZT00,CZY000,RKRQ00,RKSJ00,YPQLDH) VALUES(?,?,?,?,?,?, TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS'),?) 104 15:21:51 SQL Data In: ORACLE - Rows affected = 1 105 15:21:51 SQL Execute: ORACLE - INSERT INTO YF_YPRKMX (YPRKPC, RKDH00, YPNM00, YPMC00, YPGG00, RKSL00, RKDW00, ZHL000,GJDJ00,LSDJ00,SCPH00,YPSXRQ,YKRKPC) SELECT SQ_YF_YPRKMX_YPRKPC.NEXTVAL,'178470',YPNM00,YPMC00,YPGG00, jysysl,CKDW00,ZHL000,GJDJ00,LSDJ00,SCPH00,YPSXRQ,YKRKPC FROM YF_YPCKMX WHERE CKDH00='1136925' and jysysl>0 106 15:21:51 SQL Data In: ORACLE - Rows affected = 1 107 15:21:51 SQL Execute: ORACLE - update YF_YPCKD0 set JYSFGH='Y',HYRQ00=to_char(sysdate,'YYYYMMDD'), HYSJ00=to_char(sysdate,'HH24:MI:SS') ,HYR000='1624' where CKDH00='1136925' 108 15:21:51 SQL Data In: ORACLE - Rows affected = 1 109 15:21:51 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 110 15:21:51 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 111 15:21:51 SQL Misc: ORACLE - Set stored procedure on or off 112 15:21:51 SQL Data In: ORACLE - Param = 1, Name = PRKDH00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 178470 113 15:21:51 SQL Data In: ORACLE - Param = 2, Name = PQRRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220315 114 15:21:51 SQL Data In: ORACLE - Param = 3, Name = PQRSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:21:51 115 15:21:51 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1305 116 15:21:51 SQL Data In: ORACLE - Param = 5, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 495 117 15:21:51 SQL Data In: ORACLE - Param = 6, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 118 15:21:51 SQL Data In: ORACLE - Param = 7, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 119 15:21:51 SQL Data In: ORACLE - Param = 8, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 120 15:21:51 SQL Data In: ORACLE - Param = 9, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 121 15:21:51 SQL Execute: ORACLE - BEGIN "SP_YF_YPRKD0_AUDIT" (PRKDH00 => :PRKDH00,PQRRQ00 => :PQRRQ00,PQRSJ00 => :PQRSJ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 122 15:21:51 SQL Misc: ORACLE - Set stored procedure on or off 123 15:21:51 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 124 15:21:51 SQL Data In: ORACLE - Param = 2, Name = PDJLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 125 15:21:51 SQL Data In: ORACLE - Param = 3, Name = PLYDJH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13936725 126 15:21:51 SQL Data In: ORACLE - Param = 4, Name = PYFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 127 15:21:51 SQL Data In: ORACLE - Param = 5, Name = PKSBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 505.000000 128 15:21:51 SQL Data In: ORACLE - Param = 6, Name = PYPNM00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7748.000000 129 15:21:51 SQL Data In: ORACLE - Param = 7, Name = PCKSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 130 15:21:51 SQL Data In: ORACLE - Param = 8, Name = PCFDW00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 盒 131 15:21:51 SQL Data In: ORACLE - Param = 9, Name = PZHL000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.600000 132 15:21:51 SQL Data In: ORACLE - Param = 10, Name = PLSDJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.130000 133 15:21:51 SQL Data In: ORACLE - Param = 11, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1305 134 15:21:51 SQL Data In: ORACLE - Param = 12, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 495 135 15:21:51 SQL Data In: ORACLE - Param = 13, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 136 15:21:51 SQL Data In: ORACLE - Param = 14, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 137 15:21:51 SQL Data In: ORACLE - Param = 15, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 138 15:21:51 SQL Data In: ORACLE - Param = 16, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 139 15:21:51 SQL Execute: ORACLE - BEGIN "SP_YF_KSJYMX" (POPFLAG => :POPFLAG,PDJLX00 => :PDJLX00,PLYDJH0 => :PLYDJH0,PYFBMBH => :PYFBMBH,PKSBMBH => :PKSBMBH,PYPNM00 => :PYPNM00,PCKSL00 => :PCKSL00,PCFDW00 => :PCFDW00,PZHL000 => :PZHL000,PLSDJ00 => :PLSDJ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 140 15:21:51 SQL Execute: ORACLE - RollBack 141 15:21:51 SQL Data In: ORACLE - Rows affected = 0 142 15:21:51 SQL Execute: ORACLE - Commit 143 15:21:51 SQL Data In: ORACLE - Rows affected = 0 144 15:21:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 145 15:21:56 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 146 15:21:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1137097 147 15:21:59 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 148 15:22:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 149 15:22:09 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 150 15:22:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 151 15:22:09 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 152 15:22:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 153 15:22:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220301 154 15:22:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220315 155 15:22:10 SQL Execute: ORACLE - select * from (SELECT 'N' XZ0000,R.CKDH00,Y.ZWXM00,R.QRRQ00||R.QRSJ00 QRRQSJ,R.CKBMBH, (select BMMC00 from VW_YF_YPCKFX where R.CKBMBH=BMBH00) BMMC00, (SELECT L.ZWXM00 FROM BM_YGBM00 L WHERE R.LYR000=L.YGBH00) LYR000, (SELECT I.ZWXM00 FROM BM_YGBM00 I WHERE R.JYR000=I.YGBH00) JYR000, (SELECT I.ZWXM00 FROM BM_YGBM00 I WHERE R.QRR000=I.YGBH00) QRRXM0, R.JYSFYK,R.YFBMBH FROM YF_YPCKD0 R,BM_YGBM00 Y WHERE R.YFBMBH=? AND R.QRRQ00 between ? and ? AND R.CKZT00='1' AND R.CKLXBH='08' AND R.JYSFGH='N' AND R.CZY000=Y.YGBH00(+) ) order by QRRQSJ 156 15:22:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132206 157 15:22:10 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 158 15:22:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132206 159 15:22:10 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 160 15:22:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132206 161 15:22:10 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 162 15:22:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132206 163 15:22:10 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 164 15:22:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133380 165 15:22:12 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 166 15:22:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133099 167 15:22:12 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 168 15:22:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132977 169 15:22:12 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 170 15:22:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132846 171 15:22:12 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 172 15:22:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132371 173 15:22:12 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 174 15:22:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132206 175 15:22:12 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 176 15:22:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132206 177 15:22:12 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 178 15:22:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132371 179 15:22:13 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 180 15:22:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132846 181 15:22:13 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 182 15:22:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132977 183 15:22:13 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 184 15:22:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133099 185 15:22:13 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 186 15:22:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133380 187 15:22:13 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 188 15:22:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133937 189 15:22:13 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 190 15:22:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 191 15:22:13 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 192 15:22:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1135243 193 15:22:13 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 194 15:22:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136716 195 15:22:13 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 196 15:22:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136760 197 15:22:13 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 198 15:22:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 199 15:22:13 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 200 15:22:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1137097 201 15:22:14 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 202 15:22:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1137097 203 15:22:14 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 204 15:22:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 205 15:22:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220201 206 15:22:18 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220315 207 15:22:18 SQL Execute: ORACLE - select * from (SELECT 'N' XZ0000,R.CKDH00,Y.ZWXM00,R.QRRQ00||R.QRSJ00 QRRQSJ,R.CKBMBH, (select BMMC00 from VW_YF_YPCKFX where R.CKBMBH=BMBH00) BMMC00, (SELECT L.ZWXM00 FROM BM_YGBM00 L WHERE R.LYR000=L.YGBH00) LYR000, (SELECT I.ZWXM00 FROM BM_YGBM00 I WHERE R.JYR000=I.YGBH00) JYR000, (SELECT I.ZWXM00 FROM BM_YGBM00 I WHERE R.QRR000=I.YGBH00) QRRXM0, R.JYSFYK,R.YFBMBH FROM YF_YPCKD0 R,BM_YGBM00 Y WHERE R.YFBMBH=? AND R.QRRQ00 between ? and ? AND R.CKZT00='1' AND R.CKLXBH='08' AND R.JYSFGH='N' AND R.CZY000=Y.YGBH00(+) ) order by QRRQSJ 208 15:22:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126062 209 15:22:18 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 210 15:22:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126062 211 15:22:18 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 212 15:22:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126062 213 15:22:18 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 214 15:22:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126062 215 15:22:18 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 216 15:22:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132206 217 15:22:18 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 218 15:22:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130084 219 15:22:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 220 15:22:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132206 221 15:22:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 222 15:22:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132371 223 15:22:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 224 15:22:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132846 225 15:22:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 226 15:22:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132977 227 15:22:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 228 15:22:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133099 229 15:22:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 230 15:22:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133380 231 15:22:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 232 15:22:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133937 233 15:22:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 234 15:22:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 235 15:22:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 236 15:22:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1135243 237 15:22:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 238 15:22:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136716 239 15:22:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 240 15:22:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136760 241 15:22:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 242 15:22:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 243 15:22:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 244 15:22:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1137097 245 15:22:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 246 15:22:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1137097 247 15:22:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 248 15:22:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 249 15:22:21 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 250 15:22:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136760 251 15:22:21 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 252 15:22:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136716 253 15:22:21 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 254 15:22:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1135243 255 15:22:21 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 256 15:22:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 257 15:22:21 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 258 15:22:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133937 259 15:22:21 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 260 15:22:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133380 261 15:22:21 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 262 15:22:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133099 263 15:22:21 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 264 15:22:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132977 265 15:22:21 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 266 15:22:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132846 267 15:22:21 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 268 15:22:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132371 269 15:22:21 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 270 15:22:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132206 271 15:22:22 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 272 15:22:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130084 273 15:22:22 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 274 15:22:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130016 275 15:22:22 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 276 15:22:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130010 277 15:22:22 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 278 15:22:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1129904 279 15:22:23 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 280 15:22:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1129560 281 15:22:23 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 282 15:22:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1128908 283 15:22:23 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 284 15:22:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1128442 285 15:22:23 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 286 15:22:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1127406 287 15:22:23 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 288 15:22:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1127066 289 15:22:23 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 290 15:22:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126392 291 15:22:23 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 292 15:22:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126269 293 15:22:24 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 294 15:22:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126062 295 15:22:24 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 296 15:22:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126062 297 15:22:24 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 298 15:22:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 299 15:22:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220101 300 15:22:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220315 301 15:22:30 SQL Execute: ORACLE - select * from (SELECT 'N' XZ0000,R.CKDH00,Y.ZWXM00,R.QRRQ00||R.QRSJ00 QRRQSJ,R.CKBMBH, (select BMMC00 from VW_YF_YPCKFX where R.CKBMBH=BMBH00) BMMC00, (SELECT L.ZWXM00 FROM BM_YGBM00 L WHERE R.LYR000=L.YGBH00) LYR000, (SELECT I.ZWXM00 FROM BM_YGBM00 I WHERE R.JYR000=I.YGBH00) JYR000, (SELECT I.ZWXM00 FROM BM_YGBM00 I WHERE R.QRR000=I.YGBH00) QRRXM0, R.JYSFYK,R.YFBMBH FROM YF_YPCKD0 R,BM_YGBM00 Y WHERE R.YFBMBH=? AND R.QRRQ00 between ? and ? AND R.CKZT00='1' AND R.CKLXBH='08' AND R.JYSFGH='N' AND R.CZY000=Y.YGBH00(+) ) order by QRRQSJ 302 15:22:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1116156 303 15:22:30 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 304 15:22:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1116156 305 15:22:30 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 306 15:22:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1116156 307 15:22:30 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 308 15:22:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1116156 309 15:22:30 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 310 15:22:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1116156 311 15:22:30 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 312 15:22:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1117000 313 15:22:32 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 314 15:22:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1117357 315 15:22:32 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 316 15:22:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1119294 317 15:22:32 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 318 15:22:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1119891 319 15:22:32 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 320 15:22:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1120467 321 15:22:32 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 322 15:22:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1121396 323 15:22:33 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 324 15:22:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1121646 325 15:22:33 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 326 15:22:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1122467 327 15:22:33 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 328 15:22:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1122971 329 15:22:33 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 330 15:22:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123281 331 15:22:33 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 332 15:22:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1122971 333 15:22:34 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 334 15:22:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1122467 335 15:22:34 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 336 15:22:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1122467 337 15:22:41 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 338 15:22:53 SQL Execute: ORACLE - Select YGBH00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='310366' and CZBZ00<>'2' and BMBH00 in (495,794) 339 15:22:53 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 340 15:22:53 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='310366' and CZBZ00 in ('0','1') 341 15:22:53 SQL Execute: ORACLE - SELECT SF_YK_GETLSH('YFYPRKDH') RKDH00 FROM DUAL 342 15:22:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 178471 343 15:22:53 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 344 15:22:53 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 514 345 15:22:53 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 11 346 15:22:53 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 347 15:22:53 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1305.000000 348 15:22:53 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1122467 349 15:22:53 SQL Execute: ORACLE - INSERT INTO YF_YPRKD0 (RKDH00,YFBMBH,RKBMBH,RKLXBH,RKZT00,CZY000,RKRQ00,RKSJ00,YPQLDH) VALUES(?,?,?,?,?,?, TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS'),?) 350 15:22:53 SQL Data In: ORACLE - Rows affected = 1 351 15:22:53 SQL Execute: ORACLE - INSERT INTO YF_YPRKMX (YPRKPC, RKDH00, YPNM00, YPMC00, YPGG00, RKSL00, RKDW00, ZHL000,GJDJ00,LSDJ00,SCPH00,YPSXRQ,YKRKPC) SELECT SQ_YF_YPRKMX_YPRKPC.NEXTVAL,'178471',YPNM00,YPMC00,YPGG00, jysysl,CKDW00,ZHL000,GJDJ00,LSDJ00,SCPH00,YPSXRQ,YKRKPC FROM YF_YPCKMX WHERE CKDH00='1122467' and jysysl>0 352 15:22:53 SQL Data In: ORACLE - Rows affected = 1 353 15:22:53 SQL Execute: ORACLE - update YF_YPCKD0 set JYSFGH='Y',HYRQ00=to_char(sysdate,'YYYYMMDD'), HYSJ00=to_char(sysdate,'HH24:MI:SS') ,HYR000='1624' where CKDH00='1122467' 354 15:22:53 SQL Data In: ORACLE - Rows affected = 1 355 15:22:53 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 356 15:22:53 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 357 15:22:53 SQL Misc: ORACLE - Set stored procedure on or off 358 15:22:53 SQL Data In: ORACLE - Param = 1, Name = PRKDH00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 178471 359 15:22:53 SQL Data In: ORACLE - Param = 2, Name = PQRRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220315 360 15:22:53 SQL Data In: ORACLE - Param = 3, Name = PQRSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:22:53 361 15:22:53 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1305 362 15:22:53 SQL Data In: ORACLE - Param = 5, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 495 363 15:22:53 SQL Data In: ORACLE - Param = 6, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 364 15:22:53 SQL Data In: ORACLE - Param = 7, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 365 15:22:53 SQL Data In: ORACLE - Param = 8, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 366 15:22:53 SQL Data In: ORACLE - Param = 9, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 367 15:22:53 SQL Execute: ORACLE - BEGIN "SP_YF_YPRKD0_AUDIT" (PRKDH00 => :PRKDH00,PQRRQ00 => :PQRRQ00,PQRSJ00 => :PQRSJ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 368 15:22:53 SQL Misc: ORACLE - Set stored procedure on or off 369 15:22:53 SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 370 15:22:53 SQL Data In: ORACLE - Param = 2, Name = PDJLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 371 15:22:53 SQL Data In: ORACLE - Param = 3, Name = PLYDJH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13609946 372 15:22:53 SQL Data In: ORACLE - Param = 4, Name = PYFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 373 15:22:53 SQL Data In: ORACLE - Param = 5, Name = PKSBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 514.000000 374 15:22:53 SQL Data In: ORACLE - Param = 6, Name = PYPNM00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7628.000000 375 15:22:53 SQL Data In: ORACLE - Param = 7, Name = PCKSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 376 15:22:53 SQL Data In: ORACLE - Param = 8, Name = PCFDW00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 盒 377 15:22:53 SQL Data In: ORACLE - Param = 9, Name = PZHL000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.900000 378 15:22:53 SQL Data In: ORACLE - Param = 10, Name = PLSDJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 23.620000 379 15:22:53 SQL Data In: ORACLE - Param = 11, Name = PCZY000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1305 380 15:22:53 SQL Data In: ORACLE - Param = 12, Name = PCZYKS0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 495 381 15:22:53 SQL Data In: ORACLE - Param = 13, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 382 15:22:53 SQL Data In: ORACLE - Param = 14, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 383 15:22:53 SQL Data In: ORACLE - Param = 15, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 384 15:22:53 SQL Data In: ORACLE - Param = 16, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 385 15:22:53 SQL Execute: ORACLE - BEGIN "SP_YF_KSJYMX" (POPFLAG => :POPFLAG,PDJLX00 => :PDJLX00,PLYDJH0 => :PLYDJH0,PYFBMBH => :PYFBMBH,PKSBMBH => :PKSBMBH,PYPNM00 => :PYPNM00,PCKSL00 => :PCKSL00,PCFDW00 => :PCFDW00,PZHL000 => :PZHL000,PLSDJ00 => :PLSDJ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 386 15:22:53 SQL Execute: ORACLE - RollBack 387 15:22:53 SQL Data In: ORACLE - Rows affected = 0 388 15:22:53 SQL Execute: ORACLE - Commit 389 15:22:53 SQL Data In: ORACLE - Rows affected = 0 390 15:23:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1122467 391 15:23:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 392 15:23:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1122467 393 15:23:25 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 394 15:23:43 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 395 15:23:43 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='2' 396 15:23:43 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 397 15:23:43 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 398 15:23:43 SQL Execute: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=495 399 15:23:43 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=495 400 15:23:43 SQL Execute: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='220035' 401 15:23:43 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL 402 15:23:43 SQL Execute: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual 403 15:23:43 SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(495) as SFBZDJ from dual 404 15:23:43 SQL Execute: ORACLE - select * from VW_XT_BGSZJY where MKDLL0 = 'DLL_YF_CXTJ.dll' and YGBH00 = 1305 405 15:23:43 SQL Execute: ORACLE - select * from XT_BGSZMX where BGSZID = 1142.00 order by CLINDX,MXID00 406 15:23:43 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00 in ('YF_CFMXJE_SRWS','YF_YZMXJE_SRWS','YF_CFZJE_SRWS','YF_CFMXJE_CZFS','YF_YZMXJE_CZFS','YF_MZCFSFTD','YF_SFXSGJJ','YK_RCKTJDDYHS','YF_SFDLSJGL','YF_LYDQBKGS','YF_ZJKFDDDYGS','YF_LYDSFFR3DY','YF_ZYCFFYSFCYSFYZ') 407 15:23:43 SQL Execute: ORACLE - select * from BM_YPLB00 408 15:23:43 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=1305 409 15:23:43 SQL Execute: ORACLE - SELECT SFXMMC FROM BM_YPLB00 where LBBH00='3' 410 15:23:43 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 = '审方退回原因' and LBBZ00='0' order by XSXH00 411 15:23:43 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 = '代煎标签药品名称' and LBBZ00='0' order by XSXH00 412 15:23:43 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 = '住院片剂包药机编号名称' and LBBZ00='0' order by XSXH00 413 15:23:43 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '福建预交金统一平台' and BH0000 = 'Open_MZ' 414 15:23:43 SQL Execute: ORACLE - SELECT * FROM BM_YFRKLX 415 15:23:43 SQL Execute: ORACLE - SELECT BMBH00,BMMC00 FROM VW_YF_YPGHDW A 416 15:23:43 SQL Execute: ORACLE - SELECT LBBH00,LBMC00 FROM BM_YPLB00 ORDER BY LBBH00 417 15:23:43 SQL Execute: ORACLE - select a.YLBH00,a.LBBH00,a.YLMC00 from Bm_YPYL00 a where a.SJYLBH='##' and exists (select 1 from YF_YPKCXX b,BM_YD0000 c where c.LBBH00=a.LBBH00 and b.YPNM00=c.YPNM00 and b.YFBMBH=495) order by a.LBBH00 418 15:23:43 SQL Execute: ORACLE - select LBBH00, LEVEL, a.FLBBH0, a.YPFLBH, a.YPFLMC, a.YPNM00, a.PYSM00, a.FLAG00,a.WZSX00 from VW_BM_YPFLTREEVIEW a where a.FLAG00 <= 0 connect by a.FLBBH0 = Prior a.YPFLBH start with a.YPFLBH in ('A','B') order by LEVEL,FLBBH0,YPFLBH 419 15:23:43 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1305,'柯珊','192.168.202.163','00-23-24-D4-04-01','2','ACT_YF_RKMXCX','19387802') 420 15:23:43 SQL Data In: ORACLE - Rows affected = 1 421 15:23:43 SQL Execute: ORACLE - Commit 422 15:23:43 SQL Data In: ORACLE - Rows affected = 0 423 15:23:46 SQL Execute: ORACLE - SELECT decode(a.CRBMBH,66666,a.ZY0000,a.RCLXMC) as RCLXMC,A.YPMC00,A.YPGG00,JZRQ00,JZSJ00,CRBMBH,ZY0000, B.KCDW00 JZDW00,B.K2J000 ZHL000,a.GJDJ00,a.SLDJ00, ROUND(SLSL00*ZHL000/B.K2J000,3) SLSL00,a.GJDJ00 as SLGJDJ, SLJE00,DJH000 AS RKDH00,B.PYSM00,B.YPMLBZ,A.GJSLJE,B.ZBQMC0,decode(B.SF4J70,'1','是','否') SF4J70,decode(nvl(B.TZRQ00,''),'','否','是')SFTY00, (select SCPH00 from YK_YPRKMX where YPRKPC=A.YKRKPC) SCPH00,(select YPSXRQ from YK_YPRKMX where YPRKPC=A.YKRKPC) YPSXRQ, (select YPQLDH from YF_YPRKD0 where RKDH00=A.DJH000 and rownum=1) YPQLDH,(select MC0000 from VW_YK_YDYPXZ where BH0000=b.YPXZ00) YPXZ00, decode(nvl(a.WZSX00,( select nvl(max(WZSX00),'是') from BM_WZQTXX where YPNM00=A.YPNM00)),'3','否','4','否','是') SFSF00 FROM YF_YPMXZ0 A,BM_YD0000 B WHERE A.YPNM00=B.YPNM00 and ( (b.YLBH00 like '%' ) or (''='-1') or (''='WZ') ) and ((b.TYMBH0='ALL' or 'ALL'='ALL') or (''='-1') ) AND YFBMBH+0=495 AND RCLXBH like'%' AND LBBH00 like'%' AND JZRQ00>='20220315' AND JZRQ00<='20220315' AND JZRQ00||JZSJ00>='2022031500:00:00' AND JZRQ00||JZSJ00<='2022031523:59:59' AND JZXZ00='R' AND A.CRBMBH <> 66666 order by b.YLBH00,b.ypbm00 424 15:24:10 SQL Misc: ORACLE - Set stored procedure on or off 425 15:24:10 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1305.000000 426 15:24:10 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 427 15:24:10 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21252243.000000 428 15:24:10 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 429 15:24:10 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1305 and CZXH00 = 21252243.00) 430 15:24:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1122467 431 15:24:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 432 15:24:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123767 433 15:24:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 434 15:24:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123779 435 15:24:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 436 15:24:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123898 437 15:24:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 438 15:24:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126062 439 15:24:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 440 15:24:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126269 441 15:24:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 442 15:24:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126392 443 15:24:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 444 15:24:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1127066 445 15:24:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 446 15:24:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1127406 447 15:24:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 448 15:24:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1128442 449 15:24:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 450 15:24:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1128908 451 15:24:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 452 15:24:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1129560 453 15:24:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 454 15:24:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1129904 455 15:24:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 456 15:24:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130010 457 15:24:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 458 15:24:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130016 459 15:24:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 460 15:24:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130084 461 15:24:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 462 15:24:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132206 463 15:24:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 464 15:24:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132371 465 15:24:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 466 15:24:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132846 467 15:24:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 468 15:24:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132977 469 15:24:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 470 15:24:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133099 471 15:24:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 472 15:24:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133380 473 15:24:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 474 15:24:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133937 475 15:24:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 476 15:24:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 477 15:24:21 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 478 15:24:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1135243 479 15:24:21 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 480 15:24:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136716 481 15:24:21 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 482 15:24:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136760 483 15:24:21 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 484 15:24:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 485 15:24:21 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 486 15:24:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1137097 487 15:24:21 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 488 15:24:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1137097 489 15:24:21 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 490 15:24:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 491 15:24:22 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 492 15:24:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136760 493 15:24:23 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 494 15:24:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136716 495 15:24:23 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 496 15:24:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1135243 497 15:24:23 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 498 15:24:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 499 15:24:23 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 500 15:24:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133937 501 15:24:24 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 502 15:24:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133380 503 15:24:25 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 504 15:24:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133099 505 15:24:25 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 506 15:24:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132977 507 15:24:25 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 508 15:24:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133099 509 15:24:25 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 510 15:24:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133380 511 15:24:26 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 512 15:24:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133937 513 15:24:26 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 514 15:24:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 515 15:24:26 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 516 15:24:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1135243 517 15:24:26 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 518 15:24:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136716 519 15:24:26 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 520 15:24:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136760 521 15:24:26 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 522 15:24:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 523 15:24:26 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 524 15:24:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1137097 525 15:24:26 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 526 15:24:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1137097 527 15:24:26 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 528 15:24:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 529 15:24:27 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 530 15:24:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136760 531 15:24:27 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 532 15:24:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136716 533 15:24:28 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 534 15:24:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136760 535 15:24:28 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 536 15:24:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 537 15:24:28 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 538 15:24:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136760 539 15:24:28 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 540 15:24:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136716 541 15:24:29 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 542 15:24:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1135243 543 15:24:29 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 544 15:24:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 545 15:24:29 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 546 15:24:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133937 547 15:24:29 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 548 15:24:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133380 549 15:24:29 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 550 15:24:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133099 551 15:24:29 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 552 15:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132977 553 15:24:30 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 554 15:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132846 555 15:24:30 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 556 15:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132371 557 15:24:30 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 558 15:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132206 559 15:24:30 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 560 15:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130084 561 15:24:30 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 562 15:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130016 563 15:24:30 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 564 15:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130010 565 15:24:30 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 566 15:24:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1129904 567 15:24:30 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 568 15:24:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1129560 569 15:24:31 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 570 15:24:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1128908 571 15:24:31 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 572 15:24:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1128442 573 15:24:31 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 574 15:24:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1127406 575 15:24:31 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 576 15:24:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1127066 577 15:24:31 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 578 15:24:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126392 579 15:24:31 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 580 15:24:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126269 581 15:24:31 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 582 15:24:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126062 583 15:24:32 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 584 15:24:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123898 585 15:24:32 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 586 15:24:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123779 587 15:24:32 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 588 15:24:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123767 589 15:24:32 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 590 15:24:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123445 591 15:24:32 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 592 15:24:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123281 593 15:24:32 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 594 15:24:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1122971 595 15:24:32 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 596 15:24:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1122467 597 15:24:32 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 598 15:24:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1121646 599 15:24:32 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 600 15:24:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1121396 601 15:24:33 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 602 15:24:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1120467 603 15:24:33 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 604 15:24:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1119891 605 15:24:33 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 606 15:24:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1119294 607 15:24:33 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 608 15:24:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1117357 609 15:24:33 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 610 15:24:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1117000 611 15:24:33 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 612 15:24:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1116939 613 15:24:34 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 614 15:24:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1116156 615 15:24:34 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 616 15:24:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1116156 617 15:24:34 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 618 15:24:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1116939 619 15:24:35 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 620 15:24:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1117000 621 15:24:35 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 622 15:24:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1117357 623 15:24:35 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 624 15:24:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1119294 625 15:24:35 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 626 15:24:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1119891 627 15:24:35 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 628 15:24:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1120467 629 15:24:35 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 630 15:24:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1121396 631 15:24:35 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 632 15:24:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1121646 633 15:24:35 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 634 15:24:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1122467 635 15:24:35 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 636 15:24:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1122971 637 15:24:35 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 638 15:24:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123281 639 15:24:35 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 640 15:24:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123445 641 15:24:36 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 642 15:24:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123767 643 15:24:36 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 644 15:24:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123779 645 15:24:36 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 646 15:24:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123898 647 15:24:36 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 648 15:24:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126062 649 15:24:36 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 650 15:24:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126269 651 15:24:36 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 652 15:24:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126392 653 15:24:37 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 654 15:24:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1127066 655 15:24:37 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 656 15:24:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1127406 657 15:24:37 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 658 15:24:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1128442 659 15:24:37 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 660 15:24:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1128908 661 15:24:37 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 662 15:24:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1129560 663 15:24:37 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 664 15:24:37 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1129904 665 15:24:37 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 666 15:24:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130010 667 15:24:38 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 668 15:24:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130016 669 15:24:38 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 670 15:24:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130084 671 15:24:38 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 672 15:24:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132206 673 15:24:38 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 674 15:24:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132371 675 15:24:38 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 676 15:24:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132846 677 15:24:38 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 678 15:24:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132977 679 15:24:38 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 680 15:24:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133099 681 15:24:38 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 682 15:24:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133380 683 15:24:38 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 684 15:24:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133937 685 15:24:38 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 686 15:24:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 687 15:24:38 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 688 15:24:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1135243 689 15:24:39 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 690 15:24:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136716 691 15:24:39 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 692 15:24:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136760 693 15:24:39 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 694 15:24:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 695 15:24:39 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 696 15:24:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1137097 697 15:24:39 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 698 15:24:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1137097 699 15:24:39 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 700 15:24:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 701 15:24:42 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 702 15:24:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136716 703 15:24:42 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 704 15:24:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 705 15:24:43 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 706 15:24:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136760 707 15:24:44 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 708 15:24:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136716 709 15:24:45 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 710 15:24:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1135243 711 15:24:45 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 712 15:24:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 713 15:24:45 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 714 15:24:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133937 715 15:24:45 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 716 15:24:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133380 717 15:24:45 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 718 15:24:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136716 719 15:24:47 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 720 15:24:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133937 721 15:24:48 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 722 15:24:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133380 723 15:24:50 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 724 15:24:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133099 725 15:24:50 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 726 15:24:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132977 727 15:24:50 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 728 15:24:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132846 729 15:24:50 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 730 15:24:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132371 731 15:24:50 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 732 15:24:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132846 733 15:24:51 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 734 15:24:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132977 735 15:24:51 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 736 15:24:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133099 737 15:24:51 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 738 15:24:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133380 739 15:24:51 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 740 15:24:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133937 741 15:24:51 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 742 15:24:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 743 15:24:51 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 744 15:24:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1135243 745 15:24:52 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 746 15:24:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136716 747 15:24:52 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 748 15:24:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136760 749 15:24:52 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 750 15:24:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 751 15:24:52 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 752 15:24:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1137097 753 15:24:52 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 754 15:24:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 755 15:24:52 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 756 15:24:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136760 757 15:24:52 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 758 15:24:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136716 759 15:24:52 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 760 15:24:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136760 761 15:24:52 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 762 15:24:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 763 15:24:52 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 764 15:24:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136760 765 15:24:58 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 766 15:24:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136716 767 15:24:58 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 768 15:24:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1135243 769 15:24:58 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 770 15:24:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 771 15:24:58 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 772 15:24:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1135243 773 15:24:58 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 774 15:24:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136716 775 15:24:58 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 776 15:24:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136760 777 15:24:58 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 778 15:24:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 779 15:24:58 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 780 15:24:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1137097 781 15:24:58 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 782 15:24:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1137097 783 15:24:59 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 784 15:25:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1128442 785 15:25:01 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 786 15:25:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1128908 787 15:25:01 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 788 15:25:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1129560 789 15:25:01 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 790 15:25:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1129904 791 15:25:02 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 792 15:25:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130010 793 15:25:02 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 794 15:25:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1128908 795 15:25:02 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 796 15:25:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1129560 797 15:25:03 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 798 15:25:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1129904 799 15:25:03 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 800 15:25:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130010 801 15:25:03 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 802 15:25:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130016 803 15:25:03 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 804 15:25:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130084 805 15:25:03 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 806 15:25:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132206 807 15:25:04 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 808 15:25:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132371 809 15:25:04 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 810 15:25:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132846 811 15:25:04 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 812 15:25:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132977 813 15:25:04 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 814 15:25:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133099 815 15:25:04 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 816 15:25:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132977 817 15:25:04 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 818 15:25:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132846 819 15:25:04 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 820 15:25:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132371 821 15:25:04 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 822 15:25:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132206 823 15:25:04 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 824 15:25:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130084 825 15:25:04 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 826 15:25:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130016 827 15:25:04 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 828 15:25:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130010 829 15:25:04 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 830 15:25:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1129904 831 15:25:04 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 832 15:25:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1129560 833 15:25:04 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 834 15:25:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1128908 835 15:25:04 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 836 15:25:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1128442 837 15:25:04 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 838 15:25:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1127406 839 15:25:04 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 840 15:25:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1127066 841 15:25:05 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 842 15:25:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126392 843 15:25:05 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 844 15:25:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126269 845 15:25:05 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 846 15:25:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1128908 847 15:25:06 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 848 15:25:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1128442 849 15:25:07 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 850 15:25:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1127406 851 15:25:07 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 852 15:25:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1127066 853 15:25:07 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 854 15:25:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126392 855 15:25:07 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 856 15:25:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126269 857 15:25:07 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 858 15:25:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126062 859 15:25:07 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 860 15:25:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123898 861 15:25:08 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 862 15:25:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123779 863 15:25:08 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 864 15:25:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123767 865 15:25:08 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 866 15:25:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123445 867 15:25:08 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 868 15:25:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123281 869 15:25:08 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 870 15:25:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1122971 871 15:25:08 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 872 15:25:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1122467 873 15:25:08 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 874 15:25:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1121646 875 15:25:08 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 876 15:25:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1121396 877 15:25:08 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 878 15:25:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1120467 879 15:25:08 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 880 15:25:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1122467 881 15:25:09 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 882 15:25:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1122971 883 15:25:09 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 884 15:25:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123281 885 15:25:09 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 886 15:25:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123445 887 15:25:09 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 888 15:25:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123767 889 15:25:09 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 890 15:25:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123779 891 15:25:09 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 892 15:25:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1123898 893 15:25:09 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 894 15:25:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126062 895 15:25:10 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 896 15:25:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126269 897 15:25:10 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 898 15:25:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1126392 899 15:25:10 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 900 15:25:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1127066 901 15:25:10 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 902 15:25:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1127406 903 15:25:10 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 904 15:25:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1128442 905 15:25:10 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 906 15:25:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1128908 907 15:25:10 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 908 15:25:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1129560 909 15:25:10 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 910 15:25:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1129904 911 15:25:10 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 912 15:25:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130010 913 15:25:10 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 914 15:25:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130016 915 15:25:11 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 916 15:25:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1130084 917 15:25:11 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 918 15:25:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132206 919 15:25:11 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 920 15:25:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132371 921 15:25:11 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 922 15:25:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132846 923 15:25:11 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 924 15:25:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1132977 925 15:25:11 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 926 15:25:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133099 927 15:25:11 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 928 15:25:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133380 929 15:25:11 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 930 15:25:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133937 931 15:25:11 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 932 15:25:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 933 15:25:11 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 934 15:25:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1135243 935 15:25:11 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 936 15:25:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 937 15:25:14 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 938 15:25:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 939 15:25:14 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 940 15:25:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 941 15:25:15 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 942 15:25:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1133099 943 15:25:15 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 944 15:25:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 945 15:25:16 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 946 15:25:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1135243 947 15:25:18 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 948 15:25:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136716 949 15:25:18 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 950 15:25:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136760 951 15:25:18 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 952 15:25:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 953 15:25:18 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 954 15:25:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1137097 955 15:25:18 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 956 15:25:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1136925 957 15:25:19 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 958 15:25:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 959 15:25:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 960 15:25:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1134825 961 15:25:20 SQL Execute: ORACLE - select * from ( select a.*,b.K2J000 from YF_YPCKMX a,BM_YD0000 b WHERE a.CKDH00=? and a.YPNM00=b.YPNM00) ORDER BY YPCKPC 962 15:27:10 SQL Misc: ORACLE - Set stored procedure on or off 963 15:27:10 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1305.000000 964 15:27:10 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 965 15:27:10 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21252402.000000 966 15:27:10 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 967 15:27:10 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1305 and CZXH00 = 21252402.00) 968 15:28:00 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 969 15:28:00 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 970 15:28:00 SQL Execute: ORACLE - select * from XT_XSDBSX where CKMC00='frmYF_SLRKQR' and DBMC00='DBGridEh1' and YGBH00=1305 order by LXH000 971 15:28:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 972 15:28:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220213 973 15:28:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220315 974 15:28:00 SQL Execute: ORACLE - select DISTINCT Q.YPQLDH,B.ZWXM00,Q.QLRQ00,QRRQ00 from YK_YPQLD0 Q,BM_YGBM00 B,YK_YPQLMX X where Q.CKQXBH=? AND Q.QLZT00='1' AND Q.QRRQ00>=? AND Q.QRRQ00<=? AND Q.YPQLDH=X.YPQLDH AND X.CXBZ00='Z' AND Q.CZYBH0=B.YGBH00(+) AND nvl(Q.LYFS00,'0')<>'4' AND Q.CKLXBH<>'25' 975 15:28:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 86314 976 15:28:00 SQL Execute: ORACLE - select b.sccjzw,x.*,(select ypmlbz from bm_yd0000 where ypnm00=x.ypnm00) ypmlbz, decode(sign(x.QLSL00),0,'',x.QLSL00||trim(x.QLDW00))||decode(sign(nvl(x.JLQLSL,0)),0,'',x.JLQLSL||trim(x.JLQLDW)) as QLZSL0, decode(sign(a.CKSL00),0,'',a.CKSL00||trim(a.CKDW00))||decode(sign(nvl(a.JLCKSL,0)),0,'',a.JLCKSL||trim(a.JLCKDW)) as SFZSL0, b.SCCJBH, b.scph00 PH0000, b.ypsxrq, b.scrq00, b.YPRKPC, 0 XGBZ00, a.CKSL00, a.JLCKSL from YK_YPQLMX x,yk_ypckmx a ,yk_yprkmx b WHERE x.YPQLDH=? AND x.CXBZ00='Z' and x.ypqlpc=a.ypqlpc(+) and a.yprkpc=b.yprkpc(+) ORDER BY x.YPQLPC 977 15:28:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 86314 978 15:28:01 SQL Execute: ORACLE - select b.sccjzw,x.*,(select ypmlbz from bm_yd0000 where ypnm00=x.ypnm00) ypmlbz, decode(sign(x.QLSL00),0,'',x.QLSL00||trim(x.QLDW00))||decode(sign(nvl(x.JLQLSL,0)),0,'',x.JLQLSL||trim(x.JLQLDW)) as QLZSL0, decode(sign(a.CKSL00),0,'',a.CKSL00||trim(a.CKDW00))||decode(sign(nvl(a.JLCKSL,0)),0,'',a.JLCKSL||trim(a.JLCKDW)) as SFZSL0, b.SCCJBH, b.scph00 PH0000, b.ypsxrq, b.scrq00, b.YPRKPC, 0 XGBZ00, a.CKSL00, a.JLCKSL from YK_YPQLMX x,yk_ypckmx a ,yk_yprkmx b WHERE x.YPQLDH=? AND x.CXBZ00='Z' and x.ypqlpc=a.ypqlpc(+) and a.yprkpc=b.yprkpc(+) ORDER BY x.YPQLPC 979 15:28:01 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '取药队列字典' and BH0000 = 'DSFBYJK_ZY' 980 15:28:01 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1305,'柯珊','192.168.202.163','00-23-24-D4-04-01','2','ACT_YF_SLRKQR','19387802') 981 15:28:01 SQL Data In: ORACLE - Rows affected = 1 982 15:28:01 SQL Execute: ORACLE - Commit 983 15:28:01 SQL Data In: ORACLE - Rows affected = 0 984 15:28:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 86325 985 15:28:05 SQL Execute: ORACLE - select b.sccjzw,x.*,(select ypmlbz from bm_yd0000 where ypnm00=x.ypnm00) ypmlbz, decode(sign(x.QLSL00),0,'',x.QLSL00||trim(x.QLDW00))||decode(sign(nvl(x.JLQLSL,0)),0,'',x.JLQLSL||trim(x.JLQLDW)) as QLZSL0, decode(sign(a.CKSL00),0,'',a.CKSL00||trim(a.CKDW00))||decode(sign(nvl(a.JLCKSL,0)),0,'',a.JLCKSL||trim(a.JLCKDW)) as SFZSL0, b.SCCJBH, b.scph00 PH0000, b.ypsxrq, b.scrq00, b.YPRKPC, 0 XGBZ00, a.CKSL00, a.JLCKSL from YK_YPQLMX x,yk_ypckmx a ,yk_yprkmx b WHERE x.YPQLDH=? AND x.CXBZ00='Z' and x.ypqlpc=a.ypqlpc(+) and a.yprkpc=b.yprkpc(+) ORDER BY x.YPQLPC 986 15:28:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 86314 987 15:28:21 SQL Execute: ORACLE - select b.sccjzw,x.*,(select ypmlbz from bm_yd0000 where ypnm00=x.ypnm00) ypmlbz, decode(sign(x.QLSL00),0,'',x.QLSL00||trim(x.QLDW00))||decode(sign(nvl(x.JLQLSL,0)),0,'',x.JLQLSL||trim(x.JLQLDW)) as QLZSL0, decode(sign(a.CKSL00),0,'',a.CKSL00||trim(a.CKDW00))||decode(sign(nvl(a.JLCKSL,0)),0,'',a.JLCKSL||trim(a.JLCKDW)) as SFZSL0, b.SCCJBH, b.scph00 PH0000, b.ypsxrq, b.scrq00, b.YPRKPC, 0 XGBZ00, a.CKSL00, a.JLCKSL from YK_YPQLMX x,yk_ypckmx a ,yk_yprkmx b WHERE x.YPQLDH=? AND x.CXBZ00='Z' and x.ypqlpc=a.ypqlpc(+) and a.yprkpc=b.yprkpc(+) ORDER BY x.YPQLPC 988 15:28:24 SQL Execute: ORACLE - select rtrim(xmlagg(xmlparse(content A.YPMC00||'、' wellformed) order by A.YPQLPC).getclobval(), '、') YPMC00 from YK_YPQLMX A where exists(select 1 from YF_YPKCXX B where B.YFBMBH=495 and A.YPNM00=B.YPNM00 and B.ZTBZ00='1') and A.YPQLDH='86314' 989 15:28:24 SQL Misc: ORACLE - Set stored procedure on or off 990 15:28:24 SQL Data In: ORACLE - Param = 1, Name = P_YPQLDH, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 86314 991 15:28:24 SQL Data In: ORACLE - Param = 2, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 992 15:28:24 SQL Data In: ORACLE - Param = 3, Name = P_QRRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1305.000000 993 15:28:24 SQL Data In: ORACLE - Param = 4, Name = P_YPRKDH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 994 15:28:24 SQL Execute: ORACLE - BEGIN "SP_YF_YPSLRKQR" (P_YPQLDH => :P_YPQLDH,P_YFBMBH => :P_YFBMBH,P_QRRBH0 => :P_QRRBH0,P_YPRKDH => :P_YPRKDH); END; 995 15:28:24 SQL Execute: ORACLE - Commit 996 15:28:24 SQL Data In: ORACLE - Rows affected = 0 997 15:28:25 SQL Misc: ORACLE - Set stored procedure on or off 998 15:28:25 SQL Data In: ORACLE - Param = 1, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 999 15:28:25 SQL Data In: ORACLE - Param = 2, Name = P_RKDH00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 178472 1000 15:28:25 SQL Data In: ORACLE - Param = 3, Name = P_QRR000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1305.000000 1001 15:28:25 SQL Execute: ORACLE - BEGIN "SP_YF_YPCFZDCL" (P_YFBMBH => :P_YFBMBH,P_RKDH00 => :P_RKDH00,P_QRR000 => :P_QRR000); END; 1002 15:28:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 1003 15:28:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220213 1004 15:28:25 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220315 1005 15:28:25 SQL Execute: ORACLE - select DISTINCT Q.YPQLDH,B.ZWXM00,Q.QLRQ00,QRRQ00 from YK_YPQLD0 Q,BM_YGBM00 B,YK_YPQLMX X where Q.CKQXBH=? AND Q.QLZT00='1' AND Q.QRRQ00>=? AND Q.QRRQ00<=? AND Q.YPQLDH=X.YPQLDH AND X.CXBZ00='Z' AND Q.CZYBH0=B.YGBH00(+) AND nvl(Q.LYFS00,'0')<>'4' AND Q.CKLXBH<>'25' 1006 15:28:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 86325 1007 15:28:25 SQL Execute: ORACLE - select b.sccjzw,x.*,(select ypmlbz from bm_yd0000 where ypnm00=x.ypnm00) ypmlbz, decode(sign(x.QLSL00),0,'',x.QLSL00||trim(x.QLDW00))||decode(sign(nvl(x.JLQLSL,0)),0,'',x.JLQLSL||trim(x.JLQLDW)) as QLZSL0, decode(sign(a.CKSL00),0,'',a.CKSL00||trim(a.CKDW00))||decode(sign(nvl(a.JLCKSL,0)),0,'',a.JLCKSL||trim(a.JLCKDW)) as SFZSL0, b.SCCJBH, b.scph00 PH0000, b.ypsxrq, b.scrq00, b.YPRKPC, 0 XGBZ00, a.CKSL00, a.JLCKSL from YK_YPQLMX x,yk_ypckmx a ,yk_yprkmx b WHERE x.YPQLDH=? AND x.CXBZ00='Z' and x.ypqlpc=a.ypqlpc(+) and a.yprkpc=b.yprkpc(+) ORDER BY x.YPQLPC 1008 15:28:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 86325 1009 15:28:25 SQL Execute: ORACLE - select b.sccjzw,x.*,(select ypmlbz from bm_yd0000 where ypnm00=x.ypnm00) ypmlbz, decode(sign(x.QLSL00),0,'',x.QLSL00||trim(x.QLDW00))||decode(sign(nvl(x.JLQLSL,0)),0,'',x.JLQLSL||trim(x.JLQLDW)) as QLZSL0, decode(sign(a.CKSL00),0,'',a.CKSL00||trim(a.CKDW00))||decode(sign(nvl(a.JLCKSL,0)),0,'',a.JLCKSL||trim(a.JLCKDW)) as SFZSL0, b.SCCJBH, b.scph00 PH0000, b.ypsxrq, b.scrq00, b.YPRKPC, 0 XGBZ00, a.CKSL00, a.JLCKSL from YK_YPQLMX x,yk_ypckmx a ,yk_yprkmx b WHERE x.YPQLDH=? AND x.CXBZ00='Z' and x.ypqlpc=a.ypqlpc(+) and a.yprkpc=b.yprkpc(+) ORDER BY x.YPQLPC 1010 15:28:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 86325 1011 15:28:25 SQL Execute: ORACLE - select b.sccjzw,x.*,(select ypmlbz from bm_yd0000 where ypnm00=x.ypnm00) ypmlbz, decode(sign(x.QLSL00),0,'',x.QLSL00||trim(x.QLDW00))||decode(sign(nvl(x.JLQLSL,0)),0,'',x.JLQLSL||trim(x.JLQLDW)) as QLZSL0, decode(sign(a.CKSL00),0,'',a.CKSL00||trim(a.CKDW00))||decode(sign(nvl(a.JLCKSL,0)),0,'',a.JLCKSL||trim(a.JLCKDW)) as SFZSL0, b.SCCJBH, b.scph00 PH0000, b.ypsxrq, b.scrq00, b.YPRKPC, 0 XGBZ00, a.CKSL00, a.JLCKSL from YK_YPQLMX x,yk_ypckmx a ,yk_yprkmx b WHERE x.YPQLDH=? AND x.CXBZ00='Z' and x.ypqlpc=a.ypqlpc(+) and a.yprkpc=b.yprkpc(+) ORDER BY x.YPQLPC 1012 15:28:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 86325 1013 15:28:25 SQL Execute: ORACLE - select b.sccjzw,x.*,(select ypmlbz from bm_yd0000 where ypnm00=x.ypnm00) ypmlbz, decode(sign(x.QLSL00),0,'',x.QLSL00||trim(x.QLDW00))||decode(sign(nvl(x.JLQLSL,0)),0,'',x.JLQLSL||trim(x.JLQLDW)) as QLZSL0, decode(sign(a.CKSL00),0,'',a.CKSL00||trim(a.CKDW00))||decode(sign(nvl(a.JLCKSL,0)),0,'',a.JLCKSL||trim(a.JLCKDW)) as SFZSL0, b.SCCJBH, b.scph00 PH0000, b.ypsxrq, b.scrq00, b.YPRKPC, 0 XGBZ00, a.CKSL00, a.JLCKSL from YK_YPQLMX x,yk_ypckmx a ,yk_yprkmx b WHERE x.YPQLDH=? AND x.CXBZ00='Z' and x.ypqlpc=a.ypqlpc(+) and a.yprkpc=b.yprkpc(+) ORDER BY x.YPQLPC 1014 15:28:29 SQL Execute: ORACLE - select rtrim(xmlagg(xmlparse(content A.YPMC00||'、' wellformed) order by A.YPQLPC).getclobval(), '、') YPMC00 from YK_YPQLMX A where exists(select 1 from YF_YPKCXX B where B.YFBMBH=495 and A.YPNM00=B.YPNM00 and B.ZTBZ00='1') and A.YPQLDH='86325' 1015 15:28:29 SQL Misc: ORACLE - Set stored procedure on or off 1016 15:28:29 SQL Data In: ORACLE - Param = 1, Name = P_YPQLDH, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 86325 1017 15:28:29 SQL Data In: ORACLE - Param = 2, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 1018 15:28:29 SQL Data In: ORACLE - Param = 3, Name = P_QRRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1305.000000 1019 15:28:29 SQL Data In: ORACLE - Param = 4, Name = P_YPRKDH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1020 15:28:29 SQL Execute: ORACLE - BEGIN "SP_YF_YPSLRKQR" (P_YPQLDH => :P_YPQLDH,P_YFBMBH => :P_YFBMBH,P_QRRBH0 => :P_QRRBH0,P_YPRKDH => :P_YPRKDH); END; 1021 15:28:29 SQL Execute: ORACLE - Commit 1022 15:28:29 SQL Data In: ORACLE - Rows affected = 0 1023 15:28:30 SQL Misc: ORACLE - Set stored procedure on or off 1024 15:28:30 SQL Data In: ORACLE - Param = 1, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 1025 15:28:30 SQL Data In: ORACLE - Param = 2, Name = P_RKDH00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 178474 1026 15:28:30 SQL Data In: ORACLE - Param = 3, Name = P_QRR000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1305.000000 1027 15:28:30 SQL Execute: ORACLE - BEGIN "SP_YF_YPCFZDCL" (P_YFBMBH => :P_YFBMBH,P_RKDH00 => :P_RKDH00,P_QRR000 => :P_QRR000); END; 1028 15:28:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 1029 15:28:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220213 1030 15:28:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220315 1031 15:28:30 SQL Execute: ORACLE - select DISTINCT Q.YPQLDH,B.ZWXM00,Q.QLRQ00,QRRQ00 from YK_YPQLD0 Q,BM_YGBM00 B,YK_YPQLMX X where Q.CKQXBH=? AND Q.QLZT00='1' AND Q.QRRQ00>=? AND Q.QRRQ00<=? AND Q.YPQLDH=X.YPQLDH AND X.CXBZ00='Z' AND Q.CZYBH0=B.YGBH00(+) AND nvl(Q.LYFS00,'0')<>'4' AND Q.CKLXBH<>'25' 1032 15:28:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 1033 15:28:30 SQL Execute: ORACLE - select b.sccjzw,x.*,(select ypmlbz from bm_yd0000 where ypnm00=x.ypnm00) ypmlbz, decode(sign(x.QLSL00),0,'',x.QLSL00||trim(x.QLDW00))||decode(sign(nvl(x.JLQLSL,0)),0,'',x.JLQLSL||trim(x.JLQLDW)) as QLZSL0, decode(sign(a.CKSL00),0,'',a.CKSL00||trim(a.CKDW00))||decode(sign(nvl(a.JLCKSL,0)),0,'',a.JLCKSL||trim(a.JLCKDW)) as SFZSL0, b.SCCJBH, b.scph00 PH0000, b.ypsxrq, b.scrq00, b.YPRKPC, 0 XGBZ00, a.CKSL00, a.JLCKSL from YK_YPQLMX x,yk_ypckmx a ,yk_yprkmx b WHERE x.YPQLDH=? AND x.CXBZ00='Z' and x.ypqlpc=a.ypqlpc(+) and a.yprkpc=b.yprkpc(+) ORDER BY x.YPQLPC 1034 15:28:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 1035 15:28:30 SQL Execute: ORACLE - select b.sccjzw,x.*,(select ypmlbz from bm_yd0000 where ypnm00=x.ypnm00) ypmlbz, decode(sign(x.QLSL00),0,'',x.QLSL00||trim(x.QLDW00))||decode(sign(nvl(x.JLQLSL,0)),0,'',x.JLQLSL||trim(x.JLQLDW)) as QLZSL0, decode(sign(a.CKSL00),0,'',a.CKSL00||trim(a.CKDW00))||decode(sign(nvl(a.JLCKSL,0)),0,'',a.JLCKSL||trim(a.JLCKDW)) as SFZSL0, b.SCCJBH, b.scph00 PH0000, b.ypsxrq, b.scrq00, b.YPRKPC, 0 XGBZ00, a.CKSL00, a.JLCKSL from YK_YPQLMX x,yk_ypckmx a ,yk_yprkmx b WHERE x.YPQLDH=? AND x.CXBZ00='Z' and x.ypqlpc=a.ypqlpc(+) and a.yprkpc=b.yprkpc(+) ORDER BY x.YPQLPC 1036 15:28:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 1037 15:28:30 SQL Execute: ORACLE - select b.sccjzw,x.*,(select ypmlbz from bm_yd0000 where ypnm00=x.ypnm00) ypmlbz, decode(sign(x.QLSL00),0,'',x.QLSL00||trim(x.QLDW00))||decode(sign(nvl(x.JLQLSL,0)),0,'',x.JLQLSL||trim(x.JLQLDW)) as QLZSL0, decode(sign(a.CKSL00),0,'',a.CKSL00||trim(a.CKDW00))||decode(sign(nvl(a.JLCKSL,0)),0,'',a.JLCKSL||trim(a.JLCKDW)) as SFZSL0, b.SCCJBH, b.scph00 PH0000, b.ypsxrq, b.scrq00, b.YPRKPC, 0 XGBZ00, a.CKSL00, a.JLCKSL from YK_YPQLMX x,yk_ypckmx a ,yk_yprkmx b WHERE x.YPQLDH=? AND x.CXBZ00='Z' and x.ypqlpc=a.ypqlpc(+) and a.yprkpc=b.yprkpc(+) ORDER BY x.YPQLPC 1038 15:28:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 1039 15:28:30 SQL Execute: ORACLE - select b.sccjzw,x.*,(select ypmlbz from bm_yd0000 where ypnm00=x.ypnm00) ypmlbz, decode(sign(x.QLSL00),0,'',x.QLSL00||trim(x.QLDW00))||decode(sign(nvl(x.JLQLSL,0)),0,'',x.JLQLSL||trim(x.JLQLDW)) as QLZSL0, decode(sign(a.CKSL00),0,'',a.CKSL00||trim(a.CKDW00))||decode(sign(nvl(a.JLCKSL,0)),0,'',a.JLCKSL||trim(a.JLCKDW)) as SFZSL0, b.SCCJBH, b.scph00 PH0000, b.ypsxrq, b.scrq00, b.YPRKPC, 0 XGBZ00, a.CKSL00, a.JLCKSL from YK_YPQLMX x,yk_ypckmx a ,yk_yprkmx b WHERE x.YPQLDH=? AND x.CXBZ00='Z' and x.ypqlpc=a.ypqlpc(+) and a.yprkpc=b.yprkpc(+) ORDER BY x.YPQLPC 1040 15:28: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 1041 15:28: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') and KLDH00 = '' 1042 15:28:31 SQL Execute: ORACLE - select nvl(BMXZ00,-1) from BM_BMBM00 where BMBH00=495 1043 15:28:31 SQL Execute: ORACLE - SELECT BMBH00, BMMC00 FROM BM_BMBM00 WHERE BMXZ00 in( '6','2','3') AND FLAG00 = '1' AND SFYX00 = '1' and CZBZ00<>'2' and BMBH00<>495 order by decode(BMXZ00,'6',0,1),PXXH00 1044 15:28:31 SQL Execute: ORACLE - select distinct YPQLDH, QLRQ00, QLRQGG, CZYXM0 from VW_YK_YPQLDCX A where nvl(A.LYFS00,'0')<>'4' and A.CKLXBH<>'25' and CKQXBH = 495 and QLZT00 = decode('3','J','0','3') and QLRQ00 between '20220308' and '20220315' ORDER BY YPQLDH DESC 1045 15:28:32 SQL Execute: ORACLE - select distinct YPQLDH, QLRQ00, QLRQGG, CZYXM0 from VW_YK_YPQLDCX A where nvl(A.LYFS00,'0')<>'4' and A.CKLXBH<>'25' and CKQXBH = 495 and QLZT00 = decode('0','J','0','0') and QLRQ00 between '20220308' and '20220315' and SFYJD0='N' ORDER BY YPQLDH DESC 1046 15:28:32 SQL Execute: ORACLE - select distinct YPQLDH, QLRQ00, QLRQGG, CZYXM0 from VW_YK_YPQLDCX A where nvl(A.LYFS00,'0')<>'4' and A.CKLXBH<>'25' and CKQXBH = 495 and QLZT00 = decode('J','J','0','J') and QLRQ00 between '20220308' and '20220315' and SFYJD0='Y' ORDER BY YPQLDH DESC 1047 15:28:32 SQL Execute: ORACLE - select distinct YPQLDH, QLRQ00, QLRQGG, CZYXM0 from VW_YK_YPQLDCX A where nvl(A.LYFS00,'0')<>'4' and A.CKLXBH<>'25' and CKQXBH = 495 and QLZT00 = decode('1','J','0','1') and QLRQ00 between '20220308' and '20220315' ORDER BY YPQLDH DESC 1048 15:28:32 SQL Execute: ORACLE - select distinct YPQLDH, QLRQ00, QLRQGG, CZYXM0 from VW_YK_YPQLDCX A where nvl(A.LYFS00,'0')<>'4' and A.CKLXBH<>'25' and CKQXBH = 495 and QLZT00 = decode('2','J','0','2') and QLRQ00 between '20220308' and '20220315' ORDER BY YPQLDH DESC 1049 15:28:32 SQL Execute: ORACLE - select distinct YPQLDH, QLRQ00, QLRQGG, CZYXM0 from VW_YK_YPQLDCX A where nvl(A.LYFS00,'0')<>'4' and A.CKLXBH<>'25' and CKQXBH = 495 and QLZT00 = decode('5','J','0','5') and QLRQ00 between '20220308' and '20220315' ORDER BY YPQLDH DESC 1050 15:28:32 SQL Execute: ORACLE - select distinct A.YPQLDH, A.YKBMBH, CZYBH0, QLRQ00, QLSJ00, (select BMMC00 from BM_BMBM00 where BMBH00 = A.YKBMBH) YKBMMC, A.CZYXM0, A.QLRQGG, CKQXBH, CKLXBH, QLZT00 from VW_YK_YPQLDCX A where nvl(A.LYFS00,'0')<>'4' and A.CKLXBH<>'25' and CKQXBH = 495 and QLRQ00 between '20220308' and '20220315' and QLZT00 = '3' ORDER BY YPQLDH DESC 1051 15:28:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 522 1052 15:28:32 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=? 1053 15:28:32 SQL Execute: ORACLE - select rownum XH, A.* from (select YPNM00, CZFLMC, YPMC00, YPGG00, GJBZBM ,GJBZMC, LSJ000, KCDW00, YKYPKC,substr(SF_YF_GETYPKC(YPNM00,YFBMBH,0,2),1,100) YFKCSL,SCCJ00, PYSM00, WBSM00, GJJ000, K2J000, ZBXH00,MZFYDW,M2J000,PFJ000,ZJJLDW,ZJJL2J, YPBM00,GHDWMC,YAOKKC from VW_YF_YPSLSRTS1 where 1=1 and YFBMBH=495and YKBMBH=522) A 1054 15:28:32 SQL Execute: ORACLE - select YPQLPC, YPQLDH, YPMC00, YPGG00, GJBZBM, GJBZMC, QLDW00, ZBXH00, YPNM00, QLSL00, GJDJ00, QLDJ00, GJJE00, LSJE00, ZHL000, QLRQ00, QLSJ00, substr(SF_YF_GETYPKC(YPNM00, '495', 0, 2),1,100) KCSL00, K2ZJJL,JLZHL0,JLQLDW,JLQLSL, (QLSL00 * K2ZJJL)QLZJL0,PFDJ00,YPBM00,SFSLXX,SYSYL0,SYHL00,substr(SF_YK_GETYPKC(a.YPNM00,a.YKBMBH,1),1,100) as YKYPKC,SCCJZW,GHDWMC ,(SELECT KCSX00 FROM YF_YPKCXX WHERE YFBMBH=495 AND YPNM00=A.YPNM00) KCSX00 ,(SELECT KCXX00 FROM YF_YPKCXX WHERE YFBMBH=495 AND YPNM00=A.YPNM00) KCXX00 from VW_YK_YPQLDCX a where YPQLDH = '86289' 1055 15:28:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 522 1056 15:28:32 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=? 1057 15:28:32 SQL Execute: ORACLE - select rownum XH, A.* from (select YPNM00, CZFLMC, YPMC00, YPGG00, GJBZBM ,GJBZMC, LSJ000, KCDW00, YKYPKC,substr(SF_YF_GETYPKC(YPNM00,YFBMBH,0,2),1,100) YFKCSL,SCCJ00, PYSM00, WBSM00, GJJ000, K2J000, ZBXH00,MZFYDW,M2J000,PFJ000,ZJJLDW,ZJJL2J, YPBM00,GHDWMC,YAOKKC from VW_YF_YPSLSRTS1 where 1=1 and YFBMBH=495and YKBMBH=522) A 1058 15:28:32 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '取药队列字典' and BH0000 = 'DSFBYJK_ZY' 1059 15:28:32 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1305,'柯珊','192.168.202.163','00-23-24-D4-04-01','2','ACT_YF_YPSL','19387802') 1060 15:28:32 SQL Data In: ORACLE - Rows affected = 1 1061 15:28:32 SQL Execute: ORACLE - Commit 1062 15:28:32 SQL Data In: ORACLE - Rows affected = 0 1063 15:28:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 522 1064 15:28:33 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=? 1065 15:28:33 SQL Execute: ORACLE - select rownum XH, A.* from (select YPNM00, CZFLMC, YPMC00, YPGG00, GJBZBM ,GJBZMC, LSJ000, KCDW00, YKYPKC,substr(SF_YF_GETYPKC(YPNM00,YFBMBH,0,2),1,100) YFKCSL,SCCJ00, PYSM00, WBSM00, GJJ000, K2J000, ZBXH00,MZFYDW,M2J000,PFJ000,ZJJLDW,ZJJL2J, YPBM00,GHDWMC,YAOKKC from VW_YF_YPSLSRTS1 where 1=1 and YFBMBH=495and YKBMBH=522) A 1066 15:28:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 522 1067 15:28:33 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=? 1068 15:28:33 SQL Execute: ORACLE - select rownum XH, A.* from (select YPNM00, CZFLMC, YPMC00, YPGG00, GJBZBM ,GJBZMC, LSJ000, KCDW00, YKYPKC,substr(SF_YF_GETYPKC(YPNM00,YFBMBH,0,2),1,100) YFKCSL,SCCJ00, PYSM00, WBSM00, GJJ000, K2J000, ZBXH00,MZFYDW,M2J000,PFJ000,ZJJLDW,ZJJL2J, YPBM00,GHDWMC,YAOKKC from VW_YF_YPSLSRTS1 where 1=1 and YFBMBH=495and YKBMBH=522) A 1069 15:28:33 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = 9000013209 1070 15:28:33 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = 9000013209 1071 15:28:33 SQL Execute: ORACLE - select YPQLPC, YPQLDH, YPMC00, YPGG00, GJBZBM, GJBZMC, QLDW00, ZBXH00, YPNM00, QLSL00, GJDJ00, QLDJ00, GJJE00, LSJE00, ZHL000, QLRQ00, QLSJ00, substr(SF_YF_GETYPKC(YPNM00, '495', 0, 2),1,100) KCSL00, K2ZJJL,JLZHL0,JLQLDW,JLQLSL, (QLSL00 * K2ZJJL)QLZJL0,PFDJ00,YPBM00,SFSLXX,SYSYL0,SYHL00,substr(SF_YK_GETYPKC(a.YPNM00,a.YKBMBH,1),1,100) as YKYPKC,SCCJZW,GHDWMC ,(SELECT KCSX00 FROM YF_YPKCXX WHERE YFBMBH=495 AND YPNM00=A.YPNM00) KCSX00 ,(SELECT KCXX00 FROM YF_YPKCXX WHERE YFBMBH=495 AND YPNM00=A.YPNM00) KCXX00 from VW_YK_YPQLDCX a where YPQLDH = '86289' 1072 15:28:33 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = 9000013209 1073 15:28:33 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = 9000013209 1074 15:28:33 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = 9000013209 1075 15:28:33 SQL Execute: ORACLE - select YPQLPC, YPQLDH, YPMC00, YPGG00, GJBZBM, GJBZMC, QLDW00, ZBXH00, YPNM00, QLSL00, GJDJ00, QLDJ00, GJJE00, LSJE00, ZHL000, QLRQ00, QLSJ00, substr(SF_YF_GETYPKC(YPNM00, '495', 0, 2),1,100) KCSL00, K2ZJJL,JLZHL0,JLQLDW,JLQLSL, (QLSL00 * K2ZJJL)QLZJL0,PFDJ00,YPBM00,SFSLXX,SYSYL0,SYHL00,substr(SF_YK_GETYPKC(a.YPNM00,a.YKBMBH,1),1,100) as YKYPKC,SCCJZW,GHDWMC ,(SELECT KCSX00 FROM YF_YPKCXX WHERE YFBMBH=495 AND YPNM00=A.YPNM00) KCSX00 ,(SELECT KCXX00 FROM YF_YPKCXX WHERE YFBMBH=495 AND YPNM00=A.YPNM00) KCXX00 from VW_YK_YPQLDCX a where YPQLDH = '86289' 1076 15:28:33 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = 9000013209 1077 15:28:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 522 1078 15:28:33 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=? 1079 15:28:33 SQL Execute: ORACLE - select rownum XH, A.* from (select YPNM00, CZFLMC, YPMC00, YPGG00, GJBZBM ,GJBZMC, LSJ000, KCDW00, YKYPKC,substr(SF_YF_GETYPKC(YPNM00,YFBMBH,0,2),1,100) YFKCSL,SCCJ00, PYSM00, WBSM00, GJJ000, K2J000, ZBXH00,MZFYDW,M2J000,PFJ000,ZJJLDW,ZJJL2J, YPBM00,GHDWMC,YAOKKC from VW_YF_YPSLSRTS1 where 1=1 and YFBMBH=495and YKBMBH=522) A 1080 15:28:33 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = -1 and YPNM00 = 9000013209 1081 15:28:33 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = -1 and YPNM00 = 9000013209 1082 15:28:33 SQL Execute: ORACLE - select YPQLPC, YPQLDH, YPMC00, YPGG00, GJBZBM, GJBZMC, QLDW00, ZBXH00, YPNM00, QLSL00, GJDJ00, QLDJ00, GJJE00, LSJE00, ZHL000, QLRQ00, QLSJ00, substr(SF_YF_GETYPKC(YPNM00, '495', 0, 2),1,100) KCSL00, K2ZJJL,JLZHL0,JLQLDW,JLQLSL, (QLSL00 * K2ZJJL)QLZJL0,PFDJ00,YPBM00,SFSLXX,SYSYL0,SYHL00,'0'||(select KCDW00 from BM_YD0000 where YPNM00=a.YPNM00 ) as YKYPKC,SCCJZW,GHDWMC ,(SELECT KCSX00 FROM YF_YPKCXX WHERE YFBMBH=495 AND YPNM00=A.YPNM00) KCSX00 ,(SELECT KCXX00 FROM YF_YPKCXX WHERE YFBMBH=495 AND YPNM00=A.YPNM00) KCXX00 from VW_YK_YPQLDCX a where YPQLDH = '' 1083 15:28:33 SQL Execute: ORACLE - select YPQLPC, YPQLDH, YPMC00, YPGG00, GJBZBM, GJBZMC, QLDW00, ZBXH00, YPNM00, QLSL00, GJDJ00, QLDJ00, GJJE00, LSJE00, ZHL000, QLRQ00, QLSJ00, substr(SF_YF_GETYPKC(YPNM00, '495', 0, 2),1,100) KCSL00, K2ZJJL,JLZHL0,JLQLDW,JLQLSL, (QLSL00 * K2ZJJL)QLZJL0,PFDJ00,YPBM00,SFSLXX,SYSYL0,SYHL00,'0'||(select KCDW00 from BM_YD0000 where YPNM00=a.YPNM00 ) as YKYPKC,SCCJZW,GHDWMC ,(SELECT KCSX00 FROM YF_YPKCXX WHERE YFBMBH=495 AND YPNM00=A.YPNM00) KCSX00 ,(SELECT KCXX00 FROM YF_YPKCXX WHERE YFBMBH=495 AND YPNM00=A.YPNM00) KCXX00 from VW_YK_YPQLDCX a where YPQLDH = '' 1084 15:28:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 522 1085 15:28:33 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=? 1086 15:28:33 SQL Execute: ORACLE - select rownum XH, A.* from (select YPNM00, CZFLMC, YPMC00, YPGG00, GJBZBM ,GJBZMC, LSJ000, KCDW00, YKYPKC,substr(SF_YF_GETYPKC(YPNM00,YFBMBH,0,2),1,100) YFKCSL,SCCJ00, PYSM00, WBSM00, GJJ000, K2J000, ZBXH00,MZFYDW,M2J000,PFJ000,ZJJLDW,ZJJL2J, YPBM00,GHDWMC,YAOKKC from VW_YF_YPSLSRTS1 where 1=1 and YFBMBH=495and YKBMBH=522) A 1087 15:28:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 522 1088 15:28:33 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=? 1089 15:28:33 SQL Execute: ORACLE - select rownum XH, A.* from (select YPNM00, CZFLMC, YPMC00, YPGG00, GJBZBM ,GJBZMC, LSJ000, KCDW00, YKYPKC,substr(SF_YF_GETYPKC(YPNM00,YFBMBH,0,2),1,100) YFKCSL,SCCJ00, PYSM00, WBSM00, GJJ000, K2J000, ZBXH00,MZFYDW,M2J000,PFJ000,ZJJLDW,ZJJL2J, YPBM00,GHDWMC,YAOKKC from VW_YF_YPSLSRTS1 where 1=1 and YFBMBH=495and YKBMBH=522) A 1090 15:28:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 522 1091 15:28:34 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=? 1092 15:28:34 SQL Execute: ORACLE - select rownum XH, A.* from (select YPNM00, CZFLMC, YPMC00, YPGG00, GJBZBM ,GJBZMC, LSJ000, KCDW00, YKYPKC,substr(SF_YF_GETYPKC(YPNM00,YFBMBH,0,2),1,100) YFKCSL,SCCJ00, PYSM00, WBSM00, GJJ000, K2J000, ZBXH00,MZFYDW,M2J000,PFJ000,ZJJLDW,ZJJL2J, YPBM00,GHDWMC,YAOKKC from VW_YF_YPSLSRTS1 where 1=1 and YFBMBH=495and YKBMBH=522) A 1093 15:28:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 522 1094 15:28:34 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=? 1095 15:28:34 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = -1 1096 15:28:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 522 1097 15:28:39 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=? 1098 15:28:39 SQL Execute: ORACLE - select rownum XH, A.* from (select YPNM00, CZFLMC, YPMC00, YPGG00, GJBZBM ,GJBZMC, LSJ000, KCDW00, YKYPKC,substr(SF_YF_GETYPKC(YPNM00,YFBMBH,0,2),1,100) YFKCSL,SCCJ00, PYSM00, WBSM00, GJJ000, K2J000, ZBXH00,MZFYDW,M2J000,PFJ000,ZJJLDW,ZJJL2J, YPBM00,GHDWMC,YAOKKC from VW_YF_YPSLSRTS1 where 1=1 and PYSM00 like '%s%' and YFBMBH=495and YKBMBH=522) A 1099 15:28:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 522 1100 15:28:39 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=? 1101 15:28:39 SQL Execute: ORACLE - select rownum XH, A.* from (select YPNM00, CZFLMC, YPMC00, YPGG00, GJBZBM ,GJBZMC, LSJ000, KCDW00, YKYPKC,substr(SF_YF_GETYPKC(YPNM00,YFBMBH,0,2),1,100) YFKCSL,SCCJ00, PYSM00, WBSM00, GJJ000, K2J000, ZBXH00,MZFYDW,M2J000,PFJ000,ZJJLDW,ZJJL2J, YPBM00,GHDWMC,YAOKKC from VW_YF_YPSLSRTS1 where 1=1 and PYSM00 like '%sq%' and YFBMBH=495and YKBMBH=522) A 1102 15:28:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 522 1103 15:28:40 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=? 1104 15:28:40 SQL Execute: ORACLE - select rownum XH, A.* from (select YPNM00, CZFLMC, YPMC00, YPGG00, GJBZBM ,GJBZMC, LSJ000, KCDW00, YKYPKC,substr(SF_YF_GETYPKC(YPNM00,YFBMBH,0,2),1,100) YFKCSL,SCCJ00, PYSM00, WBSM00, GJJ000, K2J000, ZBXH00,MZFYDW,M2J000,PFJ000,ZJJLDW,ZJJL2J, YPBM00,GHDWMC,YAOKKC from VW_YF_YPSLSRTS1 where 1=1 and PYSM00 like '%sqj%' and YFBMBH=495and YKBMBH=522) A 1105 15:28:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 522 1106 15:28:40 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=? 1107 15:28:40 SQL Execute: ORACLE - select rownum XH, A.* from (select YPNM00, CZFLMC, YPMC00, YPGG00, GJBZBM ,GJBZMC, LSJ000, KCDW00, YKYPKC,substr(SF_YF_GETYPKC(YPNM00,YFBMBH,0,2),1,100) YFKCSL,SCCJ00, PYSM00, WBSM00, GJJ000, K2J000, ZBXH00,MZFYDW,M2J000,PFJ000,ZJJLDW,ZJJL2J, YPBM00,GHDWMC,YAOKKC from VW_YF_YPSLSRTS1 where 1=1 and PYSM00 like '%sqjt%' and YFBMBH=495and YKBMBH=522) A 1108 15:28:52 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = -1 1109 15:28:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 9000013248 1110 15:28:52 SQL Execute: ORACLE - select YPMC00 from BM_YD0000 where YPNM00=? 1111 15:28:52 SQL Execute: ORACLE - select YPNM00,KCSX00,KCXX00 from YF_YPKCXX where YFBMBH= 495 and YPNM00 = 9000013248 1112 15:28:52 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = 9000013248 1113 15:29:17 SQL Execute: ORACLE - select SF_YK_GETLSH('YKYPQLDH','522') from dual 1114 15:29:17 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = 9000013248 1115 15:29:17 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = 9000013248 1116 15:29:17 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = 9000013248 1117 15:29:17 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = 9000013248 1118 15:29:17 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = 9000013248 1119 15:29:17 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = 9000013248 1120 15:29:17 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = 9000013248 1121 15:29:17 SQL Execute: ORACLE - insert into YK_YPQLD0(YPQLDH, YKBMBH, QLRQ00, QLSJ00, CZYBH0, CKQXBH, CKLXBH, QLZT00,LYRBH0) values('86329', '522', TO_CHAR(SYSDATE,'YYYYMMDD'), TO_CHAR(SYSDATE,'HH24:MI:SS'), '1305','495', '05', '3',1305) 1122 15:29:17 SQL Data In: ORACLE - Rows affected = 1 1123 15:29:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 86329 1124 15:29:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9000013248.000000 1125 15:29:17 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 参芪降糖片 1126 15:29:17 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = 0.35g*100片 1127 15:29:17 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 盒 1128 15:29:17 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1129 15:29:17 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 1130 15:29:17 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 35.000000 1131 15:29:17 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 200.000000 1132 15:29:17 SQL Data In: ORACLE - Param = 10, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1133 15:29:17 SQL Data In: ORACLE - Param = 11, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1134 15:29:17 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 片 1135 15:29:17 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.350000 1136 15:29:17 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 1137 15:29:17 SQL Execute: ORACLE - insert into YK_YPQLMX (YPQLPC, YPQLDH, YPNM00, YPMC00, YPGG00, QLDW00, GJDJ00, QLDJ00, ZHL000, QLSL00, PFDJ00,JLQLSL,JLQLDW,JLZHL0,SYHL00) values (SQ_YK_YPQLMX_YPQLPC.NEXTVAL, ?, ?, ?, ?, ?, ?, ?, ?, nvl(?,0),?,?,?,?,? ) 1138 15:29:17 SQL Data In: ORACLE - Rows affected = 1 1139 15:29:17 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = 9000013248 1140 15:29:17 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = 9000013248 1141 15:29:17 SQL Execute: ORACLE - commit 1142 15:29:17 SQL Data In: ORACLE - Rows affected = 0 1143 15:29:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 86329 1144 15:29:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 1145 15:29:18 SQL Execute: ORACLE - select 1 from YK_YPQLD0 where YPQLDH=? and QLZT00=? 1146 15:29:18 SQL Execute: ORACLE - select count(*) from YK_YPQLMX where YPQLDH='86329' and (QLSL00<=0 or QLSL00 is null) and (JLQLSL<=0 or JLQLSL is null) 1147 15:29:18 SQL Execute: ORACLE - update YK_YPQLD0 set QLZT00 = '0' where YPQLDH = '86329' 1148 15:29:18 SQL Data In: ORACLE - Rows affected = 1 1149 15:29:18 SQL Execute: ORACLE - Commit 1150 15:29:18 SQL Data In: ORACLE - Rows affected = 0 1151 15:29:19 SQL Execute: ORACLE - select YPQLPC, YPQLDH, YPMC00, YPGG00, GJBZBM, GJBZMC, QLDW00, ZBXH00, YPNM00, QLSL00, GJDJ00, QLDJ00, GJJE00, LSJE00, ZHL000, QLRQ00, QLSJ00, substr(SF_YF_GETYPKC(YPNM00, '495', 0, 2),1,100) KCSL00, K2ZJJL,JLZHL0,JLQLDW,JLQLSL, (QLSL00 * K2ZJJL)QLZJL0,PFDJ00,YPBM00,SFSLXX,SYSYL0,SYHL00,'0'||(select KCDW00 from BM_YD0000 where YPNM00=a.YPNM00 ) as YKYPKC,SCCJZW,GHDWMC ,(SELECT KCSX00 FROM YF_YPKCXX WHERE YFBMBH=495 AND YPNM00=A.YPNM00) KCSX00 ,(SELECT KCXX00 FROM YF_YPKCXX WHERE YFBMBH=495 AND YPNM00=A.YPNM00) KCXX00 from VW_YK_YPQLDCX a where YPQLDH = '' 1152 15:29:19 SQL Execute: ORACLE - select distinct YPQLDH, QLRQ00, QLRQGG, CZYXM0 from VW_YK_YPQLDCX A where nvl(A.LYFS00,'0')<>'4' and A.CKLXBH<>'25' and CKQXBH = 495 and QLZT00 = decode('3','J','0','3') and QLRQ00 between '20220308' and '20220315' ORDER BY YPQLDH DESC 1153 15:29:19 SQL Execute: ORACLE - select distinct YPQLDH, QLRQ00, QLRQGG, CZYXM0 from VW_YK_YPQLDCX A where nvl(A.LYFS00,'0')<>'4' and A.CKLXBH<>'25' and CKQXBH = 495 and QLZT00 = decode('0','J','0','0') and QLRQ00 between '20220308' and '20220315' and SFYJD0='N' ORDER BY YPQLDH DESC 1154 15:29:19 SQL Execute: ORACLE - select distinct YPQLDH, QLRQ00, QLRQGG, CZYXM0 from VW_YK_YPQLDCX A where nvl(A.LYFS00,'0')<>'4' and A.CKLXBH<>'25' and CKQXBH = 495 and QLZT00 = decode('J','J','0','J') and QLRQ00 between '20220308' and '20220315' and SFYJD0='Y' ORDER BY YPQLDH DESC 1155 15:29:19 SQL Execute: ORACLE - select distinct YPQLDH, QLRQ00, QLRQGG, CZYXM0 from VW_YK_YPQLDCX A where nvl(A.LYFS00,'0')<>'4' and A.CKLXBH<>'25' and CKQXBH = 495 and QLZT00 = decode('1','J','0','1') and QLRQ00 between '20220308' and '20220315' ORDER BY YPQLDH DESC 1156 15:29:19 SQL Execute: ORACLE - select distinct YPQLDH, QLRQ00, QLRQGG, CZYXM0 from VW_YK_YPQLDCX A where nvl(A.LYFS00,'0')<>'4' and A.CKLXBH<>'25' and CKQXBH = 495 and QLZT00 = decode('2','J','0','2') and QLRQ00 between '20220308' and '20220315' ORDER BY YPQLDH DESC 1157 15:29:19 SQL Execute: ORACLE - select distinct YPQLDH, QLRQ00, QLRQGG, CZYXM0 from VW_YK_YPQLDCX A where nvl(A.LYFS00,'0')<>'4' and A.CKLXBH<>'25' and CKQXBH = 495 and QLZT00 = decode('5','J','0','5') and QLRQ00 between '20220308' and '20220315' ORDER BY YPQLDH DESC 1158 15:29:19 SQL Execute: ORACLE - select distinct A.YPQLDH, A.YKBMBH, CZYBH0, QLRQ00, QLSJ00, CKQXBH, CKLXBH, (select BMMC00 from BM_BMBM00 where BMBH00 = A.YKBMBH) YKBMMC, A.CZYXM0, A.QLRQGG, QLZT00 from VW_YK_YPQLDCX A where nvl(A.LYFS00,'0')<>'4' and A.CKLXBH<>'25' and CKQXBH = 495 and YPQLDH = '86329' 1159 15:29:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 522 1160 15:29:19 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=? 1161 15:29:19 SQL Execute: ORACLE - select rownum XH, A.* from (select YPNM00, CZFLMC, YPMC00, YPGG00, GJBZBM ,GJBZMC, LSJ000, KCDW00, YKYPKC,substr(SF_YF_GETYPKC(YPNM00,YFBMBH,0,2),1,100) YFKCSL,SCCJ00, PYSM00, WBSM00, GJJ000, K2J000, ZBXH00,MZFYDW,M2J000,PFJ000,ZJJLDW,ZJJL2J, YPBM00,GHDWMC,YAOKKC from VW_YF_YPSLSRTS1 where 1=1 and YFBMBH=495and YKBMBH=522) A 1162 15:29:19 SQL Execute: ORACLE - select YPQLPC, YPQLDH, YPMC00, YPGG00, GJBZBM, GJBZMC, QLDW00, ZBXH00, YPNM00, QLSL00, GJDJ00, QLDJ00, GJJE00, LSJE00, ZHL000, QLRQ00, QLSJ00, substr(SF_YF_GETYPKC(YPNM00, '495', 0, 2),1,100) KCSL00, K2ZJJL,JLZHL0,JLQLDW,JLQLSL, (QLSL00 * K2ZJJL)QLZJL0,PFDJ00,YPBM00,SFSLXX,SYSYL0,SYHL00,'0'||(select KCDW00 from BM_YD0000 where YPNM00=a.YPNM00 ) as YKYPKC,SCCJZW,GHDWMC ,(SELECT KCSX00 FROM YF_YPKCXX WHERE YFBMBH=495 AND YPNM00=A.YPNM00) KCSX00 ,(SELECT KCXX00 FROM YF_YPKCXX WHERE YFBMBH=495 AND YPNM00=A.YPNM00) KCXX00 from VW_YK_YPQLDCX a where YPQLDH = '86329' 1163 15:29:19 SQL Execute: ORACLE - select nvl(sum(KCSL00),0) KCSL00 from VW_YK_YPKCXX where YKBMBH = 522 and YPNM00 = 9000013248 1164 15:29:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 522 1165 15:29:19 SQL Execute: ORACLE - select bmxz00 from bm_bmbm00 where bmbh00=? 1166 15:29:19 SQL Execute: ORACLE - select rownum XH, A.* from (select YPNM00, CZFLMC, YPMC00, YPGG00, GJBZBM ,GJBZMC, LSJ000, KCDW00, YKYPKC,substr(SF_YF_GETYPKC(YPNM00,YFBMBH,0,2),1,100) YFKCSL,SCCJ00, PYSM00, WBSM00, GJJ000, K2J000, ZBXH00,MZFYDW,M2J000,PFJ000,ZJJLDW,ZJJL2J, YPBM00,GHDWMC,YAOKKC from VW_YF_YPSLSRTS1 where 1=1 and YFBMBH=495and YKBMBH=522) A 1167 15:30:10 SQL Misc: ORACLE - Set stored procedure on or off 1168 15:30:10 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1305.000000 1169 15:30:10 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 1170 15:30:10 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21252459.000000 1171 15:30:10 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 1172 15:30:10 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1305 and CZXH00 = 21252459.00) 1173 15:33:10 SQL Misc: ORACLE - Set stored procedure on or off 1174 15:33:10 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1305.000000 1175 15:33:10 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 1176 15:33:10 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21252618.000000 1177 15:33:10 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 1178 15:33:10 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1305 and CZXH00 = 21252618.00)