APPS.WF_MONITOR dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 497: wf_item_activity_statuses s,

493: wf_process_activities p,
494: wf_activities a,
495: wf_activities_tl a1,
496: wf_item_types_vl ait,
497: wf_item_activity_statuses s,
498: wf_lookups l1,
499: wf_lookups l2,
500: wf_lookup_types art,
501: wf_notifications n

Line 764: wf_item_activity_statuses s,

760: wf_process_activities p,
761: wf_activities a,
762: wf_activities_tl a1,
763: wf_item_types_vl ait,
764: wf_item_activity_statuses s,
765: wf_notifications n,
766: wf_lookups l1,
767: wf_lookups l2,
768: wf_lookup_types art

Line 1020: wf_item_activity_statuses s,

1016: from wf_activities pd,
1017: wf_process_activities p1,
1018: wf_activities a,
1019: wf_activity_transitions t,
1020: wf_item_activity_statuses s,
1021: wf_lookups l,
1022: wf_process_activities p2
1023: where pd.item_type = x_proc_type
1024: and pd.name = x_proc_name

Line 2320: from wf_item_activity_statuses ias

2316: ((wi.end_date is not null) and (x_active in ('COMPLETE', 'ALL'))))
2317: and ((x_numdays is null) or
2318: (wi.end_date is null and not exists
2319: (select null
2320: from wf_item_activity_statuses ias
2321: where ias.item_type = wi.item_type
2322: and ias.item_key = wi.item_key
2323: and ias.end_date > sysdate - x_numdays)))
2324: and ((c_person is null) or exists

Line 2326: from wf_item_activity_statuses ias,

2322: and ias.item_key = wi.item_key
2323: and ias.end_date > sysdate - x_numdays)))
2324: and ((c_person is null) or exists
2325: (select null
2326: from wf_item_activity_statuses ias,
2327: wf_notifications ntf
2328: where wi.end_date is null
2329: and ias.item_type = wi.item_type
2330: and ias.item_key = wi.item_key

Line 2336: from wf_item_activity_statuses ias

2332: and ntf.group_id = ias.notification_id
2333: and ntf.recipient_role||'' = upper(c_person)))
2334: and ((x_status = 'ALL') or exists
2335: (select null
2336: from wf_item_activity_statuses ias
2337: where ias.item_type = wi.item_type
2338: and ias.item_key = wi.item_key
2339: and ias.activity_status||'' = x_status))
2340: order by 1,2;

Line 2346: from wf_item_activity_statuses wias

2342: proc proc_info%rowtype;
2343:
2344: cursor status_info(itype varchar2, ikey varchar2, status varchar2) is
2345: select count(1)
2346: from wf_item_activity_statuses wias
2347: where wias.item_type = itype
2348: and wias.item_key = ikey
2349: and wias.activity_status = status;
2350:

Line 4040: from wf_item_activity_statuses ias,

4036: wf_core.activity_result(ac.result_type, ias.activity_result_code) result,
4037: ias.error_name,
4038: ias.error_message,
4039: ias.error_stack
4040: from wf_item_activity_statuses ias,
4041: wf_process_activities pa,
4042: wf_activities_vl ac,
4043: wf_activities_vl ap,
4044: wf_items i