1 16:11:12 SQL Execute: ORACLE - select TO_CHAR(SYSDATE,'YYYYMMDDHH24:MI:SS') time00 from dual 2 16:11:12 SQL Execute: ORACLE - select value0 from XT_XTCS00 where name00 in ('JY_ZYTMDYYLSFGXJGZT') 3 16:11:12 SQL Execute: ORACLE - select * from (select ZYGHID ZYID00,YZCFID YZID00,ZLXMJC,ZJE000,KDYSXM,SQRQ00,SQBQ00, BBDYBZ YJDJDY,YJDJH0,ZDMC00,dyrqtm,TXM000,THYY00,JGZT00,ZYZBID,BBID00,JZBZ00,TXMYSZ,XMZT00,CYRQSJ,DYRQSJ,JYYWID from VW_JY_BBCJD0 B where ZYGHID=759237 AND ((SQBQ00=485) or (0=0)) AND SQRQ00 Between '20141019' And '20150127' AND NVL(CJKSBH,SQBQ00) not in (0) and NVL(CJKSBH,SQBQ00)=485 and NVL(DYRQTM,'0')='0' ) order by ZYZBID,BBID00,SQRQ00 DESC,TXM000 DESC 4 16:11:12 SQL Execute: ORACLE - select * from (select ZYGHID ZYID00,YZCFID YZID00,ZLXMJC,ZJE000,KDYSXM,SQRQ00,SQBQ00, BBDYBZ YJDJDY,YJDJH0,ZDMC00,dyrqtm,TXM000,THYY00,JGZT00,ZYZBID,BBID00,JZBZ00,TXMYSZ,XMZT00,CYRQSJ,DYRQSJ,JYYWID from VW_JY_BBCJD0 B where ZYGHID=758899 AND ((SQBQ00=485) or (0=0)) AND SQRQ00 Between '20141019' And '20150127' AND NVL(CJKSBH,SQBQ00) not in (0) and NVL(CJKSBH,SQBQ00)=485 and NVL(DYRQTM,'0')='0' ) order by ZYZBID,BBID00,SQRQ00 DESC,TXM000 DESC 5 16:11:12 SQL Execute: ORACLE - select * from (select ZYGHID ZYID00,YZCFID YZID00,ZLXMJC,ZJE000,KDYSXM,SQRQ00,SQBQ00, BBDYBZ YJDJDY,YJDJH0,ZDMC00,dyrqtm,TXM000,THYY00,JGZT00,ZYZBID,BBID00,JZBZ00,TXMYSZ,XMZT00,CYRQSJ,DYRQSJ,JYYWID from VW_JY_BBCJD0 B where ZYGHID=758456 AND ((SQBQ00=485) or (0=0)) AND SQRQ00 Between '20141019' And '20150127' AND NVL(CJKSBH,SQBQ00) not in (0) and NVL(CJKSBH,SQBQ00)=485 and NVL(DYRQTM,'0')='0' ) order by ZYZBID,BBID00,SQRQ00 DESC,TXM000 DESC 6 16:11:12 SQL Execute: ORACLE - select * from (select ZYGHID ZYID00,YZCFID YZID00,ZLXMJC,ZJE000,KDYSXM,SQRQ00,SQBQ00, BBDYBZ YJDJDY,YJDJH0,ZDMC00,dyrqtm,TXM000,THYY00,JGZT00,ZYZBID,BBID00,JZBZ00,TXMYSZ,XMZT00,CYRQSJ,DYRQSJ,JYYWID from VW_JY_BBCJD0 B where ZYGHID=759254 AND ((SQBQ00=485) or (0=0)) AND SQRQ00 Between '20141019' And '20150127' AND NVL(CJKSBH,SQBQ00) not in (0) and NVL(CJKSBH,SQBQ00)=485 and NVL(DYRQTM,'0')='0' ) order by ZYZBID,BBID00,SQRQ00 DESC,TXM000 DESC 7 16:11:12 SQL Execute: ORACLE - select DISTINCT a.ZYGHID ZYID00,a.BRXM00,a.XB0000,a.NL0000,a.TXMMC0,'打印' JBXX01,TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') CYRQSJ,a.BBMC00, a.CH0000,decode('N','Y',decode(rownum1,1,a.txm000,'0'),a.TXM000) txm000,a.XMMC00,a.YBTJ00,a.YBSM00,a.BRLB00,a.BMMC00,a.JZBZ00,a.ZYHGHH,c.rownum1,a.sqysxm from VW_JY_TXMCJD a , BM_ZLZD00 b, (select rownum rownum1 from yj_yw0000 where rownum<=10) c where a.zlxmid=b.zlxmid and c.rownum1<=nvl(b.tmdycs,1) and nvl(b.tmdycs,1)>=1 and MZZYBZ='1' AND ((KDBQ00=485) or (0=0)) AND KDRQ00 Between '20141019' And '20150127' and ZYGHID in (-1,759237,758899,758456,759254) AND NVL(CJKSBH,KDBQ00)=485 AND NVL(TMDYRQ,'0')='0' AND YJDJH0 IN ('-1','13499535','13500152','13514334','13514211','13349225','13514210','13514208','13514209','13478590','13457233','13441807','13388288','13180872','13513802','13513803','13514346','13514355','13514354','13514349','13514351','13514350','13514348','13514353','13514352','13514356','13514357','13514358','13514360','13514359','13514362','13514361','13514363') 8 16:11:12 SQL Error: ORACLE - ORA-00918: 未明确定义列 9 16:11:12 SQL Error: ORACLE - Unmapped SQL Error Code: 918 10 16:11:12 SQL Data In: ORACLE - Rows affected = 0