Operation Details
Description: To get the summary of a related Instruction Line Item by specifying the relatedInstructionLineItemID and the relationship type.
Sterotype: nsmulti
SQL 
SELECT
  ili.instructLineItemID,
  ili.amount,
  ili.instructLineItemCategory,
  ili.instructionLineItemType,
  ili.caseID,
  ili.finInstructionID,
  ili.concernRoleID,
  ili.creditDebitType
INTO
  :instructLineItemID,
  :amount,
  :instructLineItemCategory,
  :instructionLineItemType,
  :caseID,
  :finInstructionID,
  :concernRoleID,
  :creditDebitType 
FROM
  InstructionLineItem ili,
  InstructionLineItemRelation rel 
WHERE rel.relatedLineItemID = :instructLineItemID 
  AND rel.typeCode = :type 
  AND rel.instructLineItemID = ili.instructLineItemID