SELECT * 
  FROM oh o
  WHERE o.oh_client = 1
    AND o.oh_otype IN ('JOBS', 'JOBP', 'SCRI')
    AND o.oh_deleteflag = 0
    AND NOT EXISTS (
                     SELECT 1 
                     FROM odoc d 
                     WHERE o.oh_idnr = d.ODOC_OH_Idnr
                   )