CREATE PROCEDURE  [dbo].[MssWebGetInternationalLiftVan]
    @inOrderId int,
    @inLiftVanId int
as
begin

    set nocount on

    select
        InternationalLiftVan.InternationalLiftVanID,
        InternationalLiftVan.OrdersFID,
        InternationalLiftVan.InternationalContainerFID,
        InternationalContainer.ContainerNumber,
        InternationalLiftVan.InternationalLiftVanStatusFID,
        InternationalLiftVanStatus.StatusName as LiftVanStatusName,
        InternationalLiftVan.LiftVanNumber,
        InternationalLiftVan.Pieces,
        InternationalLiftVan.GrossWeight,
        InternationalLiftVan.TareWeight,
        InternationalLiftVan.NetWeight,
        InternationalLiftVan.SealNumber,
        InternationalLiftVan.CubicFeet,
        InternationalLiftVan.Length,
        InternationalLiftVan.Width,
        InternationalLiftVan.Height
    from InternationalLiftVan
        left outer join InternationalLiftVanStatus on InternationalLiftVanStatus.InternationalLiftVanStatusID = InternationalLiftVan.InternationalLiftVanStatusFID
        left outer join InternationalContainer on InternationalContainer.InternationalContainerID = InternationalLiftvan.InternationalContainerFID
    where InternationalLiftVan.OrdersFID = @inOrderId and InternationalLiftVan.InternationalLiftVanID = @inLiftVanId

end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetInternationalLiftVan] TO [MssExec]
GO