Operation Details
Description: Method to return all organization unit resources for specified organization unit and resource type code.
Sterotype: nsmulti
SQL 
SELECT
  OrganisationUnitResource.organisationUnitResourceID,
  Resources.resourceID,
  Resources.name,
  Resources.typeCode,
  Resources.resourceStatus,
  Location.name,
  CASE 
    WHEN OrganisationUnit.defaultPrinterID = OrganisationUnitResource.resourceID 
    THEN 1 
    ELSE 0 
  END
  ,
  OrganisationUnitResource.versionNo
INTO
  :organisationUnitResourceID,
  :resourceID,
  :resourceName,
  :resourceTypeCode,
  :resourceStatus,
  :locationName,
  :defaultPrinterInd,
  :versionNo 
FROM
  OrganisationUnitResource,
  Resources,
  Location,
  OrganisationUnit 
WHERE OrganisationUnitResource.organisationUnitID = :organisationUnitID 
  AND Resources.resourceID = OrganisationUnitResource.resourceID 
  AND Resources.typeCode = :typeCode 
  AND OrganisationUnit.organisationUnitID = OrganisationUnitResource.organisationUnitID