CREATE PROCEDURE [dbo].[MssWebGetInternationalShipmentDetails]
    @inOrderID int
as
begin
    set nocount on

    select
        OrdersFID,
        InternationalTransportationModeFID,
        InternationalDirectionFID,
        InternationalServiceTypeFID
    from InternationalShippingInformation
    where OrdersFID = @inOrderID

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