1       14:49:18  SQL Execute: ORACLE - select * from XK_SXSQ00  where  SQDH00='163838'

2       14:49:19  SQL Execute: ORACLE - select b.ZYH000,a.QXRQ00,a.QXSJ00,a.SQDH00,a.QXRXM0,a.SXRXM0,nvl(a.SXRQ00,to_char(sysdate,'YYYYMMDD'))SXRQ00,a.SXSJ00,nvl(a.SXKSRQ,to_char(sysdate,'YYYYMMDD'))SXKSRQ,a.SXKSSJ,nvl(a.SXJSRQ,to_char(sysdate,'YYYYMMDD'))SXJSRQ,a.SXJSSJ,a.SXGC00,a.HDRXM0,a.HDRXM1,nvl(a.JLRQ00,to_char(sysdate,'YYYYMMDD')) JLRQ00,a.JLSJ00,a.JLRXM0,b.xm0000,b.xb0000,SUBSTR(SF_XT_CSRQTONL(b.CSRQ00,a.SQRQ00),1,8) brnl00,a.CH0000,a.LCZDMC,b.RHXX00,b.JYYGBH,b.FJRXM0,b.ZDXX00,b.TYKTSC,a.SXSZ00,a.SXHS00,a.SXHS01,a.PXYGBH,a.FXRBH0,a.KSMC00,(select BRBLH0 from BM_BRXXB0 where BRID00=a.BRID00) as BRBLH0, SXCF00,SXSL00,SXDW00,FXDH00,a.SXFY00,a.CLJG00 from XK_SXSQ00 a,XK_BRXX00 b where a.brid00=b.brid00 and a.SQDH00='163838'

3       14:49:19  SQL Execute: ORACLE - select to_date('20160217','yyyymmdd') from dual

4       14:49:19  SQL Execute: ORACLE - select to_date('20160219','yyyymmdd') from dual

5       14:49:20  SQL Execute: ORACLE - select to_date('20160219','yyyymmdd') from dual

6       14:49:20  SQL Execute: ORACLE - select to_date('20160219','yyyymmdd') from dual

7       14:49:20  SQL Execute: ORACLE - select to_date('20160219','yyyymmdd') from dual

8       14:49:21  SQL Execute: ORACLE - select * from bm_ygbm00 where ygbh00='839'

9       14:49:21  SQL Execute: ORACLE - select * from bm_ygbm00 where ygbh00='839'

10      14:49:21  SQL Execute: ORACLE - select * from bm_ygbm00 where ygbh00=''

11      14:49:21  SQL Execute: ORACLE - select * from bm_ygbm00 where ygbh00=''

12      14:49:22  SQL Execute: ORACLE - select * from bm_ygbm00 where ygbh00='839'

13      14:49:22  SQL Execute: ORACLE - select '1' XZ,XDBH00,(select XYPZMC from XK_XYRK00 where XDBH00=a.XDBH00 and rownum=1) XYPZMC, (select PXFFMC from VW_XK_PXFFBM where PXFFID=a.FFID00) XMMC00,ZCJG00,CCJG00, (select PXFFMC from VW_XK_PXFFBM where PXFFID=a.FFID01) XMMC01,ZCJG01,CCJG01, (select PXFFMC from VW_XK_PXFFBM where PXFFID=a.FFID02) XMMC02,ZCJG02,CCJG02 from XK_JCPXBG a where sqdh00='163838' 

14      15:20:10  SQL Execute: ORACLE - select BZ0000 from BM_TYZD00  where ZDMC00='ÊäѪ¼Ç¼µ¥¸ñʽ' and  MC0000=(select trim(SFXYSY) from  VW_XK_JCPXBG where SQDH00='163838' and rownum=1 )

15      15:20:10  SQL Execute: ORACLE - select A.*,B.XDBH00,B.XYPZMC,B.XXZXM0,B.XX0000,B.RHXX00,B.CKDW00,B.CKSL00,decode(A.SQDFZH,NULL,A.SQDH00,A.SQDFZH) SQDFZH
 from VW_XK_SXJLXX A, XK_XYCK00 B WHERE A.SQDH00=B.SQDH00 AND (A.SQDH00='163838' or A.SQDFZH='163838') order by a.SQDH00