CREATE PROCEDURE [dbo].[MssWebGetInternationalFinancialInformation]
    @inOrderId int
as
begin
    set nocount on

    select
        InternationalShippingInformation.OrdersFID,
        InternationalShippingInformation.CostPlus,
        InternationalShippingInformation.ReadyToBill,
        InternationalShippingInformation.ReadyToBillUploaded,
        InternationalShippingInformation.ReleasedToBill,
        InternationalShippingInformation.TariffIndicator,
        InternationalShippingInformation.GppApplies,
        InternationalShippingInformation.InternationalValuationDeclinedReasonFID,
        InternationalShippingInformation.CertificationNumber,
        InternationalShippingInformation.DeductibleAmount,
        InternationalShippingInformation.InternationalValueTypeFID,
        InternationalShippingInformation.TotalLossCoverage,
        InternationalShippingInformation.MechanicalMalfunction,
        InternationalShippingInformation.PairsOrSets,
        InternationalShippingInformation.MoldOrMildew,
        InternationalShippingInformation.InsuredRate,
        InternationalShippingInformation.InternalRate,
        InternationalShippingInformation.BilledRate,
        InternationalShippingInformation.IncludeAutoOnCertificate,
        InternationalShippingInformation.InsuredValueForAuto,
        InternationalShippingDate.ReadyToBillDate,
        InternationalShippingDate.CertificateDate,
        InternationalShippingDate.ReleaseToBillDate
    from InternationalShippingInformation
    cross join InternationalShippingDate
    where InternationalShippingInformation.OrdersFID = @inOrderId
        and InternationalShippingDate.OrdersFID = @inOrderId

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