add

About Me

My photo
Oracle Apps - Techno Functional consultant

Sunday, July 29

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

No comments: