
rem *********************************************************************

rem *                                                                   *

rem *             Copyright (c) Ultra Electronics Airport Systems       *

rem *                           All rights reserved.                    *

rem *                                                                   *

rem *********************************************************************

rem *                                                                   *

rem * Filename:             arrival_load_bag_popup_v.sql                *

rem * Module Name:          arrival_load_bag_popup_v                    *

rem * Subsystem Name:       views                                       *

rem * Originating Author:   James Creegan                               *

rem * Design Reference:     FAS/BBTRK/SD/225                            *

rem *                                                                   *

rem *********************************************************************

rem *                                                                   *

rem * Description:                                                      *

rem *  View required for inbound flight screens                         *

rem *********************************************************************

rem *                                                                   *

rem * Program Identification Array:                                     *

rem *                                                                   *

rem * "%Z%%M% VERSION %I% %E% %U%"

rem *                                                                   *

rem *********************************************************************

rem *                                                                   *

rem * Modification History:                                             *

rem *                                                                   *

rem * Rel Date/Time      Proj/Id   CA Ref/Details Of Change             *

rem * --- -------------- --------  ------------------------------------ *

rem * 1.0 28 May 03                File initially checked in            *

rem *********************************************************************/
PROMPT Creating view arrival_load_bag_popup_v

CREATE OR REPLACE FORCE VIEW arrival_load_bag_popup_v
(bag_tag,
 destination,
 class,
 uld_load_sequence,
 passenger,
 exception,
 in_flight_id,
 in_uld_no
 )
AS
  /* note that extra security is not needed as the inbound       */
  /* flight and ULD have already been selected by secure methods */
  SELECT 
    bag.bag_tag, 
    bag.bag_destination, 
    pax.pax_class,
    bag.bag_sequence_no,
    pax.pax_surname,
    bag.bag_exception,
    flight.flight_id,
    ulds.uld_no
  FROM bag, pax, ulds, flight 
  WHERE 
    /* Bag is on the uld */	
    bag.pax_id=pax.pax_id AND
    bag.uld_no=ulds.uld_no AND
    ulds.flight_id=flight.flight_id ;
    
