CREATE OR REPLACE VIEW SD_HOSPITAL.VW_YS_CFMX00_HTBL
 (
 PRES_DETAIL_NO, PARENT_ORDER_SN, DRUG_CODE, DRUG_NAME, DRUG_SPEC, ROUTE_CODE, 
ROUTE_NAME, DOSE, DOSE_UNIT_CODE, DOSE_UNIT, DOSEAGE_FORM_CODE, DOSEAGE_FORM, 
GROSS_AMOUNT, GROSS_UNIT, GROSS_UNIT_CODE, SELF_DRUG, DECOCTION_CODE, DECOCTION_NAME, 
DRUG_STORE_CODE, DRUG_STORE_NAME, FREQUENCY_CODE, FREQUENCY_NAME, GROSS_FEE, 
PRICE, DAYS

 )
 AS 
select
-- person      date            comments
-- ruanbh      2023.01.06      create 海泰电子病历接口_门诊处方明细视图
-- cyf          2023.02.09     集平成平调整了总量，总量单位，总量单位代码，总价的字段名
  A.CFID00 PRES_DETAIL_NO    ,--处方明细号  
  A.CFLSH0 PARENT_ORDER_SN   ,--主医嘱流水号
  A.YPNM00 DRUG_CODE         ,--药品代码    
  A.YPMC00 DRUG_NAME         ,--药品名称    
  A.YPGG00 DRUG_SPEC         ,--药品规格    
  C.YFID00 ROUTE_CODE        ,--用法代码    
  A.YPYFMC ROUTE_NAME        ,--用法名称    
  A.CSL000 DOSE              ,--剂量        
  A.JLDW00 DOSE_UNIT_CODE    ,--剂量单位代码
  A.JLDW00 DOSE_UNIT         ,--剂量单位    
  (select X.JXBH00 from BM_YD0000 X where X.YPNM00=A.YPNM00) DOSEAGE_FORM_CODE ,--剂型代码
  decode(b.ypdlbh,'2',(select Y.JXMC00 from BM_YD0000 X,BM_YPJX00 Y where X.YPNM00=A.YPNM00 and X.JXBH00=Y.JXBH00 and Y.LBBH00='2' ),
  '1',(select Y.JXMC00 from BM_YD0000 X,BM_YPJX00 Y where X.YPNM00=A.YPNM00 and X.JXBH00=Y.JXBH00 and Y.LBBH00='1' ),'0',(select Y.JXMC00 from BM_YD0000 X,BM_YPJX00 Y where X.YPNM00=A.YPNM00 and X.JXBH00=Y.JXBH00 and Y.LBBH00='0' )) DOSEAGE_FORM      ,--剂型名称
  A.YPZSL0 GROSS_AMOUNT            ,--总量 TOTAL
  A.CFDW00 GROSS_UNIT         ,--总量单位 TOTAL_UNIT
  A.CFDW00 GROSS_UNIT_CODE   ,--总量单位代码 TOTAL_UNIT_CODE
  A.SFZBY0 SELF_DRUG         ,--自备药标志  
  '' DECOCTION_CODE    ,--特殊煎法代码
  '' DECOCTION_NAME    ,--特殊煎法名称
  B.YFBMBH DRUG_STORE_CODE   ,--药房代码    
  (select X.BMMC00 from BM_BMBM00 X where X.BMBH00=B.YFBMBH) DRUG_STORE_NAME   ,--药房名称    
  C.PCID00 FREQUENCY_CODE    ,--频次代码    
  A.PCMC00 FREQUENCY_NAME    ,--频次名称    
  A.HJJE00 GROSS_FEE       ,--总价  TOTAL_PRICE
  A.LSDJ00 PRICE             ,--单价        
  A.YYSJ00 DAYS               --天数/周期数 
  from YF_MZCFMX A,YF_MZCF00 B,YS_CFMX00 C
  where A.CFLSH0=B.CFLSH0 and A.CFID00=C.CFID00
/