| Operation Details |  |
| Description: | Search all active operating resources by type code |
| Sterotype: | nsmulti |
| SQL | |
SELECT Resources.resourceID, Resources.name INTO :resourceID, :resourceName FROM Resources WHERE Resources.typeCode = :resourceType AND Resources.statusCode = :statusCode AND Resources.resourceStatus = :resourceStatus |