Paste code

FROM (
     SELECT COALESCE(AA.NUM_DOCUMENTO, T.NUM_DOCUMENTO) NUM_DOCUMENTO_COMPLETO, AA.*
	 FROM E_DW_VIEWS.V_FEEDBACK_TELEVENTAS AA
	 LEFT JOIN (
		SELECT NUM_DOCUMENTO, NUM_TELEFONO
		FROM E_DW_VIEWS.V_FEEDBACK_TELEVENTAS 
		WHERE GESTION = &#039;202210&#039; 
		AND NUM_DOCUMENTO IS NOT NULL AND NUM_TELEFONO IS NOT NULL
		QUALIFY ROW_NUMBER() OVER(PARTITION BY NUM_TELEFONO ORDER BY (
		    CASE WHEN LENGTH(NUM_DOCUMENTO) = 11 AND  (CATEGORIA = &#039;CE&#039; OR RESULTADO_LLAMADA LIKE &#039;(CE)&#039;) THEN 1
			     WHEN LENGTH(NUM_DOCUMENTO) = 11 AND  (CATEGORIA = &#039;CNE&#039; OR RESULTADO_LLAMADA LIKE &#039;(CNE)&#039;) THEN 2
				 WHEN LENGTH(NUM_DOCUMENTO) = 11 AND  (CATEGORIA = &#039;ET&#039; OR RESULTADO_LLAMADA LIKE &#039;(ET)&#039;) THEN 3
				 WHEN LENGTH(NUM_DOCUMENTO) = 11 AND  (CATEGORIA = &#039;NC&#039; OR RESULTADO_LLAMADA LIKE &#039;(NC)&#039;) THEN 4
		         WHEN CATEGORIA = &#039;CE&#039; OR RESULTADO_LLAMADA LIKE &#039;(CE)&#039; THEN 5
			     WHEN CATEGORIA = &#039;CNE&#039; OR RESULTADO_LLAMADA LIKE &#039;(CNE)&#039; THEN 6
				 WHEN CATEGORIA = &#039;ET&#039; OR RESULTADO_LLAMADA LIKE &#039;(ET)&#039; THEN 7
				 WHEN CATEGORIA = &#039;NC&#039; OR RESULTADO_LLAMADA LIKE &#039;(NC)&#039; THEN 8
				 ELSE 9 END
		) ASC ) = 1
	) T
	ON AA.NUM_TELEFONO = T.NUM_TELEFONO AND AA.NUM_DOCUMENTO IS NULL
	WHERE 1 = 1
	AND AA.GESTION = &#039;202210&#039;
	AND AA.RESULTADO_LLAMADA NOT IN (
	  &#039;ININ-OUTBOUND-CONTACT-ATTEMPT-LIMIT-SKIPPED&#039;,
	  &#039;ININ-OUTBOUND-EXTERNALLY-THROTTLED&#039;,
	  &#039;ININ-OUTBOUND-LIVE-VOICE&#039;,&#039;ININ-OUTBOUND-PREVIEW-SKIPPED&#039;,
	  &#039;SIP: [486]&#039;, &#039;SIP: [500]&#039;, &#039;SIP: [503]&#039;,
	  &#039;ININ-OUTBOUND-NUMBER_COULD_NOT_BE_DIALED&#039;,
	  &#039;ININ-OUTBOUND-NUMBERS-INVALID&#039;,
	  &#039;ININ-OUTBOUND-RULE-ERROR-SKIPPED&#039;,
	  &#039;ININ-OUTBOUND-RULE-SKIPPED&#039;)
	 
 ) A