Operation Details
Description: Retrieves details on all tasks the have been assigned to a work queue but have yet to be reserved.
Sterotype: nsmulti
SQL 
SELECT
  t.taskID,
  t.priority,
  t.status,
  t.assignedDateTime,
  t.wdoSnapshot,
  t.overflowInd,
  t.versionNo,
  w.deadlineTime
  
INTO
  :taskID,
  :priority,
  :status,
  :assignedDateTime,
  :wdoSnapshot,
  :overflowInd,
  :versionNo,
  :dueDateTime
FROM
  TaskAssignment ta,
  WorkQueue wq,
  Task t 
  
  LEFT OUTER JOIN
  
  WorkflowDeadline w 
  ON w.taskID = t.taskID 
WHERE ta.relatedID = :relatedID 
  AND ta.assigneeType = :assigneeType 
  AND t.taskID = ta.taskID 
  AND wq.workQueueID = ta.relatedID 
  AND t.reservedBy IS NULL