Operation Details
Description: To get a list of instructionLineItem for a particular categoryCode and statusCode.
Sterotype: nsmulti
SQL 
SELECT
  InstructionLineItem.instructLineItemID,
  InstructionLineItem.amount,
  InstructionLineItem.unprocessedAmount,
  InstructionLineItem.instructLineItemCategory,
  InstructionLineItem.instructionLineItemType,
  InstructionLineItem.financialCompID,
  InstructionLineItem.coverPeriodFrom,
  InstructionLineItem.coverPeriodTo,
  InstructionLineItem.effectiveDate,
  InstructionLineItem.creationDate,
  InstructionLineItem.statusCode,
  InstructionLineItem.caseID,
  InstructionLineItem.finInstructionID,
  InstructionLineItem.concernRoleID,
  InstructionLineItem.caseNomineeID,
  InstructionLineItem.primaryClientID,
  InstructionLineItem.deliveryMethodType,
  InstructionLineItem.creditDebitType,
  InstructionLineItem.currencyExchangeID,
  InstructionLineItem.currencyTypeCode,
  InstructionLineItem.adjustmentInd,
  InstructionLineItem.adjustmentFrequency,
  InstructionLineItem.nextAdjustmentDate,
  InstructionLineItem.instrumentGenInd,
  InstructionLineItem.fundID,
  InstructionLineItem.maximumAmount,
  InstructionLineItem.versionNo,
  InstructionLineItem.dueDate,
  InstructionLineItem.inRespectOfID,
  InCasePartRole.participantRoleID
INTO
  :instructLineItemID,
  :amount,
  :unprocessedAmount,
  :instructLineItemCategory,
  :instructionLineItemType,
  :financialCompID,
  :coverPeriodFrom,
  :coverPeriodTo,
  :effectiveDate,
  :creationDate,
  :statusCode,
  :caseID,
  :finInstructionID,
  :concernRoleID,
  :caseNomineeID,
  :primaryClientID,
  :deliveryMethodType,
  :creditDebitType,
  :currencyExchangeID,
  :currencyTypeCode,
  :adjustmentInd,
  :adjustmentFrequency,
  :nextAdjustmentDate,
  :instrumentGenInd,
  :fundID,
  :maximumAmount,
  :versionNo,
  :dueDate,
  :inRespectOfID,
  :nomineeParticipantRoleID 
FROM
  CaseNominee InputCaseNominee,
  CaseParticipantRole InCasePartRole,
  CaseParticipantRole AllCasesCasePRole,
  CaseNominee AllCasesCaseNom,
  InstructionLineItem 
WHERE InputCaseNominee.caseNomineeID = :caseNomineeID 
  AND InputCaseNominee.caseParticipantRoleID = InCasePartRole.caseParticipantRoleID 
  AND AllCasesCasePRole.participantRoleID = InCasePartRole.participantRoleID 
  AND AllCasesCaseNom.caseParticipantRoleID = AllCasesCasePRole.caseParticipantRoleID 
  AND InstructionLineItem.caseNomineeID = AllCasesCaseNom.caseNomineeID 
  AND InstructionLineItem.statusCode = :statusCode 
  AND InstructionLineItem.instructLineItemCategory = :instructLineItemCategory 
ORDER BY InstructionLineItem.concernRoleID,
  InstructionLineItem.currencyTypeCode,
  InstructionLineItem.deliveryMethodType,
  InstructionLineItem.caseID