APPS.INV_DETAIL_UTIL_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 120: FROM mtl_txn_request_lines

116: l_secondary_quantity_to_detail NUMBER; /* Bug 9172258 */
117:
118: CURSOR l_req_csr IS
119: SELECT *
120: FROM mtl_txn_request_lines
121: WHERE line_id = p_move_order_line_id FOR UPDATE nowait;
122: --
123: l_primary_quantity NUMBER;
124: l_txn_type_id NUMBER;

Line 513: UPDATE mtl_txn_request_lines

509: --bug 1248138
510: --not sure why this is happening, but it probably shouldn't be, so
511: -- i'm commenting it out.
512: /*
513: UPDATE mtl_txn_request_lines
514: SET txn_source_id = header_id
515: WHERE line_id = p_move_order_line_id;
516: */
517: ELSIF x_request_line_rec.transaction_source_type_id = 12 THEN --RMA

Line 617: UPDATE mtl_txn_request_lines SET

613: IF ((l_primary_quantity <> x_request_line_rec.primary_quantity) OR
614: (x_request_context.transaction_source_type_id <> x_request_line_rec.transaction_source_type_id) OR
615: (x_request_context.txn_header_id <> x_request_line_rec.txn_source_id) OR
616: (x_request_context.txn_line_id <> x_request_line_rec.txn_source_line_id)) THEN
617: UPDATE mtl_txn_request_lines SET
618: primary_quantity = x_request_line_rec.primary_quantity,
619: transaction_source_type_id = x_request_context.transaction_source_type_id,
620: txn_source_id = x_request_context.txn_header_id,
621: txn_source_line_id = x_request_context.txn_line_id

Line 3769: UPDATE mtl_txn_request_lines

3765: l_mmtt_tbl(l_mmtt_tbl_size).transaction_quantity := l_qty_sign * trunc(l_txn_temp_qty,5);
3766: l_mmtt_tbl(l_mmtt_tbl_size).transaction_uom := p_request_context.primary_uom_code;
3767:
3768: IF l_index = 2 THEN
3769: UPDATE mtl_txn_request_lines
3770: SET quantity = primary_quantity,
3771: uom_code = p_request_context.primary_uom_code
3772: WHERE line_id = p_request_line_rec.line_id;
3773: END IF;