CREATE PROCEDURE  [dbo].[MssWebGetInternationalVesselVoyage]
    @inOrderID int,
    @inVesselVoyageId 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 and InternationalVoyage.InternationalVoyageID = @inVesselVoyageId
end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetInternationalVesselVoyage] TO [MssExec]
GO