Untitled

update cs_agent_card_sales_participants cs
set cs.sales_agent_code = (select code from agents where id = cs.agent_id)
where agent_id is not null
  and sales_agent_code is null;

update cs_card_block_ussd_queue ca
set ca.customer_agent_code = (select code from agents where id = ca.agent_id)
where agent_id is not null
  and ca.customer_agent_code is null;

update cs_card_cost_request_failure_log ca
set ca.customer_agent_code = (select code from agents where id = ca.agent_id)
where agent_id is not null
  and ca.customer_agent_code is null;

update cs_card_cost_request_failure_log cs
set cs.local_govt_code = (select code from local_governments lg where lg.id = cs.local_government_id)
where cs.local_government_id is not null
  and cs.local_govt_code is null;

update cs_card_delivery_requests cs
set cs.customer_agent_code = (select code from agents where id = cs.agent_id)
where agent_id is not null
  and cs.customer_agent_code is null;

update cs_card_delivery_requests cs
set cs.local_govt_code = (select code from local_governments lg where lg.id = cs.local_government_id)
where cs.local_government_id is not null
  and cs.local_govt_code is null;

update cs_fulfillment_centers cs
set cs.local_govt_code = (select code from local_governments lg where lg.id = cs.local_government_id)
where cs.local_government_id is not null
  and cs.local_govt_code is null;

update cs_fulfillment_center_managers cs
set cs.aggregator_code = (select code from aggregators a where a.id = cs.aggregator_id)
where cs.aggregator_id is not null
  and cs.aggregator_code is null;

update cs_card_carton_inventory cs
set cs.custodian_supreme_aggregator_code = (select code from supreme_aggregators a where a.id = cs.custodian_supreme_aggregator)
where cs.custodian_supreme_aggregator is not null
  and cs.custodian_supreme_aggregator_code is null;

update cs_card_carton_inventory cs
set cs.custodian_super_aggregator_code = (select code from super_aggregators a where a.id = cs.custodian_super_aggregator)
where cs.custodian_super_aggregator is not null
  and cs.custodian_super_aggregator_code is null;

update cs_card_carton_inventory cs
set cs.custodian_aggregator_code = (select code from aggregators a where a.id = cs.custodian_aggregator)
where cs.custodian_aggregator is not null
  and cs.custodian_aggregator_code is null;

update cs_card_carton_inventory cs
set cs.custodian_sales_agent_code = (select code from agents a where a.id = cs.custodian_agent)
where cs.custodian_agent is not null
  and cs.custodian_sales_agent_code is null;

update cs_card_carton_requests cs
set cs.custodian_supreme_aggregator_code = (select code from supreme_aggregators a where a.id = cs.custodian_supreme_aggregator)
where cs.custodian_supreme_aggregator is not null
  and cs.custodian_supreme_aggregator_code is null;

update cs_card_carton_requests cs
set cs.custodian_super_aggregator_code = (select code from super_aggregators a where a.id = cs.custodian_super_aggregator)
where cs.custodian_super_aggregator is not null
  and cs.custodian_super_aggregator_code is null;

update cs_card_carton_requests cs
set cs.custodian_aggregator_code = (select code from aggregators a where a.id = cs.custodian_aggregator)
where cs.custodian_aggregator is not null
  and cs.custodian_aggregator_code is null;

update cs_card_carton_requests cs
set cs.custodian_sales_agent_code = (select code from agents a where a.id = cs.custodian_agent)
where cs.custodian_agent is not null
  and cs.custodian_sales_agent_code is null;

update cs_card_inventory_history cs
set cs.custodian_supreme_aggregator_code = (select code from supreme_aggregators a where a.id = cs.custodian_supreme_aggregator)
where cs.custodian_supreme_aggregator is not null
  and cs.custodian_supreme_aggregator_code is null;

update cs_card_inventory_history cs
set cs.custodian_super_aggregator_code = (select code from super_aggregators a where a.id = cs.custodian_super_aggregator)
where cs.custodian_super_aggregator is not null
  and cs.custodian_super_aggregator_code is null;

update cs_card_inventory_history cs
set cs.custodian_aggregator_code = (select code from aggregators a where a.id = cs.custodian_aggregator)
where cs.custodian_aggregator is not null
  and cs.custodian_aggregator_code is null;

update cs_card_inventory_history cs
set cs.custodian_sales_agent_code = (select code from agents a where a.id = cs.custodian_agent)
where cs.custodian_agent is not null
  and cs.custodian_sales_agent_code is null;

update cs_card_carton_inventory_history cs
set cs.custodian_supreme_aggregator_code = (select code from supreme_aggregators a where a.id = cs.custodian_supreme_aggregator)
where cs.custodian_supreme_aggregator is not null
  and cs.custodian_supreme_aggregator_code is null;

update cs_card_carton_inventory_history cs
set cs.custodian_super_aggregator_code = (select code from super_aggregators a where a.id = cs.custodian_super_aggregator)
where cs.custodian_super_aggregator is not null
  and cs.custodian_super_aggregator_code is null;

update cs_card_carton_inventory_history cs
set cs.custodian_aggregator_code = (select code from aggregators a where a.id = cs.custodian_aggregator)
where cs.custodian_aggregator is not null
  and cs.custodian_aggregator_code is null;

update cs_card_packet_inventory_history cs
set cs.custodian_aggregator_code = (select code from aggregators a where a.id = cs.custodian_aggregator)
where cs.custodian_aggregator is not null
  and cs.custodian_aggregator_code is null;

update cs_card_packet_inventory_history cs
set cs.custodian_sales_agent_code = (select code from agents a where a.id = cs.custodian_agent)
where cs.custodian_agent is not null
  and cs.custodian_sales_agent_code is null;

update cs_card_packet_request_transactions cs
set cs.sales_agent_code = (select code from agents a where a.id = cs.agent_id)
where cs.agent_id is not null
  and cs.sales_agent_code is null;

update cs_carton_request_transactions cs
set cs.wallet_token = (select token from wallets w where w.id = cs.wallet_id)
where cs.wallet_id is not null
  and cs.wallet_token is null;