Operation Details
Description: Reads organization unit name, business type code, location name and units status details.
Sterotype: ns
SQL 
SELECT
  OrganisationUnit.name,
  OrganisationUnit.businessTypeCode,
  OrganisationUnit.recordStatus,
  OrganisationUnit.statusCode,
  Location.name
INTO
  :organisationUnitName,
  :businessTypeCode,
  :recordStatus,
  :statusCode,
  :locationName 
FROM
  OrganisationUnit 
  
  LEFT OUTER JOIN
  
  Location 
  ON OrganisationUnit.locationID = Location.locationID 
WHERE OrganisationUnit.organisationUnitID = :organisationUnitID