/*
* Gets international containers for an order. This is used for bookmarks in the Forms Designer.
*
* @param @inOrderId Primary key of an Orders record.
*/
CREATE procedure [dbo].[GetInternationalContainersForLetter]
    @inOrderId int
as
set nocount on

select
    InternationalContainer.ContainerNumber,
    InternationalContainer.Pieces,
    InternationalContainer.GrossWeight,
    InternationalContainer.TareWeight,
    InternationalContainer.NetWeight,
    InternationalContainerLoadType.TypeName as LoadType,
    InternationalContainerSizeType.SizeName as SizeType,
    InternationalContainer.CubicFeet,
    InternationalContainer.SealNumber,
    InternationalContainer.SealNumber2,
    case
        when InternationalContainer.AutoInContainer = 1 then 'Yes'
        else 'No'
    end as AutoInContainer,
    InternationalContainer.RequiredDate as EstimatedPositionedDate,
    InternationalContainer.PositionedDate as ActualPositionedDate,
    InternationalContainer.LoadedDate,
    InternationalContainer.EmptyDate,
    InternationalContainer.ReturnedDate
from InternationalContainer
left outer join InternationalContainerLoadType on
    InternationalContainer.InternationalContainerLoadTypeFID = InternationalContainerLoadType.InternationalContainerLoadTypeID
left outer join InternationalContainerSizeType on
    InternationalContainer.InternationalContainerSizeTypeFID = InternationalContainerSizeType.InternationalContainerSizeTypeID
where InternationalContainer.OrdersFID = @inOrderId
GO
GRANT EXECUTE ON  [dbo].[GetInternationalContainersForLetter] TO [MssExec]
GO