/*****************************************************************************
*
* Filename         - $Workfile:   prg_flight_info.sql  $
*
*                     Name: Yomi Kogbe    Date: 08/06/00  Version1.0     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         - Live Schema View
*
* Language         - Oracle SQL*Plus script
*
* Classification   - Commercial In Confidence
*
*          (c) Ultra Electronics Limited, 1997
*
*****************************************************************************/
drop view prg_fids_info;
create view prg_fids_info( 
  id, 
  timestamp,
  flight_no,
  flight_date,
	flight_dest,
  gate,
  scheduled,
  estimate,
  blockoff,
  runway,
  direction,
	flight_code3,
	flight_code2,
	flight_number
) as
select  
  id,
  timestamp,
  flight_no,
  flight_date,
	flight_dest,
  gate,
  scheduled,
  estimate,
  blockoff,
  runway,
  direction,
	flight_code3,
	flight_code2,
	flight_number
from
  live.prg_fids_info;
