SELECT
evidenceBrokerConfigID,
sourceType,
sourceID,
sourceSystemID,
targetType,
targetID,
sourceEvidenceType,
targetEvidenceType,
autoAcceptInd,
webServicesInd,
sharedType,
shareVerificationsOption,
externalSystem,
recordStatus,
readOnlyInd,
logicESharingRules,
logicESharingRulesFileName,
trustedSource,
versionNo
INTO
:evidenceBrokerConfigID,
:sourceType,
:sourceID,
:sourceSystemID,
:targetType,
:targetID,
:sourceEvidenceType,
:targetEvidenceType,
:autoAcceptInd,
:webServicesInd,
:sharedType,
:shareVerificationsOption,
:externalSystem,
:recordStatus,
:readOnlyInd,
:logicESharingRules,
:logicESharingRulesFileName,
:trustedSource,
:versionNo
FROM
EvidenceBrokerConfig
WHERE
(
sourceID = :sourceID
OR
sourceID IS NULL
)
AND
(
sourceType = :sourceType
OR
sourceType IS NULL
)
AND
(
sourceEvidenceType = :sourceEvidenceType
OR
sourceEvidenceType IS NULL
)
AND
(
sourceSystemID = :sourceSystemID
OR
sourceSystemID IS NULL
)
AND recordStatus = :recordStatus
ORDER BY targetID,
targetType,
targetEvidenceType
|