1 09:40:35 SQL Execute: ORACLE - select distinct A.PYRQ00,A.YBH000 from VW_JY_JYJG00 A,VW_JY_YW0000 B where A.JYYWID=B.JYYWID and A.SFCJJZ||'B'='YB' and B.JGZT00||'A' in ('6A', '8A', '9A') and (ceil((sysdate-to_date(BGRQ00||' '||BGSJ00,'YYYY-MM-DD HH24-MI-SS'))*24*60)>=5) and B.BGCKSJ is null and TXKWJZ='0' order by A.PYRQ00,A.YBH000 2 09:40:35 SQL Execute: ORACLE - select BGVIEW from JY_JYYQZD where YQDH00='AU' 3 09:40:35 SQL Execute: ORACLE - select Y.*,substr(BRLX00,1,1)||' '||substr(BRLX00,2,1)||' บล:' BRLXMC, substr(SQRQ00,1,4)||'.'||substr(SQRQ00,5,2)||'.'||substr(SQRQ00,7,2) SQ0000, substr(PYRQ00,1,4)||'.'||substr(PYRQ00,5,2)||'.'||substr(PYRQ00,7,2) PY0000, substr(CBGRQ0,1,4)||'.'||substr(CBGRQ0,5,2)||'.'||substr(CBGRQ0,7,2)||' '||CBGSJ0 BG0000 from VW_JY_YW0000 Y WHERE YBH000='AU0001' and PYRQ00='20210204' and rownum=1 4 09:40:35 SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'AU0001' and PYRQ00 = '20210204' 5 09:40:35 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,42440,42440) 6 09:40:35 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='AU0001' and pyrq00='20210204' ORDER BY DYSX00 7 09:40:35 SQL Execute: ORACLE - select decode(sign(to_date(to_char(sysdate,'YYYYMMDD')||' '||'23:00:00','YYYYMMDD HH24:MI:SS')-sysdate),1,'A','B') from dual 8 09:40:35 SQL Execute: ORACLE - select SF_JY_PDJHRS(14) from dual 9 09:40:35 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where ZT0000='0' and flag00='J' and jqbh00=14 10 09:40:35 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where cyckbh=5 and jhbz00 in ('1','3','7','8') 11 09:40:35 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14 12 09:40:35 SQL Execute: ORACLE - select * from VW_JY_PDJHB0 where CYCKBH='5' and JHBZ00<>'2' 13 09:40:35 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00<>'2' 14 09:40:35 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and CYCKBH='5' and JHBZ00='2' 15 09:40:35 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00='2' 16 09:40:35 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00='2' and CYCKBH in (select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14) order by DJSJ00 desc 17 09:40:35 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00<>'2' order by DJSJ00 desc 18 09:40:35 SQL Execute: ORACLE - SELECT QZMC00 FROM JY_QDXHQZ WHERE CJXQ00 = (SELECT to_char(sysdate,'day') FROM DUAL) 19 09:40:36 SQL Execute: ORACLE - select BGVIEW from JY_JYYQZD where YQDH00='AU' 20 09:40:36 SQL Execute: ORACLE - select Y.*,substr(BRLX00,1,1)||' '||substr(BRLX00,2,1)||' บล:' BRLXMC, substr(SQRQ00,1,4)||'.'||substr(SQRQ00,5,2)||'.'||substr(SQRQ00,7,2) SQ0000, substr(PYRQ00,1,4)||'.'||substr(PYRQ00,5,2)||'.'||substr(PYRQ00,7,2) PY0000, substr(CBGRQ0,1,4)||'.'||substr(CBGRQ0,5,2)||'.'||substr(CBGRQ0,7,2)||' '||CBGSJ0 BG0000 from VW_JY_YW0000 Y WHERE YBH000='AU0001' and PYRQ00='20210204' and rownum=1 21 09:40:36 SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'AU0001' and PYRQ00 = '20210204' 22 09:40:36 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,42440,42440) 23 09:40:36 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='AU0001' and pyrq00='20210204' ORDER BY DYSX00 24 09:40:38 SQL Execute: ORACLE - select BGVIEW from JY_JYYQZD where YQDH00='AU' 25 09:40:38 SQL Execute: ORACLE - select Y.*,substr(BRLX00,1,1)||' '||substr(BRLX00,2,1)||' บล:' BRLXMC, substr(SQRQ00,1,4)||'.'||substr(SQRQ00,5,2)||'.'||substr(SQRQ00,7,2) SQ0000, substr(PYRQ00,1,4)||'.'||substr(PYRQ00,5,2)||'.'||substr(PYRQ00,7,2) PY0000, substr(CBGRQ0,1,4)||'.'||substr(CBGRQ0,5,2)||'.'||substr(CBGRQ0,7,2)||' '||CBGSJ0 BG0000 from VW_JY_YW0000 Y WHERE YBH000='AU0001' and PYRQ00='20210204' and rownum=1 26 09:40:38 SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'AU0001' and PYRQ00 = '20210204' 27 09:40:38 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,42440,42440) 28 09:40:38 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='AU0001' and pyrq00='20210204' ORDER BY DYSX00 29 09:40:38 SQL Execute: ORACLE - select decode(sign(to_date(to_char(sysdate,'YYYYMMDD')||' '||'23:00:00','YYYYMMDD HH24:MI:SS')-sysdate),1,'A','B') from dual 30 09:40:38 SQL Execute: ORACLE - select SF_JY_PDJHRS(14) from dual 31 09:40:38 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where ZT0000='0' and flag00='J' and jqbh00=14 32 09:40:38 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where cyckbh=5 and jhbz00 in ('1','3','7','8') 33 09:40:38 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14 34 09:40:38 SQL Execute: ORACLE - select * from VW_JY_PDJHB0 where CYCKBH='5' and JHBZ00<>'2' 35 09:40:38 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00<>'2' 36 09:40:38 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and CYCKBH='5' and JHBZ00='2' 37 09:40:38 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00='2' 38 09:40:38 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00='2' and CYCKBH in (select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14) order by DJSJ00 desc 39 09:40:38 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00<>'2' order by DJSJ00 desc 40 09:40:41 SQL Execute: ORACLE - select distinct A.PYRQ00,A.YBH000 from VW_JY_JYJG00 A,VW_JY_YW0000 B where A.JYYWID=B.JYYWID and A.SFCJJZ||'B'='YB' and B.JGZT00||'A' in ('6A', '8A', '9A') and (ceil((sysdate-to_date(BGRQ00||' '||BGSJ00,'YYYY-MM-DD HH24-MI-SS'))*24*60)>=5) and B.BGCKSJ is null and TXKWJZ='0' order by A.PYRQ00,A.YBH000 41 09:40:41 SQL Execute: ORACLE - select decode(sign(to_date(to_char(sysdate,'YYYYMMDD')||' '||'23:00:00','YYYYMMDD HH24:MI:SS')-sysdate),1,'A','B') from dual 42 09:40:41 SQL Execute: ORACLE - select SF_JY_PDJHRS(14) from dual 43 09:40:41 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where ZT0000='0' and flag00='J' and jqbh00=14 44 09:40:41 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where cyckbh=5 and jhbz00 in ('1','3','7','8') 45 09:40:41 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14 46 09:40:41 SQL Execute: ORACLE - select * from VW_JY_PDJHB0 where CYCKBH='5' and JHBZ00<>'2' 47 09:40:41 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00<>'2' 48 09:40:41 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and CYCKBH='5' and JHBZ00='2' 49 09:40:41 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00='2' 50 09:40:41 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00='2' and CYCKBH in (select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14) order by DJSJ00 desc 51 09:40:41 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00<>'2' order by DJSJ00 desc 52 09:40:44 SQL Execute: ORACLE - select decode(sign(to_date(to_char(sysdate,'YYYYMMDD')||' '||'23:00:00','YYYYMMDD HH24:MI:SS')-sysdate),1,'A','B') from dual 53 09:40:44 SQL Execute: ORACLE - select SF_JY_PDJHRS(14) from dual 54 09:40:44 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where ZT0000='0' and flag00='J' and jqbh00=14 55 09:40:44 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where cyckbh=5 and jhbz00 in ('1','3','7','8') 56 09:40:44 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14 57 09:40:44 SQL Execute: ORACLE - select * from VW_JY_PDJHB0 where CYCKBH='5' and JHBZ00<>'2' 58 09:40:44 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00<>'2' 59 09:40:44 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and CYCKBH='5' and JHBZ00='2' 60 09:40:44 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00='2' 61 09:40:44 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00='2' and CYCKBH in (select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14) order by DJSJ00 desc 62 09:40:44 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00<>'2' order by DJSJ00 desc 63 09:40:45 SQL Execute: ORACLE - Select * From VW_JY_YGQXZD where YGBH00='1057' and QXLX00='JGCL' and QXGNDH='JGDY' 64 09:40:45 SQL Execute: ORACLE - Select * From VW_JY_YGQXZD where YGBH00='1057' and QXLX00='JGCL' and QXGNDH='TJBG' 65 09:40:45 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20210204','AU0001') from dual 66 09:40:45 SQL Execute: ORACLE - select BGVIEW from JY_JYYQZD where YQDH00='AU' 67 09:40:45 SQL Execute: ORACLE - select Y.*,substr(BRLX00,1,1)||' '||substr(BRLX00,2,1)||' บล:' BRLXMC, substr(SQRQ00,1,4)||'.'||substr(SQRQ00,5,2)||'.'||substr(SQRQ00,7,2) SQ0000, substr(PYRQ00,1,4)||'.'||substr(PYRQ00,5,2)||'.'||substr(PYRQ00,7,2) PY0000, substr(CBGRQ0,1,4)||'.'||substr(CBGRQ0,5,2)||'.'||substr(CBGRQ0,7,2)||' '||CBGSJ0 BG0000 from VW_JY_YW0000 Y WHERE YBH000='AU0001' and PYRQ00='20210204' and rownum=1 68 09:40:45 SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'AU0001' and PYRQ00 = '20210204' 69 09:40:45 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,42440,42440) 70 09:40:45 SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00 WHERE ybh000='AU0001' and pyrq00='20210204' ORDER BY DYSX00 71 09:40:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = JY_DYYLSFZDGB 72 09:40:45 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 73 09:40:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = JY_DYJSZBCFS 74 09:40:45 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 75 09:40:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 15, Scale = 0, Data = JY_JYDYSFDYFCJG 76 09:40:45 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 77 09:40:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = JY_JGCLDYYLBDYSFGXZT 78 09:40:45 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 79 09:40:45 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JYBGDYSTSFCYGCTQNR') 80 09:40:45 SQL Execute: ORACLE - select DISTINCT YQDH00 from JY_YW0000 a where a.JYYWID in (0,18594,18597) 81 09:40:45 SQL Execute: ORACLE - select BGYS00,BGMC00,YQSM00, HYSL00, BGVIEW from JY_JYYQZD where YQDH00='AU' 82 09:40:45 SQL Execute: ORACLE - select distinct decode(sign(count(*)-0),1,'>',0,'=','-1','<') FH from VW_JY_JYJG00 where (YBH000,PYRQ00) in (select distinct YBH000,PYRQ00 from JY_YW0000 A where a.JYYWID in (0,18594,18597) and YQDH00='AU') group by YBH000,PYRQ00 83 09:40:45 SQL Execute: ORACLE - select * from (select DISTINCT a.brxm00,a.ybh000,a.pyrq00,0 bgdh00,(select nvl(SQBQ00,0) from jy_yw0000 where ybh000=a.ybh000 and pyrq00=a.pyrq00 and rownum=1) sqbq00 from JY_YW0000 a where JYYWID in (0,18594,18597) and (YBH000,PYRQ00) in (select YBH000,PYRQ00 from JY_JYJG00 where (YBH000,PYRQ00) in (select distinct YBH000,PYRQ00 from JY_YW0000 A where a.JYYWID in (0,18594,18597) and YQDH00='AU') group by YBH000,PYRQ00 having count(*) > 0) and not exists (select 1 from jy_jyjg00 where pyrq00=a.pyrq00 AND ybh000=a.ybh000 and bgxmid in (888888,888887,888886,888885) and jyywid=a.jyywid) ) order by pyrq00,ybh000 84 09:40:45 SQL Execute: ORACLE - select Y.*, (select decode(lengthb(trim(BRLXDH)),11,BRLXDH,decode(BRDH00,'0',null,BRDH00)) from BM_BRXXB0 where BRID00=Y.BRID00) BRDH00 from(select distinct A.BRID00,A.BRXM00,A.YBH000,A.PYRQ00,0 BGDH00, (select nvl(SQBQ00,0) from JY_YW0000 where YBH000=A.YBH000 and PYRQ00=A.PYRQ00 and rownum=1) SQBQ00 from JY_YW0000 a where JYYWID in (0,18594,18597) and (YBH000,PYRQ00) in (select YBH000,PYRQ00 from JY_JYJG00 where (YBH000,PYRQ00) in (select distinct YBH000,PYRQ00 from JY_YW0000 A where a.JYYWID in (0,18594,18597) and YQDH00='AU') group by YBH000,PYRQ00 having count(*) > 0) ) Y order by PYRQ00,YBH000 85 09:40:45 SQL Execute: ORACLE - select photo1,bgxmid,ybh000,pyrq00 from jy_jyjg00 where 1=1 and YQDH00='AU' and JYYWID in (0,18594,18597) and (YBH000,PYRQ00) in (select YBH000,PYRQ00 from JY_JYJG00 where (YBH000,PYRQ00) in (select distinct YBH000,PYRQ00 from JY_YW0000 A where a.JYYWID in (0,18594,18597) and YQDH00='AU') group by YBH000,PYRQ00 having count(*) > 0) and (bgxmid>=999988 or bgxmid in (888888,888887,888886,888885)) and photo1 is not null and nvl(jyywid,0)<>0 86 09:40:45 SQL Execute: ORACLE - commit 87 09:40:45 SQL Data In: ORACLE - Rows affected = 0 88 09:40:45 SQL Execute: ORACLE - select distinct decode(PDFBZ0,'0','0',YBH000) YBH000,decode(PDFBZ0,'0','0',PYRQ00) PYRQ00,BRID00,BRXM00,PDFBZ0 from(select distinct YBH000,PYRQ00,SF_JY_GETPDFFlAG(PYRQ00,YBH000) PDFBZ0, (select BRID00 from JY_YW0000 where JYYWID=A.JYYWID) BRID00, (select BRXM00 from JY_YW0000 where JYYWID=A.JYYWID) BRXM00 from JY_YW0000 A where 1 = 1 and JYYWID in (0,18594,18597) and (YBH000,PYRQ00) in (select YBH000,PYRQ00 from JY_JYJG00 where (YBH000,PYRQ00) in (select distinct YBH000,PYRQ00 from JY_YW0000 A where a.JYYWID in (0,18594,18597) and YQDH00='AU') group by YBH000,PYRQ00 having count(*) > 0) and nvl(JYYWID, 0) <> 0 ) 89 09:40:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 15, Scale = 0, Data = JY_JYDYSFDYFCJG 90 09:40:45 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 91 09:40:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 92 09:40:45 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 93 09:40:45 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 a where YBH000=? and PYRQ00=? 94 09:40:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 95 09:40:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 96 09:40:46 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 a where YBH000=? and PYRQ00=? 97 09:40:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 98 09:40:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 99 09:40:46 SQL Execute: ORACLE - select A.*,A.BRLX00||'บล:' BRLXMC, decode(NL0000,'0','',NL0000||NLDWMC) NLDWQC from VW_JY_YW0000 A where A.PYRQ00=? and A.YBH000=? and BRID00=2736595 and rownum=1 100 09:40:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 101 09:40:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 102 09:40:46 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 103 09:40:46 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 104 09:40:46 SQL Execute: ORACLE - SELECT C.*, rownum,(SELECT count(*) FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ) ROWCOUNT FROM (SELECT * FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ORDER BY DYSX00) C 105 09:40:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 106 09:40:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 107 09:40:46 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 108 09:40:46 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 109 09:40:46 SQL Execute: ORACLE - SELECT C.*, rownum,(SELECT count(*) FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ) ROWCOUNT FROM (SELECT * FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ORDER BY DYSX00) C 110 09:40:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 111 09:40:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 112 09:40:46 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 a where YBH000=? and PYRQ00=? 113 09:40:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 114 09:40:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 115 09:40:46 SQL Execute: ORACLE - select A.*,A.BRLX00||'บล:' BRLXMC, decode(NL0000,'0','',NL0000||NLDWMC) NLDWQC from VW_JY_YW0000 A where A.PYRQ00=? and A.YBH000=? and BRID00=2736595 and rownum=1 116 09:40:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 117 09:40:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 118 09:40:46 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 119 09:40:46 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 120 09:40:46 SQL Execute: ORACLE - SELECT C.*, rownum,(SELECT count(*) FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ) ROWCOUNT FROM (SELECT * FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ORDER BY DYSX00) C 121 09:40:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 122 09:40:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 123 09:40:46 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 a where YBH000=? and PYRQ00=? 124 09:40:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 125 09:40:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 126 09:40:46 SQL Execute: ORACLE - select A.*,A.BRLX00||'บล:' BRLXMC, decode(NL0000,'0','',NL0000||NLDWMC) NLDWQC from VW_JY_YW0000 A where A.PYRQ00=? and A.YBH000=? and BRID00=2736595 and rownum=1 127 09:40:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 128 09:40:47 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 129 09:40:47 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 130 09:40:47 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 131 09:40:47 SQL Execute: ORACLE - select a.*, (select count(*) w from VW_JY_JYJG00 where YBH000=? and PYRQ00=? and JGLX00<>'S') + ROWNUM "ROWNUM" from VW_JY_JYJG00 a where PYRQ00=? and YBH000=? and JGLX00='S' 132 09:40:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 133 09:40:47 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 134 09:40:47 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999997' 135 09:40:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 136 09:40:47 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 137 09:40:47 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND BGXMID = '999998' 138 09:40:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 139 09:40:47 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 140 09:40:47 SQL Execute: ORACLE - SELECT pic000 photo1 FROM jy_pic000 WHERE PYRQ00=? AND YBH000=? AND BGXMID = '999999' 141 09:40:51 SQL Execute: ORACLE - select distinct A.PYRQ00,A.YBH000 from VW_JY_JYJG00 A,VW_JY_YW0000 B where A.JYYWID=B.JYYWID and A.SFCJJZ||'B'='YB' and B.JGZT00||'A' in ('6A', '8A', '9A') and (ceil((sysdate-to_date(BGRQ00||' '||BGSJ00,'YYYY-MM-DD HH24-MI-SS'))*24*60)>=5) and B.BGCKSJ is null and TXKWJZ='0' order by A.PYRQ00,A.YBH000 142 09:40:51 SQL Execute: ORACLE - select decode(sign(to_date(to_char(sysdate,'YYYYMMDD')||' '||'23:00:00','YYYYMMDD HH24:MI:SS')-sysdate),1,'A','B') from dual 143 09:40:51 SQL Execute: ORACLE - select SF_JY_PDJHRS(14) from dual 144 09:40:51 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where ZT0000='0' and flag00='J' and jqbh00=14 145 09:40:51 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where cyckbh=5 and jhbz00 in ('1','3','7','8') 146 09:40:51 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14 147 09:40:51 SQL Execute: ORACLE - select * from VW_JY_PDJHB0 where CYCKBH='5' and JHBZ00<>'2' 148 09:40:51 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00<>'2' 149 09:40:51 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and CYCKBH='5' and JHBZ00='2' 150 09:40:51 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00='2' 151 09:40:51 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00='2' and CYCKBH in (select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14) order by DJSJ00 desc 152 09:40:51 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00<>'2' order by DJSJ00 desc 153 09:40:54 SQL Execute: ORACLE - select decode(sign(to_date(to_char(sysdate,'YYYYMMDD')||' '||'23:00:00','YYYYMMDD HH24:MI:SS')-sysdate),1,'A','B') from dual 154 09:40:54 SQL Execute: ORACLE - select SF_JY_PDJHRS(14) from dual 155 09:40:54 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where ZT0000='0' and flag00='J' and jqbh00=14 156 09:40:54 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where cyckbh=5 and jhbz00 in ('1','3','7','8') 157 09:40:54 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14 158 09:40:54 SQL Execute: ORACLE - select * from VW_JY_PDJHB0 where CYCKBH='5' and JHBZ00<>'2' 159 09:40:54 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00<>'2' 160 09:40:54 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and CYCKBH='5' and JHBZ00='2' 161 09:40:54 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00='2' 162 09:40:54 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00='2' and CYCKBH in (select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14) order by DJSJ00 desc 163 09:40:54 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00<>'2' order by DJSJ00 desc 164 09:40:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 165 09:40:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 166 09:40:56 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 167 09:40:56 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 168 09:40:56 SQL Execute: ORACLE - SELECT C.*, rownum,(SELECT count(*) FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ) ROWCOUNT FROM (SELECT * FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ORDER BY DYSX00) C 169 09:40:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 170 09:40:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 171 09:40:56 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 a where YBH000=? and PYRQ00=? 172 09:40:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 173 09:40:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 174 09:40:56 SQL Execute: ORACLE - select A.*,A.BRLX00||'บล:' BRLXMC, decode(NL0000,'0','',NL0000||NLDWMC) NLDWQC from VW_JY_YW0000 A where A.PYRQ00=? and A.YBH000=? and BRID00=2736595 and rownum=1 175 09:40:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 176 09:40:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 177 09:40:56 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 178 09:40:56 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 179 09:40:56 SQL Execute: ORACLE - SELECT C.*, rownum,(SELECT count(*) FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ) ROWCOUNT FROM (SELECT * FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ORDER BY DYSX00) C 180 09:40:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 181 09:40:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 182 09:40:56 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 a where YBH000=? and PYRQ00=? 183 09:40:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 184 09:40:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 185 09:40:56 SQL Execute: ORACLE - select A.*,A.BRLX00||'บล:' BRLXMC, decode(NL0000,'0','',NL0000||NLDWMC) NLDWQC from VW_JY_YW0000 A where A.PYRQ00=? and A.YBH000=? and BRID00=2736595 and rownum=1 186 09:40:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 187 09:40:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 188 09:40:56 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 189 09:40:56 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 190 09:40:56 SQL Execute: ORACLE - SELECT C.*, rownum,(SELECT count(*) FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ) ROWCOUNT FROM (SELECT * FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ORDER BY DYSX00) C 191 09:40:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 192 09:40:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 193 09:40:56 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 a where YBH000=? and PYRQ00=? 194 09:40:56 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 195 09:40:56 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 196 09:40:56 SQL Execute: ORACLE - select A.*,A.BRLX00||'บล:' BRLXMC, decode(NL0000,'0','',NL0000||NLDWMC) NLDWQC from VW_JY_YW0000 A where A.PYRQ00=? and A.YBH000=? and BRID00=2736595 and rownum=1 197 09:40:57 SQL Execute: ORACLE - select distinct A.PYRQ00,A.YBH000 from VW_JY_JYJG00 A,VW_JY_YW0000 B where A.JYYWID=B.JYYWID and A.SFCJJZ||'B'='YB' and B.JGZT00||'A' in ('6A', '8A', '9A') and (ceil((sysdate-to_date(BGRQ00||' '||BGSJ00,'YYYY-MM-DD HH24-MI-SS'))*24*60)>=5) and B.BGCKSJ is null and TXKWJZ='0' order by A.PYRQ00,A.YBH000 198 09:40:57 SQL Execute: ORACLE - select decode(sign(to_date(to_char(sysdate,'YYYYMMDD')||' '||'23:00:00','YYYYMMDD HH24:MI:SS')-sysdate),1,'A','B') from dual 199 09:40:57 SQL Execute: ORACLE - select SF_JY_PDJHRS(14) from dual 200 09:40:57 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where ZT0000='0' and flag00='J' and jqbh00=14 201 09:40:57 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where cyckbh=5 and jhbz00 in ('1','3','7','8') 202 09:40:57 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14 203 09:40:57 SQL Execute: ORACLE - select * from VW_JY_PDJHB0 where CYCKBH='5' and JHBZ00<>'2' 204 09:40:57 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00<>'2' 205 09:40:57 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and CYCKBH='5' and JHBZ00='2' 206 09:40:57 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00='2' 207 09:40:57 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00='2' and CYCKBH in (select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14) order by DJSJ00 desc 208 09:40:57 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00<>'2' order by DJSJ00 desc 209 09:41:00 SQL Execute: ORACLE - select decode(sign(to_date(to_char(sysdate,'YYYYMMDD')||' '||'23:00:00','YYYYMMDD HH24:MI:SS')-sysdate),1,'A','B') from dual 210 09:41:00 SQL Execute: ORACLE - select SF_JY_PDJHRS(14) from dual 211 09:41:00 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where ZT0000='0' and flag00='J' and jqbh00=14 212 09:41:00 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where cyckbh=5 and jhbz00 in ('1','3','7','8') 213 09:41:00 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14 214 09:41:00 SQL Execute: ORACLE - select * from VW_JY_PDJHB0 where CYCKBH='5' and JHBZ00<>'2' 215 09:41:00 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00<>'2' 216 09:41:00 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and CYCKBH='5' and JHBZ00='2' 217 09:41:00 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00='2' 218 09:41:00 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00='2' and CYCKBH in (select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14) order by DJSJ00 desc 219 09:41:01 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00<>'2' order by DJSJ00 desc 220 09:41:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 15, Scale = 0, Data = JY_JYDYSFDYFCJG 221 09:41:03 SQL Execute: ORACLE - select trim(VALUE0) from XT_XTCS00 where NAME00 = ? 222 09:41:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 223 09:41:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 224 09:41:03 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 a where YBH000=? and PYRQ00=? 225 09:41:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 226 09:41:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 227 09:41:03 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 a where YBH000=? and PYRQ00=? 228 09:41:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 229 09:41:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 230 09:41:03 SQL Execute: ORACLE - select A.*,A.BRLX00||'บล:' BRLXMC, decode(NL0000,'0','',NL0000||NLDWMC) NLDWQC from VW_JY_YW0000 A where A.PYRQ00=? and A.YBH000=? and BRID00=2736596 and rownum=1 231 09:41:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 232 09:41:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 233 09:41:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 234 09:41:03 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 235 09:41:03 SQL Execute: ORACLE - SELECT C.*, rownum,(SELECT count(*) FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ) ROWCOUNT FROM (SELECT * FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ORDER BY DYSX00) C 236 09:41:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 237 09:41:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 238 09:41:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 239 09:41:03 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 240 09:41:03 SQL Execute: ORACLE - SELECT C.*, rownum,(SELECT count(*) FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ) ROWCOUNT FROM (SELECT * FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ORDER BY DYSX00) C 241 09:41:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 242 09:41:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 243 09:41:03 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 a where YBH000=? and PYRQ00=? 244 09:41:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 245 09:41:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 246 09:41:03 SQL Execute: ORACLE - select A.*,A.BRLX00||'บล:' BRLXMC, decode(NL0000,'0','',NL0000||NLDWMC) NLDWQC from VW_JY_YW0000 A where A.PYRQ00=? and A.YBH000=? and BRID00=2736596 and rownum=1 247 09:41:03 SQL Execute: ORACLE - select distinct A.PYRQ00,A.YBH000 from VW_JY_JYJG00 A,VW_JY_YW0000 B where A.JYYWID=B.JYYWID and A.SFCJJZ||'B'='YB' and B.JGZT00||'A' in ('6A', '8A', '9A') and (ceil((sysdate-to_date(BGRQ00||' '||BGSJ00,'YYYY-MM-DD HH24-MI-SS'))*24*60)>=5) and B.BGCKSJ is null and TXKWJZ='0' order by A.PYRQ00,A.YBH000 248 09:41:04 SQL Execute: ORACLE - select decode(sign(to_date(to_char(sysdate,'YYYYMMDD')||' '||'23:00:00','YYYYMMDD HH24:MI:SS')-sysdate),1,'A','B') from dual 249 09:41:04 SQL Execute: ORACLE - select SF_JY_PDJHRS(14) from dual 250 09:41:04 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where ZT0000='0' and flag00='J' and jqbh00=14 251 09:41:04 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where cyckbh=5 and jhbz00 in ('1','3','7','8') 252 09:41:04 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14 253 09:41:04 SQL Execute: ORACLE - select * from VW_JY_PDJHB0 where CYCKBH='5' and JHBZ00<>'2' 254 09:41:04 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00<>'2' 255 09:41:04 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and CYCKBH='5' and JHBZ00='2' 256 09:41:04 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00='2' 257 09:41:04 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00='2' and CYCKBH in (select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14) order by DJSJ00 desc 258 09:41:04 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00<>'2' order by DJSJ00 desc 259 09:41:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 260 09:41:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 261 09:41:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 262 09:41:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 263 09:41:04 SQL Execute: ORACLE - SELECT C.*, rownum,(SELECT count(*) FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ) ROWCOUNT FROM (SELECT * FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ORDER BY DYSX00) C 264 09:41:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 265 09:41:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 266 09:41:04 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 a where YBH000=? and PYRQ00=? 267 09:41:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 268 09:41:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 269 09:41:04 SQL Execute: ORACLE - select A.*,A.BRLX00||'บล:' BRLXMC, decode(NL0000,'0','',NL0000||NLDWMC) NLDWQC from VW_JY_YW0000 A where A.PYRQ00=? and A.YBH000=? and BRID00=2736596 and rownum=1 270 09:41:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 271 09:41:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 272 09:41:04 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 273 09:41:04 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 274 09:41:04 SQL Execute: ORACLE - select a.*, (select count(*) w from VW_JY_JYJG00 where YBH000=? and PYRQ00=? and JGLX00<>'S') + ROWNUM "ROWNUM" from VW_JY_JYJG00 a where PYRQ00=? and YBH000=? and JGLX00='S' 275 09:41:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 276 09:41:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 277 09:41:04 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where PYRQ00=? AND YBH000=? AND BGXMID = '999997' 278 09:41:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 279 09:41:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 280 09:41:04 SQL Execute: ORACLE - select pic000 photo1 from jy_pic000 where pyrq00=? AND YBH000=? AND BGXMID = '999998' 281 09:41:04 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 282 09:41:04 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 283 09:41:04 SQL Execute: ORACLE - SELECT pic000 photo1 FROM jy_pic000 WHERE PYRQ00=? AND YBH000=? AND BGXMID = '999999' 284 09:41:09 SQL Execute: ORACLE - SELECT QZMC00 FROM JY_QDXHQZ WHERE CJXQ00 = (SELECT to_char(sysdate,'day') FROM DUAL) 285 09:41:09 SQL Execute: ORACLE - select decode(sign(to_date(to_char(sysdate,'YYYYMMDD')||' '||'23:00:00','YYYYMMDD HH24:MI:SS')-sysdate),1,'A','B') from dual 286 09:41:09 SQL Execute: ORACLE - select SF_JY_PDJHRS(14) from dual 287 09:41:09 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where ZT0000='0' and flag00='J' and jqbh00=14 288 09:41:09 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where cyckbh=5 and jhbz00 in ('1','3','7','8') 289 09:41:09 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14 290 09:41:09 SQL Execute: ORACLE - select * from VW_JY_PDJHB0 where CYCKBH='5' and JHBZ00<>'2' 291 09:41:09 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00<>'2' 292 09:41:09 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and CYCKBH='5' and JHBZ00='2' 293 09:41:09 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00='2' 294 09:41:09 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00='2' and CYCKBH in (select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14) order by DJSJ00 desc 295 09:41:09 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00<>'2' order by DJSJ00 desc 296 09:41:09 SQL Execute: ORACLE - select distinct A.PYRQ00,A.YBH000 from VW_JY_JYJG00 A,VW_JY_YW0000 B where A.JYYWID=B.JYYWID and A.SFCJJZ||'B'='YB' and B.JGZT00||'A' in ('6A', '8A', '9A') and (ceil((sysdate-to_date(BGRQ00||' '||BGSJ00,'YYYY-MM-DD HH24-MI-SS'))*24*60)>=5) and B.BGCKSJ is null and TXKWJZ='0' order by A.PYRQ00,A.YBH000 297 09:41:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 298 09:41:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 299 09:41:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 300 09:41:10 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 301 09:41:10 SQL Execute: ORACLE - SELECT C.*, rownum,(SELECT count(*) FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ) ROWCOUNT FROM (SELECT * FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ORDER BY DYSX00) C 302 09:41:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 303 09:41:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 304 09:41:10 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 a where YBH000=? and PYRQ00=? 305 09:41:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 306 09:41:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 307 09:41:10 SQL Execute: ORACLE - select A.*,A.BRLX00||'บล:' BRLXMC, decode(NL0000,'0','',NL0000||NLDWMC) NLDWQC from VW_JY_YW0000 A where A.PYRQ00=? and A.YBH000=? and BRID00=2736596 and rownum=1 308 09:41:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 309 09:41:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 310 09:41:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 311 09:41:10 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 312 09:41:10 SQL Execute: ORACLE - SELECT C.*, rownum,(SELECT count(*) FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ) ROWCOUNT FROM (SELECT * FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ORDER BY DYSX00) C 313 09:41:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 314 09:41:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 315 09:41:10 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 a where YBH000=? and PYRQ00=? 316 09:41:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 317 09:41:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 318 09:41:10 SQL Execute: ORACLE - select A.*,A.BRLX00||'บล:' BRLXMC, decode(NL0000,'0','',NL0000||NLDWMC) NLDWQC from VW_JY_YW0000 A where A.PYRQ00=? and A.YBH000=? and BRID00=2736596 and rownum=1 319 09:41:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 320 09:41:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 321 09:41:10 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 322 09:41:10 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 323 09:41:10 SQL Execute: ORACLE - SELECT C.*, rownum,(SELECT count(*) FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ) ROWCOUNT FROM (SELECT * FROM (SELECT zlxmid,brid00,zlxmjc,ybh000,pyrq00,dysx00,bgxmid,bzbm00,bgxmmc,jgid00,jyywid,yjdjh0,zwmc00, ywmc00,ckxx00,cksx00,ckfw00,jglx00,ckznl0,ckzxb0,ckzbb0,ckzbl0,jd0000,xtzy00,xmsm00,ysjyjg,JYJG00, jyjg01,od0000,bgjyjg,jgdw00,jgzcbz,yqdh00,yqmc00,yqflzm,yqjc00,yqsm00,sector,cupnum,photo1,photo2, photo3,bgrq00,bgsj00,shr000,jgbz00,jyff00,yqjcrq,jjzsx0,jjzxx0,sfjm00,sfcjjz,fcxh00,czr000,bbid00, sfky00,brxm00,tydwmc,mzzybz,sftj00,brxb00,nl0000,zyhghh,brlx00,nldx00,sqysxm,sqks00,sqksmc,sqbq00, sqbqmc,zdid00,zdmc00,bbmc00,xb0000,csrq00,jgzt00,CUTOFF,SCO000 FROM VW_JY_JYJG00 a WHERE PYRQ00=? AND YBH000=? AND JGLX00 <> 'S' ) ORDER BY DYSX00) C 324 09:41:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 325 09:41:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 326 09:41:10 SQL Execute: ORACLE - select count(*) sl0000 from jy_jyjg00 a where YBH000=? and PYRQ00=? 327 09:41:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20210204 328 09:41:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = AU0001 329 09:41:10 SQL Execute: ORACLE - select A.*,A.BRLX00||'บล:' BRLXMC, decode(NL0000,'0','',NL0000||NLDWMC) NLDWQC from VW_JY_YW0000 A where A.PYRQ00=? and A.YBH000=? and BRID00=2736596 and rownum=1 330 09:41:12 SQL Execute: ORACLE - select decode(sign(to_date(to_char(sysdate,'YYYYMMDD')||' '||'23:00:00','YYYYMMDD HH24:MI:SS')-sysdate),1,'A','B') from dual 331 09:41:12 SQL Execute: ORACLE - select SF_JY_PDJHRS(14) from dual 332 09:41:12 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where ZT0000='0' and flag00='J' and jqbh00=14 333 09:41:12 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where cyckbh=5 and jhbz00 in ('1','3','7','8') 334 09:41:12 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14 335 09:41:12 SQL Execute: ORACLE - select * from VW_JY_PDJHB0 where CYCKBH='5' and JHBZ00<>'2' 336 09:41:12 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00<>'2' 337 09:41:12 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and CYCKBH='5' and JHBZ00='2' 338 09:41:12 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00='2' 339 09:41:12 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00='2' and CYCKBH in (select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14) order by DJSJ00 desc 340 09:41:12 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00<>'2' order by DJSJ00 desc 341 09:41:15 SQL Execute: ORACLE - select decode(sign(to_date(to_char(sysdate,'YYYYMMDD')||' '||'23:00:00','YYYYMMDD HH24:MI:SS')-sysdate),1,'A','B') from dual 342 09:41:15 SQL Execute: ORACLE - select SF_JY_PDJHRS(14) from dual 343 09:41:15 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where ZT0000='0' and flag00='J' and jqbh00=14 344 09:41:15 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where cyckbh=5 and jhbz00 in ('1','3','7','8') 345 09:41:15 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14 346 09:41:15 SQL Execute: ORACLE - select * from VW_JY_PDJHB0 where CYCKBH='5' and JHBZ00<>'2' 347 09:41:15 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00<>'2' 348 09:41:15 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and CYCKBH='5' and JHBZ00='2' 349 09:41:15 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00='2' 350 09:41:15 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00='2' and CYCKBH in (select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14) order by DJSJ00 desc 351 09:41:15 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00<>'2' order by DJSJ00 desc 352 09:41:16 SQL Execute: ORACLE - select distinct A.PYRQ00,A.YBH000 from VW_JY_JYJG00 A,VW_JY_YW0000 B where A.JYYWID=B.JYYWID and A.SFCJJZ||'B'='YB' and B.JGZT00||'A' in ('6A', '8A', '9A') and (ceil((sysdate-to_date(BGRQ00||' '||BGSJ00,'YYYY-MM-DD HH24-MI-SS'))*24*60)>=5) and B.BGCKSJ is null and TXKWJZ='0' order by A.PYRQ00,A.YBH000 353 09:41:18 SQL Execute: ORACLE - select decode(sign(to_date(to_char(sysdate,'YYYYMMDD')||' '||'23:00:00','YYYYMMDD HH24:MI:SS')-sysdate),1,'A','B') from dual 354 09:41:18 SQL Execute: ORACLE - select SF_JY_PDJHRS(14) from dual 355 09:41:18 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where ZT0000='0' and flag00='J' and jqbh00=14 356 09:41:18 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where cyckbh=5 and jhbz00 in ('1','3','7','8') 357 09:41:18 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14 358 09:41:18 SQL Execute: ORACLE - select * from VW_JY_PDJHB0 where CYCKBH='5' and JHBZ00<>'2' 359 09:41:18 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00<>'2' 360 09:41:18 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and CYCKBH='5' and JHBZ00='2' 361 09:41:18 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00='2' 362 09:41:18 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00='2' and CYCKBH in (select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14) order by DJSJ00 desc 363 09:41:18 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00<>'2' order by DJSJ00 desc 364 09:41:19 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 ='JY_LISDYDYCSSFJY' 365 09:41:19 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 ='JY_BGDYJLFS' 366 09:41:19 SQL Execute: ORACLE - update jy_yw0000 a set a.jgzt00='8',a.DYCS00 = NVL(a.DYCS00, 0) + 1 where 1=1 and a.YQDH00='AU' and JYYWID in (0,18594,18597) and (YBH000,PYRQ00) in (select YBH000,PYRQ00 from JY_JYJG00 where (YBH000,PYRQ00) in (select distinct YBH000,PYRQ00 from JY_YW0000 A where a.JYYWID in (0,18594,18597) and YQDH00='AU') group by YBH000,PYRQ00 having count(*) > 0) 367 09:41:19 SQL Data In: ORACLE - Rows affected = 2 368 09:41:19 SQL Execute: ORACLE - update jy_yw0000 a set a.ZZBGDY=trim('LPE_PC'),a.ZZBGRS=to_char(sysdate,'YYYYMMDD HH24:MI:SS') where 1=1 and a.ZZBGDY is null and a.YQDH00='AU' and JYYWID in (0,18594,18597) and (YBH000,PYRQ00) in (select YBH000,PYRQ00 from JY_JYJG00 where (YBH000,PYRQ00) in (select distinct YBH000,PYRQ00 from JY_YW0000 A where a.JYYWID in (0,18594,18597) and YQDH00='AU') group by YBH000,PYRQ00 having count(*) > 0) 369 09:41:19 SQL Data In: ORACLE - Rows affected = 0 370 09:41:19 SQL Execute: ORACLE - COMMIT 371 09:41:19 SQL Data In: ORACLE - Rows affected = 0 372 09:41:21 SQL Execute: ORACLE - select decode(sign(to_date(to_char(sysdate,'YYYYMMDD')||' '||'23:00:00','YYYYMMDD HH24:MI:SS')-sysdate),1,'A','B') from dual 373 09:41:21 SQL Execute: ORACLE - select SF_JY_PDJHRS(14) from dual 374 09:41:21 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where ZT0000='0' and flag00='J' and jqbh00=14 375 09:41:21 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where cyckbh=5 and jhbz00 in ('1','3','7','8') 376 09:41:21 SQL Execute: ORACLE - select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14 377 09:41:21 SQL Execute: ORACLE - select * from VW_JY_PDJHB0 where CYCKBH='5' and JHBZ00<>'2' 378 09:41:21 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00<>'2' 379 09:41:21 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and CYCKBH='5' and JHBZ00='2' 380 09:41:21 SQL Execute: ORACLE - select count(*) from JY_PDJHB0 where PHRQ00=to_char(sysdate,'YYYYMMDD') and JHBZ00='2' 381 09:41:21 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00='2' and CYCKBH in (select CKBH00 from BM_CKBM00 where flag00='J' and JQBH00=14) order by DJSJ00 desc 382 09:41:21 SQL Execute: ORACLE - select * from jy_pdjhb0 where JHBZ00<>'2' order by DJSJ00 desc 383 09:41:22 SQL Execute: ORACLE - select distinct A.PYRQ00,A.YBH000 from VW_JY_JYJG00 A,VW_JY_YW0000 B where A.JYYWID=B.JYYWID and A.SFCJJZ||'B'='YB' and B.JGZT00||'A' in ('6A', '8A', '9A') and (ceil((sysdate-to_date(BGRQ00||' '||BGSJ00,'YYYY-MM-DD HH24-MI-SS'))*24*60)>=5) and B.BGCKSJ is null and TXKWJZ='0' order by A.PYRQ00,A.YBH000