  IF EXISTS
(
    SELECT *
    FROM SYS.VIEWS
    WHERE OBJECT_ID = OBJECT_ID(N'[DBO].[V_EST_PROD_PRECO_TENTACLE]')
)
    DROP VIEW [DBO].[V_EST_PROD_PRECO_TENTACLE];
GO
CREATE VIEW [dbo].[V_EST_PROD_PRECO_TENTACLE]
AS
  SELECT
	  cd_ctr   
	  ,cd_emp   
	  ,cd_filial 
	  ,cd_prod   
	  ,vlr_oferta
	  ,vlr_tabela
	  ,sts_preco 
	  ,0 AS alt_sist  
	  ,0 AS reg_alterado  
	  ,vlr_oferta_avista 
	  ,GETDATE() AS dt_hr_carga  
	  ,isnull(flag_sobrepoe_descontos,0) flag_sobrepoe_descontos 
	  ,dt_cad   
	  ,vlr_custo
  FROM EST_PROD_PRECO

go