SELECT oh_name 
  FROM oh o
     , jba j
  WHERE o.oh_client = 1
    AND o.oh_deleteflag = 0
    AND o.oh_idnr = j.jba_oh_idnr
    AND j.jba_rest LIKE '%E=''1''%'
    AND o.oh_otype = 'JOBS'

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
                   )