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 1528: FROM mtl_txn_request_lines mtrl, mtl_material_transactions mmt

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

Line 1729: FROM mtl_txn_request_lines

1725:
1726: BEGIN
1727: SELECT reference,reference_type_code,reference_id
1728: INTO l_ref,l_ref_type, l_ref_id
1729: FROM mtl_txn_request_lines
1730: WHERE
1731: line_id = mmtt_row.move_order_line_id;
1732: EXCEPTION
1733: WHEN others THEN

Line 2297: , mtl_txn_request_lines mtrl

2293:
2294: CURSOR c_mo_line_id IS
2295: SELECT mtrl.line_id
2296: FROM mtl_material_transactions_temp mmtt
2297: , mtl_txn_request_lines mtrl
2298: WHERE (mmtt.transaction_temp_id = p_temp_id OR mmtt.parent_line_id = p_temp_id)
2299: AND mtrl.line_id = mmtt.move_order_line_id
2300: AND mtrl.line_status = INV_GLOBALS.G_TO_STATUS_CANCEL_BY_SOURCE;
2301:

Line 2404: UPDATE mtl_txn_request_lines

2400: OPEN c_get_mmtt_count;
2401: FETCH c_get_mmtt_count INTO l_mmtt_count;
2402: CLOSE c_get_mmtt_count;
2403:
2404: UPDATE mtl_txn_request_lines
2405: SET quantity_detailed =(quantity_detailed - l_deleted_quantity)
2406: , line_status = DECODE(l_mmtt_count, 0, INV_GLOBALS.G_TO_STATUS_CLOSED, line_status)
2407: WHERE line_id = l_mo_line_id;
2408: END LOOP;