1       14:45:27  SQL Execute: ORACLE - 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='1150' 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.PYRQ00 between '20130701' and '20130725' and A.ZYHGHH = '1306148' and (A.SQKS00 = '27' or A.SQBQ00 = '27')) t1 order by t1.PYRQ00 desc,t1.yqdh00,t1.ybh000,t1.ch0000 asc

2       14:45:27  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='B80219' and pyrq00='20130725' and rownum=1

3       14:45:27  SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = 'B80219' and PYRQ00 = '20130725'

4       14:45:27  SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1,2469)

5       14:45:27  SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00  WHERE ybh000='B80219' and pyrq00='20130725'
 ORDER BY DYSX00

6       14:45:33  SQL Execute: ORACLE - 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='1150' 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='1306148')) t1 order by t1.PYRQ00 desc,t1.yqdh00,t1.ybh000,t1.ch0000 asc

7       14:45:33  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='' and pyrq00='' and rownum=1

8       14:45:33  SQL Execute: ORACLE - select b.zlxmid from jy_ywmx00 b where YBH000 = '' and PYRQ00 = ''

9       14:45:33  SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (-1)

10      14:45:33  SQL Execute: ORACLE - SELECT * FROM VW_JY_JYJG00  WHERE ybh000='' and pyrq00=''
 ORDER BY DYSX00

11      14:45:33  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
12      14:45:33  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
13      14:45:33  SQL Execute: ORACLE - SELECT distinct  PYRQ00,YBH000,XJID00,XJYWMC,ZWMC00,XJJG00,BBBZ00,JGZT00,XJMS00
 FROM VW_JY_XJJG00 WHERE YBH000=? AND PYRQ00=?