select t.Article, t.Name, t.Country, t.PriceFull, t.UnitName, t.QtyPrint, t.BarCode, decode(t.PLU,null,'','Весы: '||t.PLU) PLU from supermag.SVPriceCard t order by 1
supermag.SMGetPricerInfoArticle(:ARTICLE, :PRICETYPE, :PROPID)
SELECT t.Article,t.Name,t.Country,t.Price,t.UnitName,t.QtyPrint,t.BarCode,t.RUBNAME, DECODE(t.PLU,NULL,'','PLU: '||t.PLU) PLU, supermag.SMGetPricerInfoArticle(t.Article, :P_PRICE_TYPE, 1) stpc FROM supermag.SVPriceCard t ORDER BY 1
if (stpc == "соц") { Text11.Text = "Социальная цена"; }