Operation Details
Description: Searches for all the latest Reservation based on Compartment and Reservation status.
Sterotype: nsmulti
SQL 
SELECT
  Reservation.reservationID,
  Reservation.placementID,
  Reservation.placeID,
  Reservation.providerOfferingID,
  Reservation.caseParticipantRoleID,
  Reservation.unitAmount,
  Reservation.unitAmountFixedIndicator,
  Reservation.fromDate,
  Reservation.toDate,
  Reservation.dateOfExpiry,
  Reservation.comments,
  Reservation.status,
  Reservation.versionNo
INTO
  :reservationID,
  :placementID,
  :placeID,
  :providerOfferingID,
  :caseParticipantRoleID,
  :unitAmount,
  :unitAmountFixedIndicator,
  :fromDate,
  :toDate,
  :dateOfExpiry,
  :comments,
  :status,
  :versionNo 
FROM
  Reservation ,
  Place 
WHERE Place.compartmentID = :compartmentID 
  AND status = :reservationStatus 
  AND Reservation.placeID = Place.placeID 
  AND Reservation.fromDate = 
  ( 
  SELECT
    MAX(Reservation.fromDate) 
  FROM
    Reservation 
  WHERE Place.compartmentID = :compartmentID 
    AND status = :reservationStatus 
    AND Reservation.placeID =Place.placeID 
  )