/****** Object:  View [dbo].[V_EST_NF_ENT]    Script Date: 05/27/2013 23:03:10 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[V_EST_NF_ENT_DANFE_PROVISORIO_CHECKIN_ENTRADA]'))
DROP VIEW [dbo].[V_EST_NF_ENT_DANFE_PROVISORIO_CHECKIN_ENTRADA]
GO
CREATE VIEW [dbo].[V_EST_NF_ENT_DANFE_PROVISORIO_CHECKIN_ENTRADA] AS 
SELECT     
	EST_NF_ENT_DANFE_PROVISORIO_EST_NF_ENT.CD_EMP, 
	EST_NF_ENT_DANFE_PROVISORIO_EST_NF_ENT.CD_FILIAL, 
    EST_NF_ENT_DANFE_PROVISORIO_EST_NF_ENT.CD_NF, 
	EST_NF_ENT_DANFE_PROVISORIO.CD_MOV_OP,
	EST_NF_ENT_DANFE_PROVISORIO_CHECKIN_ENTRADA.CD_USU, 
    EST_NF_ENT_DANFE_PROVISORIO_CHECKIN_ENTRADA.DT_CAD, 
	EST_NF_ENT_DANFE_PROVISORIO_CHECKIN_ENTRADA.CHECKIN_DIVERGENCIA, 
	EST_NF_ENT_DANFE_PROVISORIO_CHECKIN_ENTRADA_CPL.CD_PROD, 
	EST_NF_ENT_DANFE_PROVISORIO_CHECKIN_ENTRADA_CPL.QT_IT_CHECK
FROM         
	EST_NF_ENT_DANFE_PROVISORIO_EST_NF_ENT INNER JOIN EST_NF_ENT_DANFE_PROVISORIO_CHECKIN_ENTRADA ON 
	EST_NF_ENT_DANFE_PROVISORIO_EST_NF_ENT.CD_CTR = EST_NF_ENT_DANFE_PROVISORIO_CHECKIN_ENTRADA.CD_CTR 
	INNER JOIN EST_NF_ENT_DANFE_PROVISORIO_CHECKIN_ENTRADA_CPL ON 
	EST_NF_ENT_DANFE_PROVISORIO_CHECKIN_ENTRADA.CD_CTR = EST_NF_ENT_DANFE_PROVISORIO_CHECKIN_ENTRADA_CPL.CD_CTR
	INNER JOIN EST_NF_ENT_DANFE_PROVISORIO ON
	EST_NF_ENT_DANFE_PROVISORIO_EST_NF_ENT.CD_CTR = EST_NF_ENT_DANFE_PROVISORIO.CD_CTR 


