
/*****************************************************************************
*
* Filename         - $Workfile:   bag_groups_v1.sql  $
*
*                     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 View
*
* Language         - Oracle SQL*Plus script
*
* Classification   - Commercial In Confidence
*
*          (c) Ultra Electronics Limited, 2005
*
*****************************************************************************/

PROMPT Creating view     bag_groups_v1;

CREATE OR REPLACE FORCE VIEW   bag_groups_v1
              (
                     group_no,
                     no_of_bags,
                     user_id,
                     site_id,
                     agent_code,
                     group_name
              ) AS
              SELECT
                     bg.group_no,
                     bg.no_of_bags,
                     bg.user_id,
                     bg.site_id,
                     bg.agent_code,
                     bg.group_name
              FROM
                     bag_group bg
              WHERE
                     bg.holding_pen <> 'Y';


