SELECT A.chs_no, a.engine_no, a.lic_no
  FROM   MROH A
 WHERE   A.code = 'O7'
         AND A.eng_no LIKE '%Z13DTJ%'
         AND NOT EXISTS
               (SELECT   NULL
                  FROM   mroj C
                 WHERE       a.id = c.rohd_id
                         AND c.JC = 'T1179'
                         AND c.STS != 'X');