SELECT D.XKH000, B.QSRQ00||' '||B.QSSJ00 QSRQSJ, B.YJDJH0, B.BRID00, B.BRXM00,B.XB0000,B.NL0000, B.ZLXMJC,
  decode(substr(txm000,1,1),'Y', substr(SF_YJ_GetChar(length(txm000),'*'),1,20), TXM000) JMTXM0, TXM000, B.ZYGHID, 
  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 BMMC00 FROM BM_BMBM00 WHERE BMBH00(+) = B.SMKSBH) SMKS00, 
  (Select ZYZBMC FROM BM_JYZYZB E WHERE E.ZYZBID = C.ZYZBID) ZYZBMC, 
  nvl(B.SMKSBH, 359) SMKSBH, nvl(B.QSR000,854) 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
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 '20121009' AND '20121009' 
 AND (SELECT DYBGRQ FROM YJ_YW0000 WHERE YJDJH0=B.YJDJH0) IS NULL 
AND YJLRBZ = 'T' 
AND YJDJH0 not in (Select CXDJH0 from VW_TJ_YJ_YW0000 where ZYGHID = B.ZYGHID AND cxdjh0 <> 0 )
AND YJDJH0 NOT IN (SELECT YJDJH0 FROM TJ_YJDJH0 Y,TJ_ZHXM00 D WHERE Y.ZLXMID=D.ZLXMID AND Y.GHID00 = B.ZYGHID AND D.SFYX00='N')
 ORDER BY BRID00, ZYHGHH, ZYZBID, YZCFID, KDRQ00