pvivltab then pvivlven else pvivltab end)*pviqtdeatecar as pvivltab
,(case when pvivlven>pvivltab then 0 else pvivltab-pvivlven end)*pviqtdeatecar as vldesc
,pvivltotal
,coalesce(pvivlst,0) as pvivlst
,coalesce(pvivlipi,0) as pvivlipi
,coalesce(pvvlfrete,0) as pvvlfrete
,coalesce(pvobsped,'') as pvobsped
,pvivlipi
,pvivlst
,proncm
,procest
from pv
join cli on pvcliparcod=cliparcod
join par c on cliparcod=c.parcod
join plpg on pvplpgcod=plpgcod
join tc on pvtccod=tccod
join loc on cliloccod = loccod
join par r on pvrcaparcod = r.parcod
join par e on pvempparcod = e.parcod
join mun clii on c.parmuncod=muncod
join mun emp on e.parmuncod=emp.muncod
join pvi on pvcod=pvipvcod
join uve on uveprocod = pviprocod and uvecod = pviuvecod and uvedispven = 'S'
join pro on pviprocod=procod
where pviqtdeatecar>0 and pvsta <> 'EX'
and pvcod=$P{P_PVCOD}
order by prodes]]>
CNPJ: "+$F{clicnpj}]]>