Operation Details
Description: To retrieve the list of certifications which are sorted by period from date.
Sterotype: nsmulti
SQL 
SELECT
  ProductDeliveryCertDiary.caseID,
  certificationReceivedDate,
  periodFromDate,
  periodToDate,
  documentRefNumber,
  fileRefNumber,
  certificationDiaryID,
  ProductDeliveryCertDiary.comments,
  ProductDeliveryCertDiary.statusCode
INTO
  :caseID,
  :certificationReceivedDate,
  :periodFromDate,
  :periodToDate,
  :documentRefNumber,
  :fileRefNumber,
  :certificationDiaryID,
  :comments,
  :statusCode 
FROM
  ProductDeliveryCertDiary 
WHERE ProductDeliveryCertDiary.caseID = :caseID 
ORDER BY periodFromDate DESC