Paste code

SELECT NUMDOC,
                MAX(FLG_MERCADO_BPE) FLG_MERCADO_BPE,
				MAX(FLG_RESCATE_MICRO) FLG_RESCATE_MICRO,
				MAX(FLG_RESCATE_BPE) FLG_RESCATE_BPE,
				MAX(FLG_RESCATE_BE) FLG_RESCATE_BE,
				MAX(FLG_BARRIDO_TLV_BPE) FLG_BARRIDO_TLV_BPE,
				MAX(FLG_PROVEEDORES_CORPO) FLG_PROVEEDORES_CORPO

(logica)
UNION 


SELECT CASE WHEN LENGTH(Ruc_Beneficiario) = 11 AND Ruc_Beneficiario LIKE &#039;10%&#039; THEN SUBSTRING(Ruc_Beneficiario, 3, 8) ELSE Ruc_Beneficiario END NUMDOC,
                0 FLG_MERCADO_BPE,
				0 FLG_RESCATE_MICRO,
				0 FLG_RESCATE_BPE,
				0 FLG_RESCATE_BE,
				0 FLG_BARRIDO_TLV_BPE,   --check
				1 FLG_PROVEEDORES_CORPO
FROM E_DW_VIEWS.V_MST_VPC_CORPORATIVO

UNION
SELECT CASE WHEN  LENGTH(NUM_DOCUMENTO) = 11 AND NUM_DOCUMENTO LIKE &#039;10%&#039; THEN SUBSTRING(NUM_DOCUMENTO, 3, 8) ELSE NUM_DOCUMENTO END NUMDOC,
                0 FLG_MERCADO_BPE,
				0 FLG_RESCATE_MICRO,
				0 FLG_RESCATE_BPE,
				0 FLG_RESCATE_BE,
				1 FLG_BARRIDO_TLV_BPE,   --check
				0 FLG_PROVEEDORES_CORPO
FROM  E_DW_VIEWS.V_FEEDBACK_TELEVENTAS 
WHERE  FEC_LLAMADA >= &#039;2021-01-01&#039;
AND (
    ID_CAMPANIA like &#039;%BPE%&#039; OR  ID_TRATAMIENTO like &#039;%BPE%&#039;  OR TIP_CLIENTE like &#039;%BPE%&#039; 
)
AND PREFIJO_CAMPANA = &#039;TLV&#039;

UNION

(logica)
GROUP BY NUMDOC