select 'N' NX, a.YJKSMC,  A.XMZT00, A.ZLXMID, A.MZZYBZ, A.YZCFID, A.DCBZ00, A.BRID00,A.ZT0000,  A.YJDJH0, A.YJFZH0, A.ZYHGHH, A.BRXM00, A.YEXM00, A.ZLXMJC, A.XB0000, 
 A.CSRQ00, A.BRNL00, A.LRXM00, A.KDSJ00, A.ZYGHID, B.LBBH00, B.ZYZBID,  A.KDYSXM, A.KDKSMC, A.KDRQ00, A.JZBZ00, A.BWMC00, A.BZ0000, A.ZDMC00,  A.SL0000, A.ZXSL00, 
 A.ZJE000, A.YJLRBZ, A.KDBQ00, nvl(A.CXDJH0,0) CXDJH0, A.ZXRXM0,  A.ZXRQ00, A.ZXSJ00, A.BRYBMC, A.SM0000, A.ZLDCCF, A.CXSL00, A.TXM000,  A.FBBH00, A.CH0000, A.YJKSBH, 
 A.KDRQSJ, A.ZXRQSJ, A.YPNM00, A.BBZT00, A.JYTXM0,A.SFDJH0,  decode(sign(A.SL0000),1,NULL,decode(A.SFDJH0,0,0,1)) SFGZ00, A.BBID00,   
 (select BBMC00 from BM_BBZD00 where BBID00 = A.BBID00) BBMC00,b.SFQZX0,  A.JCZID0, A.YYID00, A.HBXHID, A.YYZT00, A.HBDJH0,A.YYBZ00,A.JCSQDH,A.KDKSBH, 
  A.KDYS00,A.JCLBID,A.SFZTMC,decode(A.HBZYXM,'2','تا','·ٌ') HBZYXM,A.DW0000,A.SFZF00,  decode(SF_YJ_GETYJJZZT(nvl(a.CXDJH0,0),a.BRID00,a.MZZYBZ,a.ZYGHID),1,'تا','·ٌ') as SFJSMC, 
    a.TFSHR0,a.TFSHXM,a.TFSHRQ,a.TFSHSJ,a.KYJCJG,a.HXYZMC,a.SJSL00   
    from VW_YJ_YW0000 A, BM_ZLZD00 B 
    where B.ZLXMID = A.ZLXMID  
      and BRID00 = 2143640
      and not exists ( select 1 from YJ_YW0000 where YJKSBH<>2207 and XMZT00=3 and YJDJH0=a.yjdjh0 )  
      and not exists ( select 1 from YJ_YW0000 where YJKSBH<>2207 and KDKSBH<>2207 and XMZT00='1' and MZZYBZ='1' and YJDJH0=a.yjdjh0 ) 
       and (YJKSBH = 2207 or KDKSBH= 2207 or (exists (select 1 from XT_KSZXXM where ZXKSBH = 2207 and ZLXMID=b.ZLXMID and b.SFQZX0='Y' and A.MZZYBZ='0' ) and   instr(',2207,',',2207,')>0))
     and (1=1  and ( A.MZZYBZ = '0'  or A.MZZYBZ = '1' ) and (XMZT00 in ('0', '1','5','7','9')  or XMZT00 in ('2')  or XMZT00 in ('3','4') ) ) 
     and nvl(A.CXDJH0,0) = 0  and (A.SL0000-A.CXSL00)>0 and ZYHGHH in ('')
       
        and KDRQ00 between '20230722' and '20230725'  order by XMZT00,YJDJH0 Desc