Добавить Столбец X из таблицы Y для вывода под параметры запросы
Z из таблицы Y = V.CD_M
SELECT
V.CD_U as «Код поставщика (cd_u)»
, u.nm_u as «Название поставщика»
, V.CD_M as «Код позиции»
, V.NM_M as «Наименование позиции»
, V.SHK as «Штрих-код позиции»
, V.NM_PROD as «Производитель позиции»
, V.PRINT_NAME as «Страна производства»
, men.full_name, men.user_name, men.mail
FROM ABC.V_REP_SHK_POST V, ABC.QRUNPARAM Q, abc.wabc_org_med w, abc.usr u,
(select u.cd_u, u.nm_u nm_jurid, b.full_name, b.user_name, b.mail — мен
from abc.usr u,
(select u.cd_u, u.nm_u nm_jurid, n.net_login full_name,n.net_login || '.xlsx' user_name, n.net_login||'@'||n.net_domain mail
from abc.NETPROPUSER n, abc.agent a, abc.usr u
where a.cd_a = n.cd_a
and u.cd_a = a.cd_a) b — мен
where u.cd_u = b.cd_u(+)
and u.cd_u in (select distinct cd_u from abc.doc where tp = 1861 and date0 >= trunc(sysdate)-1 /'01.10.2018'/)) men
WHERE V.CD_U = Q.PVALUE1 AND Q.PCLASS = 2 and not exists (select 1 from epost.invoice_cross_med where ITEMIDORG = V.CD_M and supplier = v.cd_u)
and w.cd_m = v.cd_m
and w.org_id=1
and u.cd_u = v.cd_u
and v.cd_u = men.cd_u