CREATE PROCEDURE  [dbo].[MssWebGetInternationalContainer]
    @inOrderID int,
    @inContainerId int
as
begin
    set nocount on

    select
        InternationalContainer.InternationalContainerId,
        InternationalContainer.OrdersFId,
        InternationalContainer.InternationalContainerLoadTypeFId,
        InternationalContainerLoadType.TypeName as ContainerLoadTypeName,
        InternationalContainer.ContainerNumber,
        InternationalContainer.Pieces,
        InternationalContainer.GrossWeight,
        InternationalContainer.TareWeight,
        InternationalContainer.NetWeight,
        InternationalContainer.SealNumber,
        InternationalContainer.CubicFeet,
        InternationalContainer.RequiredDate,
        InternationalContainer.PositionedDate,
        InternationalContainer.LoadedDate,
        InternationalContainer.EmptyDate,
        InternationalContainer.ReturnedDate,  
        InternationalContainer.SealNumber2,
        InternationalContainer.InternationalContainerSizeTypeFId,
        InternationalContainerSizeType.SizeName as ContainerSizeTypeName,
        InternationalContainer.AutoInContainer
    from InternationalContainer
        left outer join InternationalContainerLoadType on InternationalContainerLoadType.InternationalContainerLoadTypeID = InternationalContainer.InternationalContainerLoadTypeFID
        left outer join InternationalContainerSizeType on InternationalContainerSizeType.InternationalContainerSizeTypeID = InternationalContainer.InternationalContainerSizeTypeFID
    where InternationalContainer.OrdersFID = @inOrderID and InternationalContainer.InternationalContainerID = @inContainerId
end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetInternationalContainer] TO [MssExec]
GO