Operation Details
Description:  
Sterotype: nsmulti
SQL 
   SELECT 
     AdviceItemCaseLink.adviceItemCaseLinkID, 
     AdviceItemCaseLink.adviceItemID,
     AdviceItemCaseLink.caseID,
     AdviceItemCaseLink.evidenceType,
     AdviceItemCaseLink.relatedID
   INTO
     :adviceItemCaseLinkID,
     :adviceItemID,
     :caseID,
     :evidenceType,
     :relatedID
   FROM
      AdviceItemCaseLink,
      AdviceItem
      
   WHERE AdviceItemCaseLink.caseID = :caseID
      AND AdviceItemCaseLink.relatedID = :relatedID
      AND AdviceItemCaseLink.adviceItemID = AdviceItem.adviceItemID  
      AND AdviceItem.categoryType = :categoryType