1       09:48:27  SQL Execute: ORACLE - SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID,A.SCXJJG,A.SCBGRQ FROM  VW_JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 and kssid0 is null AND YBH000='DA1361' AND PYRQ00='20120825'

2       09:48:27  SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000=''

3       09:48:27  SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00=''

4       09:48:27  SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0'

5       09:48:27  SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00=''

6       09:48:27  SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID=''

7       09:48:27  SQL Execute: ORACLE -  select rownum,JG.* from ( select * from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMJGNE,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID ,XJID00 ,a.SCXJJG,a.SCYMSM,a.SCYMJG,a.SCYMKB,a.SCYMNE,a.SCBGRQ, decode(nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0),  0,b.xh0000,nvl((select XH0000 from VW_JY_XJBZXH where xjid00=a.xjid00 and kssid0=a.kssid0 and rownum=1),0)) XH0000  from VW_JY_XJBGJG a,JY_KSSZD0 B  where B.KSSID0=A.KSSID0  AND XJID00='' AND YBH000=''  AND PYRQ00='' ) ORDER BY XH0000) JG 

8       09:48:27  SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,B.XH0000 XH0001,A.DW0000 FROM  JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT exists (SELECT 1 from JY_XJBGJG WHERE  kssid0=B.KSSID0 and XJID00='' AND YBH000='' AND  PYRQ00='')
 ORDER BY XY0000 DESC,XH0001,XH0000

9       09:48:27  SQL Execute: ORACLE - select * from vw_JY_YW0000 where YBH000='DA1361' and PYRQ00='20120825' order by jyywid desc 

10      09:48:27  SQL Execute: ORACLE - select BBBZ00,XH0000 from JY_BBBZZD
 where BBID00='10'

11      09:48:28  SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (select zlxmid from jy_ywmx00 where YBH000 = 'DA1361' and PYRQ00 = '20120825')

12      09:48:28  SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '644' and YQDH00 = 'DA' AND QXLX00 = 'JGCL' and QXGNDH = 'CKJM'

13      09:48:28  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120825
14      09:48:28  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = DA1361
15      09:48:28  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120825
16      09:48:28  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = DA1361
17      09:48:28  SQL Execute: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00 from VW_JY_JYJG00 a WHERE a.PYRQ00 = ?  and a.YBH000 = ? UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00 from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ?  and a.YBH000 = ? ) 
 where DECODE(NVL(jyywid,0),0,0,1)||SFJM00 = '1N' 
 order by DYSX00

18      09:48:28  SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '644' and YQDH00 = 'DA' AND QXLX00 = 'JGCL' and QXGNDH = 'CKJM'

19      09:48:28  SQL Execute: ORACLE - SELECT count(*) FROM JY_YW0000  WHERE ybh000='DA1361' and pyrq00='20120825' and SFJM00='Y'