create or replace view vw_sf_byjk00_mzcfmx_qt as
select
   a.CFLSH0 as Presc_no,          --处方编号
   null as Advice_code,           --医嘱编号
   a.YPNM00 as Drug_code,         --药品编号
   a.YPGG00 as Drug_spec,         --药品规格
   a.YPMC00 as Drug_name,         --药品名称
   null as Firm_id,               --厂商编号
   null as Firm_name,             --厂商名称
   null as Package_spec,          --药品包装规格
   null as Package_units,         --药品包装单位
   a.YPZSL0 as Quantity,          --数量
   a.CFDW00 as Unit,              --药品单位
   a.HJJE00 as Costs,             --费用
   a.HJJE00 as Payments,          --实付费用
   trim(to_char(a.CSL000,'fm9999999990.00')) as Dosage,                  --药品剂量（每次服用量）
   a.JLDW00 as Dosage_units,      --剂量单位（每次服用单位）
   a.YPYFMC as Administration,    --药品用法（使用方法）
   (select SM0000 from BM_PC0000 where PCMC00=a.PCMC00 and rownum=1) as frequency,    --药品用量（使用频率每天几次）
   (select psmc00 from bm_ps0000 b where a.pslbid=b.psid00) as Additionusage,         --补充用法
   ZB0000 as Rcpt_remark            --处方明细备注信息
from YF_MZCFMX a
;