Operation Details
Description: To get information on the (debit) instruction line items to which the specified credit 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
  :debitInstructionLineItemID,
  :debitType,
  :debitCategory,
  :debitAmount,
  :debitEffectiveDate,
  :debitFinInstructionID,
  :debitCaseID,
  :debitConcernRoleID,
  :debitAdjustmentInd,
  :debitStatusCode,
  :allocationAmount,
  :allocationDate 
FROM
  InstructionLineItem ili,
  AllocationLine alloc 
WHERE alloc.instructLineItemID = :instructLineItemID 
  AND alloc.relatedLineItemID = ili.instructLineItemID