1 15:08:38 SQL Prepare: ORACLE - select B.DWMC00,D.BRBLH0,D.BRXM00,D.BRXB00,C.BRZJE0 Amount,C.JZJE00,C.ZFJE00,C.GFJE00 JMJE00,F.ZWXM00,pjxh00,C.JZRQ00,C.JZSJ00 from bm_brxxb0 A,bm_tydwb0 B,SF_JZB000 C,BM_BRXXB0 D,SF_PJSYQK E,BM_YGBM00 F where A.tydwid = B.dwid00 and A.BRID00 = C.BRID00 and C.BRID00 = D.BRID00 AND C.PJH000=e.FZPJH0 AND F.YGBH00(+)=C.JZY000 and C.JZRQ00 >= '20100129' and C.JZRQ00 <= '20100129' and C.JZRQ00||C.JZSJ00 >= '2010012900:00:00' and C.JZRQ00||C.JZSJ00 <= '2010012923:59:59' and e.pjzt00='0' order by B.DWMC00,D.BRBLH0,D.BRXM00,D.BRXB00,E.PJXH00 2 15:08:38 SQL Execute: ORACLE - select B.DWMC00,D.BRBLH0,D.BRXM00,D.BRXB00,C.BRZJE0 Amount,C.JZJE00,C.ZFJE00,C.GFJE00 JMJE00,F.ZWXM00,pjxh00,C.JZRQ00,C.JZSJ00 from bm_brxxb0 A,bm_tydwb0 B,SF_JZB000 C,BM_BRXXB0 D,SF_PJSYQK E,BM_YGBM00 F where A.tydwid = B.dwid00 and A.BRID00 = C.BRID00 and C.BRID00 = D.BRID00 AND C.PJH000=e.FZPJH0 AND F.YGBH00(+)=C.JZY000 and C.JZRQ00 >= '20100129' and C.JZRQ00 <= '20100129' and C.JZRQ00||C.JZSJ00 >= '2010012900:00:00' and C.JZRQ00||C.JZSJ00 <= '2010012923:59:59' and e.pjzt00='0' order by B.DWMC00,D.BRBLH0,D.BRXM00,D.BRXB00,E.PJXH00