SQL & PL/SQL :: ORA-00907 / Missing Right Parenthesis

I am trying to execute the following query

SELECT inst_id, SID, serial#, module,username, machine, action, logon_time,status,event FROM gv$session
WHERE SID in
(
SELECT sid,id1,request FROM GV$LOCK
WHERE (id1, id2, type) IN
(SELECT id1, id2, type FROM GV$LOCK WHERE request>0) ORDER BY id1, request
)

And I received the following error message

ORA-00907: missing right parenthesis

But when I execute

SELECT inst_id, SID, serial#, module,username, machine, action, logon_time,status,event FROM gv$session

and

SELECT sid,id1,request FROM GV$LOCK
WHERE (id1, id2, type) IN
(SELECT id1, id2, type FROM GV$LOCK WHERE request>0) ORDER BY id1, request

separately. It works fine. Why is it erroring out when I include the query in WHERE clause. Rather than the work around, I would like to know the reason for the need of right paranthesis.