SELECT B.MZZYBZ,D.XKH000, B.QSRQ00||' '||B.QSSJ00 QSRQSJ, B.YJDJH0, B.BRID00,B.XB0000,B.NL0000,B.ZLXMID, B.ZLXMJC,
  decode(substr(txm000,1,1),'Y', substr(SF_YJ_GetChar(length(txm000),'*'),1,20), TXM000) JMTXM0, TXM000, B.ZYGHID,b.ZYHGHH, 
  B.LRXM00, B.KDYSXM, B.KDRQ00, B.SL0000, B.ZJE000, 
  (DECODE(nvl(sfdjh0,'0'),'0','0','1')) XMZT00, 
  (SELECT BMMC00 FROM BM_BMBM00 WHERE BMBH00 = B.YJKSBH) ZXKS00, 
  (SELECT BRZJBH FROM BM_BRXXB0 WHERE BRID00 = B.BRID00 AND ROWNUM = 1) BRZJBH, 
  (SELECT BRJTDZ FROM BM_BRXXB0 WHERE BRID00 = B.BRID00 AND ROWNUM = 1) BRJTDZ, 
  (SELECT nvl(BRDH00,BRLXDH) FROM BM_BRXXB0 WHERE BRID00 = B.BRID00 AND ROWNUM = 1) BRDH00, 
  (SELECT BMMC00 FROM BM_BMBM00 WHERE BMBH00(+) = B.SMKSBH) SMKS00, 
  (Select ZYZBMC FROM BM_JYZYZB E WHERE E.ZYZBID = C.ZYZBID) ZYZBMC, 
  nvl(B.SMKSBH, 204) SMKSBH, nvl(B.QSR000,4289) QSR000, 
  NVL((SELECT DWID00 FROM TJ_BRXXB0 WHERE GHID00 = B.ZYGHID), 0) DWID00, B.YJKSBH, 
  (SELECT YBLB00 FROM BM_BRXXB0 WHERE BRID00 = B.BRID00 AND ROWNUM = 1) YBLB00, B.BBZT00
, B.BRXM00||(select decode(G.XKH000,null,null,'--'||G.XKH000) from BM_YGBM00 G,BM_BRXXB0 M where G.SFZBH0=M.BRZJBH and M.BRID00=b.BRID00 and rownum=1) as BRXM00 
  ,0 as Hour
 ,C.CYGLX0, B.BBCLFF,C.CXGYS0,C.XMDM00 
 ,(select BBMC00 from BM_BBZD00 where BBID00=trim(B.BBID00)) BBMC00 
 ,B.DBTXM0,b.DYRQTM 
 FROM YJ_YW0000 B, BM_ZLZD00 C, BM_YGBM00 D 
  WHERE B.QSR000 = D.YGBH00(+) AND C.ZLXMID = B.ZLXMID  AND B.ZLXMJC <> 'Ò½¼¼¿ÆÊÒ·ÑÓÃÍË·Ñ' 
  AND XMZT00 IN ('0','1','2','3','4') 
  AND LBBH00 = 4 AND NVL(SL0000, 0) - NVL(CXSL00, 0) > 0 AND SL0000 > 0 
 AND B.MZZYBZ = '0' 
 AND KDRQ00 BETWEEN '20240401' AND '20240422' 
 AND (SELECT DYBGRQ FROM YJ_YW0000 WHERE YJDJH0=B.YJDJH0) IS NOT NULL 
AND YJLRBZ <> 'T' 
 ORDER BY BRID00, ZYHGHH, ZYZBID, YZCFID, KDRQ00