create or replace view cwzz_zdywview
(sheetid, sdate, shopid, shopid1, shopid2, shoptypeid, psje, bhsje, jxse)
as
select w.sheetid,
trunc(to_date(sdate)),
decode(isjm, 0, c.fascode, 1, '00303'),
decode(isjm, 0, '011', 1, '011'),
f.fascode,
shoptypeid,
sum(costvalue),
sum(w.cost * qty/1.17),
sum(w.cost * qty * 0.17 / 1.17 )
from shop a,
wastebook w,
fasshopcode c,
departuse@DBDMS e,
fasshopcode1 f
where a.shopid = w.shopid
and a.shopid = c.shopid
and sheettype = '2261'
and e.sheetid = w.sheetid
and f.shopid = to_char(e.departmentid)
and e.dtype = 1
group by sdate,
decode(isjm, 0, c.fascode, 1, '00303'),
shoptypeid,
w.sheetid,
decode(isjm, 0, '011', 1, '011'),
f.fascode;