1 10:28:04 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='1127' and QXLX00='JGCL' and QXGNDH='CKJM' and YQDH00=t1.YQDH00),0,'N','Y')) YXDY00 from (select distinct a.brid00,a.brxm00,a.xb0000,a.csrq00,a.nl0000,a.sqksmc,a.brlx00,a.ch0000,a.yqdh00,a.ybh000,a.pyrq00,a.jgzt00,a.sftj00,a.SFJM00,DECODE(a.JGZT00,'6','Y','N') dy0000,SFYB00,BGYSZ0,DYCS00,a.txm000,a.mzzybz,a.zyhghh,SUBSTR(SF_JY_UNION_XMMC00_BBK(txm000,mzzybz,zyhghh,'','',0,1),1,120) xmmc00 from VW_JY_YW0000 a where mzzybz='0' and PYRQ00 between '20170607' and '20170614' AND JGZT00 not in ('0','3','7') and brid00 in (select distinct brid00 from jy_yw0000 where TXM000='041706142988')) t1 order by pyrq00,ybh000 2 10:28:04 SQL Error: ORACLE - ORA-03114: δÁ¬½Óµ½ ORALCE 3 10:28:04 SQL Error: ORACLE - Unmapped SQL Error Code: 3114 4 10:28:04 SQL Data In: ORACLE - Rows affected = 0