To find locked oracle query

SELECT sql_text FROM   v$sql WHERE  sql_id IN (SELECT sql_id                   FROM   v$session                   WHERE  sid IN (SELECT sid                                  FROM   v$lock                                  WHERE  (id1,id2,TYPE) IN (SELECT id1,                                                                   id2,                                                                   TYPE                                                            FROM   v$lock                                                            WHERE  request > 0)))