DBA Data[Home] [Help]

APPS.INV_DETAIL_UTIL_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 117: FROM mtl_txn_request_lines

113: l_allocate_serial_flag VARCHAR2(1);
114: l_quantity_to_detail NUMBER;
115: CURSOR l_req_csr IS
116: SELECT *
117: FROM mtl_txn_request_lines
118: WHERE line_id = p_move_order_line_id FOR UPDATE nowait;
119: --
120: l_primary_quantity NUMBER;
121: l_txn_type_id NUMBER;

Line 465: UPDATE mtl_txn_request_lines

461: --bug 1248138
462: --not sure why this is happening, but it probably shouldn't be, so
463: -- i'm commenting it out.
464: /*
465: UPDATE mtl_txn_request_lines
466: SET txn_source_id = header_id
467: WHERE line_id = p_move_order_line_id;
468: */
469: ELSIF x_request_line_rec.transaction_source_type_id = 12 THEN --RMA

Line 569: UPDATE mtl_txn_request_lines SET

565: IF ((l_primary_quantity <> x_request_line_rec.primary_quantity) OR
566: (x_request_context.transaction_source_type_id <> x_request_line_rec.transaction_source_type_id) OR
567: (x_request_context.txn_header_id <> x_request_line_rec.txn_source_id) OR
568: (x_request_context.txn_line_id <> x_request_line_rec.txn_source_line_id)) THEN
569: UPDATE mtl_txn_request_lines SET
570: primary_quantity = x_request_line_rec.primary_quantity,
571: transaction_source_type_id = x_request_context.transaction_source_type_id,
572: txn_source_id = x_request_context.txn_header_id,
573: txn_source_line_id = x_request_context.txn_line_id