-- Start of DDL Script for View SD_HOSPITAL.VW_BQ_SYKPNR
-- Generated 1-ÁùÔÂ-2012 10:16:30 from SD_HOSPITAL@ORCL

CREATE OR REPLACE VIEW vw_bq_sykpnr (
   yzid00,
   ypyfmc,
   ypmc00,
   ypmcgg,
   ypgg00,
   yyzf00,
   pcmc00,
   yznr01 )
AS
select t1.yzid00,ypyfmc,t1.YPMC00,t1.YPMC00||'['||t1.YPGG00||']' ypmcgg,decode(t1.YZCLLB,'×Ô±¸Ò©','[±¸]')||' '||DECode(Sign(t1.MCSL00-1),-1,'0','')||t1.mcsl00||t1.JLDW00 YPGG00,Substrb(t2.YYZF00,1,10)yyzf00,
t2.PCMC00,lpad(t1.YPMC00||'['||t1.YPGG00||']',20,' ')|| t1.yznr01 yznr01
from BQ_YPYZMX t1, BQ_YPYZ00 t2 WHERE t1.YZID00=t2.YZID00
/


-- End of DDL Script for View SD_HOSPITAL.VW_BQ_SYKPNR