---病人费别下拉框sql
select * from bm_ybbrlb  ORDER BY FBBH00,YBZXLB,YBBRLB

---特殊打印跟踪SQL
select ZYID00,ZYH000,GJBM00,GJBM01,XMBH00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00*100 ZFBL00,FBBH00,YBZXLB,YBBRLB, 
 SUM(XMSL00) XMSL00,SUM(HJJE00) HJJE00,SUM(ZFJE00) ZFJE00 
 from VW_ZY_RQDMX1_TS where 
 zyid00=2526571
 and QDRQ00>='20200110'
 and QDRQ00<='20201010'
 and FBBH00+0=3
 and YBZXLB='1'
 and YBBRLB='0'
 group by ZYID00,ZYH000,GJBM00,GJBM01,XMBH00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00*100,FBBH00,YBZXLB,YBBRLB 
 ORDER BY GJBM01

---特殊打印视图（vw_zy_rqdmx1_ts）
CREATE OR REPLACE VIEW vw_zy_rqdmx1_ts (
   zyid00,
   zyh000,
   qdrq00,
   gjbm00,
   gjbm01,
   xmbh00,
   xmmc00,
   xmgg00,
   xmdw00,
   xmdj00,
   xmsl00,
   hjje00,
   zfje00,
   zfbl00,
   fbbh00,
   ybzxlb,
   ybbrlb )
AS
select   
          b.zyid00 ,
          b.zyh000 ,
          B.QDRQ00 ,
          max(G.GJBM00) , --显示用
          max(A.GJBM00) , --排序用
          max(A.XMBH00) ,
          A.HBXMMC ,
          ' ',
          max(A.XMDW00) ,
          to_char(Round(sum(a.HJJE00),2)) XMDJ00,  --单价 
          1,                 
          SUM(A.XMSL00*A.XMDJ00) HJJE00,
          SUM(A.XMSL00*A.XMDJ00*F.ZFBL00) ZFJE00,
          max(F.ZFBL00) ,
          max(F.FBBH00) ,
          max(F.YBZXLB) ,
          max(F.YBBRLB)
   from  ZY_FYMX00 A ,ZY_BRFY00 B ,VW_BM_YBSFDY F,BM_YYSFXM G
       where A.DJH000 = B.DJH000
         and F.SFYP00 = 'N'         
         and A.XMBH00 = F.SFXMID
         AND A.XMBH00 = G.SFXMID  
         and a.xmbh00<9999999990   
         and a.HBXMMC is not null 
   group by B.ZYID00,B.ZYH000,B.QDRQ00,A.HBXMMC
union all
   select   
          b.zyid00 ,
          b.zyh000 ,
          B.QDRQ00 ,
          G.GJBM00 , --显示用
          A.GJBM00 , --排序用
          A.XMBH00 ,
          A.XMMC00 , 
          substr(decode(G.JSXM00,'2',G.GG0000,G.BZ0000),1,100),     --规格,收费项目没有规格,用单位代替
          A.XMDW00 ,
          DECODE(SIGN(A.XMDJ00-1),-1,'0','')||TO_CHAR(A.XMDJ00)||'/'||TO_CHAR(F.ZFBL00) XMDJ00,
          SUM(A.XMSL00) ,                 
          SUM(A.XMSL00*A.XMDJ00) HJJE00,
          SUM(A.XMSL00*A.XMDJ00*F.ZFBL00) ZFJE00,
          F.ZFBL00 ,
          F.FBBH00 ,
          F.YBZXLB ,
          F.YBBRLB
   from  ZY_FYMX00 A ,ZY_BRFY00 B ,VW_BM_YBSFDY F,BM_YYSFXM G
       where A.DJH000 = B.DJH000
         and F.SFYP00 = 'N'         
         and A.XMBH00 = F.SFXMID
         AND A.XMBH00 = G.SFXMID  
         and a.xmbh00<9999999990   
         and a.HBXMMC is null 
   group by B.ZYID00,B.ZYH000,B.QDRQ00,G.GJBM00,A.GJBM00,A.XMBH00,A.XMMC00,substr(decode(G.JSXM00,'2',G.GG0000,G.BZ0000),1,100),A.XMDW00,DECODE(SIGN(A.XMDJ00-1),-1,'0','')||TO_CHAR(A.XMDJ00),F.ZFBL00,F.FBBH00,F.YBZXLB,F.YBBRLB
union all
      select 
          A.ZYID00,
          A.ZYH000,
          A.QDRQ00,
          '',
          '',
          C.YPNM00,
          C.YPMC00,
          C.YPGG00,
          C.CFDW00,                 
          DECODE(SIGN(C.LSDJ00-1),-1,'0','')||TO_CHAR(C.LSDJ00)||'/'||TO_CHAR(J.ZFBL00) XMDJ00, 
          SUM(C.YPZSL0),
          SUM(round(C.LSDJ00*C.YPZSL0,2)) HJJE00,
          SUM(round(C.LSDJ00*C.YPZSL0,2)*J.ZFBL00) ZFJE00,
          J.ZFBL00,
          J.FBBH00,
          J.YBZXLB,
          J.YBBRLB
   from  ZY_BRFY00 A,yf_zycf00 B,yf_zycfmx C,VW_BM_YBSFDY J
       where A.DJH000 = B.DJH000 
         and B.cflsh0 = C.cflsh0
         AND J.SFYP00 = 'Y'
         AND J.SFXMID = C.YPNM00
    group by A.ZYID00,A.ZYH000,A.QDRQ00,C.YPNM00,C.YPMC00,C.YPGG00,C.CFDW00,DECODE(SIGN(C.LSDJ00-1),-1,'0','')||TO_CHAR(C.LSDJ00),J.ZFBL00,J.FBBH00,J.YBZXLB,J.YBBRLB
union all 
     select 
          A.ZYID00,
          A.ZYH000,
          A.QDRQ00,
          '',
          '',                 
          B.YPNM00,
          B.YPMC00,
          B.YPGG00,
          B.QLDW00,     
          DECODE(SIGN(B.LSDJ00-1),-1,'0','')||TO_CHAR(B.LSDJ00)||'/'||TO_CHAR(F.ZFBL00) XMDJ00,
          SUM(B.YPZSL0),
          SUM(round(B.LSDJ00*B.YPZSL0,2)) HJJE00,
          SUM(round(B.LSDJ00*B.YPZSL0,2)*F.ZFBL00) ZFJE00,
          F.ZFBL00,
          F.FBBH00,
          F.YBZXLB,
          F.YBBRLB
 from  ZY_BRFY00 A,YF_YZYPSQ B,VW_BM_YBSFDY F
      where A.DJH000 = B.DJH000
        AND F.SFYP00 = 'Y'
        AND F.SFXMID = B.YPNM00
  group by A.ZYID00,A.ZYH000,A.QDRQ00,B.YPNM00,B.YPMC00,B.YPGG00,B.QLDW00,DECODE(SIGN(B.LSDJ00-1),-1,'0','')||TO_CHAR(B.LSDJ00),F.ZFBL00,F.FBBH00,F.YBZXLB,F.YBBRLB
/