1       14:57:16  SQL Execute: ORACLE - Select (select bmmc00 from bm_bmbm00 where bmbh00=b.YJKSBH)YJKSBH,b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.brybmc,b.SM0000,ZLDCCF from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid
 and xmzt00 ='3'
 and b.mzzybz='1'
 and brid00=6174904
 and YJKSBH<>25
 and  (not  exists  ( select 1 from yj_yw0000 a where a.cxdjh0=b.yjdjh0 and a.zyhghh=b.zyhghh)) 
 and  SL0000>0 and nvl(cxdjh0,0)=0 
 and kdrq00 between '20230124' and '20230131' 
 order by brid00,zyhghh,zyzbid,yzcfid,kdrq00,zlxmid