/****** Object:  View [dbo].[View_ListaDetalheSSCCsParaExpedir]    Script Date: 02/12/2021 14:24:02 ******/
DROP VIEW [dbo].[View_ListaDetalheSSCCsParaExpedir]
GO

/****** Object:  View [dbo].[View_ListaDetalheSSCCsParaExpedir]    Script Date: 02/12/2021 14:24:02 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[View_ListaDetalheSSCCsParaExpedir]
AS
SELECT        dbo.M01_SSCC_Cab.StrCarro, dbo.M01_SSCC_Cab.strIA_00_SSCC, dbo.M01_SSCC_Cab.strArtigoCodigo, dbo.M01_SSCC_Cab.StrPeça, dbo.M01_SSCC_Cab.StrTamanho, 
                         dbo.M01_SSCC_Cab.fltQtdActual AS fltQuantidadeEstampada, dbo.T19_TiposProducao.bitNecessitaPesagem, dbo.T99_0204_SubArtTam.fltPesoReferencia
FROM            dbo.M01_SSCC_Cab INNER JOIN
                         dbo.T01_Artigos ON dbo.M01_SSCC_Cab.strArtigoCodigo = dbo.T01_Artigos.StrCodigo INNER JOIN
                         dbo.T19_TiposProducao ON dbo.T01_Artigos.strTipo = dbo.T19_TiposProducao.strCodigo INNER JOIN
                         dbo.T99_0204_SubArtTam ON dbo.M01_SSCC_Cab.StrPeça = dbo.T99_0204_SubArtTam.StrCodSubArtigo
WHERE        (dbo.M01_SSCC_Cab.bitEliminado IS NULL) AND (dbo.M01_SSCC_Cab.StrDocumentoERP IS NULL) AND (NOT (dbo.M01_SSCC_Cab.dtmFimProducao IS NULL)) AND (dbo.M01_SSCC_Cab.IntIdExpedicao IS NULL)
GO