APPS.WMS_UNLOAD_UTILS_PVT dependencies on WMS_DISPATCHED_TASKS

Line 62: FROM wms_dispatched_tasks wdt

58: FROM mtl_material_transactions_temp mmtt
59: WHERE mmtt.move_order_line_id = mol_id
60: AND NOT EXISTS(
61: SELECT wdt.transaction_temp_id
62: FROM wms_dispatched_tasks wdt
63: WHERE wdt.transaction_temp_id = mmtt.transaction_temp_id
64: AND wdt.transaction_temp_id IS NOT NULL
65: AND wdt.transaction_temp_id <> p_temp_id);
66:

Line 102: FROM wms_dispatched_tasks

98: x_ret_value := 0;
99:
100: SELECT COUNT(transaction_temp_id)
101: INTO cnt
102: FROM wms_dispatched_tasks
103: WHERE transaction_temp_id = p_temp_id;
104:
105: IF (cnt IN(0, -1)) THEN
106: x_ret_value := 0;

Line 232: DELETE wms_dispatched_tasks

228: IF (l_debug = 1) THEN
229: mydebug('updated mol:' || mol_id);
230: END IF;
231:
232: DELETE wms_dispatched_tasks
233: WHERE transaction_temp_id = p_temp_id;
234:
235: IF (l_debug = 1) THEN
236: mydebug('deleted from wms_dispatched_tasks ');

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

232: DELETE wms_dispatched_tasks
233: WHERE transaction_temp_id = p_temp_id;
234:
235: IF (l_debug = 1) THEN
236: mydebug('deleted from wms_dispatched_tasks ');
237: END IF;
238:
239: SELECT COUNT(transaction_temp_id)
240: INTO cnt

Line 425: DELETE wms_dispatched_tasks

421: , transfer_lpn_id = NULL
422: , wms_task_status = 1 -- Bug4185621: update mmtt task status back to pending
423: WHERE transaction_temp_id = p_temp_id;
424:
425: DELETE wms_dispatched_tasks
426: WHERE transaction_temp_id = p_temp_id;
427:
428: IF (l_debug = 1) THEN
429: mydebug('deleted WDT with temp_id ' || p_temp_id);

Line 651: FROM wms_dispatched_tasks w

647: ) IS
648: -- Material packed into content LPNs
649: SELECT m.transaction_temp_id
650: , 1 dummy_sort
651: FROM wms_dispatched_tasks w
652: , mtl_material_transactions_temp m
653: WHERE m.transfer_lpn_id = p_xfer_lpn_id
654: AND m.transaction_temp_id <> p_temp_id
655: AND m.transaction_temp_id = m.parent_line_id

Line 672: FROM wms_dispatched_tasks w

668: UNION ALL
669: -- Content LPNs
670: SELECT m.transaction_temp_id
671: , 2 dummy_sort
672: FROM wms_dispatched_tasks w
673: , mtl_material_transactions_temp m
674: WHERE m.transfer_lpn_id = p_xfer_lpn_id
675: AND m.transaction_temp_id <> p_temp_id
676: AND m.transaction_temp_id = m.parent_line_id

Line 684: FROM wms_dispatched_tasks w

680: UNION ALL
681: -- Material unpacked from content LPNs
682: SELECT m.transaction_temp_id
683: , 3 dummy_sort
684: FROM wms_dispatched_tasks w
685: , mtl_material_transactions_temp m
686: WHERE m.transfer_lpn_id = p_xfer_lpn_id
687: AND m.transaction_temp_id <> p_temp_id
688: AND m.transaction_temp_id = m.parent_line_id

Line 705: FROM wms_dispatched_tasks w

701: UNION ALL
702: -- All other picked material
703: SELECT m.transaction_temp_id
704: , 4 dummy_sort
705: FROM wms_dispatched_tasks w
706: , mtl_material_transactions_temp m
707: WHERE m.transfer_lpn_id = p_xfer_lpn_id
708: AND m.transaction_temp_id <> p_temp_id
709: AND m.transaction_temp_id = m.parent_line_id

Line 1040: DELETE wms_dispatched_tasks

1036: IF (l_debug = 1) THEN
1037: mydebug('deleting WDT with temp_id: ' || to_char(p_txn_temp_id));
1038: END IF;
1039:
1040: DELETE wms_dispatched_tasks
1041: WHERE transaction_temp_id = p_txn_temp_id;
1042:
1043: --
1044: -- The lpn ids must be set to null for this task