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: --BUG 12769978 begin

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: --BUG 12769978 begin
50: l_lot_control_code NUMBER;

Line 85: FROM wms_dispatched_tasks w ,

81: BEGIN
82: /* Bug#5563901.Replaced wms_dispatchable_tasks_v by a query from MMTT and MCCE */
83: SELECT t.inventory_item_id, w.created_by
84: INTO l_inventory_item_id, l_created_by
85: FROM wms_dispatched_tasks w ,
86: (SELECT mmtt.transaction_temp_id task_id, mmtt.wms_task_type wms_task_type_id,
87: mmtt.inventory_item_id
88: FROM mtl_material_transactions_temp mmtt
89: WHERE mmtt.transaction_temp_id = l_task_id

Line 194: DELETE FROM wms_dispatched_tasks

190: mydebug('Before Deleting from wms_dispatched_task');
191: END IF;
192: l_progress := '50';
193:
194: DELETE FROM wms_dispatched_tasks
195: WHERE transaction_temp_id = l_task_id AND
196: task_type = p_wms_task_type;
197: IF (l_debug = 1) THEN
198: mydebug('After Deleting from wms_dispatched_task');