SELECT
[VND].[NAME] AS [VENDOR],
[VND_EVA].[DOC_NUMBER] AS [DOCUMENT],
[VND_EVA].[DATE] AS [DOC DATE],
DATEDIFF
(dd,
ISNULL([VND_EVA].[max_promise_delivery_date],
ISNULL([VND_EVA].[date_delivery_plan], '1900/01/01')),
ISNULL([VND_EVA].[date_delivery_plan], '1900/01/01')
) AS [DELAYED DAYS],
[VND_EVA].[NCR],
[VND_EVA].[PACKING_ISSUES] AS [PACKING],
[VND_EVA].[INVOICING_ISSUES] AS [INVOICE]
FROM
[#tmp_vend_eval] AS [VND_EVA]
INNER JOIN
[VENDORS] AS [VND]
ON ([VND].[ID] = [VND_EVA].[id_vendor])
WHERE
ISNULL(@ID_SECTOR,id_sector) = [VND_EVA].[id_sector] AND
ISNULL(@ID_PROJECT,id_project) = [VND_EVA].[id_project] AND
ISNULL(@ID_COMPANY,id_company) = [VND_EVA].[id_company] AND
ISNULL(@ID_DOC_TYPE,doc_type) = [VND_EVA].[doc_type] AND
ISNULL(@ID_VENDOR,id_vendor) = [VND_EVA].[id_vendor] AND
[VND_EVA].[date]
between ISNULL(@DATE_INI_DOC,[VND_EVA].[date]) AND
ISNULL(@DATE_FIN_DOC,[VND_EVA].[date]) AND
[VND_EVA].[date_delivery_plan]
BETWEEN ISNULL(@DATE_INI_DELIVERY,[VND_EVA].[date_delivery_plan]) AND
ISNULL(@DATE_FIN_DELIVERY,[VND_EVA].[date_delivery_plan])
ORDER BY [VND_EVA].[ID]
DROP TABLE [#tmp_vend_eval]
END
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO