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 
  (
    sharedType = :sharedType 
    OR 
    sharedType IS NULL 
  ) 
  AND recordStatus = :recordStatus 
  ORDER BY targetID,
  targetType,
  targetEvidenceType