--医技执行单打印备份
CREATE OR REPLACE VIEW SD_HOSPITAL.VW_YJ_YFCFMX
 (
 CFLSH0, YPMC00, CSL000, JLDW00, YPZSL0, CFDW00, YPYFMC, PCMC00, YYSJ00, 
YYSJDW, ZB0000, ZXCS00, CFID00, ZXCS01

 )
 AS 
SELECT
a.CFLSH0,
a.YPMC00,
DECODE(NVL(a.CSL000,0),0,a.YPZSL0,a.CSL000),
DECODE(NVL(a.CSL000,0),0,a.CFDW00,a.JLDW00),
a.YPZSL0,
a.CFDW00,
a.YPYFMC,
a.PCMC00,
DECODE(NVL(a.YYSJ00,0),0,1,a.YYSJ00),
DECODE(NVL(a.YYSJ00,0),0,'天',a.YYSJDW),
a.ZB0000,
DECODE(NVL(a.ZXcs00,0),0,1,a.ZXcs00) ZXCS00,
a.CFID00,
decode(nvl((select sl0000 from yj_yw0000 b where a.cflsh0=b.yzcfid and rownum=1),0),0,1,
            (select sl0000 from yj_yw0000 b where a.cflsh0=b.yzcfid and rownum=1))
FROM YF_MZCFMX a
/