SELECT
OrganisationUnitResource.organisationUnitResourceID,
Resources.resourceID,
Resources.name,
Resources.typeCode,
OrganisationUnitResource.recordStatus,
CASE
WHEN OrganisationUnit.defaultPrinterID = OrganisationUnitResource.resourceID
THEN 1
ELSE 0
END
,
OrganisationUnitResource.versionNo
INTO
:organisationUnitResourceID,
:resourceID,
:resourceName,
:resourceTypeCode,
:recordStatus,
:defaultPrinterInd,
:versionNo
FROM
OrganisationUnitResource,
Resources,
OrganisationUnit
WHERE OrganisationUnitResource.organisationUnitID = :organisationUnitID
AND Resources.resourceID = OrganisationUnitResource.resourceID
AND OrganisationUnit.organisationUnitID = OrganisationUnitResource.organisationUnitID
AND
(
OrganisationUnitResource.recordStatus = :recordStatus
OR OrganisationUnitResource.recordStatus IS NULL
)
|