IF  EXISTS (SELECT * FROM SYS.VIEWS WHERE OBJECT_ID = OBJECT_ID(N'[DBO].[V_EST_PROD_COND_CP_PG_FORN_VIGENTE]'))
DROP VIEW [DBO].[V_EST_PROD_COND_CP_PG_FORN_VIGENTE]    
GO
/****** Object:  View [dbo].[V_EST_PROD_COND_CP_PG_FORN_VIGENTE]    Script Date: 29/01/2016 12:31:32 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[V_EST_PROD_COND_CP_PG_FORN_VIGENTE]   
AS   
SELECT 
      CD_CTR
      ,CD_EMP
      ,CD_PROD
      ,CD_FORN
      ,CD_ORDEM
      ,VLR_CUSTO
      ,ST_COND_CP
      ,DT_INI_VLD
      ,DT_FIM_VLD
      ,PERC_DESC
      ,VLR_REF 
FROM EST_PROD_COND_CP_PG_FORN_VIGENTE  
WHERE ST_COND_CP = 1
 
GO


