Operation Details |
Description: | To read the sum of the amount field based on CaseID, FinInstructID, Category and Status. |
Sterotype: | ns |
SQL |
SELECT SUM(amount) INTO :amount FROM InstructionLineItem WHERE InstructionLineItem.caseID = :caseID AND InstructionLineItem.finInstructionID = :finInstructionID AND InstructionLineItem.instructLineItemCategory = :instructLineItemCategory AND InstructionLineItem.statusCode = :statusCode |