Ценник за шт плюс за упаковку : Супермаг Плюс (Супермаг 2000)

VitorJ ➤ По факту теперь нужно дополнить запрос, выборкой параметров из SMDiscQuantity и обработать в ценике

select t.Article, t.Name, t.Country,
(case
when c.weight < 1 and w.abbrev ='кг' then to_char(c.weight*1000)||'гр'
when c.weight < 1 and w.abbrev ='л' then to_char(c.weight*1000)||'мл'
else to_char(c.weight)||w.abbrev end) as weight,
t.Price,
t.PriceFull,
t.PriceShort,
supermag.russianspell.PriceCardString(0, t.Price) as grn,
supermag.russianspell.PriceCardString(2, t.Price) as kop,
(select ph.price
from supermag.SMPriceHistory ph
where (eventtime, recid) =
(select max(eventtime), max(recid)
from supermag.SMPriceHistory
where article = :P_ARTICLE
and storeloc = :P_LOC
and pricetype = :P_PRICE_TYPE
and round(:P_QTY*price,2) != t.Price)
and ph.storeloc = :P_LOC
and ph.article = :P_ARTICLE
and ph.pricetype = :P_PRICE_TYPE
and round(:P_QTY*ph.price,2) != t.Price) as oldprice,
(select QUANTITY
from (select rownum recnum, QUANTITY
from
( select article, QUANTITY, PERCENT
from supermag.SMDISCQUANTITY) article
where rownum < 3)
where recnum = 1) QUANTITY1,
(select QUANTITY
from (select rownum recnum, QUANTITY
from
( select article, QUANTITY, PERCENT
from supermag.SMDISCQUANTITY) article
where rownum < 3)
where recnum = 2) QUANTITY2,
(select PERCENT
from (select rownum recnum, PERCENT
from
( select article, QUANTITY, PERCENT
from supermag.SMDISCQUANTITY) article
where rownum < 3)
where recnum = 1) PERCENT1,
(select PERCENT
from (select rownum recnum, PERCENT
from
( select article, QUANTITY, PERCENT
from supermag.SMDISCQUANTITY) article
where rownum < 3)
where recnum = 2) PERCENT2,
t.RubSum,
t.RubName,
t.KopSum,
t.KopName,
t.UnitName,
t.QtyPrint,
t.BarCode,
t.CardComment
from supermag.SVPriceCard t,
supermag.SMCard c,
supermag.SAMeasurement w
where c.article = t.Article
and w.id (+)= c.idmeasweight
order by 1