/* $Id$ */
/*============================================================================*
 |                 Copyright (c) 2012 Applaud Solutions UK Ltd                |
 |                             All rights reserved                            |
 *===========================================================================*/

SET VERIFY OFF
SET FEEDBACK OFF
WHENEVER OSERROR  EXIT FAILURE ROLLBACK
WHENEVER SQLERROR EXIT FAILURE ROLLBACK

  CREATE OR REPLACE FORCE VIEW xxas_com_data_ame_approvers_v
  AS
  SELECT xcda.transaction_id
  ,      xcda.internal_data_id
  ,      xcda.ame_application_id
  ,      xcda.ame_transaction_type_id   
  ,      xcdaa.approver_role 
  ,      xcdaa.notification_id 
  FROM   xxas_com_data_ame            xcda
  ,      xxas_com_data_ame_approvers  xcdaa 
  WHERE  xcda.transaction_id           = xcdaa.transaction_id(+);

COMMIT;
EXIT;
