日期 时间 异常信息 执行时间（ms） SQL 20200922 10:44:45 4 SELECT XH0000, XTDM00, CZYKSM, CZRQ00, XXNR00,XXXZ00,XXBH00,XXGLLX,XXGLBZ,JSKSBH,BRID00 FROM VW_HT_XTTSXX_DZBL a where yxq000 >= TO_CHAR(SYSDATE, 'YYYYMMDD') and ((XXXZ00 = '1' and (xtdm00 = '-1' OR xtdm00 = 'V ')) or (XXXZ00 = '0' and xtdm00 = 'V ')) and (JSKSBH IS NULL OR instr(',' || jsksbh || ',', decode(fsdx00,'2',',537,','0',',26,')) > 0 ) and not exists (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 537 ) order by a.XH0000 desc 20200922 10:44:49 4 select LJMC00, ZRZCID,LJID00,ZLJID0 from LJ_ZRZC00 a where ZYID00=:ZYID00 and nvl(JSRQ00,' ')=' ' order by ZRZCID 20200922 10:44:49 4 parameters :ZYID00=2780159 20200922 10:44:49 3 select LJMC00, ZRZCID,LJID00,JSRQ00 from LJ_BRZLJ0 a where ZRZCID=:ZRZCID and LJID00 in (0 ) and nvl(JSRQ00,' ')=' ' order by KSRQ00 20200922 10:44:49 3 parameters :ZRZCID=32753 20200922 10:44:49 5 select ZLJID0,A.*,C.LJMC00,SF_ZS_LJ_GETLJJDMC_ZYDZBL(A.ZRZCID,A.ZXKSRQ,A.BRZXJD) as NWJDMC from LJ_JDZXQK A,LJ_ZRZC00 C where A.ZYID00=:ZYID00 and nvl(SFJXZX,'0')='0' and JDZT00<>'1' and A.ZRZCID=C.ZRZCID and nvl(C.JSRQ00,' ')=' ' and C.zrzcid=:ZRZCID and A.ZLJBZ0='0' and A.JDZT00='0' order by A.brzxjd,A.ZXKSRQ,JHRQ00,RCID00 20200922 10:44:49 5 parameters :ZYID00=2780159 :ZRZCID=32753 20200922 10:44:49 2 select yexm00,brid00 from BQ_JSXX00 where zyid00= 2780159 20200922 10:44:49 3 select min(zxksrq) from lj_jdzxqk where zrzcid = :zrzcid 20200922 10:44:49 3 parameters :zrzcid=32753 20200922 10:44:49 11 select ZNFA00 from LJ_MBZNFA a where LJID00=:LJID00 20200922 10:44:49 11 parameters :LJID00=128 20200922 10:44:49 2 select SFXSFL from lj_mb0000 where ljid00=128 20200922 10:45:15 908 SP_ZY_LJ_YMBYZTB_ZYDZBL 20200922 10:45:15 908 parameters ad_ZRZCID=32753 as_KSRQ00=20200912 ad_JHMXID=0 ad_CZY000=537 as_YHMSG0= as_SYSMSG= 20200922 10:45:15 3 select ZLJID0,A.*,C.LJMC00,SF_ZS_LJ_GETLJJDMC_ZYDZBL(A.ZRZCID,A.ZXKSRQ,A.BRZXJD) as NWJDMC from LJ_JDZXQK A,LJ_ZRZC00 C where A.ZYID00=:ZYID00 and nvl(SFJXZX,'0')='0' and JDZT00<>'1' and A.ZRZCID=C.ZRZCID and nvl(C.JSRQ00,' ')=' ' and C.zrzcid=:ZRZCID and A.ZLJBZ0='0' and A.JDZT00='0' order by A.brzxjd,A.ZXKSRQ,JHRQ00,RCID00 20200922 10:45:15 3 parameters :ZYID00=2780159 :ZRZCID=32753 20200922 10:45:15 1 select MC0000 from BM_TYZD00 where ZDMC00='路径医嘱排序' 20200922 10:45:15 213 select c.*,SF_ZS_LJ_DTYZZTMC_ZYDZBL(c.BRYZZT,c.KSRQ00,c.JHTZRQ,c.TZRQ00,c.ZXZXRQ,c.JHMXID,'20200922',c.BYYY00,c.CXBZ00,LYJHID,YZFWLB,FLID00) DTZTMC, to_char(ROWNUM) as ZNO000, c.YPNM00 as OYPNM00, c.ZLXMID as OZLXMID,SF_ZS_LJ_RETURNSELECT_ZYDZBL(YZXZLX,nvl(TLBZXH,0),ZRZCID,RCID00,JHMXID,WBMXID,'20200919','20200924',c.BZKSRQ,c.JHTZRQ,c.BYYY00,0) MRBZ00,(select sxysxm from zy_brxxb0 where zyid00=c.zyid00) sxysxm ,MCSL00 mcsl01 from (select a.* from VW_ZS_LJJHYZXX_ZYDZBL a where a.ZYID00 ='2780159' and ZRZCID='32753' and KSRQ00<='20200924' and nvl(JDGYYZ,'N')<>'Y' and( a.MRXSBZ='1' or nvl(WBMXID,0)>0) and ((brzxjd= 135598 and CLBZ00=1 ) or CLBZ00=0 ) and (JHTZRQ>='20200919' or NVL(TZRQ00,' ')=' ') union all select b.* from VW_ZS_LJJHYZXX_ZYDZBL b where b.ZYID00 ='2780159' and ZRZCID='32753' and rcid00=431 and JDGYYZ='Y' and( b.MRXSBZ='1' or nvl(WBMXID,0)>0) and ((brzxjd= 135598 and CLBZ00=1 ) or CLBZ00=0 ) and ((KSRQ00>='20200919' and clbz00=0) or clbz00=1) ) c where 1=1 order by CLBZ00,RCID00,PXH000,NO0000,TLBZXH,XH0000 20200922 10:45:15 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:15 1 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='103' 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='104' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 1 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='18949' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 1 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='18947' 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='18948' 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='18950' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='18362' 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='18360' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 1 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='7845' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='15398' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 1 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='15315' 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='13209' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='15323' 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='13203' 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=1051 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=4140 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=22885 and zyid00='2780159' and rownum=1 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 1 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='18896' 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='10217' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='10330' 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='10224' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 1 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='10363' 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='10362' 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 1 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='10350' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='10333' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='10331' 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=9708 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=23823 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='10211' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=23015 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=22985 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=22985 and zyid00='2780159' and rownum=1 20200922 10:45:16 1 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=9708 and zyid00='2780159' and rownum=1 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=18808 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=16679 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=4140 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=10079 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=9708 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=23384 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=6216 and zyid00='2780159' and rownum=1 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=17900 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=12437 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=9708 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=2630 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=9708 and zyid00='2780159' and rownum=1 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=23918 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=4140 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=18523 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=4140 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=23382 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=9708 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=23382 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=23696 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=17177 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=22766 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=829 and zyid00='2780159' and rownum=1 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=23857 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=9708 and zyid00='2780159' and rownum=1 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=2620 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=1041 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=4997 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=9708 and zyid00='2780159' and rownum=1 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=23378 and zyid00='2780159' and rownum=1 20200922 10:45:16 5 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=9708 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=18512 and zyid00='2780159' and rownum=1 20200922 10:45:16 5 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=34884 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=13127 and zyid00='2780159' and rownum=1 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=31188 and zyid00='2780159' and rownum=1 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=26912 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=35506 and zyid00='2780159' and rownum=1 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=26850 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=31172 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=35506 and zyid00='2780159' and rownum=1 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='20728' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='16515' 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='16487' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='16488' 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='16108' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='16843' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 6 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='16497' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='16501' 20200922 10:45:16 5 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='16502' 20200922 10:45:16 4 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='16480' 20200922 10:45:16 5 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='7661' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 2 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='24737' 20200922 10:45:16 3 select a.ypnm00,a.ykkcsl,b.mcsl00 from YF_YPKCXX a,VW_ZS_LJJHYZXX_ZYDZBL b where a.ypnm00=b.ypnm00 and a.ypnm00=0 and zyid00='2780159' and rownum=1 20200922 10:45:16 3 select ZLXMJC from vw_bq_zlxm00 where ZLXMID='7662' 20200922 10:45:16 3 select max(brzxjd) from lj_jdzxqk where DQJDBZ='1' and zyid00=2780159 and zrzcid=32753 20200922 10:45:16 4 select LJID00,KJMXID,CLBZMC,ZLXMJC,XZLXMC,ZTMC00,decode(ZXBZ00,'2',BZ0000,'') BZ0000 from VW_ZS_LJ_GetKJMX00_ZYDZBL a where BRZXJD=135598 and LB0000=0 and zrzcid=32753 order by ZXRQ00,XH0000 20200922 10:45:16 4 select max(brzxjd) from lj_jdzxqk where DQJDBZ='1' and zyid00=2780159 and zrzcid=32753 20200922 10:45:16 4 select a.LJID00,a.JHMXID KJMXID,a.ZLXMJC,decode(a.YZXZLX,'0','必选','1','可选','','必选') XZLXMC,decode(b.SFZX00,'0','未执行','1','已执行','2','放弃') ZTMC00,decode(b.SFZX00,'2',b.BZ0000,'') BZ0000 from LJ_YZMX00 a inner join LJ_HLZXJL b on a.ZRZCID=b.ZRZCID and a.LJYZMX=b.LJYZMX where a.BRZXJD=135598 and a.SYFW00='2' and a.zrzcid=32753 order by ZXRQ00,XH0000 20200922 10:45:16 2 select max(brzxjd) from lj_jdzxqk where DQJDBZ='1' and zyid00=2780159 and zrzcid=32753 20200922 10:45:16 4 select LJID00,ZLXMJC,decode(YZXZLX,'0','必选','1','可选','','必选') XZLXMC,decode(SFZX00,'0','未执行','1','已执行','2','放弃') ZTMC00,decode(SFZX00,'2',BZ0000,'') BZ0000,ZXRXM0 from VW_BQ_LJHLZXMXA_ZYDZBL where BRZXJD=135598 and zrzcid=32753 order by ZXRQ00,XH0000 20200922 10:45:16 1 Update LJ_JDZXQK set DQJDBZ='2',BYYY00='自动进入下阶段' where ZYID00=2780159 and DQJDBZ is null and ZXJSRQ<'20200922' 20200922 10:45:17 6 SELECT XH0000, XTDM00, CZYKSM, CZRQ00, XXNR00,XXXZ00,XXBH00,XXGLLX,XXGLBZ,JSKSBH,BRID00 FROM VW_HT_XTTSXX_DZBL a where yxq000 >= TO_CHAR(SYSDATE, 'YYYYMMDD') and ((XXXZ00 = '1' and (xtdm00 = '-1' OR xtdm00 = 'V ')) or (XXXZ00 = '0' and xtdm00 = 'V ')) and (JSKSBH IS NULL OR instr(',' || jsksbh || ',', decode(fsdx00,'2',',537,','0',',26,')) > 0 ) and not exists (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 537 ) order by a.XH0000 desc