CREATE OR REPLACE VIEW SD_HOSPITAL.VW_WZ_RCK000_MSQL
 (
 RCKID0, RCKDH0, QRRQ00, QZ0000, QZ0001, ZJEDX0, ZJEXX0, FHBMMC, CKLYLB, 
RKYGXM, RCKBMC, CGYGXM, FPH000, CKKSLB, SHBMMC, QRYGXM, SHYGXM, DJMC00, 
DYBZ00

 )
 AS 
select b.RCKID0,b.RCKDH0,substr(b.QRRQ00,1,4)||'年'||substr(substr(b.QRRQ00,1,6),5,6)||'月'||substr(b.QRRQ00,7,8)||'日' QRRQ00,
           ' ' QZ0000,  --类别值,有包含'其中:'
           ' ' QZ0001,  --类别值,不包含'其中:'
           ' ' ZJEDX0,  --总金额大写
           ' ' ZJEXX0,  --总金额小写
           b.FHBMMC,
           b.RCKBMC,
           b.RKYGXM,
           decode(b.RCKLB0,'2',decode(b.RCKLX0,'32','申请人:','申领人:')) CKLYLB,
           b.CGYGXM,
           (select A.FPH000 from WZ_RCKMX0 A where A.RCKID0=B.RCKID0 and ROWNUM=1) FPH000,
           decode(b.RCKLB0,'2',decode(b.RCKLX0,'32','申退科室：','领用科室：')) as CKKSLB,
           b.SHBMMC,
           b.QRYGXM,
           b.shygxm,
           decode(b.RCKLB0,'1',decode(b.ZTBZ00,'4','入库作废单',decode(b.RCKLX0,'07','退库入库单','入库单')),'2',decode(b.ZTBZ00,'4','出库作废单','出库')) as DJMC00,
           decode(sign(round(to_number(sysdate-to_date(decode(b.QRRQ00,null,'100010100:00:00',b.QRRQ00||b.QRSJ00),'YYYYMMDDHH24:MI:SS'))*24*60*60,1)-20),1,'(补打)','') DYBZ00
      from VW_WZ_RCK000 B
/