I had checked alertlog file and found the following

Tue Jan 16 11:37:57 2007
ORA-000060: Deadlock detected. More info in file E:\oracle\admin\wizerp\udump\ORA02996.TRC.

and when i checked that ORA02996.TRC file

DEADLOCK DETECTED
Current SQL statement for this session:

SELECT 1 FROM journal_mt WHERE journal_id=
( SELECT NVL(MAX(journal_id),1 - 1) FROM journal_mt WHERE journal_id BETWEEN 1 AND 99999999) FOR UPDATE

i also had found some other statements in that particular ORA02996.TRC file
But i suspect that the above mentioned statement is the major source of deadlock

My question is ,should i look in-depth the above mentioned query
or i have to look the other statements in this trace file to resolve the deadlocks?