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

    select
        InternationalVoyage.InternationalVoyageID,
        InternationalVoyage.OrdersFID,
        InternationalVoyage.InternationalPortFID,
        InternationalDestPort.PortCode as DestinationPortCode,
        InternationalDestPort.Name as DestinationPortName,
        InternationalVoyage.Name,
        InternationalVoyage.EstimatedDepartureDate,
        InternationalVoyage.ActualDepartureDate,
        InternationalVoyage.EstimatedArrivalDate,
        InternationalVoyage.ActualArrivalDate,
        InternationalVoyage.InternationalOriginPortFID,
        InternationalOrigPort.PortCode as OriginPortCode,
        InternationalOrigPort.Name as OriginPortName
    from InternationalVoyage
        left outer join InternationalPort as InternationalDestPort on InternationalVoyage.InternationalPortFID = InternationalDestPort.InternationalPortID
        left outer join InternationalPort as InternationalOrigPort on InternationalVoyage.InternationalOriginPortFID = InternationalOrigPort.InternationalPortID
    where InternationalVoyage.OrdersFID = @inOrderID

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