Operation Details
Description: To retrieve a subset of InstructionLineItems details for a specified CaseID Type Code & Date Range.
Sterotype: nsmulti
SQL 
SELECT
  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
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 
FROM
  InstructionLineItem 
WHERE InstructionLineItem.caseID = :caseID 
  AND InstructionLineItem.instructionLineItemType = :typeCode 
  AND 
  (
    InstructionLineItem.effectiveDate >= :effectiveDateFrom 
    OR :effectiveDateFrom IS NULL 
  ) 
  AND 
  (
    InstructionLineItem.effectiveDate <= :effectiveDateTo 
    OR :effectiveDateTo IS NULL 
  )