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

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

CREATE INDEX XXAS_TCM_PENDING_CLOCKS_NK6
       ON XXAS_TCM_PENDING_CLOCKS (ASSIGNMENT_ID, MISSED_OUT_FLAG)
       TABLESPACE APPS_TS_TX_IDX;

COMMIT;
EXIT;
