CREATE OR REPLACE VIEW SD_HOSPITAL.VW_YS_YJYW00_HTBL
 (
 ORDER_SN, REGISTER_NO, PAT_INDEX_NO, ORDER_TYPE, ORDER_CLASS, ORDER_CODE, 
ORDER_CONTENT, PARENT_ORDER_SN, IS_SUB_ORDER, OUT_ORDER_STATUS, DEPT_CODE, 
DEPT_NAME, GROSS_FEE, PRICE, DOCTOR_MEMO, PRESCRIPTION_SN, EXAM_CODE, EXAM_NAME, 
SAMPLE_CODE, SAMPLE

 )
 AS 
select
-- person      date            comments
-- ruanbh      2023.01.06      create 海泰电子病历接口_医技业务视图
  A.YJDJH0 ORDER_SN            ,--记录唯一号      
  A.ZYHGHH REGISTER_NO         ,--挂号流水号      
  A.BRID00 PAT_INDEX_NO        ,--患者索引号      
  (select decode(LBBH00,4,'JY',3,'JC',5,'ZL',6,'SS','QT') from BM_ZLZD00 X where X.ZLXMID=A.ZLXMID) ORDER_TYPE          ,--医嘱类型        
  nvl((select decode(instr(X.LBMC00,'急'),0,'OUT','JZ') from BM_GHLBB0 X where X.LBBH00=B.GHLB00 and rownum=1),'OUT') ORDER_CLASS         ,--医嘱分类        
  A.ZLXMID ORDER_CODE          ,--医嘱代码
  A.ZLXMJC ORDER_CONTENT       ,--医嘱内容        
  A.YJDJH0 PARENT_ORDER_SN     ,--主医嘱号        
  'N' IS_SUB_ORDER        ,--是否子医嘱             
  '050' OUT_ORDER_STATUS    ,--医嘱状态        
  A.KDKSBH DEPT_CODE           ,--下达科室代码    
  (select X.BMMC00 from BM_BMBM00 X where X.BMBH00=A.KDKSBH) DEPT_NAME           ,--下达科室名称    
  A.ZJE000   GROSS_FEE       ,--总价     TOTAL_PRICE
  round(A.ZJE000/A.SL0000,2) PRICE               ,--单价            
  A.BZ0000 DOCTOR_MEMO         ,--医生说明        
  A.YJDJH0 PRESCRIPTION_SN     ,--处方号          
  A.YJDJH0 EXAM_CODE           ,--检查单代码
  A.ZLXMJC EXAM_NAME           ,--检查单名称      
  A.BBID00 SAMPLE_CODE         ,--标本代码        
  (select X.BBMC00 from BM_BBZD00 X where X.BBID00=A.BBID00) SAMPLE              --标本名称        
  from YJ_YW0000 A,SF_BRXXB0 B
  where A.ZYGHID=B.GHID00
/