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    from VW_YJ_YW0000 A, BM_ZLZD00 B where B.ZLXMID = A.ZLXMID  and (YJKSBH = ? or (exists (select 1 from XT_KSZXXM where ZXKSBH = ? and ZLXMID=b.ZLXMID and b.SFQZX0='Y' ) and   instr(',211,16,301,',',301,')>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 KDRQ00 between '20200201' and '20200208'  order by XMZT00,YJDJH0 Desc