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_ITEM_ACTIVITY_STATUSES

Line 1215: v_status wf_item_activity_statuses.activity_status%TYPE;

1211: v_context_type az_processes.context_type%TYPE;
1212: v_context_name az_processes.context_name%TYPE;
1213: v_display_order az_processes.display_order%TYPE;
1214:
1215: v_status wf_item_activity_statuses.activity_status%TYPE;
1216: v_task_status wf_item_activity_statuses.activity_status%TYPE;
1217: v_dummy_begin_date wf_item_activity_statuses.begin_date%TYPE;
1218: v_root_activity wf_items.root_activity%TYPE;
1219: v_item_key wf_items.item_key%TYPE;

Line 1216: v_task_status wf_item_activity_statuses.activity_status%TYPE;

1212: v_context_name az_processes.context_name%TYPE;
1213: v_display_order az_processes.display_order%TYPE;
1214:
1215: v_status wf_item_activity_statuses.activity_status%TYPE;
1216: v_task_status wf_item_activity_statuses.activity_status%TYPE;
1217: v_dummy_begin_date wf_item_activity_statuses.begin_date%TYPE;
1218: v_root_activity wf_items.root_activity%TYPE;
1219: v_item_key wf_items.item_key%TYPE;
1220: v_count NUMBER(4);

Line 1217: v_dummy_begin_date wf_item_activity_statuses.begin_date%TYPE;

1213: v_display_order az_processes.display_order%TYPE;
1214:
1215: v_status wf_item_activity_statuses.activity_status%TYPE;
1216: v_task_status wf_item_activity_statuses.activity_status%TYPE;
1217: v_dummy_begin_date wf_item_activity_statuses.begin_date%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);

Line 1249: wf_item_activity_statuses wias,

1245: azp.item_type,
1246: azp.context_id
1247: FROM wf_item_attribute_values wiav1,
1248: wf_item_attribute_values wiav2,
1249: wf_item_activity_statuses wias,
1250: wf_process_activities wpa,
1251: az_processes azp,
1252: az_flow_phases_v azpfv,
1253: wf_items wfi

Line 1276: FROM wf_item_activity_statuses wias, wf_notification_attributes wna,

1272: ORDER BY wfi.begin_date;
1273:
1274: CURSOR az_steps_count_cursor IS
1275: SELECT COUNT(*)
1276: FROM wf_item_activity_statuses wias, wf_notification_attributes wna,
1277: wf_notifications wn
1278: WHERE wias.item_type = v_item_type
1279: AND wias.item_key = v_item_key
1280: AND wias.notification_id IS NOT NULL

Line 1289: FROM wf_item_activity_statuses wias, wf_notification_attributes wna,

1285: AND wna.text_value LIKE '%DONE%';
1286:
1287: CURSOR az_skip_count_cursor IS
1288: SELECT COUNT(*)
1289: FROM wf_item_activity_statuses wias, wf_notification_attributes wna,
1290: wf_notifications wn
1291: WHERE wias.item_type = v_item_type
1292: AND wias.item_key = v_item_key
1293: AND wias.notification_id is not NULL

Line 1304: FROM wf_process_activities wpa, wf_item_activity_statuses wias,

1300: CURSOR az_task_display_cursor IS
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