create view GIVCN.APP_VIEW_GR_DEB_OR (PLAT_DATE, LINE_ID, SUM_L, MEM_ORDER, LINE_NAME) as
SELECT  b.plat_date plat_date,a.line_id line_id, sum(a.bank_sum) sum_l, min(x.mem_order) mem_order , min(mem_name) line_name
FROM app_bank a, app_plateg b, line c, line_x_set x
where a.line_id= c.mem_id
and a.plat_id=b.plat_id
and b.deb_kred='D'
and c.mem_id=x.mem_id and x.set_id= 80000000 
group by b.plat_date,a.line_id
 union
 select plat_date plat_date, min( 80000326 ) line_id, sum(nds_sum) sum_l, min( 9999999 ) mem_order, min(' ПДВ (_нш_ надходження) ') line_name from app_plateg
 where plat_status='Y' and deb_kred='D'
 group by plat_date

order by  plat_date,mem_order;