Operation Details
Description: Search the resources by their 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.resourceID = LocationResourceLink.resourceID 
  AND :statusCode = Resources.statusCode 
  AND :resourceStatus = Resources.resourceStatus