Operation Details
Description: Method to return a list of resources by location and the resource status
Sterotype: nsmulti
SQL 
SELECT
  Resources.resourceID,
  Resources.name,
  Resources.typeCode,
  Resources.statusCode,
  Resources.resourceStatus,
  LocationResourceLink.locationID
INTO
  :resourceID,
  :resourceName,
  :resourceTypeCode,
  :statusCode,
  :resourceStatus,
  :locationID 
FROM
  Resources,
  LocationResourceLink 
WHERE Resources.statusCode <> :statusCode 
  AND Resources.resourceStatus = :resourceStatus 
  AND LocationResourceLink.locationID = :locationID 
  AND Resources.resourceID = LocationResourceLink.resourceID