APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on MTL_TXN_REQUEST_LINES

Line 3434: FROM mtl_txn_request_lines mtrl

3430: END;
3431:
3432: SELECT mtrl.txn_source_line_id
3433: INTO l_source_line_id
3434: FROM mtl_txn_request_lines mtrl
3435: WHERE mtrl.line_id = l_move_order_line_id;
3436:
3437:
3438: --If user has picked qty zero, backorder line,log

Line 3471: UPDATE mtl_txn_request_lines

3467: WHERE msnt.transaction_temp_id = l_txn_temp_id;
3468:
3469: END IF;
3470:
3471: UPDATE mtl_txn_request_lines
3472: SET quantity_detailed = quantity_detailed - l_pr_qty-- this diff is zero
3473: WHERE line_id = l_move_order_line_id;
3474:
3475: ELSE -- means l_mmtt_count = 0

Line 3678: UPDATE mtl_txn_request_lines

3674:
3675: IF (l_debug = 1) THEN
3676: trace('Upating quantity_detailed of mtrl');
3677: END IF;
3678: UPDATE mtl_txn_request_lines
3679: SET quantity_detailed = l_rec.transaction_quantity
3680: WHERE line_id = l_move_order_line_id;
3681:
3682: END IF;--for qty disc only