APPS.WMS_UNLOAD_UTILS_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 157: FROM mtl_txn_request_lines

153: IF (mol_id IS NOT NULL) THEN
154: BEGIN
155: SELECT line_status
156: INTO line_status
157: FROM mtl_txn_request_lines
158: WHERE line_id = mol_id;
159:
160: IF (l_debug = 1) THEN
161: mydebug(' Status ' || line_status);

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

162: END IF;
163: EXCEPTION
164: WHEN NO_DATA_FOUND THEN
165: IF (l_debug = 1) THEN
166: mydebug('No data found in mtl_txn_request_lines');
167: END IF;
168:
169: line_status := -1;
170: END;

Line 224: UPDATE mtl_txn_request_lines

220: IF (l_debug = 1) THEN
221: mydebug(' alloc quantity deleted ' || l_del_quantity);
222: END IF;
223:
224: UPDATE mtl_txn_request_lines
225: SET quantity_detailed =(quantity_detailed - l_del_quantity)
226: WHERE line_id = mol_id;
227:
228: IF (l_debug = 1) THEN

Line 250: UPDATE mtl_txn_request_lines

246: mydebug('No more allocations in mmtt left for this mo line ' || mol_id);
247: mydebug(' so closing the mo line ' || mol_id);
248: END IF;
249:
250: UPDATE mtl_txn_request_lines
251: SET line_status = inv_globals.g_to_status_closed
252: WHERE line_id = mol_id;
253:
254: IF (l_debug = 1) THEN

Line 600: , mtl_txn_request_lines mtrl

596: , mmtt.transaction_uom
597: , mmtt.move_order_line_id
598: , mtrl.uom_code
599: FROM mtl_material_transactions_temp mmtt
600: , mtl_txn_request_lines mtrl
601: WHERE mmtt.parent_line_id = p_temp_id
602: AND mtrl.line_id = mmtt.move_order_line_id
603: AND mtrl.line_status = 9
604: UNION ALL

Line 883: UPDATE mtl_txn_request_lines

879: ELSE
880: l_conv_qty := l_quantity;
881: END IF;
882:
883: UPDATE mtl_txn_request_lines
884: SET quantity_detailed = (quantity_detailed - l_conv_qty)
885: WHERE line_id = l_mo_line_id;
886:
887: IF (l_debug = 1) THEN

Line 901: UPDATE mtl_txn_request_lines

897: IF (l_debug = 1) THEN
898: mydebug('No more allocations for mo line ' || to_char(l_mo_line_id));
899: END IF;
900:
901: UPDATE mtl_txn_request_lines
902: SET line_status = inv_globals.g_to_status_closed
903: WHERE line_id = l_mo_line_id;
904: ELSE
905: IF (l_debug = 1) THEN