SELECT
GVA.GVA_FILIAL,
GVA.GVA_CDEMIT,
GVA.GVA_NRTAB,
GVA.GVA_DSTAB,
GU3.GU3_NMEMIT,
GU3.GU3_NMFAN,
GU3.GU3_MODAL,
CASE
WHEN GU3.GU3_MODAL = 1 THEN 'NÃO INFORMADO'
WHEN GU3.GU3_MODAL = 2 THEN 'RODOVIÁRIO'
WHEN GU3.GU3_MODAL = 3 THEN 'FERROVIÁRIO'
WHEN GU3.GU3_MODAL = 4 THEN 'AÉREO'
WHEN GU3.GU3_MODAL = 5 THEN 'AQUAVIÁRIO'
WHEN GU3.GU3_MODAL = 6 THEN 'DUTOVIÁRIO'
WHEN GU3.GU3_MODAL = 7 THEN 'MULTIMODAL'
END AS MODAL,
GV8.GV8_NRNEG,
GV8.GV8_NRROTA,
GV8.GV8_TPORIG,
GV8.GV8_TPDEST,
GV6.GV6_QTPRAZ,
SUM(GV1.GV1_VLFIXN) AS GV1_VLFIXN
FROM
Producao_CCAB_P11.dbo.GVA010 GVA WITH (NOLOCK)
INNER JOIN Producao_CCAB_P11.dbo.GU3010 GU3 WITH (NOLOCK) ON GVA.GVA_CDEMIT =
GU3.GU3_CDEMIT AND GU3.D_E_L_E_T_ = ''
INNER JOIN Producao_CCAB_P11.dbo.GV8010 GV8 WITH (NOLOCK) ON GVA.GVA_CDEMIT =
GV8.GV8_CDEMIT AND GVA.GVA_NRTAB = GV8.GV8_NRTAB AND GV8.D_E_L_E_T_ = ''
INNER JOIN Producao_CCAB_P11.dbo.GV6010 GV6 WITH (NOLOCK) ON GV8.GV8_CDEMIT =
GV6.GV6_CDEMIT AND GV8.GV8_NRTAB = GV6.GV6_NRTAB AND GV8.GV8_NRNEG = GV6.GV6_NRNEG
AND GV8.GV8_NRROTA = GV6.GV6_NRROTA AND GV6.D_E_L_E_T_ = ''
INNER JOIN Producao_CCAB_P11.dbo.GV1010 GV1 WITH (NOLOCK) ON GV8.GV8_CDEMIT =
GV1.GV1_CDEMIT AND GV8.GV8_NRTAB = GV1.GV1_NRTAB AND GV8.GV8_NRNEG = GV1.GV1_NRNEG
AND GV8.GV8_NRROTA = GV1.GV1_NRROTA AND GV1.D_E_L_E_T_ = ''
WHERE
GVA.D_E_L_E_T_ = ''
AND GVA.GVA_NRTAB = '000002'
AND GVA.GVA_CDEMIT = '565804223'
GROUP BY
GVA.GVA_FILIAL,
GVA.GVA_CDEMIT,
GVA.GVA_NRTAB,
GVA.GVA_DSTAB,
GU3.GU3_NMEMIT,
GU3.GU3_NMFAN,
GU3.GU3_MODAL,
GV8.GV8_NRNEG,
GV8.GV8_NRROTA,
GV8.GV8_TPORIG,
GV8.GV8_TPDEST,
GV6.GV6_QTPRAZ