--更新如下表中的数量和状态
update rcv_lots_interface rli
set rli.quantity = 37094,
rli.primary_quantity = 37094
where rli.interface_transaction_id = 754842
and rli.lot_num = '1208';
UPDATE MTL_TRANSACTION_LOTS_TEMP mtlt
SET mtlt.transaction_quantity = 37094,
mtlt.primary_quantity = 37094
WHERE mtlt.transaction_temp_id = 754842
AND mtlt.lot_number = '1208';
update rcv_transactions_interface rti
set rti.processing_status_code = 'PENDING',
rti.transaction_status_code = 'PENDING',
rti.processing_request_id = null
where interface_transaction_id = 754842;
运行请求:接收事务处理处理器
