create table test_exp (oid number, ioid number, status varchar2(20));

Below are the insert statements.

Insert into TEST_EXP (OID, IOID, STATUS) Values (1, 100, 'NEW');
Insert into TEST_EXP (OID, IOID, STATUS) Values (1, 101, 'DISCO');
Insert into TEST_EXP (OID, IOID, STATUS) Values (1, 102, 'CANCELLED');
Insert into TEST_EXP (OID, IOID, STATUS) Values (2, 103, 'NEW');
Insert into TEST_EXP (OID, IOID, STATUS) Values (3, 104, 'DISCO');
Insert into TEST_EXP (OID, IOID, STATUS) Values (4, 105, 'DISCO');
Insert into TEST_EXP (OID, IOID, STATUS) Values (4, 106, 'NEW');
Insert into TEST_EXP (OID, IOID, STATUS) Values (5, 107, 'NEW');
Insert into TEST_EXP (OID, IOID, STATUS) Values (5, 108, 'CANCELLED');  

The output looks like below:

OID|IOID|STATUS
1 |100 |NEW
1 |101 |DISCO
1 |102 |CANCELLED
2 |103 |NEW
3 |104 |DISCO
4 |105 |DISCO
4 |106 |NEW
5 |107 |NEW
5 |108 |CANCELLED  

OID|IOID|STATUS
1 |100 |NEW
1 |101 |DISCO
4 |105 |DISCO
4 |106 |NEW  

SQL> select * from test_exp
  2  where oid in (select oid from test_exp 
  3                where status in ('NEW','DISCO')
  4                group by oid having count(*) = 2)
  5    and status in ('NEW','DISCO')
  6  order by 1, 2, 3
  7  /
       OID       IOID STATUS
---------- ---------- --------------------
         1        100 NEW
         1        101 DISCO
         4        105 DISCO
         4        106 NEW

SQL> with 
  2    data as (
  3      select t.*, count(*) over (partition by oid) cnt
  4      from test_exp t
  5      where status in ('NEW','DISCO')
  6    )
  7  select oid, ioid, status
  8  from data
  9  where cnt = 2
 10  order by 1, 2, 3
 11  /
       OID       IOID STATUS
---------- ---------- --------------------
         1        100 NEW
         1        101 DISCO
         4        105 DISCO
         4        106 NEW