Paste code

CREATE TABLE DLAB_PROGRAMADATOSVPC.HM_UNIVERSO_4_BPE as(
		   --5.- CTA NEG
		SELECT CASE WHEN d.Tipo_Identificacion_Host=&#039;2&#039; AND Numero_Identificacion LIKE &#039;10%&#039; THEN SUBSTRING(Numero_Identificacion, 3, 8) ELSE Numero_Identificacion END NUMDOC
			, cast(&#039;5.- CTA NEG&#039; AS varchar(50)) CATEGORIA
			, 0 FLG_ADI
			, &#039;.&#039; logica_banca_mes_val, &#039;.&#039;  logica_banca_fin_val, &#039;.&#039;  Banca_Mes_Val, &#039;.&#039;  Banca_Fin_Val, &#039;.&#039;  LOGICA
			, 0 FLG_MERCADO_BPE
			, 0 FLG_RESCATE_BPE
			, 0 FLG_RESCATE_MICRO
			, 0 FLG_PJ
		    , 1 FLG_CTA_NEG
		    , 0 FLG_PROVEEDORES
		    , 0 FLG_CLIENTES
			, 0 FLG_RESCATE_BE
		    , 0 FLG_BARRIDO_TLV_BPE
			, 0 FLG_PNCN
			, 0 FLG_RETAIL
			--select count(1)	
			from E_DW_VIEWS.V_AGG_VPC_SALDOS_DIARIOS b 
			inner  join E_DW_VIEWS.V_DIM_CLIENTE d
			on d.Cliente_Id = b.Cliente_Id
			where 1=1
			--and b.Saldo_Promedio_Sol_Mto>0
			and b.Categoria_Prod_VPC_Dsc like &#039;%NEGOCIO%&#039;
			and b.Fecha_Saldo_Dt = ADD_MONTHS(CAST(&#039;202210&#039;||&#039;01&#039; AS DATE FORMAT &#039;YYYYMMDD&#039;),1)-1
		UNION ALL
		--6.- PROVEEDORES 7.- CLIENTES
		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
				--numero_ruc NUM_RUC,
		   , cast(case when Tipo =&#039;CLIENTE&#039; then &#039;7.- CLIENTES&#039; else &#039;6.- PROVEEDORES&#039; end AS varchar(50)) CATEGORIA
		   , 0 FLG_ADI
		   , &#039;.&#039;  logica_banca_mes_val, &#039;.&#039;  logica_banca_fin_val, &#039;.&#039;  Banca_Mes_Val, &#039;.&#039;  Banca_Fin_Val, &#039;.&#039;  LOGICA
			, 0 FLG_MERCADO_BPE
			, 0 FLG_RESCATE_BPE
			, 0 FLG_RESCATE_MICRO
			, 0 FLG_PJ
		    , 0 FLG_CTA_NEG
		    , (case when Tipo <> &#039;CLIENTE&#039; then 1 else 0 end) FLG_PROVEEDORES
			, (case when Tipo = &#039;CLIENTE&#039; then 1 else 0 end) FLG_CLIENTES
			, 0 FLG_RESCATE_BE
		    , 0 FLG_BARRIDO_TLV_BPE
			, 0 FLG_PNCN
			, 0 FLG_RETAIL
			--select count(1)
			--select max(Periodo_Val)
			FROM  E_DW_VIEWS.V_FACT_VPC_CORPORATIVO
			where Periodo_Val = &#039;202210&#039;
			) WITH DATA
			PRIMARY INDEX (NUMDOC);			
			
			
	
CREATE TABLE DLAB_PROGRAMADATOSVPC.HM_UNIVERSO_4_BPE as(	
	SELECT ZZ.CODDOC NUMDOC
		, cast(&#039;12.- RRLL POTENCIAL BPE&#039; AS varchar(50)) CATEGORIA
		, 0 FLG_ADI
		, &#039;.&#039; logica_banca_mes_val, &#039;.&#039;  logica_banca_fin_val, &#039;.&#039;  Banca_Mes_Val, &#039;.&#039;  Banca_Fin_Val, &#039;.&#039;  LOGICA
		, 0 FLG_MERCADO_BPE
		, 0 FLG_RESCATE_BPE
		, 0 FLG_RESCATE_MICRO
		, 0 FLG_PJ
	    , 0 FLG_CTA_NEG
	    , 0 FLG_PROVEEDORES
	    , 0 FLG_CLIENTES
		, 0 FLG_RESCATE_BE
	    , 0 FLG_BARRIDO_TLV_BPE
		, 0 FLG_PNCN
		, 0 FLG_RETAIL
		, 1 FLG_RRLL_BPE_PJ
		, ZZ.FLG_RRLL_DNI_CARNETEXT
	FROM (
		SELECT S.CODDOC,
		       S.TIPDOC,
		       MAX(CASE WHEN TIPDOC IN (&#039;1&#039;,&#039;3&#039;) THEN 1 ELSE 0 END) FLG_RRLL_DNI_CARNETEXT
		FROM E_DW_VIEWS.V_REP_LEGALES_SUNAT_HIST S
		INNER JOIN DLAB_PROGRAMADATOSVPC.HM_UNIVERSO_1_BPE U
		ON S.NUMRUC = U.NUMDOC
		LEFT JOIN E_DW_VIEWS.V_DATOS_PRINCIPALES_SUNAT_HIST P
		ON S.NUMRUC = P.NUMRUC
		WHERE 1 = 1
		AND S.ESTADO = 0
		AND S.FECPROCESO = &#039;05/11/2022&#039;
		AND P.FECPROCESO = &#039;05/11/2022&#039;
		AND P.NUMRUC LIKE &#039;20%&#039;
		GROUP BY S.CODDOC, S.TIPDOC		
	) ZZ
) WITH DATA
PRIMARY INDEX (NUMDOC);