1  with t (ID,TOVAR,FROm_CITY,TO_CITY,NAKLADNAYA,KOLVO) as (
  2  select 1,'TOMATO','MOSCOW','TVER',123,500 from dual union all
  3  select 2,'APPLE','MOSCOW','RIGA',322,100 from dual union all
  4  select 3,'APPLE','MOSCOW','TVER',123,10 from dual union all
  5  select 4,'APPLE','OMSK','PITER',100,25 from dual union all
  6  select 5,'TMIN','MOSCOW','TVER',123,2 from dual union all
  7  select 7,'TOMATO','Львів','Луцьк',7,500 from dual union all
  8  select 8,'Кава','Луцьк','Київ',7,500 from dual)
  9  ,tt as (
 10  select
 11    t.*
 12   ,count(distinct decode(tovar,'TOMATO',1,2)) over (partition by  nakladnaya ) f
 13  from t )
 14  select
 15   distinct tovar
 16  from tt
 17* where f=2 and tovar<>'TOMATO'
SQL> /

TOVAR
------
Кава
TMIN
APPLE