IsRemoteOnly_NSM
SELECT djv.Nzv AS "Dejavnost", 
       CASE WHEN pod.Trg='D' THEN 'Domači trg'
            WHEN pod.Trg='T' THEN 'Tuji Trgi'
            WHEN pod.Trg='M' THEN 'Maintenance Fee'
       END AS "Nabor ležarin", 
       sum(pod.vred) AS "Vrednost"
FROM (
SELECT dog. SfDjv,
       CASE WHEN dog.SfDog IN (488, 489) THEN 'D'
            WHEN dog.SfDog IN (607, 680, 728) THEN 'T'
            WHEN dog.SfDog IN (697) THEN 'M'
       END trg,
       dog.Lot / CASE WHEN (nvl(dog.TcjVlt,0)=0 OR dog.SfVlt='E') THEN 1 ELSE dog.TcjVlt END vred
FROM dog
WHERE dog.SfDog in (488,489,607,680,728,697)
AND dog.SfPdg='S'
AND dog.Stn IS  NULL
AND dog.Dan BETWEEN :dan_od AND :dan_do) pod
LEFT OUTER JOIN djv ON pod.SfDjv=djv.SfDjv
GROUP BY djv.Nzv, pod.Trg;