Может какнить его из файлика можно подгружать?

А примерчик есть какойнить как читать из файла?

Файлик прочитал. Но в RecordSet не получается поместить запрос, похоже он очень большой. Как это сделать?

Прочитал из файлика запрос поместил в RecordSet при попытке выполнения вываливается
Run-time error '-2147467259 (80004005)'
На других, не больших, запросах все отрабатывает

select
db,
sum(cnt_a) cnt_a, sum(divider_a) divider_a, sum(gnvls_a) gnvls_a, sum(licensed_a) licensed_a,
sum(dif_id_common_a) dif_id_common_a, sum(dif_fullname_a) dif_fullname_a, sum(dif_divider_a) dif_divider_a, sum(dif_gnvls_a) dif_gnvls_a, sum(dif_licensed_a) dif_licensed_a,
sum(cnt_w) cnt_w, sum(divider_w) divider_w, sum(gnvls_w) gnvls_w, sum(licensed_w) licensed_w,
sum(cnt_d) cnt_d, sum(divider_d) divider_d, sum(gnvls_d) gnvls_d, sum(licensed_d) licensed_d
from
(
select 1 ord, 'RMS' DB,
sum(decode(rms.status, 'A', 1, 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(rms.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(rms.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(rms.licensed, 1, 1, 0), 0)) licensed_a,
0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,
sum(decode(rms.status, 'W', 1, 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(rms.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(rms.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(rms.licensed, 1, 1, 0), 0)) licensed_w,
0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d
from v_goods_rms rms
union all
select 2 ord, 'DC' DB,
sum(decode(rms.status, 'A', decode(dc.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(dc.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(dc.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(dc.licensed, 1, 1, 0), 0)) licensed_a,
0 dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(rms.full_name), upper(dc.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(rms.divider, dc.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(rms.gnvls, dc.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(rms.licensed, dc.licensed, 0, 1), 0)) dif_licensed_a,
sum(decode(rms.status, 'W', decode(dc.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(dc.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(dc.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(dc.licensed, 1, 1, 0), 0)) licensed_w,
0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d
from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
union all
select 2 ord, 'DC' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,
0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,
0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,
count(*) cnt_d,
sum(decode(sign(dc.divider - 1), 1, 1, 0)) divider_d,
sum(decode(dc.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(dc.licensed, 1, 1, 0)) licensed_d
from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
where rms.bar_code is null
union all
select 3 ord, 'master' DB,
sum(decode(rms.status, 'A', decode(m.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(m.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, 1, 1, 0), 0)) licensed_a,

sum(decode(rms.status, 'A', decode(dc.id_common_name, m.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(dc.full_name), upper(m.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(dc.divider - 1, m.divider - 1, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(dc.gnvls, m.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(dc.licensed, m.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(m.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(m.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(m.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(m.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
union all
select 3 ord, 'master' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(m.id_goods) cnt_d,
sum(decode(sign(m.divider - 1), 1, 1, 0)) divider_d,
sum(decode(m.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(m.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
where rms.bar_code is null
union all
select 4 ord, 'dsosed' DB,
sum(decode(rms.status, 'A', decode(dsosed.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(dsosed.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(dsosed.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(dsosed.licensed, 1, 1, 0), 0)) licensed_a,
sum(decode(rms.status, 'A', decode(m.id_common_name, dsosed.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(dsosed.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, dsosed.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, dsosed.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, dsosed.licensed, 0, 1), 0)) dif_licensed_a,
sum(decode(rms.status, 'W', decode(dsosed.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(dsosed.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(dsosed.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(dsosed.licensed, 1, 1, 0), 0)) licensed_w,
0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d
from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_dsosed dsosed on m.id_goods = dsosed.id_goods
union all
select 4 ord, 'dsosed' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,
0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,
0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,
count(dsosed.id_goods) cnt_d,
sum(decode(sign(dsosed.divider - 1), 1, 1, 0)) divider_d,
sum(decode(dsosed.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(dsosed.licensed, 1, 1, 0)) licensed_d
from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_dsosed dsosed on m.id_goods = dsosed.id_goods
where rms.bar_code is null
union all
select 5 ord, 'ekat' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,
sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_ekat ekat on m.id_goods = ekat.id_goods
union all
select 5 ord, 'ekat' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_ekat ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
---------------------------------------------------------------------------------------------------------
union all
select 6 ord, 'interlek' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,

sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_interlek ekat on m.id_goods = ekat.id_goods
union all
select 6 ord, 'interlek' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_interlek ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
---------------------------------------------------------------------------------------------------------
union all
select 7 ord, 'kazan' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,

sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_kazan ekat on m.id_goods = ekat.id_goods
union all
select 7 ord, 'kazan' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_kazan ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
---------------------------------------------------------------------------------------------------------
union all
select 8 ord, 'lemmdb' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,

sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_lemmdb ekat on m.id_goods = ekat.id_goods
union all
select 8 ord, 'lemmdb' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_lemmdb ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
---------------------------------------------------------------------------------------------------------
union all
select 9 ord, 'megg' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,

sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_megg ekat on m.id_goods = ekat.id_goods
union all
select 9 ord, 'megg' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_megg ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
---------------------------------------------------------------------------------------------------------
union all
select 10 ord, 'murmansk' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,

sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_murmansk ekat on m.id_goods = ekat.id_goods
union all
select 10 ord, 'murmansk' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_murmansk ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
---------------------------------------------------------------------------------------------------------
union all
select 11 ord, 'novosib' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,

sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_novosib ekat on m.id_goods = ekat.id_goods
union all
select 11 ord, 'novosib' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_novosib ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
---------------------------------------------------------------------------------------------------------
union all
select 12 ord, 'orange' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,

sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_orange ekat on m.id_goods = ekat.id_goods
union all
select 12 ord, 'orange' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_orange ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
---------------------------------------------------------------------------------------------------------
union all
select 13 ord, 'perma' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,

sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_perma ekat on m.id_goods = ekat.id_goods
union all
select 13 ord, 'perma' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_perma ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
---------------------------------------------------------------------------------------------------------
union all
select 14 ord, 'perm_m' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,

sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_perm_m ekat on m.id_goods = ekat.id_goods
union all
select 14 ord, 'perm_m' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_perm_m ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
---------------------------------------------------------------------------------------------------------
union all
select 15 ord, 'piter' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,

sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_piter ekat on m.id_goods = ekat.id_goods
union all
select 15 ord, 'piter' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_piter ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
---------------------------------------------------------------------------------------------------------
union all
select 16 ord, 'rostov' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,

sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_rostov ekat on m.id_goods = ekat.id_goods
union all
select 16 ord, 'rostov' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_rostov ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
---------------------------------------------------------------------------------------------------------
union all
select 17 ord, 'santa' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,

sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_santa ekat on m.id_goods = ekat.id_goods
union all
select 17 ord, 'santa' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_santa ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
---------------------------------------------------------------------------------------------------------
union all
select 18 ord, 'saratov' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,

sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_saratov ekat on m.id_goods = ekat.id_goods
union all
select 18 ord, 'saratov' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_saratov ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
---------------------------------------------------------------------------------------------------------
union all
select 19 ord, 'spartak' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,

sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_spartak ekat on m.id_goods = ekat.id_goods
union all
select 19 ord, 'spartak' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_spartak ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
---------------------------------------------------------------------------------------------------------
union all
select 20 ord, 'togliatti' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,

sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_togliatti ekat on m.id_goods = ekat.id_goods
union all
select 20 ord, 'togliatti' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_togliatti ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
---------------------------------------------------------------------------------------------------------
union all
select 21 ord, 'trfc' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,

sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_trfc ekat on m.id_goods = ekat.id_goods
union all
select 21 ord, 'trfc' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_trfc ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
---------------------------------------------------------------------------------------------------------
union all
select 22 ord, 'trifarma' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,

sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,

sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,

0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d

from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_trifarma ekat on m.id_goods = ekat.id_goods
union all
select 22 ord, 'trifarma' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,

0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,

0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,

count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d

from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_trifarma ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
union all
select 23 ord, 'verbena' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,
sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,
sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,
0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d
from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_verbena ekat on m.id_goods = ekat.id_goods
union all
select 23 ord, 'verbena' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,
0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,
0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,
count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d
from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_verbena ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
union all
select 24 ord, 'voron' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,
sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,
sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,
0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d
from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_voron ekat on m.id_goods = ekat.id_goods
union all
select 24 ord, 'voron' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,
0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,
0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,
count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d
from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_voron ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
union all
select 25 ord, 'nnovgorod' DB,
sum(decode(rms.status, 'A', decode(ekat.id_goods, null, 0, 1), 0)) cnt_a,
sum(decode(rms.status, 'A', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_a,
sum(decode(rms.status, 'A', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_a,
sum(decode(rms.status, 'A', decode(ekat.licensed, 1, 1, 0), 0)) licensed_a,
sum(decode(rms.status, 'A', decode(m.id_common_name, ekat.id_common_name, 0, 1), 0)) dif_id_common_a,
sum(decode(rms.status, 'A', decode(upper(m.full_name), upper(ekat.full_name), 0, 1), 0)) dif_fullname_a,
sum(decode(rms.status, 'A', decode(m.divider, ekat.divider, 0, 1), 0)) dif_divider_a,
sum(decode(rms.status, 'A', decode(m.gnvls, ekat.gnvls, 0, 1), 0)) dif_gnvls_a,
sum(decode(rms.status, 'A', decode(m.licensed, ekat.licensed, 0, 1), 0)) dif_licensed_a,
sum(decode(rms.status, 'W', decode(ekat.id_goods, null, 0, 1), 0)) cnt_w,
sum(decode(rms.status, 'W', decode(sign(ekat.divider - 1), 1, 1, 0), 0)) divider_w,
sum(decode(rms.status, 'W', decode(ekat.gnvls, 1, 1, 0), 0)) gnvls_w,
sum(decode(rms.status, 'W', decode(ekat.licensed, 1, 1, 0), 0)) licensed_w,
0 cnt_d,
0 divider_d,
0 gnvls_d,
0 licensed_d
from v_goods_rms rms
left outer join v_goods_dc dc on rms.bar_code = dc.bar_code
left outer join v_goods_master m on dc.id_goods = m.id_goods
left outer join v_goods_nnovgorod ekat on m.id_goods = ekat.id_goods
union all
select 25 ord, 'nnovgorod' DB,
0 cnt_a,
0 divider_a,
0 gnvls_a,
0 licensed_a,
0 dif_id_common_a,
0 dif_fullname_a,
0 dif_divider_a,
0 dif_gnvls_a,
0 dif_licensed_a,
0 cnt_w,
0 divider_w,
0 gnvls_w,
0 licensed_w,
count(ekat.id_goods) cnt_d,
sum(decode(sign(ekat.divider - 1), 1, 1, 0)) divider_d,
sum(decode(ekat.gnvls, 1, 1, 0)) gnvls_d,
sum(decode(ekat.licensed, 1, 1, 0)) licensed_d
from v_goods_rms rms
right outer join v_goods_dc dc on rms.bar_code = dc.bar_code
right outer join v_goods_master m on dc.id_goods = m.id_goods
right outer join v_goods_nnovgorod ekat on m.id_goods = ekat.id_goods
where rms.bar_code is null
)
group by ord, db