1 11:25:41 Log started for: 易联众医院信息综合管理平台 2 11:25:41 SQL Execute: ORACLE - Select * from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 3 11:25:41 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,BZ0000) select '192.168.200.159','99',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 11:25:41 SQL Data In: ORACLE - Rows affected = 1 5 11:25:41 SQL Execute: ORACLE - Commit 6 11:25:41 SQL Data In: ORACLE - Rows affected = 0 7 11:25:41 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 8 11:25:41 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='STAR' and CZBZ00 in ('0','1') 9 11:25:41 SQL Execute: ORACLE - select count(*) COUNT0 from XT_XTYCRZ where XKH000 = 'star' and YCLBBZ ='0' and CLBZ00 = '0' 10 11:25:41 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_YHMMZDCSCS' 11 11:25:41 SQL Execute: ORACLE - select distinct XTDM00,XTMC00,XTBMXZ,DLFS00,TPSYH0,BJTP00,XTBB00,BBXH00 from VW_XT_YHBMQX_EXT where YGBH00=1913 and XTDM00 not in ('OE','MC') order by XTDM00 12 11:25:41 SQL Execute: ORACLE - Select SYSDATE from Dual 13 11:25:41 SQL Execute: ORACLE - Select SYSDATE from Dual 14 11:25:41 SQL Execute: ORACLE - select XKH000,ZWXM00,BMBH00,BMMC00,BMYYID,BMYYMC,YBYGDM,YBYGDM_EX from VW_BM_YGBM00_EXT where YGBH00= 1913 15 11:25:41 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where YGBH00 = 1913 16 11:25:41 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where DECODE(SYXT00,NULL,'-1',SYXT00) in ('999','-1') 17 11:25:42 SQL Execute: ORACLE - select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 18 11:25:42 SQL Execute: ORACLE - select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 19 11:25:42 SQL Execute: ORACLE - select SJKYH0,DBBB00 from XT_DBMS00 where upper(SJKYH0) = upper('sd_hospital') 20 11:25:42 SQL Execute: ORACLE - select INSTANCE_NAME,HOST_NAME from V$INSTANCE 21 11:25:42 SQL Execute: ORACLE - select ZBDM00 from XT_YHZB00 where YGBH00 = 1913 22 11:25:42 SQL Execute: ORACLE - select YGBH00,YGXKH0,YGXM00,JSID00,JSMC00,JSDESC,JSLX00 from VW_PT_YGJSB0 where YGBH00 = 1913 23 11:25:42 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000= '192.168.200.159' 24 11:25:42 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_MMQDYZTSDJ' 25 11:25:42 SQL Execute: ORACLE - select YGBH00,XKH000,ZWXM00,XTDM00,XTMC00,DLKS00,BMMC00,DLRQSJ from VW_XT_XTDLRZ where YGBH00 = 1913 and RowNum <= 10 order by DLRQSJ DESC 26 11:25:42 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 1913 and XTDM00='1' order by BMPLXH,BMBH00 27 11:25:43 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 1913 and XTDM00='4' order by BMPLXH,BMBH00 28 11:25:49 SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 1913 and XTDM00='2' order by BMPLXH,BMBH00 29 11:25:51 SQL Execute: ORACLE - select * from VW_XT_XTKJMK where XTDM00='2' and KJLB00 ='3' 30 11:25:51 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKWBJC,KJLB00,KJJ000,XH0000,TBSYH0,KJQDFS,MKDYCS from VW_XT_XTKJMK where XTDM00 = '2' and KJLB00 < '3' order by XH0000 31 11:25:51 SQL Execute: ORACLE - select * from XT_XTCS00 where instr(','||SYXT00||',',','||'2'||',')>0 32 11:25:51 SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKDLL0,TBSYH0 from VW_PT_YHGNMK where YGBH00 = 1913 and XTDM00 = '2' 33 11:25:51 SQL Execute: ORACLE - select XTDM00,JHGNID,RQLMC0,KJNAME,KJLMC0,KJMS00,MKNBMC,MKDLL0 from VW_XT_XTGNKJ where XTDM00 = '2' 34 11:25:51 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 35 11:25:51 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)) 36 11:25:51 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,SERIAL,BZ0000,JCID00) select '192.168.200.159','2',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@',AUDSID from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 37 11:25:51 SQL Data In: ORACLE - Rows affected = 1 38 11:25:51 SQL Execute: ORACLE - Commit 39 11:25:51 SQL Data In: ORACLE - Rows affected = 0 40 11:25:51 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 41 11:25:51 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')) 42 11:25:51 SQL Execute: ORACLE - insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00,IP0000) values(5320698,1913,'DESKTOP-QGDG26V','2',nvl('57924724',' '),'192.168.200.159#1878:26667@appYLZHis.exe',495,'192.168.200.159') 43 11:25:51 SQL Data In: ORACLE - Rows affected = 1 44 11:25:51 SQL Execute: ORACLE - Commit 45 11:25:51 SQL Data In: ORACLE - Rows affected = 0 46 11:25:51 SQL Execute: ORACLE - select count(*) from VW_XT_YHKJMK where YGBH00=1913 and XTDM00='2' 47 11:25:51 SQL Execute: ORACLE - select * from XT_BJCS00 where IP0000 = '192.168.200.159' and NAME00 = 'QDXTJZ' 48 11:25:51 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 = 1913 and XTDM00 = '2') c order by c.XH0000,c.JGLB00,c.FJGID0,c.JGID00 49 11:25:51 SQL Execute: ORACLE - select MKNBMC,MKWBMC,XTDM00,MKDLL0,TBSYH0 from VW_PT_YHCDMK where YGBH00 = 1913 and XTDM00= '+' and MKDLL0 in ('DLL_GGMK_ZHYW.dll','DLL_GGMK_CXTJ.dll') 50 11:25:51 SQL Execute: ORACLE - select KJID00,YGBH00,XTDM00,MKNBMC,MKWBMC,MKDLL0,XH0000,TBSYH0 from VW_XT_YHKJMK where YGBH00=1913 and XTDM00='2' order by XH0000 51 11:25:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 52 11:25:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 53 11:25:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 54 11:25:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 55 11:25:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 56 11:25:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 57 11:25:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61584893.000000 58 11:25:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 59 11:25:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61584893.00) 60 11:25:55 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 61 11:25:55 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='2' 62 11:25:55 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 63 11:25:55 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 = '' 64 11:25:55 SQL Execute: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=495 65 11:25:55 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=495 66 11:25:55 SQL Execute: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='220035' 67 11:25:55 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL 68 11:25:55 SQL Execute: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual 69 11:25:55 SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(495) as SFBZDJ from dual 70 11:25:55 SQL Execute: ORACLE - select * from VW_XT_BGSZJY where MKDLL0 = 'DLL_YF_CXTJ.dll' and YGBH00 = 1913 and XTDM00 = '2' 71 11:25:55 SQL Execute: ORACLE - select * from XT_BGSZMX where BGSZID = 2161.00 order by BDINDX,BDCLDX,CLINDX,MXID00 72 11:25:55 SQL Execute: ORACLE - select * from BM_YPLB00 73 11:25:55 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=1913 74 11:25:55 SQL Execute: ORACLE - SELECT SFXMMC FROM BM_YPLB00 where LBBH00='3' 75 11:25:55 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 = '审方退回原因' and LBBZ00='0' order by XSXH00 76 11:25:55 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 = '代煎标签药品名称' and LBBZ00='0' order by XSXH00 77 11:25:55 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 = '住院片剂包药机编号名称' and LBBZ00='0' order by XSXH00 78 11:25:55 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '福建预交金统一平台' and BH0000 = 'Open_MZ' 79 11:25:55 SQL Execute: ORACLE - SELECT FBBH00,FBMC00 FROM BM_BRFBB0 WHERE SFYX00 ='Y' 80 11:25:55 SQL Execute: ORACLE - SELECT BH0000,MC0000 FROM BM_TYZD00 WHERE ZDMC00='药典维护-药品性质' and YXBZ00 = '1' and LBBZ00 = '0' ORDER BY XSXH00 81 11:25:55 SQL Execute: ORACLE - Select SQ_XT_CDJCRZ_LSH000.NextVal SID from Dual 82 11:25:55 SQL Execute: ORACLE - Insert into XT_CDJCRZ(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,IP0000, CDMC00,DLRQ00,DLSJ00) Values(190492,1913,'DESKTOP-QGDG26V','2',nvl('57924724',' '),'192.168.200.159','门诊处方查询',TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS')) 83 11:25:56 SQL Data In: ORACLE - Rows affected = 1 84 11:25:56 SQL Execute: ORACLE - Commit 85 11:25:56 SQL Data In: ORACLE - Rows affected = 0 86 11:25:56 SQL Execute: ORACLE - select count(1) from BM_TYZD00 where ZDMC00='门诊处方点评-剂型' and YXBZ00 = '1' 87 11:25:56 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'YBZSMSFQY' 88 11:25:56 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1913,'易联众ss','192.168.200.159','E8-6A-64-21-05-4A','2','ACT_YF_MZCFCX','57924724') 89 11:25:56 SQL Data In: ORACLE - Rows affected = 1 90 11:25:56 SQL Execute: ORACLE - Commit 91 11:25:56 SQL Data In: ORACLE - Rows affected = 0 92 11:26:11 SQL Execute: ORACLE - SELECT row_number() over ( ORDER BY nvl(C.BCCFH0,C.CFLSH0),C.CFLSH0 ) ,'1' chkbox,C.CFLSH0,C.GHH000,C.BRID00,C.BRXM00,B.BRBLH0,C.XB0000,( select BRDH00 from BM_BRXXB0 WHERE BRID00=B.BRID00 ) BRDH00,substrb(decode (SF_YF_KSSCF0(C.CFLSH0),'N','否','Y','是' ),1,2)SFKSS0, C.CSRQ00,substrb(sf_xt_CsrqToNl(C.CSRQ00,NULL),1,20) BRNL00,DECODE('Y','Y',C.YSXM00,DECODE(SRRQ00,TO_CHAR(SYSDATE,'YYYYMMDD'),C.YSXM00,' ')) YSXM00, M.BMMC00 AS GHKS00,C.ZYTS00,( select FBMC00 from BM_BRFBB0 where FBBH00 = B.FBBH00 ) FBMC00,C.SRRQ00,C.JZRQ00,C.JZSJ00,C.CFZJE0,C.CFZT00,C.YPDLBH, decode(C.CFZT00,'0',decode(C.BCCFH0,NULL,'未记账','未退费'),'1','已记账','4','未审核','2',decode(R.ZT0000, '0', '待打印', '1', '待配药', '2', '待发药', '3', '已发药'),'3','已作废','5','已退药','6','已退费') CFZTMC, G.ZWXM00 as FHRXM0, C.DJH000,C.FYRQ00,C.FYSJ00,C.ZYDJS0, SUBSTR(C.BCCFH0||TRIM(C.BZ0000)||' '||trim(C.CFSM00),1,120) AS BZ0000, decode(c.LYRQSJ,null,null,H.ZWXM00) FYR000, (Select ZWXM00 FROM BM_YGBM00 i Where i.YGBH00=C.PFR000) PFR000, to_char(A.TW0000) TW0000,TO_CHAR(A.HXCS00) HXCS00,to_char(A.SSY000) SSY000,to_char(A.SZY000) SZY000, substrb(SF_XT_BRGMJL_DZBL('0',C.BRID00),1,200) GMJL00,A.BRSG00,A.BRTZ00, (Select sum(CFZJE0) FROM YF_MZCF00 Where BRID00=C.BRID00 and BCCFH0=C.CFLSH0 AND CFZT00 IN ('5','6') and GHID00 = C.GHID00 ) TYTFJE, rpad(nvl(trim(decode(TRIM(SF_YF_GETXYZYZD(c.GHH000,'1')),'','','(西)'||trim(SF_YF_GETXYZYZD(c.GHH000,'1'))) ||chr(10)||decode(trim(SF_YF_GETXYZYZD(c.GHH000,'0')),'','','(中)'||trim(SF_YF_GETXYZYZD(c.GHH000,'0'))) ),'待查' ),60,' ' ) ZZDMC0, SUBSTR((SELECT SF_YF_GETXYZYZD(C.GHH000,'0') FROM DUAL),1,100) as ZYZDMC, SUBSTR((SELECT SF_YF_GETXYZYZD(C.GHH000,'1') FROM DUAL),1,100) as XYZDMC, NVL(C.CFDGS0,'5') CFDGS0,d.lbmc00,substr(SF_YF_KSSCF0(C.CFLSH0),1,1) KSSCF0, decode(SF_YF_KSSCFDPJG(C.CFLSH0,'1'),0,'合 格',1,'不合格','未点评') CFDPJG,( select BRLXDH from BM_BRXXB0 WHERE BRID00=B.BRID00 ) BRLXDH, substrb(SF_YF_CFDP_NHGJG(C.CFLSH0,'1'),1,248) BHGYY0, R.FYDLXH,substr(SF_PY_PYLBMC(c.CFLSH0),1,10) PYLBMC,C.BCCFH0, decode(R.DYRQ00,null,null,R.DYSJ00||' '||substrb(R.DYRQ00,1,4)||'-'||substrb(R.DYRQ00,5,2)||'-'||substrb(R.DYRQ00,7,2)) PYDYSJ, decode(R.PYRQ00,null,null,R.PYSJ00||' '||substrb(R.PYRQ00,1,4)||'-'||substrb(R.PYRQ00,5,2)||'-'||substrb(R.PYRQ00,7,2)) PYJHSJ, round((to_date(R.PYRQ00||R.PYSJ00,'YYYYMMDDHH24:MI:SS')-to_date(R.DYRQ00||R.DYSJ00,'YYYYMMDDHH24:MI:SS'))*86400) DYJHJG, round((to_date(R.PYRQ00||R.PYSJ00,'YYYYMMDDHH24:MI:SS')-to_date(R.CJRQ00||R.CJSJ00,'YYYYMMDDHH24:MI:SS'))*86400) QHJHJG, (select CKMC00 from BM_CKBM00 where flag00='3' and CKBH00=R.FYCKBH and rownum=1) FYCKMC, (select Y.ZWXM00 from BM_YGBM00 Y,YF_DSCFDL Z where Y.YGBH00 = Z.CZY000 and Z.CFLSH0 = C.CFLSH0) ZWXM00, (select max(MC0000) from bm_tsbzb0 where BH0000 = nvl(c.TSBZBH,B.TSBZBH) and YBZXLB = B.YBZXLB ) TSBZMC ,substrb(SF_YF_GETDJSJ(c.brid00,c.zyts00,c.fjfdjh,c.DJH000),1,120) DJJZSJ ,( select count(DISTINCT(YPNM00)) from YF_MZCFMX WHERE CFLSH0 = C.CFLSH0 ) YPSL00,substrb(SF_YF_CFSFYZJYP(C.CFLSH0),1,120) SFZJCF ,( select MC0000 from BM_TYZD00 where zdmc00='门诊处方查询处方类别维护配置' and YXBZ00=1 and bh0000=B.GHLB00) GHLBMC ,DECODE(C.LYRQSJ,NULL,NULL,substrb(C.LYRQSJ,9,16)||' '||substrb(C.LYRQSJ,1,4)||'-'||substrb(C.LYRQSJ,5,2)||'-'||substrb(C.LYRQSJ,7,2)) LYRQSJ ,( select X.CZSJ00||' '||substrb(X.CZRQ00,1,4)||'-'||substr(X.CZRQ00,5,2)||'-'||substr(X.CZRQ00,7,2) from yf_sqsfrz X where X.SQSFZT in ('2','5') and X.CFLSH0 = C.CFLSH0 and rownum = 1 ) SQSFSJ ,( select max(YYCWDJ) from YF_MZCFMX where CFLSH0=C.CFLSH0) YYCWDJ ,(select ZWXM00 from BM_YGBM00 where YGBH00=C.YYSFR0) YYSFR0 from SF_BRXXB0 B,YF_MZCF00 C,YF_CFDL00 R,BM_BMBM00 M,BM_YGBM00 G,BM_YGBM00 H,BM_YPLB00 d,YS_BRBQB0 A WHERE C.YFBMBH+0=495 AND C.FYRQ00>='20240101' AND C.FYRQ00<='20241231' AND (C.CFXZ00='0' or C.cfdgs0='1' or C.cfdgs0='0' ) AND C.GHKS00=M.BMBH00 AND C.FHR000=G.YGBH00(+) AND C.GHID00=B.GHID00 AND C.CFLSH0=R.CFLSH0(+) AND C.FYR000=H.YGBH00(+) AND c.YPDLBH=d.lbbh00 AND C.GHID00=A.GHID00(+) and C.SFKSLY='N' 93 11:35:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 94 11:35:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 95 11:35:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61584894.000000 96 11:35:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 97 11:35:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61584894.00) 98 11:45:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 99 11:45:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 100 11:45:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61585576.000000 101 11:45:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 102 11:45:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61585576.00) 103 11:55:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 104 11:55:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 105 11:55:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61586237.000000 106 11:55:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 107 11:55:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61586237.00) 108 12:05:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 109 12:05:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 110 12:05:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61586695.000000 111 12:05:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 112 12:05:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61586695.00) 113 12:15:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 114 12:15:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 115 12:15:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61587329.000000 116 12:15:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 117 12:15:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61587329.00) 118 12:25:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 119 12:25:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 120 12:25:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61587752.000000 121 12:25:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 122 12:25:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61587752.00) 123 12:35:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 124 12:35:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 125 12:35:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61588278.000000 126 12:35:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 127 12:35:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61588278.00) 128 12:45:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 129 12:45:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 130 12:45:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61588680.000000 131 12:45:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 132 12:45:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61588680.00) 133 12:55:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 134 12:55:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 135 12:55:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61589173.000000 136 12:55:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 137 12:55:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61589173.00) 138 13:05:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 139 13:05:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 140 13:05:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61589682.000000 141 13:05:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 142 13:05:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61589682.00) 143 13:15:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 144 13:15:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 145 13:15:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61590086.000000 146 13:15:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 147 13:15:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61590086.00) 148 13:25:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 149 13:25:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 150 13:25:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61590584.000000 151 13:25:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 152 13:25:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61590584.00) 153 13:35:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 154 13:35:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 155 13:35:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61590991.000000 156 13:35:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 157 13:35:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61590991.00) 158 13:45:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 159 13:45:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 160 13:45:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61591492.000000 161 13:45:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 162 13:45:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61591492.00) 163 13:55:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 164 13:55:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 165 13:55:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61591885.000000 166 13:55:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 167 13:55:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61591885.00) 168 14:05:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 169 14:05:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 170 14:05:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61592390.000000 171 14:05:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 172 14:05:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61592390.00) 173 14:15:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 174 14:15:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 175 14:15:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61592893.000000 176 14:15:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 177 14:15:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61592893.00) 178 14:25:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 179 14:25:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 180 14:25:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61593284.000000 181 14:25:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 182 14:25:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61593284.00) 183 14:35:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 184 14:35:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 185 14:35:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61593782.000000 186 14:35:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 187 14:35:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61593782.00) 188 14:45:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 189 14:45:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 190 14:45:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61594317.000000 191 14:45:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 192 14:45:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61594317.00) 193 14:55:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 194 14:55:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 195 14:55:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61594857.000000 196 14:55:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 197 14:55:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61594857.00) 198 15:05:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 199 15:05:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 200 15:05:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61595303.000000 201 15:05:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 202 15:05:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61595303.00) 203 15:15:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 204 15:15:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 205 15:15:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61595947.000000 206 15:15:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 207 15:15:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61595947.00) 208 15:25:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 209 15:25:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 210 15:25:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61596388.000000 211 15:25:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 212 15:25:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61596388.00) 213 15:35:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 214 15:35:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 215 15:35:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61596938.000000 216 15:35:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 217 15:35:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61596938.00) 218 15:45:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 219 15:45:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 220 15:45:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61597494.000000 221 15:45:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 222 15:45:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61597494.00) 223 15:55:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 224 15:55:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 225 15:55:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61598055.000000 226 15:55:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 227 15:55:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61598055.00) 228 16:05:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 229 16:05:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 230 16:05:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61598723.000000 231 16:05:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 232 16:05:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61598723.00) 233 16:15:51 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 234 16:15:51 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 495.000000 235 16:15:51 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61599184.000000 236 16:15:51 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 237 16:15:51 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1913 and CZXH00 = 61599184.00)