1       11:08:57  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='1496' and QXLX00='JGCL' and QXGNDH='CKJM' and YQDH00=t1.YQDH00),0,'N','Y')) YXDY00 from (select distinct a.brxm00,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.yxbz00,a.ybh000,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,'N' dy0000,a.BGYSZ0,a.SFYB00,a.MZZYBZ from VW_JY_YW0000 a where A.JGZT00 in ('9','6','8') 
 and A.BRID00=(SELECT BRID00 FROM JY_YW0000 WHERE ROWNUM=1 AND ZYHGHH='1402430')) t1 )
 order by PYRQ00 desc,yqdh00,ybh000,ch0000 asc

2       11:08:57  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='HH0067' and pyrq00='20140311' and rownum=1

3       11:08:57  SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'HH0067' and PYRQ00 = '20140311'

4       11:08:57  SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,21651)

5       11:08:57  SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00  WHERE ybh000='HH0067' and pyrq00='20140311'
 ORDER BY DYSX00