APPS.WMS_TASK_SKIPPED dependencies on WMS_DISPATCHED_TASKS

Line 45: l_last_updated_by wms_dispatched_tasks.last_updated_by%TYPE;

41: l_org_id NUMBER;
42: l_task_id NUMBER;
43: l_sequence NUMBER;
44: l_inventory_item_id NUMBER;
45: l_last_updated_by wms_dispatched_tasks.last_updated_by%TYPE;
46: l_created_by wms_dispatched_tasks.created_by%TYPE;
47: l_progress VARCHAR2(10);
48:
49: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 46: l_created_by wms_dispatched_tasks.created_by%TYPE;

42: l_task_id NUMBER;
43: l_sequence NUMBER;
44: l_inventory_item_id NUMBER;
45: l_last_updated_by wms_dispatched_tasks.last_updated_by%TYPE;
46: l_created_by wms_dispatched_tasks.created_by%TYPE;
47: l_progress VARCHAR2(10);
48:
49: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
50: BEGIN

Line 77: FROM wms_dispatched_tasks w ,

73: BEGIN
74: /* Bug#5563901.Replaced wms_dispatchable_tasks_v by a query from MMTT and MCCE */
75: SELECT t.inventory_item_id, w.created_by
76: INTO l_inventory_item_id, l_created_by
77: FROM wms_dispatched_tasks w ,
78: (SELECT mmtt.transaction_temp_id task_id, mmtt.wms_task_type wms_task_type_id,
79: mmtt.inventory_item_id
80: FROM mtl_material_transactions_temp mmtt
81: WHERE mmtt.transaction_temp_id = l_task_id

Line 185: DELETE FROM wms_dispatched_tasks

181: mydebug('Before Deleting from wms_dispatched_task');
182: END IF;
183: l_progress := '50';
184:
185: DELETE FROM wms_dispatched_tasks
186: WHERE transaction_temp_id = l_task_id AND
187: task_type = p_wms_task_type;
188: IF (l_debug = 1) THEN
189: mydebug('After Deleting from wms_dispatched_task');