CREATE PROCEDURE [dbo].[EmailApiGetItemsRequiringPdfGeneration]
    @items IntList readonly
as
begin
    set nocount on

    select
        Item1 = Items.Item,
        Item2 = OutgoingEmailOrderMap.OrderFID

    from
    @items Items
    inner join OutgoingEmailPdfInput on items.Item = OutgoingEmailPdfInput.OutgoingEmailFid
    inner join OutgoingEmailOrderMap on items.Item = OutgoingEmailOrderMap.OutgoingEmailFid

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