Operation Details
Description: To get information on the (credit) instruction line items to which the specified debit instruction line item is allocated.
Sterotype: nsmulti
SQL 
SELECT
  ili.instructLineItemID,
  ili.instructionLineItemType,
  ili.instructLineItemCategory,
  ili.amount,
  ili.effectiveDate,
  ili.finInstructionID,
  ili.caseID,
  ili.concernRoleID,
  ili.adjustmentInd,
  ili.statusCode,
  alloc.amount,
  alloc.allocationDate
INTO
  :creditInstructionLineItemID,
  :creditType,
  :creditCategory,
  :creditAmount,
  :creditEffectiveDate,
  :creditFinInstructionID,
  :creditCaseID,
  :creditConcernRoleID,
  :creditAdjustmentInd,
  :creditStatusCode,
  :allocationAmount,
  :allocationDate 
FROM
  InstructionLineItem ili,
  AllocationLine alloc 
WHERE alloc.relatedLineItemID = :instructLineItemID 
  AND alloc.instructLineItemID = ili.instructLineItemID