DBA Data[Home] [Help]

APPS.WF_MONITOR dependencies on WF_ACTIVITIES_VL

Line 2299: wf_activities_vl wa

2295: wi.end_date,
2296: wa.display_name process_name
2297: from wf_items wi,
2298: wf_item_types_vl wit,
2299: wf_activities_vl wa
2300: where wi.item_type = wit.name
2301: and wa.item_type = wi.item_type
2302: and wa.name = wi.root_activity
2303: and wa.version = wi.root_activity_version

Line 3097: from wf_items i, wf_activities_vl a, wf_item_types_vl it

3093: -- do the fetch here.
3094: -- This is to avoid sending spaces throught web server
3095: select i.begin_date, i.end_date, a.display_name, it.display_name, i.root_activity
3096: into x_begin_date, x_end_date, proc_dispname, item_type_dispname, x_root_activity
3097: from wf_items i, wf_activities_vl a, wf_item_types_vl it
3098: where i.item_type = x_item_type
3099: and i.item_key = x_item_key
3100: and i.item_type = it.name
3101: and i.root_activity = a.name

Line 3721: 'wf_activities_vl_pub.fetch_draw_activity_details?p_item_type='||

3717:
3718: htp.tableData(
3719: cvalue=>' 3770: owa_util.get_owa_service_path||
3771: 'wf_activities_vl_pub.fetch_draw_activity_details?p_item_type='||
3772: wfa_html.conv_special_url_chars(x_activity_record.activity_item_type)||
3773: '&p_activity_type='||
3774: x_activity_record.activity_type||
3775: '&p_effective_date='||

Line 4042: wf_activities_vl ac,

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
4045: where ias.item_type = c_item_type
4046: and ias.item_key = c_item_key

Line 4043: wf_activities_vl ap,

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
4045: where ias.item_type = c_item_type
4046: and ias.item_key = c_item_key
4047: and ias.activity_status = 'ERROR'