Operation Details
Description: To get information on the (credit) instruction line items to which the specified debit instruction line item is allocated, including the case identifier of the related credit instruction line item.
Sterotype: nsmulti
SQL 
SELECT
  ili.instructLineItemID,
  ili.instructionLineItemType,
  ili.instructLineItemCategory,
  ili.amount,
  ili.effectiveDate,
  ili.finInstructionID,
  relatedili.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,
  InstructionLineItemRelation ilirel,
  InstructionLineItem relatedili 
WHERE alloc.relatedLineItemID = :instructLineItemID 
  AND alloc.instructLineItemID = ili.instructLineItemID 
  AND alloc.instructLineItemID = ilirel.relatedLineItemID
  AND ilirel.instructLineItemID = relatedili.instructLineItemID