set doc off

/*****************************************************************************
*
* Filename         - $Workfile:   $
*
*                     Name              Date      Version     CR Number
* Author           - See revision history below.
* Last Update      - See revision history below.
*
* Project Name     - TAGTRAK(Oracle Database)
*
* Source Code
* Identifier       - 
*
* Design Spec
* Section          - 
*
* Contents         - Live Schema: EQ_LOG table and associated items
*
* Language         - Oracle SQL*Plus script
*
* Classification   - Commercial In Confidence
*
*          (c) Ultra Electronics Limited, 2003
*
*****************************************************************************/
/****************************************************************************
* @(#)$Workfile:   $  $Revision:   $
*
* 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:   $
*
****************************************************************************/

PROMPT Creating view PM_RESULTS_V ;

CREATE OR REPLACE FORCE VIEW PM_RESULTS_V  AS
select
        pmr_id,
        type kit_type,
        serial_number,
        firstname,
        surname,
        pmr_time,
        pmr_timestamp,
        id kit_id,
        tagtrak_users.user_id
from
        pm_results, kit, tagtrak_users
where
        pmr_kit_id = id (+)
  and   pmr_user_id = tagtrak_users.user_id (+)
/

