CREATE procedure [dbo].[MssWebGetOrderTasks]
    @inOrderId int,
    @inSecurityModule varchar(30)
as
set nocount on

select distinct
    Id = td.ToDoID,
    [Description] = t.taskdescription,
    CompletedBy = dbo.GetSysuserName( td.CompletedBy, 1 ),
    Duedate = case
        when td.Complete = 1 or td.NotApplicableFlag = 1 then td.DueDateWhenDischarged
        else td.DueDate
    end ,
    Coordinator = dbo.GetSysuserName( td.TaskUserFID, 1 ),
    AssignedRole = ct.CoordinatorType,
    DateTimeCompleted = td.DateTimeCompleted,
    NotApplicableUserName = dbo.GetSysuserName( td.NotApplicableSysUserFID, 1 ),
    NotApplicableDateTime = td.NotApplicableDateTime,
    [Priority] = TaskPriority.PriorityNumber,
    PriorityDesc = TaskPriority.[Description],
    Note = tdn.Notes
from todo td
    left outer join orders o on o.prikey = td.orderid
    left outer join tasks t on t.taskid = td.taskid
    left outer join ToDoNote tdn on tdn.ToDoFID = td.ToDoID
    left outer join coordinatortype ct on ct.coordinatortypeid = t.coordinatortypeid
    inner join Profiles on Profiles.ProfileID = td.ProfileID
    inner join SecModules on SecModules.ModulePriKey = Profiles.SecModulesFID
    left outer join TaskPriority on td.TaskPriorityFID = TaskPriority.TaskPriorityID
where
    td.OrderID = @inOrderId
    and SecModules.Description = @inSecurityModule
GO
GRANT EXECUTE ON  [dbo].[MssWebGetOrderTasks] TO [MssExec]
GO