Database SQL Operation: AdminICEvidenceLink.searchAdminIntegratedCaseByStatusShareableInd
Description: | Retrieves all Admin Integrated Case records linked to evidence by the record status code and shareableInd specified. The details retrieved include admin integrated case ID and type. |
Sterotype: | nsmulti |
SELECT
DISTINCT AdminIntegratedCase.adminIntegratedCaseID,
AdminIntegratedCase.integratedCaseType
INTO
:adminIntegratedCaseID,
:integratedCaseType
FROM
AdminIntegratedCase,
AdminICEvidenceLink
WHERE AdminIntegratedCase.adminIntegratedCaseID =AdminICEvidenceLink.adminIntegratedCaseID
AND AdminIntegratedCase.statusCode = :statusCode
AND AdminICEvidenceLink.shareableInd = :shareableInd
|