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
|