substituicao

SELECT DISTINCT ptm.IDPROMOTORIA,

CASE
  WHEN ptm.IDPROMOTORTEMPORARIO IS NULL AND ptm.IDPROMOTORDIST = 16786 AND ptm.IDSUBSTITUICAO IS NULL THEN 'TITULAR'
  WHEN ptm.IDPROMOTORTEMPORARIO IS NOT NULL AND ptm.IDPROMOTORTEMPORARIO = 16786 AND ptm.IDSUBSTITUICAO IS NULL THEN 'TEMPORARIO'
  WHEN ptm.IDPROMOTORTEMPORARIO IS NULL AND ptm.IDSUBSTITUICAO IS NOT NULL AND sub.IDPROMOTORSUBSTITUTO = 16786 THEN 'RESPONDENDO'
END AS TIPO

FROM PROTOCOLOMOVIMENTO ptm
LEFT JOIN DELEGACAOSUBST sub ON sub.IDDELEGACAOSUBST = ptm.IDSUBSTITUICAO
WHERE
  (
    (ptm.IDPROMOTORTEMPORARIO IS NULL AND ptm.IDPROMOTORDIST = 16786 AND ptm.IDSUBSTITUICAO IS NULL) OR /* titular */
    (ptm.IDPROMOTORTEMPORARIO IS NOT NULL AND ptm.IDPROMOTORTEMPORARIO = 16786 AND ptm.IDSUBSTITUICAO IS NULL) OR /* temporario */
    (ptm.IDPROMOTORTEMPORARIO IS NULL AND ptm.IDSUBSTITUICAO IS NOT NULL AND sub.IDPROMOTORSUBSTITUTO = 16786) /* substituto */
  )