APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on MTL_TXN_REQUEST_LINES

Line 4033: FROM mtl_txn_request_lines mtrl

4029: END;
4030:
4031: SELECT mtrl.txn_source_line_id
4032: INTO l_source_line_id
4033: FROM mtl_txn_request_lines mtrl
4034: WHERE mtrl.line_id = l_move_order_line_id;
4035:
4036:
4037: --If user has picked qty zero, backorder line,log

Line 4072: UPDATE mtl_txn_request_lines

4068: END IF;
4069:
4070: /*Bug# 5868236 -- 14028129 .We will do this only if WF is not present .
4071: Otherwise WF will take care of this. So moving this code down
4072: UPDATE mtl_txn_request_lines
4073: SET quantity_detailed = quantity_detailed - l_pr_qty-- this diff is zero
4074: WHERE line_id = l_move_order_line_id; -- 14028129*/
4075:
4076: ELSIF ( l_wf = 0 ) THEN -- means l_mmtt_count = 0 . -- 14028129

Line 4298: UPDATE mtl_txn_request_lines

4294: Otherwise WF will take care of this. So moving this code down
4295: IF (l_debug = 1) THEN
4296: trace('Upating quantity_detailed of mtrl');
4297: END IF;
4298: UPDATE mtl_txn_request_lines
4299: SET quantity_detailed = l_rec.transaction_quantity
4300: WHERE line_id = l_move_order_line_id; -- 14028129*/
4301:
4302: END IF;--for qty disc only

Line 4731: UPDATE mtl_txn_request_lines

4727: ELSE -- 14028129
4728: IF (l_debug = 1) THEN
4729: trace('Updating quantity_detailed of mtrl');
4730: END IF;
4731: UPDATE mtl_txn_request_lines
4732: SET quantity_detailed = l_rec.transaction_quantity
4733: WHERE line_id = l_move_order_line_id;
4734:
4735: END IF; -- l_rec.reason_id IS NOT NULL