--declare @packageId as int
--set @packageId = 103451

select
	[OrderNumber] as [Order No]
	, [PackageCount] as [Package Quantity]
	, [PackageNumber] as [Package Number]
	, [UseHeatPack] as [Heat Pack]
	, [CarouselPackType] as [Package Type]
	, [Sell-toName] as [SoldToCustomerName]
	, [Ship-toName] as [ShipToCustomerName]
from [Green Circle Growers$GCG XPAK PackageItems] with (nolock)
where [PackageNumber] = @packageId