-- Start of DDL Script for View SD_HOSPITAL.VW_ZY_JSBBXX
-- Generated 10-°ËÔÂ-2011 16:22:57 from SD_HOSPITAL@PTXYQYY

CREATE OR REPLACE VIEW vw_zy_jsbbxx (
   hjje00,
   grzhzf,
   xnhzf0,
   tcjjzf,
   sbgrzh,
   sbtcjj,
   ybxjzf,
   jzzfje,
   jzje00,
   cyqfje,
   cyysk0,
   cyytk0,
   jmje00,
   jzrq00,
   jzsj00,
   fbbh00,
   ybdjh0,
   gwybz0 )
AS
select 
  a.HJJE00,decode(b.sfxnh0,0,a.GRZHZF,2,a.GRZHZF,3,a.GRZHZF)GRZHZF,decode(b.sfxnh0,1,a.GRZHZF,4,a.GRZHZF)XNHZF0,a.TCJJZF,decode(a.yblb00,'Z',0,a.SBGRZH)SBGRZH,
  decode(a.yblb00,'Z',0,a.SBTCJJ)SBTCJJ,decode(a.FBBH00,3,a.HJJE00-a.GRZHZF-a.TCJJZF-decode(sign(Instrb(','||trim(b.ybbhsb)||',',',14,')),1,0,a.SBGRZH+a.SBTCJJ)
   -decode(sign(Instrb(','||trim(b.ybbhsb)||',',',15,')),1,0,a.GWYBZ0),0)YBXJZF,
  decode(a.FBBH00,1,0,3,0,a.ZFJE00)JZZFJE,a.JZJE00,a.CYYSK0-a.CYYTK0 CYQFJE,
  a.CYYSK0,a.CYYTK0,a.JMJE00,a.JZRQ00,a.JZSJ00,a.FBBH00,a.YBDJH0,decode(sign(Instrb(','||trim(b.ybbhsb)||',',',15,')),1,0,a.GWYBZ0) GWYBZ0 --a.GWYBZ0
from ZY_JZB000 A,IC_YBBRLB B where a.fbbh00=b.fbbh00 and a.yblb00=b.yblb00
/


-- End of DDL Script for View SD_HOSPITAL.VW_ZY_JSBBXX