Oracle Workflow Query

select  execution_time,

to_char(ias.begin_date,'DD-MON-RR HH24:MI:SS') begin_date,

        ap.display_name||'/'||ac.display_name Activity,

        ias.activity_status Status,

        ias.activity_result_code Result,

        ias.assigned_user ass_User

from    wf_item_activity_statuses ias,

        wf_process_activities pa,

        wf_activities_vl ac,

        wf_activities_vl ap,

        wf_items i

where   ias.item_type = 'OECOGS'

and     ias.item_key  = '2441'

and     ias.process_activity    = pa.instance_id

and     pa.activity_name        = ac.name

and     pa.activity_item_type   = ac.item_type

and     pa.process_name         = ap.name

and     pa.process_item_type    = ap.item_type

and     pa.process_version      = ap.version

and     i.item_type             = 'OECOGS'

and     i.item_key              = ias.item_key

and     i.begin_date            >= ac.begin_date

and     i.begin_date            < nvl(ac.end_date, i.begin_date+1)

ORDER BY 2 DESC