Paste code

select CASE  WHEN LENGTH(RUC_PROV) = 11 AND RUC_PROV LIKE &#039;10%&#039; THEN SUBSTRING(RUC_PROV, 3, 8) 
		               ELSE RUC_PROV END NUMDOC,
							&#039;&#039; CU_HUB_ECO,
							&#039;&#039; Tipo_ECO,
							&#039;&#039; TIPO_ORIGEN_ECO,
							&#039;&#039; VENTA_ANIO4_ECO,
							&#039;&#039; VENTA_ANIO3_ECO,
							&#039;&#039; VENTA_ANIO2_ECO,
							&#039;&#039; VENTA_ANIO1_ECO,
							&#039;&#039; VENTA_ANIO_ECO,
							&#039;&#039; DETALLE_VENTAS_ECO,
							&#039;&#039; GESTION_BASE_ECO,
							&#039;&#039; GESTION_BASE_RIESGOS_ECO,
							&#039;&#039; PROMEDIO_12_MESES_ECO,
							&#039;&#039; FRECUENCIA_12_MESES_ECO,
							&#039;&#039; TIEMPO_RELACION_ECO,
							&#039;&#039; ENTREGA_BASE_ECO,
							&#039;&#039; VOLUMEN_PROM_6M_PROV_ECO,
							&#039;&#039; FRECUENCIA_PROV,
							&#039;&#039; FRECUENCIA_PROV_HUB,
							&#039;&#039; CAIDA_GC
					FROM E_DW_VIEWS.V_MST_VPC_BASES_ECOSIS_BC  ECO
					WHERE CAST(TO_CHAR(FECHA_BASE_DT, &#039;YYYYMM&#039;) AS INT) <= 202406  --- este se reemplaza por el parametro del SP
					group by CASE WHEN LENGTH(RUC_PROV) = 11 AND RUC_PROV LIKE &#039;10%&#039; THEN SUBSTRING(RUC_PROV, 3, 8) 
		               ELSE RUC_PROV END