Query to find out list of faults in Oracle SOA BPM

select coi.title,ci.component_name, ci.cmpst_id,wf.creation_date,wf.message from cube_instance ci, composite_instance coi, wi_fault wf where

wf.creation_date > to_timestamp('2014-07-25 00:00:00','YYYY-MM-DD HH24:MI:SS') and

ci.ecid=coi.ecid and

wf.cikey=ci.cikey

order by wf.creation_date desc;