SELECT [CustomerInventoryForWorkload].[CustomerId] AS [CustomerId], [CustomerInventoryForWorkload].[WorkloadId] AS [WorkloadId], [CustomerInventoryForWorkload].[CustomerInventoryId] AS [CustomerInventoryId], [CustomerInventoryForWorkload].[Category] AS [Category], [CustomerInventoryForWorkload].[ItemType] AS [ItemType], [CustomerInventoryForWorkload].[Size] AS [Size], [CustomerInventoryForWorkload].[Count] AS [Count], [CustomerInventoryForWorkload].[TCOrderPriority] AS [TCOrderPriority], [CustomerInventoryForWorkload].[TSOrderPriority] AS [TSOrderPriority] FROM [dbo].[CustomerInventoryForWorkload] AS [CustomerInventoryForWorkload] SELECT [CustomerInventoryForWorkloadClosed].[CustomerId] AS [CustomerId], [CustomerInventoryForWorkloadClosed].[WorkloadId] AS [WorkloadId], [CustomerInventoryForWorkloadClosed].[CustomerInventoryId] AS [CustomerInventoryId], [CustomerInventoryForWorkloadClosed].[Category] AS [Category], [CustomerInventoryForWorkloadClosed].[ItemType] AS [ItemType], [CustomerInventoryForWorkloadClosed].[Size] AS [Size], [CustomerInventoryForWorkloadClosed].[Count] AS [Count], [CustomerInventoryForWorkloadClosed].[TCOrderPriority] AS [TCOrderPriority], [CustomerInventoryForWorkloadClosed].[TSOrderPriority] AS [TSOrderPriority] FROM [dbo].[CustomerInventoryForWorkloadClosed] AS [CustomerInventoryForWorkloadClosed] SELECT [vwCustomerBagsWaitingCounting].[CustomerId] AS [CustomerId], [vwCustomerBagsWaitingCounting].[Name] AS [Name], [vwCustomerBagsWaitingCounting].[BagCount] AS [BagCount] FROM [dbo].[vwCustomerBagsWaitingCounting] AS [vwCustomerBagsWaitingCounting] SELECT [vwInventoryItemTypes].[Category] AS [Category], [vwInventoryItemTypes].[ItemType] AS [ItemType] FROM [dbo].[vwInventoryItemTypes] AS [vwInventoryItemTypes] SELECT [vwWorkloadCategoryTypeCounts].[WorkloadId] AS [WorkloadId], [vwWorkloadCategoryTypeCounts].[Category] AS [Category], [vwWorkloadCategoryTypeCounts].[ItemType] AS [ItemType], [vwWorkloadCategoryTypeCounts].[ItemCount] AS [ItemCount] FROM [dbo].[vwWorkloadCategoryTypeCounts] AS [vwWorkloadCategoryTypeCounts] SELECT [vwWorkloadStatusReport].[WorkloadStatusId] AS [WorkloadStatusId], [vwWorkloadStatusReport].[Status] AS [Status], [vwWorkloadStatusReport].[Customers] AS [Customers], [vwWorkloadStatusReport].[TotalItems] AS [TotalItems] FROM [dbo].[vwWorkloadStatusReport] AS [vwWorkloadStatusReport]