APPS.WMS_TASK_UTILS_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 24: , mtl_txn_request_lines mol

20: , mmtt.transaction_type_id
21: , mmtt.move_order_line_id
22: , mol.line_status
23: FROM mtl_material_transactions_temp mmtt
24: , mtl_txn_request_lines mol
25: WHERE mmtt.transfer_lpn_id = p_lpn_id
26: AND mmtt.move_order_line_id = mol.line_id
27: AND mol.line_status = inv_globals.g_to_status_cancel_by_source;
28:

Line 225: FROM mtl_txn_request_lines

221: IF (mol_id IS NOT NULL) THEN
222: BEGIN
223: SELECT line_status
224: INTO line_status
225: FROM mtl_txn_request_lines
226: WHERE line_id = mol_id;
227:
228: IF (l_debug = 1) THEN
229: mydebug(' Status ' || line_status);

Line 234: mydebug('No data found in mtl_txn_request_lines');

230: END IF;
231: EXCEPTION
232: WHEN NO_DATA_FOUND THEN
233: IF (l_debug = 1) THEN
234: mydebug('No data found in mtl_txn_request_lines');
235: END IF;
236:
237: line_status := -1;
238: END;

Line 292: UPDATE mtl_txn_request_lines

288: IF (l_debug = 1) THEN
289: mydebug(' alloc quantity deleted ' || l_del_quantity);
290: END IF;
291:
292: UPDATE mtl_txn_request_lines
293: SET quantity_detailed =(quantity_detailed - l_del_quantity)
294: WHERE line_id = mol_id;
295:
296: IF (l_debug = 1) THEN

Line 318: UPDATE mtl_txn_request_lines

314: mydebug('No more allocations in mmtt left for this mo line ' || mol_id);
315: mydebug(' so closing the mo line ' || mol_id);
316: END IF;
317:
318: UPDATE mtl_txn_request_lines
319: SET line_status = inv_globals.g_to_status_closed
320: WHERE line_id = mol_id;
321:
322: IF (l_debug = 1) THEN

Line 1525: FROM mtl_txn_request_lines mtrl, mtl_material_transactions mmt

1521: INTO l_crossdocked
1522: FROM DUAL
1523: WHERE EXISTS(
1524: SELECT mtrl.line_id
1525: FROM mtl_txn_request_lines mtrl, mtl_material_transactions mmt
1526: WHERE mtrl.line_id = mmt.move_order_line_id
1527: AND mtrl.backorder_delivery_detail_id IS NOT NULL
1528: AND mmt.transaction_set_id = p_old_header_id);
1529: EXCEPTION

Line 1720: FROM mtl_txn_request_lines

1716:
1717: BEGIN
1718: SELECT reference,reference_type_code,reference_id
1719: INTO l_ref,l_ref_type, l_ref_id
1720: FROM mtl_txn_request_lines
1721: WHERE
1722: line_id = mmtt_row.move_order_line_id;
1723: EXCEPTION
1724: WHEN others THEN

Line 2282: , mtl_txn_request_lines mtrl

2278:
2279: CURSOR c_mo_line_id IS
2280: SELECT mtrl.line_id
2281: FROM mtl_material_transactions_temp mmtt
2282: , mtl_txn_request_lines mtrl
2283: WHERE (mmtt.transaction_temp_id = p_temp_id OR mmtt.parent_line_id = p_temp_id)
2284: AND mtrl.line_id = mmtt.move_order_line_id
2285: AND mtrl.line_status = INV_GLOBALS.G_TO_STATUS_CANCEL_BY_SOURCE;
2286:

Line 2389: UPDATE mtl_txn_request_lines

2385: OPEN c_get_mmtt_count;
2386: FETCH c_get_mmtt_count INTO l_mmtt_count;
2387: CLOSE c_get_mmtt_count;
2388:
2389: UPDATE mtl_txn_request_lines
2390: SET quantity_detailed =(quantity_detailed - l_deleted_quantity)
2391: , line_status = DECODE(l_mmtt_count, 0, INV_GLOBALS.G_TO_STATUS_CLOSED, line_status)
2392: WHERE line_id = l_mo_line_id;
2393: END LOOP;