/*****************************************************************************
*
* Filename              - open_flight_events_v.sql
*
* Project Name          - UltraTrak Database
*
* Source Code Identifier - UAS/FALCP/SD/00848
*
* Description           - Creates view OPEN_FLIGHT_EVENTS_V
*
* Language              - Oracle PL/SQL
*
* File History          - For the development history run the Show History report in PVCS
*
* Copyright Ultra Electronics Airport Systems, 2004
*
*****************************************************************************/

CREATE OR REPLACE VIEW open_flight_events_v
AS SELECT *
 FROM   flight_events 
 WHERE  event_key IS NOT NULL AND
        end_log_time IS NULL AND
        NVL(event_duration,'S') = 'I';

