eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AZW_PROC dependencies on WF_PROCESS_ACTIVITIES

Line 2153: FROM wf_items wfi, wf_process_activities wpa,

2149:
2150: CURSOR az_tasks_days_cursor IS
2151: SELECT round( months_between(sysdate, wfi.begin_date)* 31),
2152: wias.activity_status
2153: FROM wf_items wfi, wf_process_activities wpa,
2154: wf_item_activity_statuses wias
2155: WHERE wfi.item_type = p_type
2156: AND wfi.root_activity = p_name
2157: AND wfi.item_key = p_key

Line 2168: FROM wf_process_activities wpa, wf_item_activity_statuses wias,

2164:
2165: CURSOR az_task_display_cursor IS
2166: SELECT wav.display_name,
2167: wias.begin_date
2168: FROM wf_process_activities wpa, wf_item_activity_statuses wias,
2169: wf_activities_vl wav
2170: WHERE wias.item_type = p_type
2171: AND wias.item_key = p_key
2172: AND wias.process_activity = wpa.instance_id

Line 2278: FROM wf_process_activities wpa, wf_item_activity_statuses wias,

2274:
2275: CURSOR az_task_display_cursor IS
2276: SELECT wav.display_name,
2277: wias.begin_date
2278: FROM wf_process_activities wpa, wf_item_activity_statuses wias,
2279: wf_activities_vl wav
2280: WHERE wias.item_type = p_type
2281: AND wias.item_key = v_new_task_key
2282: AND wias.process_activity = wpa.instance_id

Line 2523: FROM wf_items wfi, wf_process_activities wpa,

2519: v_task_status wf_item_activity_statuses.activity_status%TYPE;
2520:
2521: CURSOR az_task_status_cursor IS
2522: SELECT wias.activity_status
2523: FROM wf_items wfi, wf_process_activities wpa,
2524: wf_item_activity_statuses wias
2525: WHERE wfi.item_type = v_type
2526: AND wfi.root_activity = p_name
2527: AND wfi.item_key = v_key