CREATE OR REPLACE VIEW SD_HOSPITAL.VW_EMR_PATIENT_FEE
 (
 DRUGPROPORTION, TOTAL, DRUGFEE, IPID, FEE_INFO, OTHER_INFO

 )
 AS 
select DRUGPROPORTION,TOTAL,DRUGFEE,IPID,
 '药占比'||drugProportion||' 总费用'|| total||' 药费'||drugFee FEE_INFO,' ' OTHER_INFO
from (
select to_char(nvl(round(YBHJJE/HJJE00*100,2),0),'FM9999990.90')||'%' drugProportion,to_char(nvl(HJJE00,0),'FM9999990.90') total,
to_char(nvl(YBHJJE,0),'FM9999990.90') drugFee,ZYID00 IPID from (
select sum(b.HJJE00) HJJE00,sum(decode(sign(B.XMBH00-9999999995),1,b.HJJE00,0)) YBHJJE,A.ZYID00
from ZY_BRFY00 A, ZY_FYMX00 B where A.DJH000 = B.DJH000 group by A.ZYID00)) A
/