-- d:\d900\ck.tab
--
-- Generated for Oracle 8 on Wed May 27  13:45:09 1998 by Server Generator 2.1.20.0.0
 


PROMPT Creating Table 'CK_REPORT_PARAMETER_USAGES'
CREATE TABLE CK_REPORT_PARAMETER_USAGES
 (RPU_RPT_ID NUMBER NOT NULL
 ,RPU_PARAM_ID NUMBER NOT NULL
 ,RPU_SEQUENCE NUMBER(4,0)
 ,RPU_MANDATORY VARCHAR2(10)
 ,RPU_LOVENFORCED VARCHAR2(10)
 ,RPU_DEFAULT VARCHAR2(30)
 ,RPU_ELETYPE VARCHAR2(20)
 ,RPU_SDD_COLUMN VARCHAR2(30)
 ,RPU_EL_OCCUR_TYPE VARCHAR2(20)
 ,RPU_PAC_PARAM VARCHAR2(30)
 ,CK_USER_DEFINED VARCHAR2(10)
 ,CK_USER VARCHAR2(30)
 )
/

-- B1657085, B2506117 : M92\stlyon_005 : Add definition
-- B2908578           : M93\stlyon_001 : Add ON COMMIT clause
PROMPT Creating Table 'CK_REPORT_FOLDERS'
CREATE GLOBAL TEMPORARY TABLE CK_REPORT_FOLDERS
( IRID    NUMBER NOT NULL
 ,NAME    VARCHAR2(256)
 ,LEV     NUMBER NOT NULL
 ,IVID    NUMBER
)
ON COMMIT PRESERVE ROWS
/

PROMPT Creating Table 'CDI_VALID_PREFS'
CREATE TABLE CDI_VALID_PREFS
 (VP_DOMAIN VARCHAR2(20) NOT NULL
 ,VP_VALUE VARCHAR2(240) NOT NULL
 ,VP_MEANING VARCHAR2(240)
 ,VP_ABBREVIATION VARCHAR2(240)
 ,NLS_LANG VARCHAR2(3) NOT NULL
 )
/

PROMPT Creating Table 'RM$ASSERTIONS'
CREATE TABLE RM$ASSERTIONS
 (ID NUMBER(38,0) NOT NULL
 ,TYPES NUMBER(38,0) NOT NULL
 ,SCRATCH NUMBER(38,0)
 ,SCRATCH2 NUMBER(38,0)
 ,SOURCE_REF NUMBER(38,0)
 ,DATE_CREATED DATE
 ,DATE_CHANGED DATE
 ,CREATED_BY VARCHAR2(30)
 ,CHANGED_BY VARCHAR2(30)
 ,NAME VARCHAR2(60)
 ,PLURAL_NAME VARCHAR2(60)
 ,SHORT_NAME VARCHAR2(60)
 ,SUPERTYPES NUMBER(38,0)
 ,PRODUCT VARCHAR2(4)
 ,HACK_DEFAULT VARCHAR2(240)
 ,USER_EXTENSION VARCHAR2(1)
 ,DEFINED_AGAINST NUMBER(38,0)
 ,OF_DOMAIN NUMBER(38,0)
 ,CLASSIFICATION VARCHAR2(60)
 ,ENABLED VARCHAR2(1)
 ,EXPRESSION NUMBER(38,0)
 ,MESSAGE_USAGE NUMBER(38,0)
 ,PROPERTY NUMBER(38,0)
 ,DEFERRED VARCHAR2(1)
 ,GENERATED VARCHAR2(1)
 ,WARNING VARCHAR2(1)
 ,FACILITY VARCHAR2(3)
 ,CODE NUMBER(5,0)
 ,NUMBER_OF_TIMES_MODIFIED NUMBER(38,0)
 ,IS_UID_OR_ELM VARCHAR2(1)
 )
/

PROMPT Creating Table 'CDI_DICTIONARY_VERSION'
CREATE TABLE CDI_DICTIONARY_VERSION
 (PV_VERSION VARCHAR2(70) NOT NULL
 )
/

PROMPT Creating Table 'CDI_PRODUCT_FLAVOURS'
CREATE TABLE CDI_PRODUCT_FLAVOURS
 (P_SNAME VARCHAR2(10) NOT NULL
 ,P_CGVERSION VARCHAR2(10) NOT NULL
 ,SEQ NUMBER(2,0) NOT NULL
 ,DESCRIPTION VARCHAR2(240)
 )
/

PROMPT Creating Table 'CK_NLS_REPORT_GROUPS'
CREATE TABLE CK_NLS_REPORT_GROUPS
 (NLS_LANGUAGE VARCHAR2(3) NOT NULL
 ,RPG_ID NUMBER NOT NULL
 ,RPG_NAME VARCHAR2(50)
 ,RPG_TYPE VARCHAR2(30)
 ,CK_USER_DEFINED VARCHAR2(10)
 ,CK_USER VARCHAR2(30)
 )
/

PROMPT Creating Table 'REF_VALUES'
CREATE TABLE REF_VALUES
 (REF_CODE VARCHAR2(35) NOT NULL
 ,REF_DOMAIN VARCHAR2(30) NOT NULL
 ,REF_MEANING VARCHAR2(40) NOT NULL
 ,REF_PARENT_CODE VARCHAR2(16)
 ,REF_SYSTEM_USE VARCHAR2(1)
 )
/

PROMPT Creating Table 'RM$VIOLATIONS'
CREATE GLOBAL TEMPORARY TABLE RM$VIOLATIONS
 (ID NUMBER(38,0) NOT NULL
 ,TYPES NUMBER(38,0) NOT NULL
 ,SCRATCH NUMBER(38,0)
 ,SCRATCH2 NUMBER(38,0)
 ,SOURCE_REF NUMBER(38,0)
 ,DATE_CREATED DATE
 ,DATE_CHANGED DATE
 ,CREATED_BY VARCHAR2(30)
 ,CHANGED_BY VARCHAR2(30)
 ,PROPERTY NUMBER(38,0)
 ,ASSERTION NUMBER(38,0)
 ,ACTIVITY NUMBER(38,0)
 ,ELEMENT NUMBER(38,0)
 ,POK VARCHAR2(240)
 ,P0 VARCHAR2(240)
 ,P1 VARCHAR2(240)
 ,P2 VARCHAR2(240)
 ,P3 VARCHAR2(240)
 ,P4 VARCHAR2(240)
 ,P5 VARCHAR2(240)
 ,P6 VARCHAR2(240)
 ,P7 VARCHAR2(240)
 ,NUMBER_OF_TIMES_MODIFIED NUMBER(38,0)
 )
/

PROMPT Creating Table 'RM$HASHES'
CREATE TABLE RM$HASHES
 (EID NUMBER(38,0) NOT NULL
 ,CID NUMBER(38,0)
 ,HASH_VALUE NUMBER(38,0)
 )
/

PROMPT Creating Table 'CK_TEMP_COPY_EL_IDS'
CREATE TABLE CK_TEMP_COPY_EL_IDS
 (TRANS_REF NUMBER(38) NOT NULL
 ,ID NUMBER(38) NOT NULL
 ,NEW_ID NUMBER(38)
 )
/

PROMPT Creating Table 'CDRK_TMP_TBL'
CREATE TABLE CDRK_TMP_TBL
 (APP_REF NUMBER(38,0)
 ,DB_REF NUMBER(38,0)
 ,USERNAME VARCHAR2(30)
 ,OBJ_OWNER VARCHAR2(30)
 ,OBJ_NAME VARCHAR2(30)
 ,OBJ_TYPE VARCHAR2(30)
 ,REMOTE_USER VARCHAR2(30)
 ,PASSWORD VARCHAR2(30)
 ,CONNECT_STRING VARCHAR2(60)
 ,COUNT NUMBER(38,0)
 )
/

PROMPT Creating Table 'CK_LANGUAGE_PROPERTIES'
CREATE TABLE CK_LANGUAGE_PROPERTIES
 (LANGUAGE VARCHAR2(10) NOT NULL
 ,PROPERTY_NUMBER NUMBER(38) NOT NULL
 ,PROPERTY_DESCRIPTION VARCHAR2(240) NOT NULL
 ,PROPERTY_VALUE VARCHAR2(240)
 )
/

PROMPT Creating Table 'CDRF_TMP_TBL'
CREATE TABLE CDRF_TMP_TBL
 (APP_REF NUMBER(38,0)
 ,DB_REF NUMBER(38,0)
 ,USERNAME VARCHAR2(30)
 ,OBJ_OWNER VARCHAR2(30)
 ,OBJ_NAME VARCHAR2(30)
 ,OBJ_TYPE VARCHAR2(30)
 ,REMOTE_USER VARCHAR2(30)
 ,PASSWORD VARCHAR2(30)
 ,CONNECT_STRING VARCHAR2(60)
 ,COUNT NUMBER(38,0)
 )
/

PROMPT Creating Table 'CK_NLS_REPORTS'
CREATE TABLE CK_NLS_REPORTS
 (NLS_LANGUAGE VARCHAR2(3) NOT NULL
 ,RPT_ID NUMBER NOT NULL
 ,RPT_ORIENTATION VARCHAR2(10)
 ,RPT_NAME VARCHAR2(20)
 ,RPT_TITLE VARCHAR2(70)
 ,RPT_NEEDAPP VARCHAR2(10)
 ,RPT_PURPOSE VARCHAR2(70)
 ,RPT_STATUS VARCHAR2(10)
 ,CK_USER_DEFINED VARCHAR2(10)
 ,CK_USER VARCHAR2(30)
 )
/

PROMPT Creating Table 'CDI_PRODUCTS'
CREATE TABLE CDI_PRODUCTS
 (SNAME VARCHAR2(10) NOT NULL
 ,NAME VARCHAR2(60) NOT NULL
 ,VERSION VARCHAR2(10) NOT NULL
 )
/

PROMPT Creating Table 'CK_REPORT_GROUP_USAGES'
CREATE TABLE CK_REPORT_GROUP_USAGES
 (RGU_RPT_ID NUMBER NOT NULL
 ,RGU_RPG_ID NUMBER NOT NULL
 ,RGU_SEQUENCE NUMBER(4,0)
 ,CK_USER_DEFINED VARCHAR2(10)
 ,CK_USER VARCHAR2(30)
 )
/

PROMPT Creating Table 'CDI_CODE_SECTION_TYPES'
CREATE TABLE CDI_CODE_SECTION_TYPES
 (LANGUAGE_NAME VARCHAR2(30) NOT NULL
 ,TYPE_NAME VARCHAR2(50) NOT NULL
 ,GEN_TEMPLATE_FILE VARCHAR2(132) NOT NULL
 ,REGEN_TEMPLATE_FILE VARCHAR2(132) NOT NULL
 ,OPEN_BEGIN_MARKER VARCHAR2(40) NOT NULL
 ,CLOSE_BEGIN_MARKER VARCHAR2(40)
 ,END_MARKER VARCHAR2(40) NOT NULL
 ,FILE_FILTER VARCHAR2(40) NOT NULL
 ,SEQ NUMBER(3,0) NOT NULL
 ,REGISTRY_NAME VARCHAR2(40) NOT NULL
 ,DEFAULT_FILE_NAME VARCHAR2(40) NOT NULL
 ,CLOSE_END_MARKER VARCHAR2(40) NOT NULL
 ,SECTION_TYPE VARCHAR2(1) NOT NULL
 ,FILE_TYPE VARCHAR2(1) NOT NULL
 ,NLS_LANG VARCHAR2(3) NOT NULL
 )
/

PROMPT Creating Table 'CDI_NAV'
CREATE TABLE CDI_NAV
 (NAV_TYPE VARCHAR2(1)
 ,NAV_FNAME VARCHAR2(8)
 ,NAV_NAME VARCHAR2(10)
 ,NAV_BTNAME VARCHAR2(30)
 ,NAV_CNAME VARCHAR2(30)
 ,NAV_REF_BTNAME VARCHAR2(30)
 ,NAV_REF_CNAME VARCHAR2(30)
 ,NAV_SEQ NUMBER(3,0)
 ,NAV_ASSOC_END VARCHAR2(1)
 ,NAV_DESCRIPTION VARCHAR2(40)
 )
/

REM 'CK_TEMPORARY_SET' patched in CI0408.022
PROMPT Creating Table 'CK_TEMPORARY_SET'
CREATE TABLE CK_TEMPORARY_SET
 (TRANS_REF NUMBER NOT NULL
 ,ID NUMBER
 ,TYPE_OF VARCHAR2(60)
 ,EL_STR VARCHAR2(1) NOT NULL
 ,NEW_ID NUMBER
 ,PASS NUMBER
 ,NEW_PARENT_ID NUMBER
 ,MARKED VARCHAR2(1)
 ,READ_ONLY VARCHAR2(1)
 ,TABLE_IRID number
 ,IVID number
 )
/

PROMPT Creating Table 'CK_REPORT_GROUPS'
CREATE TABLE CK_REPORT_GROUPS
 (RPG_ID NUMBER NOT NULL
 ,RPG_SEQUENCE NUMBER(4,0)
 ,RPG_HELP_ID NUMBER(12,0)
 ,CK_USER VARCHAR2(30)
 ,CK_USER_DEFINED VARCHAR2(10)
 )
/

PROMPT Creating Table 'RM$DEFERRED_QUERIES'
CREATE GLOBAL TEMPORARY TABLE RM$DEFERRED_QUERIES
 (ID NUMBER(38,0) NOT NULL
 ,TYPES NUMBER(38,0) NOT NULL
 ,ELEMENT NUMBER(38,0)
 ,ASSERTION NUMBER(38,0)
 ,ELEMENT_TYPE NUMBER(38,0)
 ,DATE_CREATED DATE
 ,DATE_CHANGED DATE
 ,CREATED_BY VARCHAR2(30)
 ,CHANGED_BY VARCHAR2(30)
 ,NUMBER_OF_TIMES_MODIFIED NUMBER(38,0)
 )
/

PROMPT Creating Table 'CDI_DELTAB'
CREATE TABLE CDI_DELTAB
 (EL_ID NUMBER(38,0)
 ,SESSIONID NUMBER(38,0)
 ,DATESTAMP DATE
 ,PASS NUMBER(38,0)
 )
/

PROMPT Creating Table 'CDI_MODNET'
CREATE TABLE CDI_MODNET
 (ROOT_PARENT_ID NUMBER(38,0)  NOT NULL
 ,ID             NUMBER(38,0)  NOT NULL
 ,MODID          NUMBER(38,0)  NOT NULL
 ,SEQ            NUMBER(38,0)  NOT NULL
 ,DEPTH          NUMBER(38,0)  NOT NULL
 ,PARENT         NUMBER(38,0)  NOT NULL
 ,MARKER         VARCHAR2(1)
 )
/

PROMPT Creating Table 'RM$ACTIVITIES'
CREATE GLOBAL TEMPORARY TABLE RM$ACTIVITIES
 (ID NUMBER(38,0) NOT NULL
 ,TYPES NUMBER(38,0) NOT NULL
 ,OPEN_PARENT NUMBER(38,0)
 ,OPEN_CHILD NUMBER(38,0)
 ,STATUS NUMBER(38,0)
 ,CHILDREN NUMBER(38,0)
 ,DEPTH NUMBER(38,0)
 ,LABEL NUMBER(38,0)
 ,PARENT NUMBER(38,0)
 ,SCRATCH NUMBER(38,0)
 ,SCRATCH2 NUMBER(38,0)
 ,SOURCE_REF NUMBER(38,0)
 ,DATE_CREATED DATE
 ,DATE_CHANGED DATE
 ,CLOSE_END_TIME DATE
 ,CLOSE_START_TIME DATE
 ,OPEN_TIME DATE
 ,CREATED_BY VARCHAR2(30)
 ,CHANGED_BY VARCHAR2(30)
 ,READONLY VARCHAR2(1)
 ,SESSION_LABEL VARCHAR2(240)
 ,NUMBER_OF_TIMES_MODIFIED NUMBER(38,0)
 ,IN_SESSION NUMBER(38,0)
 )
/

PROMPT Creating Table 'XTNV_SDDV_STRUCTURE_ELEMENTS'
CREATE TABLE XTNV_SDDV_STRUCTURE_ELEMENTS
 (TRANS_REF NUMBER(38,0) NOT NULL
 ,STR_PART_OF NUMBER(38,0)
 ,STR_TYPE_OF VARCHAR2(20)
 ,STR_USE_OF NUMBER(38,0)
 ,STR_2ND_USE_OF_NAME VARCHAR2(60)
 ,STR_ANN_GROW_PERC NUMBER(4,0)
 ,STR_ARCH_IND VARCHAR2(1)
 ,STR_AUTHORITY VARCHAR2(10)
 ,STR_AV_VOL NUMBER(10,0)
 ,STR_CHANGED_BY VARCHAR2(30)
 ,STR_COMMENT VARCHAR2(240)
 ,STR_CREATED_BY VARCHAR2(30)
 ,STR_DATE_CHANGED DATE
 ,STR_DATE_CREATED DATE
 ,STR_DATE1 DATE
 ,STR_DEL_IND VARCHAR2(1)
 ,STR_FK_TYPE_IND VARCHAR2(1)
 ,STR_GROW_PERIOD VARCHAR2(10)
 ,STR_GROW_RATE NUMBER(4,2)
 ,STR_INIT_VOL NUMBER(10,0)
 ,STR_INS_IND VARCHAR2(1)
 ,STR_MAX_VOL NUMBER(10,0)
 ,STR_METHOD_OF_USE VARCHAR2(20)
 ,STR_OTHER_STAT NUMBER(6,0)
 ,STR_OTHER_STAT_NAME VARCHAR2(100)
 ,STR_OTHER_STAT_UOM VARCHAR2(6)
 ,STR_PART_OF_NAME VARCHAR2(60)
 ,STR_RESP_REQD VARCHAR2(12)
 ,STR_SEL_IND VARCHAR2(1)
 ,STR_SEQ NUMBER(6,0)
 ,STR_SHORT_NAME VARCHAR2(30)
 ,STR_UPD_IND VARCHAR2(1)
 ,STR_USER_USG1 VARCHAR2(1)
 ,STR_USER_USG2 VARCHAR2(1)
 ,STR_USE_OF_NAME VARCHAR2(60)
 ,STR_USE_OF_PARENT_NAME VARCHAR2(60)
 ,STR_USE_OF_PARENT_REF NUMBER(38,0)
 ,STR_USRX0 VARCHAR2(240)
 ,STR_USRX1 VARCHAR2(240)
 ,STR_USRX2 VARCHAR2(240)
 ,STR_USRX3 VARCHAR2(240)
 ,STR_USRX4 VARCHAR2(240)
 ,STR_USRX5 VARCHAR2(240)
 ,STR_USRX6 VARCHAR2(240)
 ,STR_USRX7 VARCHAR2(240)
 ,STR_USRX8 VARCHAR2(240)
 ,STR_USRX9 VARCHAR2(240)
 ,STR_USRX10 VARCHAR2(240)
 ,STR_USRX11 VARCHAR2(240)
 ,STR_USRX12 VARCHAR2(240)
 ,STR_USRX13 VARCHAR2(240)
 ,STR_USRX14 VARCHAR2(240)
 ,STR_USRX15 VARCHAR2(240)
 ,STR_USRX16 VARCHAR2(240)
 ,STR_USRX17 VARCHAR2(240)
 ,STR_USRX18 VARCHAR2(240)
 ,STR_USRX19 VARCHAR2(240)
 ,STR_VERSION NUMBER(38,0)
 ,STR_VERSION_DATE DATE
 ,STR_VOL_UOM VARCHAR2(20)
 ,STR_ID NUMBER(38,0)
 ,STR_TY NUMBER(38,0)
 ,STR_NOTM NUMBER(38,0)
 ,STR_FK1 NUMBER(38,0)
 ,STR_ELEM_OWNED_BY NUMBER(38)
 )
/

PROMPT Creating Table 'CI_ELEMENT_TYPES'
CREATE TABLE CI_ELEMENT_TYPES
 (NAME VARCHAR2(27)
 ,SHORT_NAME VARCHAR2(10) NOT NULL
 ,EL_TYPE_OF VARCHAR2(10)
 ,PRODUCT VARCHAR2(2) NOT NULL
 ,RELEASE VARCHAR2(1)
 ,PACK_GEN VARCHAR2(1)
 ,VIEW_GEN VARCHAR2(1)
 ,SUPERTYPE VARCHAR2(6)
 ,PARENT VARCHAR2(27)
 ,ADDED_TYPE VARCHAR2(20)
 ,EXTENSIBLE VARCHAR2(1)
 )
/

PROMPT Creating Table 'CG_DES_FORM_HELP'
CREATE TABLE CG_DES_FORM_HELP
 (HLP_APPLN VARCHAR2(30) NOT NULL
 ,HLP_INDEX VARCHAR2(100) NOT NULL
 ,HLP_MODTAB_NAME VARCHAR2(30)
 ,HLP_GENERATED VARCHAR2(1)
 ,HLP_SEQ NUMBER(5,0) NOT NULL
 ,HLP_TEXT VARCHAR2(70)
 ,HLP_TYPE VARCHAR2(1) NOT NULL
 )
/

PROMPT Creating Table 'CK_REPORTS'
CREATE TABLE CK_REPORTS
 (RPT_ID NUMBER NOT NULL
 ,RPT_HELP_ID NUMBER(12,0)
 ,CK_USER VARCHAR2(30)
 ,CK_USER_DEFINED VARCHAR2(30)
 )
/

PROMPT Creating Table 'CDI_PREF_DOMAINS'
CREATE TABLE CDI_PREF_DOMAINS
 (PD_DOMAIN VARCHAR2(20) NOT NULL
 ,PD_DESC VARCHAR2(240) NOT NULL
 )
/

PROMPT Creating Table 'CK_CKDBSZ_TBI_TMP'
CREATE TABLE CK_CKDBSZ_TBI_TMP
 (REP_SEQ NUMBER(38,0)
 ,TAB_NAME VARCHAR2(100)
  ,APP_ID NUMBER(38,0)
 ,TBI_ID NUMBER(38,0)
 ,TAB_ID NUMBER(38,0)
 ,OTB_ID NUMBER(38,0)
 ,DBU_ID NUMBER(38,0)
 ,ODB_ID NUMBER(38,0)
 ,TBI_INIT_TRANS NUMBER(38,0)
 ,TBI_PCT_FREE NUMBER(38,0)
 ,TAB_START_ROWS NUMBER(38,0)
 ,TBI_MAX_TRANS NUMBER(38,0)
 ,TAB_END_ROWS NUMBER(38,0)
 ,TBI_PCT_USED NUMBER(38,0)
 ,TBI_CR_STATUS VARCHAR2(1)
 )
/

PROMPT Creating Table 'CDI_TEMP_ATOMIC_ELEMENTS'
CREATE TABLE CDI_TEMP_ATOMIC_ELEMENTS
 (TMP_SEQ NUMBER(6,0) NOT NULL
 ,TMP_FOLDER_ID NUMBER(38,0) NOT NULL
 ,TMP_ID NUMBER(38,0) NOT NULL
 ,TMP_CONTEXT_TYPE VARCHAR2(1)
 ,TMP_START_END_FLAG VARCHAR2(1)
 ,TMP_DIRECTION_FLAG VARCHAR2(1)
 ,TMP_FLOW_TYPE_FLAG VARCHAR2(1)
 ,TMP_PROCESSED_FLAG VARCHAR2(1)
 )
/

PROMPT Creating Table 'CDI_TEMP_ASSOC_ELEMENTS'
CREATE TABLE CDI_TEMP_ASSOC_ELEMENTS
 (SEQ NUMBER(6,0) NOT NULL
 ,THIS_ELEM_TYPE_ID NUMBER(38,0) NOT NULL
 ,INTERSECT_TYPE_ID NUMBER(38,0) NOT NULL
 ,OTHER_ELEM_TYPE_ID NUMBER(38,0) NOT NULL
 ,THIS_VIEW       VARCHAR2(64)
 ,INTERSECT_VIEW  VARCHAR2(64)
 ,OTHER_VIEW      VARCHAR2(64)
 ,THIS_COL        VARCHAR2(64)
 ,OTHER_COL       VARCHAR2(64)
 )
/

-- REM 871929 NEED TO IDENTIFY 'BASELINE' CONTENTS OF SYSTEM FOLDER
-- REM 733492 NEED NEW COLUMN LAN_OBM_FLAG ON CDI_LANGUAGE_DEFINITIONS
PROMPT Creating Table 'CDI_LANGUAGE_DEFINITIONS'
CREATE TABLE CDI_LANGUAGE_DEFINITIONS
 (LAN_IRID NUMBER(38) NOT NULL
 ,LAN_IVID NUMBER(38) NOT NULL
 ,LAN_NAME VARCHAR2(100) NOT NULL
 ,LAN_SOURCE_DIRECTORY VARCHAR2(240)
 ,LAN_RUNTIME_DIRECTORY VARCHAR2(240)
 ,LAN_PROGRAMATICAL VARCHAR2(1)
 ,LAN_TYPE VARCHAR2(40)
 ,LAN_COMMAND_LINE VARCHAR2(100)
 ,LAN_GENERATABLE_FLAG VARCHAR2(1)
 ,LAN_INTERNAL_NAME VARCHAR2(10)
 ,LAN_OBM_FLAG VARCHAR2(1)
 )
/

PROMPT Creating Table 'CK_CKDBSZ_DBU_TMP'
CREATE TABLE CK_CKDBSZ_DBU_TMP
 (REP_SEQ NUMBER(38,0)
 ,DBU_NAME VARCHAR2(100)
 ,APP_ID NUMBER(38,0)
 ,DBU_ID NUMBER(38,0)
 ,ODB_ID NUMBER(38,0)
 ,DBU_CR_STATUS VARCHAR2(1)
 )
/

PROMPT Creating Table 'CDI_CLASS_SET_CODE_TYPES'
CREATE TABLE CDI_CLASS_SET_CODE_TYPES
 (LANGUAGE_NAME VARCHAR2(30) NOT NULL
 ,TYPE_NAME VARCHAR2(50) NOT NULL
 ,GENERATE_FLAG VARCHAR2(1) NOT NULL
 ,TEMPLATE_FILE VARCHAR2(132) NOT NULL
 ,FILE_FILTER VARCHAR2(40)
 ,SEQ NUMBER(3,0) NOT NULL
 ,DEFAULT_FILE_NAME VARCHAR2(40) NOT NULL
 ,OPEN_BEGIN_MARKER VARCHAR2(40) NOT NULL
 ,CLOSE_BEGIN_MARKER VARCHAR2(40) NOT NULL
 ,OPEN_END_MARKER VARCHAR2(40) NOT NULL
 ,CLOSE_END_MARKER VARCHAR2(40) NOT NULL
 ,FILE_TYPE VARCHAR2(1) NOT NULL
 ,NLS_LANG VARCHAR2(3) NOT NULL
 )
/

PROMPT Creating Table 'CK_INSTALLED_OBJECTS'
CREATE TABLE CK_INSTALLED_OBJECTS
 (CI_STAGE VARCHAR2(20) NOT NULL
 ,CI_TYPE VARCHAR2(13) NOT NULL
 ,CI_NAME VARCHAR2(128) NOT NULL
 ,CI_CREATED VARCHAR2(1) NOT NULL
 ,CI_NO_OF_ROWS NUMBER
 ,CI_DIR VARCHAR2(10)
 ,CI_FILENAME VARCHAR2(12)
 ,CI_COMMENT VARCHAR2(100)
 ,CI_PIN_FLAG VARCHAR2(1)
 ,CI_OWNER VARCHAR2(30)
 )
/

PROMPT Creating Table 'CDI_FUNNET'
CREATE TABLE CDI_FUNNET
 (
  SESSION_ID NUMBER(38,0) NOT NULL
 ,FOLDER_ID NUMBER(38,0)  
 ,FUNID NUMBER(38,0) NOT NULL
 ,SEQ NUMBER(38,0) NOT NULL
 ,DEPTH NUMBER(38,0) NOT NULL
 )
/

PROMPT Creating Table 'XTNV_SDDV_ELEMENTS'
CREATE TABLE XTNV_SDDV_ELEMENTS
 (TRANS_REF NUMBER(38,0) NOT NULL
 ,EL_ID NUMBER(38,0) NOT NULL
 ,EL_TYPE_OF VARCHAR2(17)
 ,EL_WITHIN_ID NUMBER(38,0)
 ,EL_WITHIN_NAME VARCHAR2(100)
 ,EL_2ND_WITHIN_ID NUMBER(38,0)
 ,EL_2ND_WITHIN_NAME VARCHAR2(100)
 ,EL_3RD_WITHIN_ID NUMBER(38,0)
 ,EL_4TH_WITHIN_ID NUMBER(38,0)
 ,EL_5TH_WITHIN_ID NUMBER(38,0)
 ,EL_6TH_WITHIN_ID NUMBER(38,0)
 ,EL_7TH_WITHIN_ID NUMBER(38,0)
 ,EL_8TH_WITHIN_ID NUMBER(38)
 ,EL_9TH_WITHIN_ID NUMBER
 ,EL_ACT_CODE VARCHAR2(10)
 ,EL_ANN_GROW_PERC NUMBER(4,0)
 ,EL_AS_CONSTRAINTS VARCHAR2(240)
 ,EL_AS_DESC_1 VARCHAR2(60)
 ,EL_AS_DESC_2 VARCHAR2(60)
 ,EL_AS_OBJ_1 VARCHAR2(60)
 ,EL_AS_OBJ_2 VARCHAR2(60)
 ,EL_AS_PRIORITIES VARCHAR2(240)
 ,EL_AUTHORITY VARCHAR2(30)
 ,EL_AVE_PERC_USED NUMBER(3,0)
 ,EL_AV_FREQ NUMBER(6,0)
 ,EL_AV_LEN NUMBER(23,3)
 ,EL_AV_LEN2 NUMBER(23,3)
 ,EL_AV_VOL NUMBER(23,3)
 ,EL_BTITLE VARCHAR2(240)
 ,EL_CALL_METH VARCHAR2(10)
 ,EL_CHAR1 VARCHAR2(40)
 ,EL_CHAR2 VARCHAR2(40)
 ,EL_CHECKED_TO VARCHAR2(20)
 ,EL_CLASSN VARCHAR2(20)
 ,EL_COL_LEV VARCHAR2(2)
 ,EL_COL_OCC VARCHAR2(30)
 ,EL_COL_PREF VARCHAR2(4)
 ,EL_COL_REDEF VARCHAR2(30)
 ,EL_COL_SIGN VARCHAR2(1)
 ,EL_COL_STOR_FORMAT VARCHAR2(16)
 ,EL_COL_VL_COL VARCHAR2(6)
 ,EL_COL_VL_ID NUMBER(38,0)
 ,EL_COMMENT VARCHAR2(2000)
 ,EL_COMPLEX VARCHAR2(10)
 ,EL_COMPRESS VARCHAR2(20)
 ,EL_COMP_IND VARCHAR2(2)
 ,EL_CONDITION VARCHAR2(240)
 ,EL_DATE DATE
 ,EL_DATE_CHANGED DATE
 ,EL_DATE_CREATED DATE
 ,EL_DEF_REP_HDG VARCHAR2(240)
 ,EL_DEF_SCR_HELP VARCHAR2(240)
 ,EL_DEF_SCR_PROMPT VARCHAR2(240)
 ,EL_DEF_VAL VARCHAR2(100)
 ,EL_DEGREE VARCHAR2(20)
 ,EL_DERIV VARCHAR2(240)
 ,EL_DESC VARCHAR2(240)
 ,EL_DEST_TYPE VARCHAR2(15)
 ,EL_ELEM_OWNED_BY NUMBER(38,0)
 ,EL_ENT_ST_CNT NUMBER(4,0)
 ,EL_ENV_NAME VARCHAR2(30)
 ,EL_EST NUMBER(8,2)
 ,EL_EST_UNITS VARCHAR2(26)
 ,EL_FIL_ACC_METH VARCHAR2(24)
 ,EL_FIL_BLK_SIZE NUMBER(23,3)
 ,EL_FIL_CLUST_SIZE NUMBER(23,3)
 ,EL_FIL_FILE_SIZE NUMBER(23,3)
 ,EL_FIL_ORG VARCHAR2(16)
 ,EL_FIL_STOR_MED VARCHAR2(16)
 ,EL_FIL_TYPE VARCHAR2(16)
 ,EL_FIL_UNIT VARCHAR2(9)
 ,EL_FK_TAB_REF NUMBER(38,0)
 ,EL_FLAG1 VARCHAR2(1)
 ,EL_FLAG2 VARCHAR2(1)
 ,EL_FLAG3 VARCHAR2(1)
 ,EL_FLAG4 VARCHAR2(1)
 ,EL_FLAG5 VARCHAR2(1)
 ,EL_FLAG6 VARCHAR2(1)
 ,EL_FLAG7 VARCHAR2(1)
 ,EL_FLAG8 VARCHAR2(1)
 ,EL_FLAG9 VARCHAR2(2)
 ,EL_FORMAT VARCHAR2(70)
 ,EL_FORMAT2 VARCHAR2(20)
 ,EL_FREQ_UNITS VARCHAR2(10)
 ,EL_GROW_RATE NUMBER(4,0)
 ,EL_GR_FREQ VARCHAR2(8)
 ,EL_GR_UNITS VARCHAR2(6)
 ,EL_HIGH_RANGE VARCHAR2(40)
 ,EL_INIT_FREQ NUMBER(23,3)
 ,EL_INIT_PERC_USED NUMBER(3,0)
 ,EL_INIT_VAL VARCHAR2(120)
 ,EL_INIT_VOL NUMBER(23,3)
 ,EL_KEY_SEQ VARCHAR2(2)
 ,EL_LANG VARCHAR2(20)
 ,EL_LONG_NAME VARCHAR2(240)
 ,EL_LOCKED_FLAG VARCHAR2(1)
 ,EL_LOW_RANGE VARCHAR2(40)
 ,EL_LV_IND VARCHAR2(1)
 ,EL_MAX_FREQ NUMBER(23,3)
 ,EL_MAX_LEN NUMBER(23,3)
 ,EL_MAX_LEN2 NUMBER(23,3)
 ,EL_MAX_PERC_USED NUMBER(3,0)
 ,EL_MAX_VOL NUMBER(23,3)
 ,EL_NAME VARCHAR2(100)
 ,EL_NAME_FOR NUMBER(38,0)
 ,EL_NJ_ID NUMBER(38,0)
 ,EL_NOTES VARCHAR2(2000)
 ,EL_NULL_VALUE VARCHAR2(40)
 ,EL_NUMB1 NUMBER(38,0)
 ,EL_OCCUR_TYPE VARCHAR2(10)
 ,EL_OPT VARCHAR2(10)
 ,EL_OP_TYPE VARCHAR2(6)
 ,EL_ORDER VARCHAR2(12)
 ,EL_PFREE NUMBER(3,0)
 ,EL_PLURAL VARCHAR2(100)
 ,EL_PREV_ID NUMBER(38,0)
 ,EL_PROJ_CODE VARCHAR2(12)
 ,EL_PURP VARCHAR2(70)
 ,EL_REC_FORM VARCHAR2(16)
 ,EL_REC_SIZE NUMBER(23,3)
 ,EL_RESP VARCHAR2(10)
 ,EL_REL_END_NO VARCHAR2(1)
 ,EL_RESP_REQD VARCHAR2(12)
 ,EL_SCALE VARCHAR2(4)
 ,EL_SCALE2 NUMBER(4,0)
 ,EL_SD_DP_INC NUMBER(38,0)
 ,EL_SCRATCH_REF NUMBER(38,0)
 ,EL_SD_DP_INIT NUMBER(38,0)
 ,EL_SD_DP_MAX NUMBER(38,0)
 ,EL_SD_IP_INC NUMBER(38,0)
 ,EL_SD_IP_INIT NUMBER(38,0)
 ,EL_SD_IP_MAX NUMBER(38,0)
 ,EL_SEQ NUMBER(6,0)
 ,EL_SEQ2 NUMBER(6,0)
 ,EL_SEQ3 NUMBER(6,0)
 ,EL_SEQ4 NUMBER(6,0)
 ,EL_SHORT_NAME VARCHAR2(20)
 ,EL_SIZE NUMBER(6,0)
 ,EL_SRCAREF NUMBER(38,0)
 ,EL_SRCEREF NUMBER(38,0)
 ,EL_SRCE_TYPE VARCHAR2(15)
 ,EL_SRCREAREF NUMBER(38,0)
 ,EL_SRCREREF NUMBER(38,0)
 ,EL_SRCRREF NUMBER(38,0)
 ,EL_SRCRURREF NUMBER(38,0)
 ,EL_STATUS VARCHAR2(1)
 ,EL_SWITCHES VARCHAR2(20)
 ,EL_SYSSORT VARCHAR2(1)
 ,EL_SYS_DESC VARCHAR2(70)
 ,EL_TASK_CODE VARCHAR2(10)
 ,EL_TIME VARCHAR2(10)
 ,EL_TTITLE VARCHAR2(70)
 ,EL_UNIQUE VARCHAR2(20)
 ,EL_UOM VARCHAR2(10)
 ,EL_USER_CHANGED_BY VARCHAR2(30)
 ,EL_USER_CREATED_BY VARCHAR2(30)
 ,EL_USER_OWNED_BY VARCHAR2(30)
 ,EL_VAL_MEANING VARCHAR2(60)
 ,EL_VERSION NUMBER(3,0)
 ,EL_VERSION_DATE DATE
 ,EL_VOL_INCR NUMBER(23,3)
 ,EL_VOL_UNITS VARCHAR2(6)
 ,EL_TY NUMBER(38,0)
 ,EL_NOTM NUMBER(38,0)
 ,EL_DATE2 DATE
 ,EL_USRX0 VARCHAR2(240)
 ,EL_USRX1 VARCHAR2(240)
 ,EL_USRX2 VARCHAR2(240)
 ,EL_USRX3 VARCHAR2(240)
 ,EL_USRX4 VARCHAR2(240)
 ,EL_USRX5 VARCHAR2(240)
 ,EL_USRX6 VARCHAR2(240)
 ,EL_USRX7 VARCHAR2(240)
 ,EL_USRX8 VARCHAR2(240)
 ,EL_USRX9 VARCHAR2(240)
 ,EL_USRX10 VARCHAR2(240)
 ,EL_USRX11 VARCHAR2(240)
 ,EL_USRX12 VARCHAR2(240)
 ,EL_USRX13 VARCHAR2(240)
 ,EL_USRX14 VARCHAR2(240)
 ,EL_USRX15 VARCHAR2(240)
 ,EL_USRX16 VARCHAR2(240)
 ,EL_USRX17 VARCHAR2(240)
 ,EL_USRX18 VARCHAR2(240)
 ,EL_USRX19 VARCHAR2(240)
 )
/

PROMPT Creating Table 'SDD_RESERVED_NAMES'
CREATE TABLE SDD_RESERVED_NAMES
 (RN_RES_NAME VARCHAR2(40) NOT NULL
 ,RN_TYPE VARCHAR2(10) NOT NULL
 ,RN_COMMENT VARCHAR2(70)
 ,RN_GLOBAL VARCHAR2(1)
 ,RN_TEMPORARY VARCHAR2(1)
 ,RN_ENABLED VARCHAR2(1)
 ,RN_USR_ACCESS VARCHAR2(1)
 ,RN_CDAPI VARCHAR2(1)
, rn_object_irid  number
, rn_object_ivid  number
 )
/

PROMPT Creating Table 'CK_REPORT_PARAMETERS'
CREATE TABLE CK_REPORT_PARAMETERS
 (PARAM_ID NUMBER NOT NULL
 ,PARAM_NAME VARCHAR2(30)
 ,PARAM_LOV_ID NUMBER(4,0)
 ,PARAM_DATATYPE VARCHAR2(10)
 ,CK_USER VARCHAR2(30)
 ,CK_USER_DEFINED VARCHAR2(30)
 )
/

PROMPT Creating Table 'CDI_TEMP_RPT_TABLES'
CREATE TABLE CDI_TEMP_RPT_TABLES
 (TMP_SEQ NUMBER(38,0) NOT NULL
 ,TMP_USERNAME VARCHAR2(30)
 ,TMP_MODSHORTNAME VARCHAR2(20)
 ,TMP_PARAMNAME VARCHAR2(30) NOT NULL
 ,TMP_TIMESTAMP DATE
 ,TMP_PARAMVALUE VARCHAR2(50)
 )
/

PROMPT Creating Table 'RM$DEFERRED_CHECKS'
CREATE GLOBAL TEMPORARY TABLE RM$DEFERRED_CHECKS
 (ID NUMBER(38,0) NOT NULL
 ,TYPES NUMBER(38,0) NOT NULL
 ,ASSERTION NUMBER(38,0)
 ,ELEMENT NUMBER(38,0)
 ,ACTIVITY NUMBER(38,0)
 ,SCRATCH NUMBER(38,0)
 ,SCRATCH2 NUMBER(38,0)
 ,SOURCE_REF NUMBER(38,0)
 ,DATE_CREATED DATE
 ,DATE_CHANGED DATE
 ,CREATED_BY VARCHAR2(30)
 ,CHANGED_BY VARCHAR2(30)
 ,NUMBER_OF_TIMES_MODIFIED NUMBER(38,0)
 ,SYNTAX VARCHAR2(240)
 )
/

PROMPT Creating Table 'CDI_GEN_TARGET_PROPERTIES'
CREATE TABLE CDI_GEN_TARGET_PROPERTIES
 (TARGET_NAME VARCHAR2(100) NOT NULL
 ,TYPE VARCHAR2(3) NOT NULL
 ,NAME VARCHAR2(32) NOT NULL
 ,VALUE VARCHAR2(100)
 )
/

REM 'CDI_DFLT_USER_PREF_USAGES' amended for US BUG 805774
REM DUP_TYPE column amended from VARCHAR2(20) to VARCHAR2(30) for bug 1642706
PROMPT Creating Table 'CDI_DFLT_USER_PREF_USAGES'
CREATE TABLE CDI_DFLT_USER_PREF_USAGES
 (P_SNAME VARCHAR2(10) NOT NULL
 ,P_CGVERSION VARCHAR2(10) NOT NULL
 ,PF_SEQ NUMBER(2,0) NOT NULL
 ,DUP_SNAME VARCHAR2(10) NOT NULL
 ,VALUE VARCHAR2(240)
 ,DUP_INTERNAL VARCHAR2(1) NOT NULL
 ,DUP_TYPE VARCHAR2(30)
 ,DESCRIPTION_MSGID NUMBER(12,0)
 ,MANDATORY VARCHAR2(1)
 ,CHR_DOMAIN VARCHAR2(20)
 ,CHR_MAXLEN NUMBER(3,0)
 ,NUM_HIVAL NUMBER(38,0)
 ,NUM_LOVAL NUMBER(38,0)
 ,DOM VARCHAR2(1)
 ,TAB VARCHAR2(1)
 ,CON VARCHAR2(1)
 ,COL VARCHAR2(1)
 ,MOD VARCHAR2(1)
 ,DTU VARCHAR2(1)
 ,CONU VARCHAR2(1)
 ,IGRP VARCHAR2(1)
 ,DCU VARCHAR2(1)
 ,ABT VARCHAR2(1)
 ,VAT VARCHAR2(1)
 ,OBT VARCHAR2(1)
 ,TME VARCHAR2(1)
 ,ARL VARCHAR2(1)
 ,TAT VARCHAR2(1)
 ,TOP VARCHAR2(1)
 ,OPP VARCHAR2(1)
 ,VVA VARCHAR2(1)
 ,ABTABT VARCHAR2(1)
 ,TCO VARCHAR2(1)
 ,GES VARCHAR2(1)
 ,PCK VARCHAR2(1)
 ,LOV VARCHAR2(1)
 ,SUB VARCHAR2(1)
 ,ACI VARCHAR2(1)
 ,NLS_LANG VARCHAR2(3) NOT NULL
 ,DESCRIPTION VARCHAR2(240)
 )
/

REM Modified for Package installs M16 
REM 1226259 - Added public_synonym_flag
REM Definition overridden from Patch CI0402.029
PROMPT Creating Table 'RM$REPOSITORIES'
CREATE TABLE RM$REPOSITORIES
 (ID NUMBER(38,0) NOT NULL
 ,TYPES NUMBER(38,0) NOT NULL
 ,NUMBER_OF_TIMES_MODIFIED NUMBER(38,0)
 ,DATE_CREATED DATE
 ,DATE_CHANGED DATE
 ,CREATED_BY VARCHAR2(30)
 ,CHANGED_BY VARCHAR2(30)
 ,OWNER_NAME VARCHAR2(30)
 ,SCHEMA_VERSION VARCHAR2(240)
 ,CODE_VERSION VARCHAR2(240)
 ,ID_OFFSET NUMBER(38,0)
 ,NLS_LANGUAGE VARCHAR2(3)
 ,REPOSITORY_VERSION VARCHAR2(70) NOT NULL
 ,SUPPORTS_CORE VARCHAR2(1) NOT NULL
 ,SUPPORTS_DESIGNER VARCHAR2(1) NOT NULL
 ,SUPPORTS_JDEVEE VARCHAR2(1) NOT NULL
 ,SUPPORTS_JDEV_TM VARCHAR2(1) NOT NULL
 ,SUPPORTS_JDEV_DD VARCHAR2(1) NOT NULL
 ,SUPPORTS_VERSION VARCHAR2(1) NOT NULL  
 ,PUBLIC_SYNONYM_FLAG VARCHAR2(1)
 )
/

PROMPT Creating Table 'CK_NLS_PARAMETERS'
CREATE TABLE CK_NLS_PARAMETERS
 (NLS_LANGUAGE VARCHAR2(3) NOT NULL
 ,PARAM_ID NUMBER NOT NULL
 ,PARAM_PROMPT VARCHAR2(35)
 ,PARAM_HINT VARCHAR2(80)
 ,PARAM_DOMAIN VARCHAR2(240)
 ,PARAM_CASE VARCHAR2(10)
 ,PARAM_WILD VARCHAR2(10)
 ,CK_USER_DEFINED VARCHAR2(10)
 ,CK_USER VARCHAR2(30)
 )
/

PROMPT Creating Table 'CDI_FORMS'
CREATE TABLE CDI_FORMS
 (FRM_FNAME VARCHAR2(8)
 ,FRM_SEQ NUMBER(3,0)
 ,FRM_DISP_NAME VARCHAR2(30)
 ,FRM_DESC VARCHAR2(80)
 )
/

PROMPT Creating Table 'CK_CKDBSZ_ODB_TMP'
CREATE TABLE CK_CKDBSZ_ODB_TMP
 (REP_SEQ NUMBER(38,0)
 ,ODB_ID NUMBER(38,0)
 ,ODB_NAME VARCHAR2(100)
 ,ODB_BLOCK_SIZE NUMBER(38,0)
 ,ODB_CR_STATUS VARCHAR2(1)
 ,APP_ID NUMBER(38,0)
 )
/

PROMPT Creating Table 'CK_UTILITY_NAVIGATION'
CREATE TABLE CK_UTILITY_NAVIGATION
 (FROM_TYPE_OF VARCHAR2(20) NOT NULL
 ,OPTIONAL VARCHAR2(1) NOT NULL
 ,DEGREE VARCHAR2(1) NOT NULL
 ,TO_TYPE_OF VARCHAR2(20) NOT NULL
 ,SOURCE_COLUMN VARCHAR2(30) NOT NULL
 ,UTILITY VARCHAR2(10) NOT NULL
 ,ACTION VARCHAR2(10) NOT NULL
 )
/

PROMPT Creating Table 'RM$PATCHES'
CREATE TABLE RM$PATCHES
 (PATCH_NAME VARCHAR2(30) NOT NULL
 ,INSTALLED_BY VARCHAR2(30) NOT NULL
 ,INSTALLED_ON DATE NOT NULL
 ,INSTALLED_OK VARCHAR2(30)
 ,INSTALL_FINISHED DATE
 )
/

PROMPT Creating Table 'RM$INFO'
CREATE TABLE RM$INFO
 (NAME VARCHAR2(128) NOT NULL
 ,VALUE VARCHAR2(128)
 )
/

PROMPT Creating Table 'RM$SESSIONS'
CREATE TABLE RM$SESSIONS
 (ID NUMBER(38,0) NOT NULL
 ,TYPES NUMBER(38,0) NOT NULL
 ,CHANGED_BY VARCHAR2(30)
 ,CREATED_BY VARCHAR2(30)
 ,DATE_CHANGED DATE
 ,DATE_CREATED DATE
 ,NUMBER_OF_TIMES_MODIFIED NUMBER(38,0)
 ,SID NUMBER
 ,AUDSID NUMBER
 ,USERNAME VARCHAR2(30)
 ,APPLICATION_SYSTEM NUMBER(38,0)
 ,ACR_SEL VARCHAR2(1)
 ,ACR_INS VARCHAR2(1)
 ,ACR_UPD VARCHAR2(1)
 ,ACR_DEL VARCHAR2(1)
 ,ACR_SHR VARCHAR2(1)
 ,ACR_OWN VARCHAR2(1)
 ,ACR NUMBER
 )
/

PROMPT Creating Table 'CK_TEMP_EL_IDS'
CREATE TABLE CK_TEMP_EL_IDS 
 (TRANS_REF NUMBER(38,0) NOT NULL 
 ,TYPE_OF VARCHAR2(120) 
 ,EL_ID NUMBER(38,0) 
 ,PASS NUMBER(15,0) 
 ,NEW_ID NUMBER(38,0) 
 ,NEW_ID2 NUMBER(38,0) 
 ,NEW_ID3 NUMBER(38,0) 
 ,COPIED VARCHAR2(1) 
 ,OWNED_BY NUMBER(38,0) 
 )
/


PROMPT Creating Table 'CK_CKDBSZ_OTB_TMP'
CREATE TABLE CK_CKDBSZ_OTB_TMP
 (REP_SEQ NUMBER(38,0)
 ,OTB_NAME VARCHAR2(100)
 ,APP_ID NUMBER(38,0)
 ,OTB_ID NUMBER(38,0)
 ,ODB_ID NUMBER(38,0)
 ,OTB_CR_STATUS VARCHAR2(1)
 )
/

PROMPT Creating Table 'CDI_GENERATION_TARGETS'
CREATE TABLE CDI_GENERATION_TARGETS
 (NAME VARCHAR2(100) NOT NULL
 ,SEQ NUMBER(3,0) NOT NULL
 ,LANGUAGE VARCHAR2(100) NOT NULL
 ,REGISTRY_NAME VARCHAR2(40) NOT NULL
 ,MEMBER_BEGIN_MARKER VARCHAR2(40) NOT NULL
 ,CLOSE_MEMBER_MARKER VARCHAR2(40) NOT NULL
 ,MEMBER_END_MARKER VARCHAR2(40) NOT NULL
 ,NLS_LANG VARCHAR2(3) NOT NULL
 )
/

PROMPT Creating Table 'RM$HASH_ELMS'
CREATE TABLE RM$HASH_ELMS
 (EID NUMBER NOT NULL
 ,TID NUMBER
 ,CID NUMBER
 ,OPN VARCHAR2(240)
 ,HASHVAL NUMBER
 )
/

PROMPT Creating Table 'CDDL_TMP_TBL'
CREATE TABLE CDDL_TMP_TBL
 (TMP_ID NUMBER(38,0) NOT NULL
 ,TMP_APPREF NUMBER(38,0) NOT NULL
 ,TMP_DBREF NUMBER(38,0) NOT NULL
 ,TMP_TYPE NUMBER(38,0) NOT NULL
 ,TMP_USERNAME VARCHAR2(30) NOT NULL
 )
/

PROMPT Creating Table 'CDI_TYPE_MATCH'
CREATE TABLE CDI_TYPE_MATCH
 (TYPE_SHORT_NAME VARCHAR2(40) NOT NULL
 ,EL_TYPE_OF VARCHAR2(10) NOT NULL
 ,EL_OCCUR_TYPE VARCHAR2(12)
 )
/

PROMPT Creating Table 'CDI_DFLT_USER_PREFS'
CREATE TABLE CDI_DFLT_USER_PREFS
 (P_SNAME VARCHAR2(10) NOT NULL
 ,P_CGVERSION VARCHAR2(10) NOT NULL
 ,SNAME VARCHAR2(10) NOT NULL
 ,NAME VARCHAR2(30) NOT NULL
 ,VALUE VARCHAR2(240)
 ,INTERNAL VARCHAR2(1) NOT NULL
 ,TYPE VARCHAR2(20)
 ,DESCRIPTION VARCHAR2(240) NOT NULL
 )
/

PROMPT Creating Table 'CKXT_TYPES'
CREATE TABLE CKXT_TYPES
 (TYPE_OF VARCHAR2(17) NOT NULL
 ,EL_LEVEL VARCHAR2(4) NOT NULL
 )
/

PROMPT Creating Table 'CK_CKDBSZ_KEY_TMP'
CREATE TABLE CK_CKDBSZ_KEY_TMP
 (REP_SEQ NUMBER(38,0)
 ,KEY_NAME VARCHAR2(100)
  ,APP_ID NUMBER(38,0)
 ,OTB_ID NUMBER(38,0)
 ,ODB_ID NUMBER(38,0)
 ,KEY_ID NUMBER(38,0)
 ,KEY_TYPE VARCHAR2(100)
 ,TAB_ID NUMBER(38,0)
 ,TAB_NAME VARCHAR2(100)
 ,KEY_PCT_FREE NUMBER(38,0)
 ,KEY_INIT_TRANS NUMBER(38,0)
 ,KEY_START_ROWS NUMBER(38,0)
 ,KEY_END_ROWS NUMBER(38,0)
 ,KEY_CR_STATUS VARCHAR2(1)
 )
/

PROMPT Creating Table 'RM$TOOLS'
CREATE TABLE RM$TOOLS
(TOOL_NAME     VARCHAR2(40) 
,PATCH_LEVEL   NUMBER(4)
)
/

PROMPT Creating Table 'CK_CIUE_UPGRADE_ACTIONS'
CREATE TABLE CK_CIUE_UPGRADE_ACTIONS
(SEQUENCE    NUMBER   
,OLD_SN      VARCHAR2(6)
,NEW_SN      VARCHAR2(6)
)
/


--B1765088, B1479214, 1388262. Must be a real non global temporary table to compute statistics
-- M53 Patch 001
PROMPT Creating Table 'CK_TEMP_IRIDS'
CREATE TABLE CK_TEMP_IRIDS
( IRID number
)
/