Operation Details
Description: Returns a list of the resources details
Sterotype: nsmulti
SQL 
SELECT
  distinct Resources.resourceID,
  Resources.name,
  Resources.typeCode,
  Resources.statusCode,
  Resources.resourceStatus,
  Resources.versionNo
INTO
  :resourceID,
  :resourceName,
  :resourceTypeCode,
  :statusCode,
  :resourceStatus,
  :versionNo 
FROM
  Resources 
ORDER BY resourceStatus ASC