APPS.AZW_HIER dependencies on WF_ITEMS

Line 1218: v_root_activity wf_items.root_activity%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);
1222: v_display_string wf_activities_vl.display_name%TYPE;

Line 1219: v_item_key wf_items.item_key%TYPE;

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);
1222: v_display_string wf_activities_vl.display_name%TYPE;
1223: v_days_no NUMBER(4);

Line 1226: v_task_begin_date wf_items.begin_date%TYPE;

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;
1227: v_task_tot_days NUMBER(5) DEFAULT 0;
1228: v_days_since NUMBER(5) DEFAULT 0;
1229: v_process_phase az_product_phases.phase%TYPE;
1230: v_display_status wf_resources.text%TYPE;

Line 1253: wf_items wfi

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
1254: WHERE wfi.item_type = azp.item_type
1255: AND wfi.root_activity = azp.process_name
1256: AND azpfv.item_type = azp.item_type
1257: AND azpfv.process_name = azp.process_name