/****** Object:  View [dbo].[V_EST_PROD_TRANSF_CONF_FASES]    Script Date: 04/20/2013 11:20:56 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[V_EST_PROD_TRANSF_CONF_FASES]'))
DROP VIEW [dbo].[V_EST_PROD_TRANSF_CONF_FASES]
GO
GO
GO


CREATE VIEW [dbo].[V_EST_PROD_TRANSF_CONF_FASES]
AS
SELECT     
	dbo.EST_PROD_TRANSF_CONF_FASES.CD_EMP, 
	dbo.EST_PROD_TRANSF_CONF_FASES.CD_FILIAL, 
	dbo.EST_PROD_TRANSF_CONF_FASES.CD_CTR, 
	dbo.EST_PROD_TRANSF_CONF_FASES.CD_CTR_FASES, 
	EST_PROD_TRANSF_CONF_FASES.CD_CONTROLE,
    dbo.EST_PROD_TRANSF_CONF_FASES_ITENS.CD_PROD, 
    dbo.EST_PROD_TRANSF_CONF_FASES_ITENS.QTDE_PROD_CONF
FROM         
	dbo.EST_PROD_TRANSF_CONF_FASES INNER JOIN dbo.EST_PROD_TRANSF_CONF_FASES_ITENS ON 
	dbo.EST_PROD_TRANSF_CONF_FASES.CD_EMP = dbo.EST_PROD_TRANSF_CONF_FASES_ITENS.CD_EMP AND 
    dbo.EST_PROD_TRANSF_CONF_FASES.CD_CTR_FASES = dbo.EST_PROD_TRANSF_CONF_FASES_ITENS.CD_CTR_FASES
