/*****************************************************************************
*
* Filename         - $Workfile:   codeshare_config_v1.sql  $
*
*                     Name              Date      Version     CR Number 15824
*                      Yomi Kogge       24/03/02  1.0
* 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: codeshare_config_v1 view and associated items
*
* Language         - Oracle SQL*Plus script
*
* Classification   - Commercial In Confidence
*
*          (c) Ultra Electronics Limited, 1997
*
*****************************************************************************/
PROMPT Creating view codeshare_config_v1;
CREATE OR REPLACE FORCE VIEW codeshare_config_v1(
OP_FLIGHTNO,
CS_FLIGHTNO,
START_DATE,
END_DATE,
SCHEDULE,
WEEKDAY,
AGENT_CODE
)
as
select
OP_FLIGHTNO,
CS_FLIGHTNO,
to_char(START_DATE,'DDMON'),
to_char(END_DATE,'DDMON'),
SCHEDULE,
WEEKDAY,
AGENT_CODE
from codeshare_config;
