1       17:14:50  SQL Execute: ORACLE - select * from ( select t1.*,SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000,SF_JUDGE_RESULT_JZ(t1.PYRQ00,t1.YBH000) SFJJ00,DECODE(t1.SFJM00,'N','Y',DECODE((Select count(*) From VW_JY_YGQXZD where YGBH00='476' and QXLX00='JGCL' and QXGNDH='CKJM' and YQDH00=t1.YQDH00),0,'N','Y')) YXDY00 from ( 
 select distinct a.brxm00,a.YEXM00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00, decode(A.JGZT00,'6','Y','N')  dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8')  and A.PYRQ00 between '20160401' and '20160412' and A.ZYHGHH = '334008' and ( ( A.SQKS00+0 = '28' or A.SQBQ00+0 = '28') ) union  select distinct a.brxm00,a.YEXM00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,to_char(to_date(a.pyrq00,'YYYYMMDD'),'YYYY-MM-DD') pyrq01,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00, decode(A.JGZT00,'6','Y','N')  dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ,to_char(to_date(a.cbgrq0,'YYYYMMDD'),'YYYY-MM-DD') CBGRQ1,a.CBGRQ0,a.ZYHGHH from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8')  and A.PYRQ00 between '20160401' and '20160412' and A.ZYHGHH = '334008' and (  ( exists (SELECT 1 FROM ZY_BRXXB0 WHERE  zyid00=A.ZYGHID and  (DQBQ00 = '28' or DQKS00='28')))) ) t1 )
 order by CBGRQ0 desc,yqdh00,ybh000,ch0000 asc

2       17:14:51  SQL Execute: ORACLE - select  BGVIEW from JY_JYYQZD  where YQDH00='AD'

3       17:14:51  SQL Execute: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' บล:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000  from vw_jy_yw0000 a  WHERE ybh000='AD0056' and pyrq00='20160406' and rownum=1

4       17:14:51  SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'AD0056' and PYRQ00 = '20160406'

5       17:14:51  SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,5303,5304)

6       17:14:51  SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00  WHERE ybh000='AD0056' and pyrq00='20160406'
 ORDER BY DYSX00

7       17:15:12  SQL Execute: ORACLE - Select * From VW_JY_YGQXZD where YGBH00='476' and QXLX00='JGCL' and QXGNDH='TJBG'

8       17:15:12  SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20160406','AD0056') from dual

9       17:15:12  SQL Execute: ORACLE - select  BGVIEW from JY_JYYQZD  where YQDH00='AD'

10      17:15:13  SQL Execute: ORACLE - select a.*,SUBSTR(a.BRLX00,1,1)||' '||SUBSTR(a.brlx00,2,1)||' บล:' BRLXMC,SUBSTR(a.sqrq00,1,4)||'.'||SUBSTR(a.sqrq00,5,2)||'.'||SUBSTR(a.sqrq00,7,2) SQ0000,SUBSTR(a.PYRQ00,1,4)||'.'||SUBSTR(a.PYRQ00,5,2)||'.'||SUBSTR(a.PYRQ00,7,2) PY0000,SUBSTR(a.CBGRQ0,1,4)||'.'||SUBSTR(a.CBGRQ0,5,2)||'.'||SUBSTR(a.CBGRQ0,7,2)||' '||CBGSJ0 BG0000  from vw_jy_yw0000 a  WHERE ybh000='AD0056' and pyrq00='20160406' and rownum=1

11      17:15:13  SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'AD0056' and PYRQ00 = '20160406'

12      17:15:14  SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,5303,5304)

13      17:15:15  SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00  WHERE ybh000='AD0056' and pyrq00='20160406'
 ORDER BY DYSX00

14      17:15:16  SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where NAME00='JY_DYJSZBCFS' 

15      17:15:17  SQL Execute: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYBGDPRT' and YGBH00 = '476'

16      17:15:17  SQL Execute: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYHZDPRT' and YGBH00 = '476' 

17      17:15:18  SQL Execute: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYZLXMPRT' and YGBH00 = '476' 

18      17:15:18  SQL Execute: ORACLE - select trim(value0) from xt_xtcs00 where name00 in ('JY_BQDYBGDZS')

19      17:15:19  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JYDYSFDYFCJG')

20      17:15:19  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JYBGDYSTSFCYGCTQNR')

21      17:15:19  SQL Execute: ORACLE - select * from xt_xtcs00 where name00 in ('JY_JGCLDYYLBDYSFGXZT')

22      17:15:20  SQL Execute: ORACLE - select DISTINCT YQDH00 from JY_YW0000 a 
 where  a.JYYWID in (0,5853956,5853957) and nvl(a.DYCS00,0)<5