Operation Details
Description: @Deprecated Method to return all organization units for specified parent organization unit.
Sterotype: nsmulti
SQL
SELECT
  OrganisationUnit.organisationUnitID,
  OrganisationUnit.name,
  OrganisationUnit.businessTypeCode,
  OrganisationUnit.creationDate,
  OrganisationUnit.recordStatus,
  OrganisationUnit.comments,
  OrganisationUnit.defaultPrinterID,
  OrganisationUnit.statusCode,
  OrgUnitParentLink.organisationStructureID,
  OrgUnitParentLink.parentOrganisationUnitID,
  OrganisationStructure.name
INTO
  :organisationUnitID,
  :name,
  :businessTypeCode,
  :creationDate,
  :recordStatus,
  :comments,
  :defaultPrinterID,
  :statusCode,
  :organisationStructureID,
  :parentOrganisationUnitID,
  :organisationStructureName 
FROM
  OrganisationUnit,
  OrgUnitParentLink,
  OrganisationStructure 
WHERE OrgUnitParentLink.organisationStructureID = :organisationStructureID 
  AND OrgUnitParentLink.parentOrganisationUnitID = :organisationUnitID 
  AND OrganisationUnit.organisationUnitID = OrgUnitParentLink.organisationUnitID 
  AND OrganisationStructure.organisationStructureID = OrgUnitParentLink.organisationStructureID