APPS.WMS_UNLOAD_UTILS_PVT dependencies on WMS_DISPATCHED_TASKS

Line 91: FROM wms_dispatched_tasks wdt

87: FROM mtl_material_transactions_temp mmtt
88: WHERE mmtt.move_order_line_id = mol_id
89: AND NOT EXISTS(
90: SELECT wdt.transaction_temp_id
91: FROM wms_dispatched_tasks wdt
92: WHERE wdt.transaction_temp_id = mmtt.transaction_temp_id
93: AND wdt.transaction_temp_id IS NOT NULL
94: AND wdt.transaction_temp_id <> p_temp_id);
95:

Line 131: FROM wms_dispatched_tasks

127: x_ret_value := 0;
128:
129: SELECT COUNT(transaction_temp_id)
130: INTO cnt
131: FROM wms_dispatched_tasks
132: WHERE transaction_temp_id = p_temp_id;
133:
134: IF (cnt IN(0, -1)) THEN
135: x_ret_value := 0;

Line 277: DELETE wms_dispatched_tasks

273: IF (l_debug = 1) THEN
274: mydebug('updated mol:' || mol_id);
275: END IF;
276:
277: DELETE wms_dispatched_tasks
278: WHERE transaction_temp_id = p_temp_id;
279:
280: IF (l_debug = 1) THEN
281: mydebug('deleted from wms_dispatched_tasks ');

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

277: DELETE wms_dispatched_tasks
278: WHERE transaction_temp_id = p_temp_id;
279:
280: IF (l_debug = 1) THEN
281: mydebug('deleted from wms_dispatched_tasks ');
282: END IF;
283:
284: SELECT COUNT(transaction_temp_id)
285: INTO cnt

Line 575: DELETE wms_dispatched_tasks

571: , transfer_lpn_id = NULL
572: , wms_task_status = 1 -- Bug4185621: update mmtt task status back to pending
573: WHERE transaction_temp_id = p_temp_id;
574:
575: DELETE wms_dispatched_tasks
576: WHERE transaction_temp_id = p_temp_id;
577:
578: IF (l_debug = 1) THEN
579: mydebug('deleted WDT with temp_id ' || p_temp_id);

Line 846: FROM wms_dispatched_tasks w

842: ) IS
843: -- Material packed into content LPNs
844: SELECT m.transaction_temp_id
845: , 1 dummy_sort
846: FROM wms_dispatched_tasks w
847: , mtl_material_transactions_temp m
848: WHERE m.transfer_lpn_id = p_xfer_lpn_id
849: AND m.transaction_temp_id <> p_temp_id
850: AND m.transaction_temp_id = m.parent_line_id

Line 867: FROM wms_dispatched_tasks w

863: UNION ALL
864: -- Content LPNs
865: SELECT m.transaction_temp_id
866: , 2 dummy_sort
867: FROM wms_dispatched_tasks w
868: , mtl_material_transactions_temp m
869: WHERE m.transfer_lpn_id = p_xfer_lpn_id
870: AND m.transaction_temp_id <> p_temp_id
871: AND m.transaction_temp_id = m.parent_line_id

Line 879: FROM wms_dispatched_tasks w

875: UNION ALL
876: -- Material unpacked from content LPNs
877: SELECT m.transaction_temp_id
878: , 3 dummy_sort
879: FROM wms_dispatched_tasks w
880: , mtl_material_transactions_temp m
881: WHERE m.transfer_lpn_id = p_xfer_lpn_id
882: AND m.transaction_temp_id <> p_temp_id
883: AND m.transaction_temp_id = m.parent_line_id

Line 900: FROM wms_dispatched_tasks w

896: UNION ALL
897: -- All other picked material
898: SELECT m.transaction_temp_id
899: , 4 dummy_sort
900: FROM wms_dispatched_tasks w
901: , mtl_material_transactions_temp m
902: WHERE m.transfer_lpn_id = p_xfer_lpn_id
903: AND m.transaction_temp_id <> p_temp_id
904: AND m.transaction_temp_id = m.parent_line_id

Line 1374: DELETE wms_dispatched_tasks

1370: IF (l_debug = 1) THEN
1371: mydebug('deleting WDT with temp_id: ' || to_char(p_txn_temp_id));
1372: END IF;
1373:
1374: DELETE wms_dispatched_tasks
1375: WHERE transaction_temp_id = p_txn_temp_id;
1376:
1377: --
1378: -- The lpn ids must be set to null for this task