
prompt Creating sequence CI_REFERENCE_RANGES_SEQ...

create sequence ci_reference_ranges_seq
  increment by 1
  start with 1
  nocycle
  cache 20
  noorder
/

prompt Creating sequence RM_ACTIVITY_LABEL...

create sequence rm_activity_label
  increment by 1
  start with 1
  minvalue 1
  nocycle
  cache 20
  noorder
/

prompt Creating sequence RM_IDGENERATOR...

create sequence rm_idgenerator
  increment by 1
  start with 100000
  minvalue 100000
  nocycle
  cache 20
  noorder
/
rem 
rem $Header: L:\\\\model\\repman40\\api\\RCS\\cdapiseq.sql 1.2 1998/08/04 12:21:48 cvanes Exp $ 
rem 
Rem  Copyright (c) 1995 by Oracle Corporation 
Rem    NAME
Rem      cdapiseq1.sql - Hand written sequences
Rem    DESCRIPTION
Rem      Hand written sequences not generated by congenins
Rem    RETURNS
Rem 
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem    MODIFIED   (MM/DD/YY)
Rem     aheath     02/08/95 -  Creation 
REM
REM Created to differentiate between reports run by different users
REM
PROMPT Creating Sequence CDI_TMP_RPT_SEQ...
CREATE SEQUENCE cdi_tmp_rpt_seq
 INCREMENT BY 1
 START WITH 1
 MINVALUE 1
 NOMAXVALUE
 NOCYCLE 
 CACHE 20
 NOORDER 
/

REM
REM Unique ID for the session table in the element log
REM
PROMPT Creating Sequence CDB_LOG_SESSION...
CREATE SEQUENCE cdb_log_session
 INCREMENT BY 1
 START WITH 1
 NOMINVALUE
 NOMAXVALUE
 NOCYCLE
 CACHE 20
 NOORDER
/

REM
PROMPT Creating Sequence SDD_EL_SEQ...
CREATE SEQUENCE sdd_el_seq
 INCREMENT BY 1
 START WITH 1
 NOMINVALUE
 NOMAXVALUE
 NOCYCLE
 CACHE 20
 NOORDER
/
