select NVL(b.Name, ' ') AS spec, ' ' as packs,
'' as Quant,
'' as Price,

 NVL(a.feeamount,0) as amount, ' ' as cpbh,' ' as cpname, ' ' as jidw
from ITM_Documentfee a  left join
sys_datadictionary b on b.id=a.feeid    

union
select
NVL(b.Spec, ' ') AS spec,
NVL(b.field1,' ') as packs,
case Quant
 when 0 then
  ' '
 when null then
  ' '
 else
   to_char(Quant) 
end as Quant
,
case Price
 when 0 then
  ' '
 when null then
  ' '
 else
   to_char(Price) 
end as Price
,
  NVL(b.Amount, 0) AS amount,
c.SerialNumber as cpbh,NVL(c.EnName, ' ') AS cpname,
NVL(t.Symbol, ' ') AS jidw
from ITM_SalesCommodity b
left join CRM_Commodity c ON c.TypeID = b.CommodityTypeID
LEFT OUTER JOIN      BSE_MeasureStyle t ON b.QuantUnitID = t.ID


select ISNULL(b.Name, ' ') AS spec, ' ' as packs,
'' as Quant,
'' as Price,

 isnull(a.feeamount,0) as amount, ' ' as cpbh,' ' as cpname, ' ' as jidw
from ITM_Documentfee a  left join
sys_datadictionary b on b.id=a.feeid    

union
select
ISNULL(b.Spec, ' ') AS spec,
isnull(b.field1,' ') as packs,
Quant =
case
 when Quant>0 then
  CAST( Quant AS varchar(20))
 else ''
end
,
Price =
case
 when Price>0 then
  CAST( Price AS varchar(20))
 else ''
end
,
  ISNULL(b.Amount, 0) AS amount,
c.SerialNumber as cpbh,ISNULL(c.EnName, ' ') AS cpname,
ISNULL(t.Symbol, ' ') AS jidw
from ITM_SalesCommodity b
left join CRM_Commodity c ON c.TypeID = b.CommodityTypeID
LEFT OUTER JOIN      BSE_MeasureStyle t ON b.QuantUnitID = t.ID