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.WMS_TASK_UTILS_PVT dependencies on WMS_DISPATCHED_TASKS

Line 118: FROM wms_dispatched_tasks wdt

114: FROM mtl_material_transactions_temp mmtt
115: WHERE mmtt.move_order_line_id = mol_id
116: AND NOT EXISTS(
117: SELECT wdt.transaction_temp_id
118: FROM wms_dispatched_tasks wdt
119: WHERE wdt.transaction_temp_id = mmtt.transaction_temp_id
120: AND wdt.transaction_temp_id IS NOT NULL
121: AND wdt.transaction_temp_id <> p_temp_id);
122:

Line 170: FROM wms_dispatched_tasks

166: x_ret_value := 0;
167:
168: SELECT COUNT(transaction_temp_id)
169: INTO cnt
170: FROM wms_dispatched_tasks
171: WHERE transaction_temp_id = p_temp_id;
172:
173: IF (cnt IN(0, -1)) THEN
174: x_ret_value := 0;

Line 300: DELETE wms_dispatched_tasks

296: IF (l_debug = 1) THEN
297: mydebug('updated mol:' || mol_id);
298: END IF;
299:
300: DELETE wms_dispatched_tasks
301: WHERE transaction_temp_id = p_temp_id;
302:
303: IF (l_debug = 1) THEN
304: mydebug('deleted from wms_dispatched_tasks ');

Line 304: mydebug('deleted from wms_dispatched_tasks ');

300: DELETE wms_dispatched_tasks
301: WHERE transaction_temp_id = p_temp_id;
302:
303: IF (l_debug = 1) THEN
304: mydebug('deleted from wms_dispatched_tasks ');
305: END IF;
306:
307: SELECT COUNT(transaction_temp_id)
308: INTO cnt

Line 496: DELETE wms_dispatched_tasks

492: , content_lpn_id = NULL
493: , transfer_lpn_id = NULL
494: WHERE transaction_temp_id = p_temp_id;
495:
496: DELETE wms_dispatched_tasks
497: WHERE transaction_temp_id = p_temp_id;
498:
499: IF (l_debug = 1) THEN
500: mydebug('deleted WDT with temp_id ' || p_temp_id);

Line 2289: FROM wms_dispatched_tasks

2285: l_deleted_quantity NUMBER := 0;
2286:
2287: CURSOR c_wdt_dispatched IS
2288: SELECT transaction_temp_id, device_request_id
2289: FROM wms_dispatched_tasks
2290: WHERE person_id = p_emp_id
2291: AND(status <= 3 OR status = 9)
2292: AND device_request_id IS NOT NULL;
2293:

Line 2310: FROM wms_dispatched_tasks wdt

2306: AND NOT EXISTS(SELECT 1
2307: FROM mtl_material_transactions_temp t1
2308: WHERE t1.parent_line_id = mmtt.transaction_temp_id)
2309: AND NOT EXISTS(SELECT 1
2310: FROM wms_dispatched_tasks wdt
2311: WHERE wdt.transaction_temp_id = mmtt.transaction_temp_id);
2312:
2313: CURSOR c_get_mmtt_count IS
2314: SELECT count(*)

Line 2358: -- DELETE FROM wms_dispatched_tasks WHERE person_id = p_emp_id AND status IN(3, 9);

2354: ROLLBACK; --bug#2458131
2355:
2356: -- Making all dispatched and active (Patchset I) tasks to pending tasks assigned to this user
2357: -- bug 3602199 keep queued tasks as queued and dont delete wdt
2358: -- DELETE FROM wms_dispatched_tasks WHERE person_id = p_emp_id AND status IN(3, 9);
2359: if(p_previous_task_status = 2/*queued*/) then
2360: DELETE FROM wms_dispatched_tasks WHERE person_id = p_emp_id AND status IN(3, 9) and transaction_temp_id <> p_temp_id;
2361: update wms_dispatched_tasks set status = 2 where transaction_temp_id = p_temp_id and person_id = p_emp_id;
2362: /* mydebug('Rows update in wdt 3602199' || SQL%ROWCOUNT);*/

Line 2360: DELETE FROM wms_dispatched_tasks WHERE person_id = p_emp_id AND status IN(3, 9) and transaction_temp_id <> p_temp_id;

2356: -- Making all dispatched and active (Patchset I) tasks to pending tasks assigned to this user
2357: -- bug 3602199 keep queued tasks as queued and dont delete wdt
2358: -- DELETE FROM wms_dispatched_tasks WHERE person_id = p_emp_id AND status IN(3, 9);
2359: if(p_previous_task_status = 2/*queued*/) then
2360: DELETE FROM wms_dispatched_tasks WHERE person_id = p_emp_id AND status IN(3, 9) and transaction_temp_id <> p_temp_id;
2361: update wms_dispatched_tasks set status = 2 where transaction_temp_id = p_temp_id and person_id = p_emp_id;
2362: /* mydebug('Rows update in wdt 3602199' || SQL%ROWCOUNT);*/
2363: else/*old code*/
2364: DELETE FROM wms_dispatched_tasks where person_id = p_emp_id and status in (3,9);

Line 2361: update wms_dispatched_tasks set status = 2 where transaction_temp_id = p_temp_id and person_id = p_emp_id;

2357: -- bug 3602199 keep queued tasks as queued and dont delete wdt
2358: -- DELETE FROM wms_dispatched_tasks WHERE person_id = p_emp_id AND status IN(3, 9);
2359: if(p_previous_task_status = 2/*queued*/) then
2360: DELETE FROM wms_dispatched_tasks WHERE person_id = p_emp_id AND status IN(3, 9) and transaction_temp_id <> p_temp_id;
2361: update wms_dispatched_tasks set status = 2 where transaction_temp_id = p_temp_id and person_id = p_emp_id;
2362: /* mydebug('Rows update in wdt 3602199' || SQL%ROWCOUNT);*/
2363: else/*old code*/
2364: DELETE FROM wms_dispatched_tasks where person_id = p_emp_id and status in (3,9);
2365: /* mydebug('All rows deleted from wdt' || SQL%ROWCOUNT);*/

Line 2364: DELETE FROM wms_dispatched_tasks where person_id = p_emp_id and status in (3,9);

2360: DELETE FROM wms_dispatched_tasks WHERE person_id = p_emp_id AND status IN(3, 9) and transaction_temp_id <> p_temp_id;
2361: update wms_dispatched_tasks set status = 2 where transaction_temp_id = p_temp_id and person_id = p_emp_id;
2362: /* mydebug('Rows update in wdt 3602199' || SQL%ROWCOUNT);*/
2363: else/*old code*/
2364: DELETE FROM wms_dispatched_tasks where person_id = p_emp_id and status in (3,9);
2365: /* mydebug('All rows deleted from wdt' || SQL%ROWCOUNT);*/
2366: end if;
2367:
2368: OPEN c_mo_line_id;