Operation Details
Description: Method to get the list of attachments for a given planned item.
Sterotype: nsmulti
SQL 
SELECT
  Attachment.attachmentID,
  Attachment.attachmentName,
  Attachment.attachmentContents,
  Attachment.attachmentStatus,
  Attachment.receiptDate,
  Attachment.documentType,
  Attachment.fileLocation,
  Attachment.fileReference,
  PlannedItemAttachmentLink.plannedItemID,
  PlannedItemAttachmentLink.description,
  PlannedItemAttachmentLink.plannedItemAttachmentLinkID
INTO
  :attachmentID,
  :attachmentName,
  :attachmentContents,
  :attachmentStatus,
  :receiptDate,
  :documentType,
  :fileLocation,
  :fileReference,
  :plannedItemID,
  :description,
  :plannedItemAttachmentLinkID 
FROM
  Attachment,
  PlannedItemAttachmentLink 
WHERE Attachment.attachmentID = PlannedItemAttachmentLink.attachmentID 
  AND PlannedItemAttachmentLink.plannedItemID = :plannedItemID