SELECT CASE
        WHEN (VCL.VCL_CODVC = 'FRT')
            AND (DATEADD(day, A.PGR_CLFROTA, VCL.VCL_DATACHECK) < GETDATE())
            THEN 'VENCIDO'
        WHEN (VCL.VCL_CODVC = 'FRT')
            AND (DATEADD(day, A.PGR_CLFROTA, VCL.VCL_DATACHECK) >= GETDATE())
            THEN 'A VENCER'
        WHEN (VCL.VCL_CODVC = 'TRC')
            AND (DATEADD(day, A.PGR_CLTERCEIRO, VCL.VCL_DATACHECK) < GETDATE())
            THEN 'VENCIDO'
        WHEN (VCL.VCL_CODVC = 'TRC')
            AND (DATEADD(day, A.PGR_CLTERCEIRO, VCL.VCL_DATACHECK) >= GETDATE())
            THEN 'A VENCER'
        WHEN (VCL.VCL_CODVC = 'AGR')
            AND (DATEADD(day, A.PGR_CLAGREGADO, VCL.VCL_DATACHECK) < GETDATE())
            THEN 'VENCIDO'
        WHEN (VCL.VCL_CODVC = 'AGR')
            AND (DATEADD(day, A.PGR_CLAGREGADO, VCL.VCL_DATACHECK) >= GETDATE())
            THEN 'A VENCER'
        END AS STATUSVENCIMENTO
FROM PGR A WITH (NOLOCK)
LEFT OUTER JOIN OPERACAO OPE ON A.PGR_CODCLN = OPE.OPE_CODCLN
LEFT OUTER JOIN VEICULO VCL ON OPE.OPE_CODIGO = VCL.VCL_CODOPE
LEFT OUTER JOIN USUARIOOPERACAO UO ON VCL.VCL_CODOPE = UO.UO_CODOPE
    AND UO.UO_CODUSR = 525
WHERE (A.PGR_CLFROTA > 0)
    AND (OPE.OPE_CODCLN = 52)
    AND (VCL.VCL_STATUSCHECK = 'A')
    AND (VCL.VCL_DATACHECK IS NOT NULL)
    AND (COALESCE(UO.UO_ATIVO, '') = 'S')
ORDER BY VCL.VCL_CODIGO