/*****************************************************************************
*
* Filename         - $Workfile:   syns.sql  $
*
*                     Name              Date      Version     CR Number
* Author           - See revision history below.
* Last Update      - See revision history below.
*
* Project Name     - TAGTRAK(Oracle database)
*
* Source Code
* Identifier       - 0/3/300/8010/112
*
* Design Spec
* Section          -
*
* Contents         - Archive Schema :  Create synonyms
*
* Language         - Oracle SQL*Plus script
*
* Classification   - Commercial In Confidence
*
*          (c) Ultra Electronics Limited, 1997
*
*****************************************************************************/
/*****************************************************************************
NOTE:any synonyms for objects in live schema should be put in this script and not 
elsewhere i.e NOT in mk_arch_schema.csh, mk_temp_schema.csh or any other script
******************************************************************************/

drop synonym location;
create synonym location for live.location;

drop synonym error;
create synonym error for live.error;

drop synonym uld_types;
create synonym uld_types for live.uld_types;

drop synonym tagtrak_users;
create synonym tagtrak_users for live.tagtrak_users;

drop synonym msg_log;
create synonym msg_log for live.msg_log;

drop synonym mws_search_plans;
create synonym mws_search_plans for live.mws_search_plans;

drop synonym agents;
create synonym agents for live.agents;

drop synonym contracted_agents;
create synonym contracted_agents for live.contracted_agents;

drop synonym kit;
create synonym kit for live.kit;

drop synonym kit_type;
create synonym kit_type for live.kit_type;

drop synonym location_group;
create synonym location_group for live.location_group;

drop synonym credentials_lookup;
create synonym credentials_lookup for live.credentials_lookup;

drop synonym carrier_lookup;
create synonym carrier_lookup for live.carrier_lookup;

drop synonym carrier_map;
create synonym carrier_map for live.carrier_map;

drop synonym user_trace;
create synonym user_trace for live.user_trace;

drop synonym site_info;
create synonym site_info for live.site_info;

drop synonym site_config;
create synonym site_config for live.site_config;

drop synonym kit_status;
create synonym kit_status for live.kit_status;

PROMPT CREATE SYNONYM unauthorised_bag FOR live.unauthorised_bag
DROP SYNONYM unauthorised_bag;
CREATE SYNONYM unauthorised_bag FOR live.unauthorised_bag;

drop synonym tracking_events;
create synonym tracking_events for live.tracking_events;

drop synonym bag_status;
create synonym bag_status for live.bag_status;

drop synonym user_role;
create synonym user_role for live.user_role;

drop synonym mct;
create synonym mct for live.mct;

drop synonym mws_flow_rate;
create synonym mws_flow_rate for live.mws_flow_rate;

drop synonym db_config;
create synonym db_config for live.db_config;

drop synonym get_user_bag_tag;
create synonym get_user_bag_tag for live.get_user_bag_tag;

drop synonym get_user_bag_tag_no_exceptions;
create synonym get_user_bag_tag_no_exceptions for live.get_user_bag_tag_no_exceptions;

drop synonym build_user_bag_tag;
create synonym build_user_bag_tag for live.build_user_bag_tag;

drop synonym get_numeric_bag_tag;
create synonym get_numeric_bag_tag for live.get_numeric_bag_tag;

drop synonym validate_bag_tag;
create synonym validate_bag_tag for live.validate_bag_tag;

drop synonym get_user_preferred_format;
create synonym get_user_preferred_format for live.get_user_preferred_format;

-- UAS/FALCP/CA/00771
DROP   SYNONYM uld_card_details;
CREATE SYNONYM uld_card_details      FOR live.uld_card_details;
DROP   SYNONYM uld_recorded_id_codes;
CREATE SYNONYM uld_recorded_id_codes FOR live.uld_recorded_id_codes;
DROP   SYNONYM split_tags;
CREATE SYNONYM split_tags            FOR live.split_tags;

drop synonym bag_exception_types;
create synonym bag_exception_types for live.bag_exception_types;

drop synonym get_user_preferred_format;
create synonym get_user_preferred_format for live.get_user_preferred_format;

drop synonym unknown_bag;
create synonym unknown_bag for live.unknown_bag;
drop synonym error;
create synonym error for live.error;

drop synonym holds;
create synonym holds for live.holds;

drop synonym eq_log;
create synonym eq_log  for  live.eq_log;    

drop synonym pm_results;
create synonym pm_results for live.pm_results;

DROP SYNONYM email_trace;
CREATE SYNONYM email_trace FOR live.email_trace;

DROP SYNONYM reports;
CREATE SYNONYM reports FOR live.reports;

DROP SYNONYM email_accounts;
CREATE SYNONYM email_accounts FOR live.email_accounts;

DROP SYNONYM email_addresses;
CREATE SYNONYM email_addresses FOR live.email_addresses;

DROP SYNONYM user_login_pkg;
CREATE SYNONYM user_login_pkg FOR live.user_login_pkg;

drop synonym get_offset;
create synonym get_offset for live.get_offset;

drop synonym user_authentication;
create synonym user_authentication for live.user_authentication;

DROP SYNONYM inbound_flight_utils;
CREATE SYNONYM inbound_flight_utils FOR live.inbound_flight_utils;

DROP SYNONYM weights;
CREATE SYNONYM weights FOR live.weights;

DROP SYNONYM uld_weights;
CREATE SYNONYM uld_weights FOR live.uld_weights;

DROP SYNONYM user_maintenance;
CREATE SYNONYM user_maintenance FOR live.user_maintenance;

DROP SYNONYM super_agents;
CREATE SYNONYM super_agents FOR live.super_agents;

DROP SYNONYM get_best_time;
CREATE SYNONYM get_best_time FOR live.get_best_time;

DROP SYNONYM carrier_site_config;
CREATE SYNONYM carrier_site_config FOR live.carrier_site_config;

DROP SYNONYM config;
CREATE SYNONYM config FOR live.config;

DROP SYNONYM add_uld_trace_record;
CREATE SYNONYM add_uld_trace_record FOR live.add_uld_trace_record;

DROP SYNONYM bag_alert_priority;
CREATE SYNONYM bag_alert_priority FOR live.bag_alert_priority;

DROP SYNONYM system_cfg;
CREATE SYNONYM system_cfg FOR live.system_cfg;

DROP SYNONYM stand_setup;
CREATE SYNONYM stand_setup FOR live.stand_setup;