1 20:52:03 SQL Execute: ORACLE - select nvl(max(TJH000),0) TJH000 from VW_PE_HISTJZ where BRID00 = 10382840.00 2 20:52:04 SQL Execute: ORACLE - select nvl(max(ZXKSBH),0) as ZXKSBH,nvl(max(KDYSBH),0) as KDYSBH from VW_PE_HISXM0 where TJH000=668755.00 3 20:52:04 SQL Data In: ORACLE - Param = 1, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 327.000000 4 20:52:04 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 107.000000 5 20:52:04 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10382840.000000 6 20:52:04 SQL Data In: ORACLE - Param = 4, Name = PTJH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 668755 7 20:52:04 SQL Data In: ORACLE - Param = 5, Name = PCZLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 8 20:52:04 SQL Data In: ORACLE - Param = 6, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 9 20:52:04 SQL Data In: ORACLE - Param = 7, Name = PID0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 10 20:52:04 SQL Data In: ORACLE - Param = 8, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 11 20:52:04 SQL Data In: ORACLE - Param = 9, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 12 20:52:04 SQL Data In: ORACLE - Param = 10, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 13 20:52:04 SQL Execute: ORACLE - BEGIN "SP_HIS_TJSFXM" (PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PBRID00 => :PBRID00,PTJH000 => :PTJH000,PCZLX00 => :PCZLX00,PCOMMIT => :PCOMMIT,PID0000 => :PID0000,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 14 20:52:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10382840.000000 15 20:52:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 16 20:52:04 SQL Execute: ORACLE - select E.CSLX00,A.KHRQ00,A.XJYE00,A.ZZYE00,A.YXQFJE,A.TYJE00,SF_SF_GETKYJE(A.BRID00,1,1,1) as KYJE00,(A.ZYE000-a.TYJE00) as ZHZYE0,B.JFLBMC,D.FBMC00,e.YBMC00, C.BRCSRQ,C.FBBH00,C.BRZJBH,C.BRBLH0,C.BRXM00,C.BRXB00,C.YBKH00,C.YBID00,C.YBLB00,C.YBBRLB,C.BRZTQK from SF_BRZHXX A,BM_BRJFLB B,BM_BRXXB0 C,bm_brfbb0 D,ic_ybbrlb E where A.JFLBID = B.JFLBID and C.FBBH00 = D.FBBH00 and C.fbbh00=E.fbbh00 and C.yblb00=E.yblb00 and A.BRID00 = C.BRID00 and A.SFDJ00 <> '2' and A.BRID00 = ? and A.JFLBID = ? 17 20:52:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10382840.000000 18 20:52:04 SQL Execute: ORACLE - select TBLBMC from VW_BM_BRXXB2 where BRID00 =? 19 20:52:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10382840.000000 20 20:52:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211026 21 20:52:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211101 22 20:52:04 SQL Execute: ORACLE - select CFLSH0 from YF_MZCF00 where BRID00=? and CFZT00 = '0' and SRRQ00>= ? and SRRQ00<= ? 23 20:52:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10382840.000000 24 20:52:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 25 20:52:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170317 26 20:52:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211101 27 20:52:04 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000000001.000000 28 20:52:04 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10382840.000000 29 20:52:04 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10382840.000000 30 20:52:04 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211026 31 20:52:04 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211101 32 20:52:04 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 33 20:52:04 SQL Execute: ORACLE - select * from ( select a.GHH000,a.FPXMMC,a.XMMC00,a.XMDJ00,a.XMDW00,a.XMSL00,a.HJJE00,a.ZFBL00,a.ZFJE00,a.JJSJ00, a.KDKSMC,a.KDYSXM,a.DJH000,a.TSBZBH,a.TSBZMC,a.ZLXMJC, a.MZFPID,a.JZBZ00,a.JZJE00,a.GFJE00,to_char(a.YJDJH0) as YJDJH0,a.SFLB00,a.MXID00,a.CXBZ00,a.OMXID0,a.CFDGS0,a.ZXKSMC, a.CZRQ00,a.JZZTMC,a.TCNWJC,nvl(a.TCID00,0) as TCID00,a.TCXMMC from VW_SF_WJSFYMX a where a.BRID00 = ? and a.JFLBID = ? and a.CZRQ00>= ? and a.CZRQ00<= ? and a.XMBH00+0 <> ? and a.GHH000 = 'TJ668755' union all select a.GHH000,a.FPXMMC,a.SFXMMC,a.XMDJ00,a.XMDW00,a.XMSL00,a.AMOUNT,a.ZFBL00,a.ZFJE00,a.JJSJ00, a.BMMC00 KDKSMC,a.KDYSXM,0 DJH000,a.TSBZBH,a.TSBZMC,a.ZLXMJC, a.FPXMID,a.JZBZ00,a.JZJE00,a.GFJE00,to_char(A.YJDJH0),a.JSXM00 SFLB00,a.ID0000 MXID00,'Z',0,a.CFDGS0,a.YJKSMC, a.KDRQ00,a.JZZTMC,'' as TCNWJC,nvl(a.TCID00,0) as TCID00,a.TCXMMC from VW_SF_YJYWMX a where a.CXDJH0 is null and A.BRID00 = ? and a.GHH000 = 'TJ668755' union all select a.GHH000,a.FPXMMC,a.YPMC00,a.LSDJ00,a.CFDW00,a.YPZSL0,a.AMOUNT,a.ZFBL00,a.ZFJE00,a.JJSJ00, a.KDKSMC,a.YSXM00,0 DJH000,a.TSBZBH,a.TSBZMC,FPXMMC ZLXMJC, a.FPXMID,a.JZBZ00,a.JZJE00,a.GFJE00,a.CFLSH0,a.SFLB00,CFID00 MXID00,'Z',0,a.CFDGS0,a.BMMC00, a.SRRQ00,a.JZZTMC,'' as TCNWJC,0 as TCID00,null as TCXMMC from VW_SF_CFMX00 a where a.BCCFH0 is null and a.THBZ00='0' and a.BRID00 = ? and a.SRRQ00>= ? and a.SRRQ00<= ? and a.SRRQ00>= to_char(sysdate-?,'YYYYMMDD') and a.GHH000 = 'TJ668755' ) order by GHH000,JZBZ00,MZFPID,CFDGS0,YJDJH0,MXID00,ZLXMJC 34 20:52:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = TJ668755 35 20:52:04 SQL Execute: ORACLE - select a.GHH000,substr(SF_SF_GETRQSJ(A.GHRQ00,A.GHSJ00),1,50) GHRQSJ,a.GHRQ00,b.bmmc00 GHKSMC, nvl((select YBBMMC from BM_YBKSBM where YBBMBH=b.YBKSBH and rownum=1),b.BMMC00) as YBGHKS, (select zwxm00 from BM_YGBM00 where ygbh00=a.jzys00) JZYSXM,a.GHYXM0,a.YBGHH0, (select mc0000 from VW_SF_TSBZB0 where BH0000=a.TSBZBH and YBZXLB=a.YBZXLB) TSBZMC, a.TSBZBH,a.GHKS00, (select LBMC00 from BM_GHLBB0 where LBBH00=a.GHLB00) GHLBMC,a.GHSJ00,a.BXLB00,a.GHID00, (select nvl(min(JZRQ00),a.GHRQ00) from SF_JZB000 where MZID00=a.GHID00 and HJJE00>0 and nvl(YBGHH0,'0')<>'0' and YBGHH0=a.YBGHH0) YBJZRQ,0 BCSFCS, decode((select ZDMC00 from YS_BRZDXX where GHH000=a.GHH000 and ZZDBZ0='3' and rownum=1),'',(select ZDMC00 from YS_BRZDXX where GHH000=a.GHH000 and ZZDBZ0='1' and rownum=1), (select ZDMC00 from YS_BRZDXX where GHH000=a.GHH000 and ZZDBZ0='3' and rownum=1)) as ZDMC00 from sf_brxxb0 a,BM_BMBM00 b where a.GHH000 = ? and a.GHKS00=b.bmbh00 order by a.GHID00 36 20:52:04 SQL Execute: ORACLE - select SF_SF_GETYNFPPJXH(121,32) as PJXH00 from dual 37 20:52:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10382840.000000 38 20:52:04 SQL Execute: ORACLE - select SF_SF_GETKYJE(a.BRID00,1,1,1) as KYJE00,(A.ZYE000-a.TYJE00) as ZHZYE0,a.* from sf_brzhxx a where jflbid = 1 and brid00=?