Operation Details
Description:  
Sterotype: nsmulti
SQL 
SELECT 
  Obligation.obligationID,
  Obligation.transactionType,
  Obligation.debitCreditType,
  Obligation.amount,
  Obligation.creationDate,
  Obligation.relatedType,
  Obligation.relatedID,
  Obligation.startDate,
  Obligation.endDate,
  Obligation.fundFiscalYearID,
  Obligation.versionNo
INTO 
  :obligationID, 
  :transactionType,
  :debitCreditType,
  :amount,
  :creationDate,
  :relatedType,
  :relatedID,
  :startDate,
  :endDate,
  :fundFiscalYearID,
  :versionNo
FROM 
  Obligation,
  ProductDelivery
WHERE  Obligation.relatedID = ProductDelivery.caseID AND ProductDelivery.productID = :relatedID AND 
Obligation.creationDate >= :startDate AND (Obligation.creationDate <= :endDate OR :endDate is NULL)