/*****************************************************************************
*
* Filename         - $Workfile:   all_views.sql  $
*
*                     Name              Date      Version     CR Number
*                     Martin Helliwell 15/08/01    1.11       15487
* 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         - Create Live Schema Views
*
* Language         - Oracle SQL*Plus script
*
* Classification   - Commercial In Confidence
*
*          (c) Ultra Electronics Limited, 1997
*
*****************************************************************************/

set doc off;
@@flight_info_v1.sql;
@@bag_alert_v1.sql;
@@bag_alert_v4.sql;
@@bag_trace_v1.sql;
@@bag_trace_v2.sql;
@@bag_trace_v3.sql;
@@bag_trace_v4.sql;
@@bag_trace_v5.sql;
@@bag_trace_v6.sql;
@@bag_v1.sql;
@@bag_v2.sql;
@@bag_v3.sql;
@@bag_v4.sql;
@@bag_v5.sql;
@@bag_v15.sql;
@@bag_v16.sql;
@@bpm_data_v1.sql;
@@carrier_lookup_v1.sql;
@@error_v1.sql;
@@flight_dest_v1.sql;
@@flight_status_v1.sql;
@@flight_trace_v2.sql;
@@flight_v1.sql;
@@ldg_strat_v1.sql;
@@location_v1.sql;
@@log_table_v1.sql;
@@mail_global_v1.sql;
@@mail_global_v2.sql;
@@mail_indiv_v1.sql;
@@mail_indiv_v2.sql;
@@mws_search_plans_v1.sql;
@@pax_v1.sql;
@@pax_v2.sql;
@@pax_v3.sql;
@@privilege_v1.sql;
@@system_cfg_v1.sql;
@@tagtrak_users_v1.sql;
@@uld_dests_v1.sql;
@@uld_manifest_reports_v.sql;
@@uld_trace_v2.sql;
@@uld_types_v1.sql;
@@ulds_v1.sql;
@@uld_ldg_prog_v1.sql;
@@user_group_v1.sql;
@@uld_dests_v2.sql;
@@inbound_flight_info.sql;
@@outbound_flight_info.sql;
@@stats_v1.sql;
@@onward_bag_v2.sql;
@@lba_info_v1.sql;
@@bag_alert_v3.sql;
@@aircraft_side_bag_v1.sql;
@@crew_bag_v1.sql;
@@gate_bag_v1.sql;
@@norm_misc_v1.sql;
@@rush_bag_v1.sql;
@@standby_bags_v1.sql;
@@uld_trace_v1.sql;
@@ltr_day_v1.sql
@@ltr_month_v1.sql
@@ltr_week_v1.sql
@@bag_v7.sql
@@load_v1.sql
@@allocated_priv_v1.sql
@@load_attempt_v1.sql
@@terminating_counts_v1.sql
@@onward_flight_v1.sql
@@onward_flight_v2.sql
@@onward_uld_v1.sql
@@hold_v1.sql
@@uld_loading_progress_v.sql
@@event_logging.sql
@@rfid_trace_v1.sql
@@bmm_bags.sql
@@onward_flight_v.sql
@@pax_and_bag_count_v1.sql
@@security_screening_v1.sql
@@security_screening_v2.sql
@@codeshare_config_v1.sql
@@flight_info_v.sql
@@arrival_baggage_information_v.sql
@@arrival_flight_load_popup_v.sql
@@arrival_flight_loading_v.sql
@@arrival_flight_uld_contents_v.sql
@@arrival_load_bag_popup_v.sql
@@departure_bag_information_v.sql
@@flight_sum_arr_info_v.sql
@@flight_sum_dep_info_v.sql
@@inbound_flight_loop_v.sql
@@inbound_flight_loop_v1.sql
@@uld_data_v.sql
@@reallocate_bag_v.sql
@@reallocate_summary_v.sql
@@reallocate_uld_v.sql
@@bag_manifest_totals_v1.sql
@@pm_results_v
@@eq_log_v
@@concurrent_logins_v.sql
@@recorded_uld_info_v1.sql
@@carrier_site_config_v.sql
@@hold_config_carrier_v.sql

@@late_bags_v.sql
@@missing_bags_all_v.sql
@@missing_bags_interline_v.sql
@@missing_bags_local_v.sql
@@missing_bags_online_v.sql
@@missing_bags_rush_v.sql
@@reflight_bag_v.sql
@@reflight_bag_list_v.sql
@@reflight_summary_v.sql
@@reflight_setup_v.sql
@@reflight_uld_bag_list_v.sql
@@reflighted_bag_v.sql
@@reflight_tag_v.sql
@@reflight_tag_v2.sql
@@reflight_pax_v1.sql

@@pax_bag_manifest_v1.sql
@@uld_contents_list_v.sql
@@rush_bag_report_v.sql
@@late_bags_report_v.sql
@@offload_bags_v.sql
@@bags_not_loaded_v.sql
@@flight_summary_info_v.sql
@@tracking_log_and_bag_trace_v.sql
@@security_certificate_v1.sql
@@company_mail_v1.sql
@@diplomatic_bags_v1.sql
@@bag_groups_v1.sql
@@holding_pens_v1.sql
@@holding_pens_v2.sql

@@reflight_flight_v1.sql
@@open_flight_events_v.sql

@@email_parent_report_v.sql
@@email_trace_v.sql
@@inbound_flight_v.sql
@@outbound_flight_v1.sql
@@inbound_flight_v1.sql
@@inbound_pax_v1.sql
@@inbound_uld_v1.sql
@@inbound_bag_v1.sql
@@manual_bmm_v1.sql
@@bmms_sent_v1.sql
@@bmm_contents_v1.sql
@@flights_linked_v1.sql
@@flights_linked_v2.sql
@@unknown_unauth_bag.sql
@@bag_trace_data.sql
@@grouped_bags_v1.sql
@@interface_state_v.sql
@@inbound_flight_loop_v2.sql
GRANT SELECT ON flight_outbound_v1 TO arch;

@@reprint_uld_info_v1.sql