/*****************************************************************************
*
* Filename         - $Workfile:   all_views.sql  $
*
*                     Name              Date      Version     CR Number
*                     Martin Helliwell 16/08/01   1.13        15487
* Author           - See revision history below.
* Last Update      - See revision history below.
*
* Project Name     - TAGTRAK(Oracle database)
*
* Source Code
* Identifier       - 3/300/8010/112
*
* Design Spec
* Section          - 
*
* Contents         - Archive schema: create all views
*
* Language         - Oracle SQL*Plus script
*
* Classification   - Commercial In Confidence
*
*          (c) Ultra Electronics Limited, 1997
*
*************************************************************************** 
/****************************************************************************
* @(#)$Workfile:   all_views.sql  $  $Revision:   1.13  $
*
* Revision History
*
* Note that user tagtrak is many users. For these users the user
* name is entered as the last line in the change description.
*
* $Log:   /pvcsarch/db_ora/db/source/arch/views/all_views.sqv  $
* 
*    Rev 1.13   16 Aug 2001 15:03:16   tagtrak
* OR:
* CR: 15487
* REV: 1.13
* DESC: Add uld_loading_progress_v and pax_and_bag_count_v1
* 
*    Rev 1.12   06 Jun 2000 09:11:06   tagtrak
*  
* 
*    Rev 1.11   31 Jan 2000 14:42:22   tagtrak
* OR:
* CR: 14402
* REV: 
* San Francisco Core Product Merge
* Neil Hilier
* 
*    Rev 1.10   20 Sep 1999 14:25:04   tagtrak
* OR:
* CR 13886,14467,14453,14425,14423,14043,14048,14049,14062,14134
* CR 12169,13291,12169,12399,13157,13163,13182,13247,12399,13384
* CR 13385,13447,13623,13627,13791
* REV:
* 
* 
*    Rev 1.9   21 Jun 1999 17:13:26   tagtrak
*  
* 
*    Rev 1.8   27 Apr 1999 15:34:46   tagtrak
* OR: 
* CR: 12146 13385
* REV:
* Comment for OR:  CR: 12146:-
* Supply View to shaoe user_id who Loaded od Unload a bag 
* -------------
* Comment for OR:  CR: 13385:-
* Modifications to provide interface for Ferranti (FASL) Flight
* Information at San Francisco.
* -------------
* Andrew Walker
* (branch build revision copied to trunk.)
* Neil Bishop
* 
* 
*    Rev 1.8   21 Apr 1999 11:09:22   tagtrak
* OR: 
* CR: 12146 13385
* REV:
* Comment for OR:  CR: 12146:-
* Supply View to shaoe user_id who Loaded od Unload a bag 
* -------------
* Comment for OR:  CR: 13385:-
* Modifications to provide interface for Ferranti (FASL) Flight
* Information at San Francisco.
* -------------
* Andrew Walker
* (branch build revision copied to trunk.)
* Neil Bishop
* 
* 
*    Rev 1.8   26 Feb 1999 09:12:18   tagtrak
*  
* 
*    Rev 1.6.1.0   19 Nov 1998 16:44:32   tagtrak
* OR: 12712 12689
* CR: 12712
* REV:
* Modifications to support bag source (local or transfer etc)
* in loading statistics.
* -------------
* Andrew Walker
* 
*    Rev 1.6   02 Apr 1998 19:09:22   tagtrak
* OR:
* CR:
* REV:
* Initial Issue
* See label for concession
* 
*    Rev 1.5   26 Feb 1998 15:16:22   tagtrak
* OR:
* CR:
* REV:
* Initial ore product version
* 
*    Rev 1.4   15 Jan 1998 15:30:02   tagtrak
* OR: OR11101, TN13, TN5
* CR:
* REV:
* Phase 2C to Phase 3 upgrade plus code review actions and some technical issues resolved.
* 
* 
*    Rev 1.3   07 Nov 1997 13:34:30   tagtrak
* OR:
* CR:
* REV:
* Added some views which were inexplicably missing
* Andrew
* 
*    Rev 1.2   28 Oct 1997 14:35:06   tagtrak
* Added PVCS header
*
**************************************************************************/

set doc off;
@@ ../live_schema/views/flight_info_v1.sql;
@@ ../live_schema/views/bag_alert_v1.sql;
@@ ../live_schema/views/bag_trace_v1.sql;
@@ ../live_schema/views/bag_trace_v2.sql;
@@ ../live_schema/views/bag_trace_v3.sql;
@@ ../live_schema/views/bag_v1.sql;
@@ ../live_schema/views/bag_v2.sql;
@@ ../live_schema/views/bag_v3.sql;
@@ ../live_schema/views/bag_v4.sql;
@@ ../live_schema/views/bag_v5.sql;
@@ ../live_schema/views/bag_v15.sql;
@@ ../live_schema/views/bag_v16.sql;
@@ ../live_schema/views/flight_dest_v1.sql;
@@ ../live_schema/views/flight_status_v1.sql;
@@ ../live_schema/views/flight_trace_v2.sql;
@@ ../live_schema/views/flight_v1.sql;
@@ ../live_schema/views/log_table_v1.sql;
@@ ../live_schema/views/onward_bag_v2.sql;
@@ ../live_schema/views/pax_v1.sql;
@@ ../live_schema/views/pax_v2.sql;
@@ ../live_schema/views/pax_v3.sql;
@@ ../live_schema/views/uld_dests_v1.sql;
@@ ../live_schema/views/uld_manifest_reports_v.sql;
@@ ../live_schema/views/uld_trace_v2.sql;
@@ ../live_schema/views/ulds_v1.sql;
@@ ../live_schema/views/uld_ldg_prog_v1.sql;
@@ ../live_schema/views/error_v1.sql;
@@ ../live_schema/views/location_v1.sql;
@@ ../live_schema/views/mws_search_plans_v1.sql;
@@ ../live_schema/views/tagtrak_users_v1.sql;
@@ ../live_schema/views/uld_types_v1.sql;
@@ ../live_schema/views/uld_ldg_prog_v1.sql;
@@ ../live_schema/views/stats_v1.sql;
@@ ../live_schema/views/lba_info_v1.sql;
@@ ../live_schema/views/aircraft_side_bag_v1.sql;
@@ ../live_schema/views/bag_alert_v3.sql;
@@ ../live_schema/views/bag_alert_v4.sql;
@@ ../live_schema/views/bag_trace_v4.sql;
@@ ../live_schema/views/bag_trace_v5.sql;
@@ ../live_schema/views/bag_trace_v6.sql;
@@ ../live_schema/views/crew_bag_v1.sql;
@@ ../live_schema/views/gate_bag_v1.sql;
@@ ../live_schema/views/norm_misc_v1.sql;
@@ ../live_schema/views/rush_bag_v1.sql;
@@ ../live_schema/views/standby_bags_v1.sql;
@@ ../live_schema/views/uld_trace_v1.sql;
@@ ../live_schema/views/lba_info_v1.sql;
@@ ../live_schema/views/uld_loading_progress_v.sql;
@@ ../live_schema/views/pax_and_bag_count_v1.sql;
@@ ../live_schema/views/terminating_counts_v1.sql
@@ ../live_schema/views/onward_flight_v1.sql
@@ ../live_schema/views/onward_flight_v2.sql
@@ ../live_schema/views/onward_uld_v1.sql
@@ ../live_schema/views/eq_log_v.sql
@@ ../live_schema/views/pm_results_v.sql
@@ ../live_schema/views/security_screening_v1.sql
@@ ../live_schema/views/reflight_bag_list_v.sql
@@ ../live_schema/views/reflighted_bag_v.sql
@@ ../live_schema/views/reflight_bag_v.sql
-- UAS/FALCP/CA/00771
@@ ../live_schema/views/bags_not_loaded_v.sql
@@ ../live_schema/views/late_bags_report_v.sql
@@ ../live_schema/views/missing_bags_all_v.sql
@@ ../live_schema/views/missing_bags_interline_v.sql
@@ ../live_schema/views/missing_bags_local_v.sql
@@ ../live_schema/views/missing_bags_online_v.sql
@@ ../live_schema/views/missing_bags_rush_v.sql
@@ ../live_schema/views/offload_bags_v.sql
@@ ../live_schema/views/rush_bag_report_v.sql
@@ ../live_schema/views/uld_contents_list_v.sql

@@ ../live_schema/views/load_v1.sql
@@ ../live_schema/views/passenger_bag_manifest.sql

@@ ../live_schema/views/recorded_uld_info_v1.sql
@@ ../live_schema/views/tracking_log_and_bag_trace_v.sql
@@ ../live_schema/views/security_certificate_v1.sql
@@ ../live_schema/views/company_mail_v1.sql
@@ ../live_schema/views/diplomatic_bags_v1.sql
@@ ../live_schema/views/pax_bag_manifest_v1.sql
@@ ../live_schema/views/hold_v1.sql

@@ ../live_schema/views/reflight_flight_v1.sql
@@ ../live_schema/views/reflight_pax_v1.sql

@@ ../live_schema/views/email_parent_report_v.sql
@@ ../live_schema/views/email_trace_v.sql
@@ ../live_schema/views/outbound_flight_v1.sql
@@ ../live_schema/views/inbound_flight_v1.sql
@@ ../live_schema/views/inbound_pax_v1.sql
@@ ../live_schema/views/inbound_uld_v1.sql
@@ ../live_schema/views/inbound_bag_v1.sql
@@ ../live_schema/views/bag_trace_data.sql
@@ ../live_schema/views/grouped_bags_v1.sql

@@ ../live_schema/views/inbound_flight_loop_v.sql
@@ ../live_schema/views/inbound_flight_loop_v2.sql
@@ ../live_schema/views/flight_sum_arr_info_v.sql
@@ ../live_schema/views/flight_info_v.sql
