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_HIER dependencies on WF_ACTIVITIES_VL

Line 205: wf_activities_vl wav

201: azfpv.phase,
202: wav.display_name
203: FROM az_processes azp,
204: az_flow_phases_v azfpv,
205: wf_activities_vl wav
206: WHERE azfpv.item_type = azp.item_type
207: AND azfpv.process_name = azp.process_name
208: AND azp.parent_id = p_process_parent_id
209: AND azp.process_type = g_current_mode

Line 229: wf_activities_vl wav

225: azfpv.phase,
226: wav.display_name
227: FROM az_processes azp,
228: az_flow_phases_v azfpv,
229: wf_activities_vl wav
230: WHERE azfpv.item_type = azp.item_type
231: AND azfpv.process_name = azp.process_name
232: AND azp.process_type = g_current_mode
233: AND wav.item_type = azp.item_type

Line 252: wf_activities_vl wav,

248: azfpv.phase,
249: wav.display_name
250: FROM az_processes azp,
251: az_flow_phases_v azfpv,
252: wf_activities_vl wav,
253: az_webform_messages azm
254: WHERE azfpv.item_type = azp.item_type
255: AND azfpv.process_name = azp.process_name
256: AND azp.process_type = g_current_mode

Line 1033: FROM wf_activities_vl wav,

1029: azp.comments,
1030: azp.parent_id,
1031: azfpv.phase,
1032: wav.display_name
1033: FROM wf_activities_vl wav,
1034: az_processes azp,
1035: az_flow_phases_v azfpv
1036: WHERE azfpv.item_type = azp.item_type
1037: AND azfpv.process_name = azp.process_name

Line 1056: FROM wf_activities_vl wav,

1052: azp.comments,
1053: azp.parent_id,
1054: azfpv.phase,
1055: wav.display_name
1056: FROM wf_activities_vl wav,
1057: az_processes azp,
1058: az_flow_phases_v azfpv
1059: WHERE azfpv.item_type = azp.item_type
1060: AND azfpv.process_name = azp.process_name

Line 1222: v_display_string wf_activities_vl.display_name%TYPE;

1218: v_root_activity wf_items.root_activity%TYPE;
1219: v_item_key wf_items.item_key%TYPE;
1220: v_count NUMBER(4);
1221: v_skip_count NUMBER(4);
1222: v_display_string wf_activities_vl.display_name%TYPE;
1223: v_days_no NUMBER(4);
1224: v_role_assd wf_item_attribute_values.text_value%TYPE;
1225: display_id NUMBER(5) DEFAULT 0;
1226: v_task_begin_date wf_items.begin_date%TYPE;

Line 1305: wf_activities_vl wav

1301: SELECT wav.display_name,
1302: round( months_between(sysdate, wias.begin_date)* 31),
1303: wias.begin_date
1304: FROM wf_process_activities wpa, wf_item_activity_statuses wias,
1305: wf_activities_vl wav
1306: WHERE wias.item_type = v_item_type
1307: AND wias.item_key = v_item_key
1308: AND wias.process_activity = wpa.instance_id
1309: AND wpa.activity_name = wav.name