Operation Details
Description: Searches for outcomes which are not associated to the related reference specified.
Sterotype: nsmulti
SQL 
SELECT
  outcomeID,
  outcomeReference,
  description,
  name,
  dateCreated,
  recordStatus,
  versionNo
INTO
  :outcomeID,
  :outcomeReference,
  :description,
  :name,
  :dateCreated,
  :recordStatus,
  :versionNo 
FROM
  Outcome 
WHERE recordStatus = :outcomeStatus 
  AND outcomeID NOT IN 
  (
  SELECT
    outcomeID 
  FROM
    OutcomeLink 
  WHERE relatedID = :relatedID
  )