--药库入库单打印备份
CREATE OR REPLACE VIEW SD_HOSPITAL.VW_YK_YPRKDZDYDJ_MSQL
 (
 QRRQ00, RKDH00, ZKJE00, CGY000, JHRQ00, CRBMMC, YPLB00, QRR000, TITLE0, 
ZBGJJE, ZBLSJE, LSJE00, GJJE00, SJGJJE, FPH000, JXCJ00, YPLBMC

 )
 AS 
SELECT TO_DATE(D.QRRQ00,'YYYY-MM-DD') QRRQ00,D.RKDH00,D.ZKJE00,G.ZWXM00 CGY000,D.JHRQ00,
    (SELECT H.CRBMMC FROM VW_YK_YPCRKDW H WHERE D.GHDWNM=H.CRBMNM) CRBMMC, 
    (SELECT L.LBMC00 FROM BM_YPLB00 L WHERE L.LBBH00=D.LBBH00) YPLB00, 
    (SELECT G1.ZWXM00 FROM BM_YGBM00 G1 WHERE D.QRRBH0=G1.YGBH00) QRR000, 
    (SELECT Trim(YYQC00) FROM XT_YYXX00 WHERE FLAG00='1')
       ||(SELECT Trim(M.BMMC00) FROM BM_BMBM00 M WHERE D.YKBMBH=M.BMBH00)||'入库单' Title0, 
    (SELECT SUM(ROUND(X.RKSL00*X.FPGJDJ,2)) 
       FROM YK_YPRKMX X WHERE X.RKDH00=D.RKDH00 AND SFZBYP='Y') ZBGJJE,
    (SELECT SUM(ROUND(X.RKSL00*X.LSDJ00,2)) 
       FROM YK_YPRKMX X WHERE X.RKDH00=D.RKDH00 AND SFZBYP='Y') ZBLSJE,
    (SELECT SUM(ROUND(X.RKSL00*X.LSDJ00,2)) FROM YK_YPRKMX X WHERE X.RKDH00=D.RKDH00 ) LSJE00,
    (SELECT SUM(ROUND(X.RKSL00*X.FPGJDJ,2)) FROM YK_YPRKMX X WHERE X.RKDH00=D.RKDH00 ) GJJE00,
    (SELECT SUM(ROUND(X.RKSL00*X.GJDJ00,2)) FROM YK_YPRKMX X WHERE X.RKDH00=D.RKDH00 ) SJGJJE,
    (SELECT  X.fph000 FROM YK_YPRKMX X WHERE X.RKDH00=D.RKDH00 and rownum = 1) FPH000,
    (SELECT SUM(ROUND(ROUND(X.RKSL00*X.LSDJ00,2)-X.GJJE00,2)) 
       FROM YK_YPRKMX X WHERE X.RKDH00=D.RKDH00 ) JXCJ00,
    DECODE((SELECT 1 FROM BM_YD0000 A,YK_YPRKMX B WHERE B.RKDH00=D.RKDH00
               AND ROWNUM=1 AND A.YPNM00=B.YPNM00
               AND (A.MZDJ00='1' OR A.DPDJ00='1' OR A.SJDJ00='1')),
             '1','麻精药品入库单','普通药品入库单')
   FROM YK_YPRKD0 D,BM_YGBM00 G 
   WHERE D.CZYBH0=G.YGBH00(+)
/