/*****************************************************************************
*
* Filename         - $Workfile:   uld_dests_v2.sql  $
*
*                     Name              Date      Version     CR Number
*                     Martin Helliwell  31/10/01    1.0        15526
* 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, 2001
*
*****************************************************************************/
/****************************************************************************
* @(#)$Workfile:   uld_dests_v2.sql  $  $Revision:   1.0  $
*
* 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/live/views/uld_dests_v2.svl  $
* 
*    Rev 1.0   31 Oct 2001 15:50:10   tagtrak
* OR:
* CR: 15526
* REV: 1.0
* DESC: Single row of uld_dests
*
*****************************************************************************/
PROMPT Creating view uld_dests_v2 

CREATE OR REPLACE FORCE
VIEW uld_dests_v2 
(uld_no
,flight_id
,uld_destination
,uld_class_list
) AS
SELECT uld_no
,flight_id
,SUBSTR(uld_destination(uld_no ,flight_id),1,200)
,SUBSTR(uld_class_list(uld_no, flight_id),1,10)
FROM 
(SELECT DISTINCT uld_no, flight_id FROM uld_dests)
/
