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