CREATE PROCEDURE [dbo].[MssWebGetShipmentDetailsTransportationModesLookups]
as
begin
    set nocount on

    select
        [Id] = InternationalTransportationMode.InternationalTransportationModeID,
        [Name] = InternationalTransportationMode.Description,
        [Type] = InternationalTransportationType.Type
    from InternationalTransportationMode
        inner join InternationalTransportationType on InternationalTransportationType.InternationalTransportationTypeID = InternationalTransportationMode.InternationalTransportationTypeFID
    order by InternationalTransportationMode.Description, InternationalTransportationType.Type

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