Date   |ID   | Type	| State
-------+-----+----------+---------------    
08/06  |12   | 3	| Rejected   --Should not be considered in the non accepted bucket as this id is already accepted. 
08/06  |12   | 2 	| Timeout    --Should not be considered in the non accepted bucket as this id is already accepted.
08/06  |12   | 1     	| Accepted   --Counted in Accepted bucket.
08/07  |45   | 2	| Rejected   --Counted in Non Accepted bucket as they have not been accepted yet.
08/08  |67   | 3 	| Timeout    --Counted in Non Accepted bucket

Date   | Accepted | Not Accepted
-------+----------+--------------
08/06  | 1  	  | 0
08/07  | 0        | 1
08/08  | 0        | 1

SELECT ID,
  SUM(
  CASE
    WHEN TYPE = 1
    THEN 1
    ELSE 0
  END) AS accepted,
  SUM(
  CASE
    WHEN TYPE != 1
    THEN 1
    ELSE 0
  END) AS nonaccepted
FROM MY_TABLE
GROUP BY ID;

ID     | Accepted | Not Accepted
-------+----------+--------------
12     | 1  	  | 2
45     | 0        | 1
67     | 0	  | 1

SELECT ID, 
       CASE WHEN accepted > 0 THEN 1 ELSE 0 END AS accepted,
       CASE WHEN accepted = 0 AND nonaccepted > 0 THEN 1 ELSE 0 END AS nonaccepted
FROM
(
	SELECT ID,
  	SUM(
  	CASE
    	WHEN TYPE = 1
    	THEN 1
    	ELSE 0
  	END) AS accepted,
  	SUM(
  	CASE
    	WHEN TYPE != 1
    	THEN 1
    	ELSE 0
  	END) AS nonaccepted
	FROM MY_TABLE
	GROUP BY ID
)

SCOTT@orcl_12.1.0.2.0> CREATE TABLE my_table
  2    (id     NUMBER,
  3  	type   NUMBER)
  4  /

Table created.

SCOTT@orcl_12.1.0.2.0> INSERT ALL
  2  INTO my_table (id, type) VALUES (12, 3)
  3  INTO my_table (id, type) VALUES (12, 2)
  4  INTO my_table (id, type) VALUES (12, 1)
  5  INTO my_table (id, type) VALUES (45, 2)
  6  INTO my_table (id, type) VALUES (67, 3)
  7  SELECT * FROM DUAL
  8  /

5 rows created.

SCOTT@orcl_12.1.0.2.0> SELECT * FROM my_table
  2  /

        ID       TYPE
---------- ----------
        12          3
        12          2
        12          1
        45          2
        67          3

5 rows selected.

SCOTT@orcl_12.1.0.2.0> SELECT id, accepted,
  2  	    DECODE (accepted, 0, not_accepted, 0) not_accepted
  3  FROM   (SELECT id,
  4  		    SUM (DECODE (type, 1, 1, 0)) accepted,
  5  		    SUM (DECODE (type, 1, 0, 1)) not_accepted
  6  	     FROM   my_table
  7  	     GROUP  BY id)
  8  ORDER  BY id
  9  /

        ID   ACCEPTED NOT_ACCEPTED
---------- ---------- ------------
        12          1            0
        45          0            1
        67          0            1

3 rows selected.

SCOTT@orcl_12.1.0.2.0> SELECT id,
  2  	    SUM (DECODE (type, 1, 1, 0)) accepted,
  3  	    DECODE (SUM (DECODE (type, 1, 1, 0)),
  4  		    0, SUM (DECODE (type, 1, 0, 1)),
  5  		    0) not_accepted
  6  FROM   my_table
  7  GROUP  BY id
  8  ORDER  BY id
  9  /

        ID   ACCEPTED NOT_ACCEPTED
---------- ---------- ------------
        12          1            0
        45          0            1
        67          0            1

3 rows selected.

SCOTT@orcl_12.1.0.2.0> SELECT id,
  2  	    SUM ( DISTINCT DECODE (type, 1, 1, 0)) accepted,
  3  	    DECODE (SUM (DISTINCT DECODE (type, 1, 1, 0)),
  4  		    0, SUM (DISTINCT DECODE (type, 1, 0, 1)),
  5  		    0) not_accepted
  6  FROM   my_table
  7  GROUP  BY id
  8  ORDER  BY id
  9  /

        ID   ACCEPTED NOT_ACCEPTED
---------- ---------- ------------
        12          1            0
        45          0            1
        67          0            1