Вот такой у меня запрос.
select
t.Article,
(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,
t.Name
, t.Country
, t.PriceFull
, t.PriceShort
, t.UnitName
, t.QtyPrint
, t.BarCode
, supermag.BarCode.ToCode128_sub('PR|'||t.BarCode||'|'||to_char(trunc(t.Price*100))||'|'||to_char(:pPricerCategory)) BarCodePR128
, decode(t.PLU,null,'','Весы: '||t.PLU) PLU
from supermag.SVPriceCard t
order by 1
Скрины печатной формы вложил.