
create table SDD_ABT_409 (irid number not null, ivid number not null
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'ABT' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, NAME VARCHAR2(100) NOT NULL
, FINAL_FLAG VARCHAR2(1) NOT NULL
, INSTANTIABLE_FLAG VARCHAR2(1) 
, MAXIMUM_LENGTH NUMBER(5) 
, DECIMAL_PLACES NUMBER(4) 
, INHERIT_LENGTH_FLAG VARCHAR2(1) 
, LARGE_OBJECT_FLAG VARCHAR2(1) 
, CASE_RESTRICTION VARCHAR2(8) 
, GENERATE_CLASS_FLAG VARCHAR2(1) NOT NULL
, PERSISTENT_FLAG VARCHAR2(1) 
, COMPLETE_FLAG VARCHAR2(1) NOT NULL
, DATATYPE VARCHAR2(16) 
, BASE_EXCEPTION_FLAG VARCHAR2(1) NOT NULL
, ABT_TYPE VARCHAR2(3) NOT NULL
, INTERFACE_FLAG VARCHAR2(1) 
, SYSTEM_ELEMENT_FLAG VARCHAR2(1) 
, AUTHOR VARCHAR2(100) 
, PACKAGE_REF NUMBER(38) 
, USRX0 VARCHAR2(240) 
, USRX1 VARCHAR2(240) 
, USRX2 VARCHAR2(240) 
, USRX3 VARCHAR2(240) 
, USRX4 VARCHAR2(240) 
, USRX5 VARCHAR2(240) 
, USRX6 VARCHAR2(240) 
, USRX7 VARCHAR2(240) 
, USRX8 VARCHAR2(240) 
, USRX9 VARCHAR2(240) 
, USRX10 VARCHAR2(240) 
, USRX11 VARCHAR2(240) 
, USRX12 VARCHAR2(240) 
, USRX13 VARCHAR2(240) 
, USRX14 VARCHAR2(240) 
, USRX15 VARCHAR2(240) 
, USRX16 VARCHAR2(240) 
, USRX17 VARCHAR2(240) 
, USRX18 VARCHAR2(240) 
, USRX19 VARCHAR2(240) 
)
/

create table SDD_ABTABT_409 (irid number not null, ivid number not null
, pac_ref number , parent_ivid number 
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'ABTABT' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, SUPERTYPE_REF NUMBER(38) NOT NULL
, SUBTYPE_REF NUMBER(38) NOT NULL
, SEQUENCE NUMBER(6) NOT NULL
, VISIBILITY VARCHAR2(10) 
, USRX0 VARCHAR2(240) 
, USRX1 VARCHAR2(240) 
, USRX2 VARCHAR2(240) 
, USRX3 VARCHAR2(240) 
, USRX4 VARCHAR2(240) 
, USRX5 VARCHAR2(240) 
, USRX6 VARCHAR2(240) 
, USRX7 VARCHAR2(240) 
, USRX8 VARCHAR2(240) 
, USRX9 VARCHAR2(240) 
, USRX10 VARCHAR2(240) 
, USRX11 VARCHAR2(240) 
, USRX12 VARCHAR2(240) 
, USRX13 VARCHAR2(240) 
, USRX14 VARCHAR2(240) 
, USRX15 VARCHAR2(240) 
, USRX16 VARCHAR2(240) 
, USRX17 VARCHAR2(240) 
, USRX18 VARCHAR2(240) 
, USRX19 VARCHAR2(240) 
)
/

create table SDD_ATP_409 (irid number not null, ivid number not null
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'ATP' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, NAME VARCHAR2(100) 
, AUTHOR VARCHAR2(100) 
, EXTERNAL_FLAG VARCHAR2(1) NOT NULL
, USRX0 VARCHAR2(240) 
, USRX1 VARCHAR2(240) 
, USRX2 VARCHAR2(240) 
, USRX3 VARCHAR2(240) 
, USRX4 VARCHAR2(240) 
, USRX5 VARCHAR2(240) 
, USRX6 VARCHAR2(240) 
, USRX7 VARCHAR2(240) 
, USRX8 VARCHAR2(240) 
, USRX9 VARCHAR2(240) 
, USRX10 VARCHAR2(240) 
, USRX11 VARCHAR2(240) 
, USRX12 VARCHAR2(240) 
, USRX13 VARCHAR2(240) 
, USRX14 VARCHAR2(240) 
, USRX15 VARCHAR2(240) 
, USRX16 VARCHAR2(240) 
, USRX17 VARCHAR2(240) 
, USRX18 VARCHAR2(240) 
, USRX19 VARCHAR2(240) 
)
/

create table SDD_CCL_409 (irid number not null, ivid number not null
, pac_ref number, parent_ivid number 
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'CCL' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, ABSTRACT_TYPE_REF NUMBER(38) NOT NULL
, LANGUAGE_NAME VARCHAR2(16) NOT NULL
, CODE_SECTION_TYPE VARCHAR2(50) NOT NULL
, SEQUENCE_NUMBER NUMBER(6) NOT NULL
, SOURCE_FILE_REF NUMBER(38) NOT NULL
, GENERATED_CODE_STATUS VARCHAR2(1) NOT NULL
)
/

create table SDD_CSL_409 (irid number not null, ivid number not null
, pac_ref number, parent_ivid number 
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'CSL' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, LANGUAGE_NAME VARCHAR2(16) NOT NULL
, CLASS_SET_CODE_TYPE VARCHAR2(50) NOT NULL
, SOURCE_FILE_REF NUMBER(38) NOT NULL
, GENERATED_CODE_STATUS VARCHAR2(1) NOT NULL
, GENERATOR_CLASS_SET_REF NUMBER(38) NOT NULL
)
/

create table SDD_DEU_409 (irid number not null, ivid number not null
, pac_ref number, parent_ivid number 
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'DEU' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, DIAGRAM_REF NUMBER(38) NOT NULL
, CIELEMENT_REF NUMBER(38) NOT NULL
, SEQUENCE NUMBER(10) NOT NULL
, NUMBER_OF_TIMES NUMBER(10) NOT NULL
, ELEMENT_TYPE_FOR VARCHAR2(10) NOT NULL
)
/

create table SDD_DIA_409 (irid number not null, ivid number not null
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'DIA' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, NAME VARCHAR2(40) NOT NULL
, DIAGRAM_TYPE VARCHAR2(3) NOT NULL
, TITLE VARCHAR2(40) 
, AUTHOR VARCHAR2(30) 
, SCENARIO VARCHAR2(6) 
, SUB_DIAGRAM_TYPE VARCHAR2(30) 
, SUB_DIAGRAM_ID NUMBER(38) 
, USRX0 VARCHAR2(240) 
, USRX1 VARCHAR2(240) 
, USRX2 VARCHAR2(240) 
, USRX3 VARCHAR2(240) 
, USRX4 VARCHAR2(240) 
, USRX5 VARCHAR2(240) 
, USRX6 VARCHAR2(240) 
, USRX7 VARCHAR2(240) 
, USRX8 VARCHAR2(240) 
, USRX9 VARCHAR2(240) 
, USRX10 VARCHAR2(240) 
, USRX11 VARCHAR2(240) 
, USRX12 VARCHAR2(240) 
, USRX13 VARCHAR2(240) 
, USRX14 VARCHAR2(240) 
, USRX15 VARCHAR2(240) 
, USRX16 VARCHAR2(240) 
, USRX17 VARCHAR2(240) 
, USRX18 VARCHAR2(240) 
, USRX19 VARCHAR2(240) 
, DIAGRAM_FILE_REF NUMBER(38) 
, DTD_FILENAME VARCHAR2(30) 
, PACKAGE_REF NUMBER(38) 
)
/


create table SDD_FIL_409 (irid number not null, ivid number not null
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'FIL' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, NAME VARCHAR2(100) NOT NULL
, FULL_PATHNAME VARCHAR2(240) 
, LANGUAGE_REF NUMBER(38) 
, FILE_TYPE VARCHAR2(16) 
, ORGANIZATION VARCHAR2(16) 
, ACCESS_METHOD VARCHAR2(16) 
, STORAGE_MEDIA VARCHAR2(16) 
, BLOCK_SIZE NUMBER(10) 
, CLUSTER_SIZE NUMBER(10) 
, FILE_SIZE NUMBER(10) 
, UNIT VARCHAR2(10) 
, REMARK VARCHAR2(70) 
, OS_FILE_TYPE VARCHAR2(3) NOT NULL
, USRX0 VARCHAR2(240) 
, USRX1 VARCHAR2(240) 
, USRX2 VARCHAR2(240) 
, USRX3 VARCHAR2(240) 
, USRX4 VARCHAR2(240) 
, USRX5 VARCHAR2(240) 
, USRX6 VARCHAR2(240) 
, USRX7 VARCHAR2(240) 
, USRX8 VARCHAR2(240) 
, USRX9 VARCHAR2(240) 
, USRX10 VARCHAR2(240) 
, USRX11 VARCHAR2(240) 
, USRX12 VARCHAR2(240) 
, USRX13 VARCHAR2(240) 
, USRX14 VARCHAR2(240) 
, USRX15 VARCHAR2(240) 
, USRX16 VARCHAR2(240) 
, USRX17 VARCHAR2(240) 
, USRX18 VARCHAR2(240) 
, USRX19 VARCHAR2(240) 
)
/

create table SDD_IVA_409 (irid number not null, ivid number not null
, pac_ref number , parent_ivid number
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'IVA' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, TYPE_ATTRIBUTE_REF NUMBER(38) NOT NULL
, VALUE VARCHAR2(40) NOT NULL
, SEQUENCE NUMBER(6) NOT NULL
, USRX0 VARCHAR2(240) 
, USRX1 VARCHAR2(240) 
, USRX2 VARCHAR2(240) 
, USRX3 VARCHAR2(240) 
, USRX4 VARCHAR2(240) 
, USRX5 VARCHAR2(240) 
, USRX6 VARCHAR2(240) 
, USRX7 VARCHAR2(240) 
, USRX8 VARCHAR2(240) 
, USRX9 VARCHAR2(240) 
, USRX10 VARCHAR2(240) 
, USRX11 VARCHAR2(240) 
, USRX12 VARCHAR2(240) 
, USRX13 VARCHAR2(240) 
, USRX14 VARCHAR2(240) 
, USRX15 VARCHAR2(240) 
, USRX16 VARCHAR2(240) 
, USRX17 VARCHAR2(240) 
, USRX18 VARCHAR2(240) 
, USRX19 VARCHAR2(240) 
)
/

create table SDD_MAP_409 (irid number not null, ivid number not null
, pac_ref number, parent_ivid number 
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'MAP' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, TRANSFORMATION_SET_REF NUMBER(38) NOT NULL
, SOURCE_CIELEMENT_REF NUMBER(38) NOT NULL
, SOURCE_ELEMENT_TYPE VARCHAR2(15) NOT NULL
, SOURCE_ELEMENT_SUBTYPE VARCHAR2(10) 
, TARGET_CIELEMENT_REF NUMBER(38) NOT NULL
, TARGET_ELEMENT_TYPE VARCHAR2(15) NOT NULL
, TARGET_ELEMENT_SUBTYPE VARCHAR2(10) 
, CREATED_BY_TRANSFORMER_FLAG VARCHAR2(1) NOT NULL
)
/

create table SDD_OPP_409 (irid number not null, ivid number not null
, pac_ref number, parent_ivid number 
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'OPP' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, TYPE_OPERATION_REF NUMBER(38) NOT NULL
, NAME VARCHAR2(100) NOT NULL
, SEQUENCE NUMBER(6) NOT NULL
, ABSTRACT_TYPE_REF NUMBER(38) 
, CALL_TYPE VARCHAR2(13) 
, DEFAULT_VALUE VARCHAR2(60) 
, USRX0 VARCHAR2(240) 
, USRX1 VARCHAR2(240) 
, USRX2 VARCHAR2(240) 
, USRX3 VARCHAR2(240) 
, USRX4 VARCHAR2(240) 
, USRX5 VARCHAR2(240) 
, USRX6 VARCHAR2(240) 
, USRX7 VARCHAR2(240) 
, USRX8 VARCHAR2(240) 
, USRX9 VARCHAR2(240) 
, USRX10 VARCHAR2(240) 
, USRX11 VARCHAR2(240) 
, USRX12 VARCHAR2(240) 
, USRX13 VARCHAR2(240) 
, USRX14 VARCHAR2(240) 
, USRX15 VARCHAR2(240) 
, USRX16 VARCHAR2(240) 
, USRX17 VARCHAR2(240) 
, USRX18 VARCHAR2(240) 
, USRX19 VARCHAR2(240) 
)
/

create table SDD_PRS_409 (irid number not null, ivid number not null
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'PRS' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, NAME VARCHAR2(30) NOT NULL
, PRODUCT_FLAVOR VARCHAR2(10) NOT NULL
, FROZEN_FLAG VARCHAR2(1) NOT NULL
, USRX0 VARCHAR2(240) 
, USRX1 VARCHAR2(240) 
, USRX2 VARCHAR2(240) 
, USRX3 VARCHAR2(240) 
, USRX4 VARCHAR2(240) 
, USRX5 VARCHAR2(240) 
, USRX6 VARCHAR2(240) 
, USRX7 VARCHAR2(240) 
, USRX8 VARCHAR2(240) 
, USRX9 VARCHAR2(240) 
, USRX10 VARCHAR2(240) 
, USRX11 VARCHAR2(240) 
, USRX12 VARCHAR2(240) 
, USRX13 VARCHAR2(240) 
, USRX14 VARCHAR2(240) 
, USRX15 VARCHAR2(240) 
, USRX16 VARCHAR2(240) 
, USRX17 VARCHAR2(240) 
, USRX18 VARCHAR2(240) 
, USRX19 VARCHAR2(240) 
)
/

create table SDD_PRU_409 (irid number not null, ivid number not null
, pac_ref number, parent_ivid number 
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'PRU' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, PREFERENCE_SET_REF NUMBER(38) NOT NULL
, CIELEMENT_REF NUMBER(38) NOT NULL
, PREFERENCE_SET_USAGE_FOR VARCHAR2(6) NOT NULL
)
/


create table SDD_TCO_409 (irid number not null, ivid number not null
, pac_ref number, parent_ivid number 
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'TCO' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, OBJECT_TYPE_REF NUMBER(38) NOT NULL
, NAME VARCHAR2(30) NOT NULL
, TCO_TYPE VARCHAR2(3) NOT NULL
, USRX0 VARCHAR2(240) 
, USRX1 VARCHAR2(240) 
, USRX2 VARCHAR2(240) 
, USRX3 VARCHAR2(240) 
, USRX4 VARCHAR2(240) 
, USRX5 VARCHAR2(240) 
, USRX6 VARCHAR2(240) 
, USRX7 VARCHAR2(240) 
, USRX8 VARCHAR2(240) 
, USRX9 VARCHAR2(240) 
, USRX10 VARCHAR2(240) 
, USRX11 VARCHAR2(240) 
, USRX12 VARCHAR2(240) 
, USRX13 VARCHAR2(240) 
, USRX14 VARCHAR2(240) 
, USRX15 VARCHAR2(240) 
, USRX16 VARCHAR2(240) 
, USRX17 VARCHAR2(240) 
, USRX18 VARCHAR2(240) 
, USRX19 VARCHAR2(240) 
)
/


create table SDD_TCOTME_409 (irid number not null, ivid number not null
, pac_ref number, parent_ivid number
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'TCOTME' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, TYPE_CONSTRAINT_REF NUMBER(38) NOT NULL
, TYPE_MEMBER_REF NUMBER(38) NOT NULL
, SEQUENCE NUMBER(6) NOT NULL
, TCO_TYPE VARCHAR2(3) NOT NULL
, TME_TYPE VARCHAR2(3) NOT NULL
, USRX0 VARCHAR2(240) 
, USRX1 VARCHAR2(240) 
, USRX2 VARCHAR2(240) 
, USRX3 VARCHAR2(240) 
, USRX4 VARCHAR2(240) 
, USRX5 VARCHAR2(240) 
, USRX6 VARCHAR2(240) 
, USRX7 VARCHAR2(240) 
, USRX8 VARCHAR2(240) 
, USRX9 VARCHAR2(240) 
, USRX10 VARCHAR2(240) 
, USRX11 VARCHAR2(240) 
, USRX12 VARCHAR2(240) 
, USRX13 VARCHAR2(240) 
, USRX14 VARCHAR2(240) 
, USRX15 VARCHAR2(240) 
, USRX16 VARCHAR2(240) 
, USRX17 VARCHAR2(240) 
, USRX18 VARCHAR2(240) 
, USRX19 VARCHAR2(240) 
)
/

create table SDD_TME_409 (irid number not null, ivid number not null
, pac_ref number , parent_ivid number
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'TME' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, NAME VARCHAR2(100) 
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, OBJECT_TYPE_REF NUMBER(38) NOT NULL
, SEQUENCE NUMBER(6) NOT NULL
, VISIBILITY VARCHAR2(10) 
, SCOPE VARCHAR2(8) NOT NULL
, VERB_NAME VARCHAR2(100) 
, AGGREGATION VARCHAR2(6) 
, MANDATORY_FLAG VARCHAR2(1) 
, MODIFIES_STATE_FLAG VARCHAR2(1) 
, TYPE_OPERATION_TYPE VARCHAR2(1) 
, CONSTANT_FLAG VARCHAR2(1) 
, NAVIGATION_TARGET_FLAG VARCHAR2(1) 
, TRANSFERABLE_FLAG VARCHAR2(1) 
, RETURN_VALUE_FLAG VARCHAR2(1) 
, VALUE_TYPE_REF NUMBER(38) 
, ABSTRACT_TYPE_REF NUMBER(38) 
, INHERIT_LENGTH_FLAG VARCHAR2(1) 
, MAXIMUM_LENGTH NUMBER(5) 
, DECIMAL_PLACES NUMBER(4) 
, MINIMIM_CARDINALITY NUMBER(10) 
, MAXIMUM_CARDINALITY NUMBER(10) 
, ORDERED_SET_FLAG VARCHAR2(1) 
, ARRAY_FLAG VARCHAR2(1) 
, ARRAY_SIZE NUMBER(10) 
, GENERATE_CLASS_MEMBER_FLAG VARCHAR2(1) NOT NULL
, PERSISTENT_FLAG VARCHAR2(1) NOT NULL
, SORT_ORDER_SEQUENCE NUMBER(6) 
, SORT_ORDER_DIRECTION VARCHAR2(1) 
, TME_TYPE VARCHAR2(3) NOT NULL
, OVERRIDABLE VARCHAR2(6) 
, DYNAMIC_BINDING_FLAG VARCHAR2(1) 
, INTERNAL_NAME VARCHAR2(100) 
, OTHER_ASSOCIATION_ROLE_REF NUMBER(38) 
, TO_OBJECT_TYPE_REF NUMBER(38) 
, USRX0 VARCHAR2(240) 
, USRX1 VARCHAR2(240) 
, USRX2 VARCHAR2(240) 
, USRX3 VARCHAR2(240) 
, USRX4 VARCHAR2(240) 
, USRX5 VARCHAR2(240) 
, USRX6 VARCHAR2(240) 
, USRX7 VARCHAR2(240) 
, USRX8 VARCHAR2(240) 
, USRX9 VARCHAR2(240) 
, USRX10 VARCHAR2(240) 
, USRX11 VARCHAR2(240) 
, USRX12 VARCHAR2(240) 
, USRX13 VARCHAR2(240) 
, USRX14 VARCHAR2(240) 
, USRX15 VARCHAR2(240) 
, USRX16 VARCHAR2(240) 
, USRX17 VARCHAR2(240) 
, USRX18 VARCHAR2(240) 
, USRX19 VARCHAR2(240) 
)
/

create table SDD_TMS_409 (irid number not null, ivid number not null
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'TMS' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, TRANSFORMATION_TYPE VARCHAR2(8) NOT NULL
, SOURCE_LEVEL VARCHAR2(10) NOT NULL
, TARGET_LEVEL VARCHAR2(10) NOT NULL
, REMARK VARCHAR2(240) 
, USRX0 VARCHAR2(240) 
, USRX1 VARCHAR2(240) 
, USRX2 VARCHAR2(240) 
, USRX3 VARCHAR2(240) 
, USRX4 VARCHAR2(240) 
, USRX5 VARCHAR2(240) 
, USRX6 VARCHAR2(240) 
, USRX7 VARCHAR2(240) 
, USRX8 VARCHAR2(240) 
, USRX9 VARCHAR2(240) 
, USRX10 VARCHAR2(240) 
, USRX11 VARCHAR2(240) 
, USRX12 VARCHAR2(240) 
, USRX13 VARCHAR2(240) 
, USRX14 VARCHAR2(240) 
, USRX15 VARCHAR2(240) 
, USRX16 VARCHAR2(240) 
, USRX17 VARCHAR2(240) 
, USRX18 VARCHAR2(240) 
, USRX19 VARCHAR2(240) 
)
/

create table SDD_TOPABT_409 (irid number not null, ivid number not null
, pac_ref number, parent_ivid number 
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'TOPABT' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, ABSTRACT_TYPE_REF NUMBER(38) NOT NULL
, TYPE_OPERATION_REF NUMBER(38) NOT NULL
, SEQUENCE NUMBER(6) NOT NULL
, USRX0 VARCHAR2(240) 
, USRX1 VARCHAR2(240) 
, USRX2 VARCHAR2(240) 
, USRX3 VARCHAR2(240) 
, USRX4 VARCHAR2(240) 
, USRX5 VARCHAR2(240) 
, USRX6 VARCHAR2(240) 
, USRX7 VARCHAR2(240) 
, USRX8 VARCHAR2(240) 
, USRX9 VARCHAR2(240) 
, USRX10 VARCHAR2(240) 
, USRX11 VARCHAR2(240) 
, USRX12 VARCHAR2(240) 
, USRX13 VARCHAR2(240) 
, USRX14 VARCHAR2(240) 
, USRX15 VARCHAR2(240) 
, USRX16 VARCHAR2(240) 
, USRX17 VARCHAR2(240) 
, USRX18 VARCHAR2(240) 
, USRX19 VARCHAR2(240) 
)
/

create table SDD_UDS_409 (irid number not null, ivid number not null
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'UDS' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, NAME VARCHAR2(30) NOT NULL
, SET_TYPE VARCHAR2(3) NOT NULL
, USRX0 VARCHAR2(240) 
, USRX1 VARCHAR2(240) 
, USRX2 VARCHAR2(240) 
, USRX3 VARCHAR2(240) 
, USRX4 VARCHAR2(240) 
, USRX5 VARCHAR2(240) 
, USRX6 VARCHAR2(240) 
, USRX7 VARCHAR2(240) 
, USRX8 VARCHAR2(240) 
, USRX9 VARCHAR2(240) 
, USRX10 VARCHAR2(240) 
, USRX11 VARCHAR2(240) 
, USRX12 VARCHAR2(240) 
, USRX13 VARCHAR2(240) 
, USRX14 VARCHAR2(240) 
, USRX15 VARCHAR2(240) 
, USRX16 VARCHAR2(240) 
, USRX17 VARCHAR2(240) 
, USRX18 VARCHAR2(240) 
, USRX19 VARCHAR2(240) 
)
/

create table SDD_UPR_409 (irid number not null, ivid number not null
, pac_ref number , parent_ivid number 
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'UPR' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, CIELEMENT_REF NUMBER(38) NOT NULL
, PREFERENCE_NAME VARCHAR2(6) NOT NULL
, PREFERENCE_VALUE VARCHAR2(240) 
, FROZEN_FLAG VARCHAR2(1) NOT NULL
, PREFERENCE_FOR VARCHAR2(6) NOT NULL
, PRODUCT_FLAVOR VARCHAR2(10) NOT NULL
)
/


create table SDD_VVA_409 (irid number not null, ivid number not null
, pac_ref number, parent_ivid number 
, TYPES NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) default 'VVA' NOT NULL
, DATE_CREATED DATE default SYSDATE NOT NULL
, CREATED_BY VARCHAR2(30) default USER NOT NULL
, DATE_CHANGED DATE 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 NOT NULL
, VALUE_TYPE_REF NUMBER(38) NOT NULL
, SEQUENCE NUMBER(6) NOT NULL
, VALUE VARCHAR2(40) 
, HIGH_VALUE VARCHAR2(40) 
, IDENTIFIER VARCHAR2(100) 
, USRX0 VARCHAR2(240) 
, USRX1 VARCHAR2(240) 
, USRX2 VARCHAR2(240) 
, USRX3 VARCHAR2(240) 
, USRX4 VARCHAR2(240) 
, USRX5 VARCHAR2(240) 
, USRX6 VARCHAR2(240) 
, USRX7 VARCHAR2(240) 
, USRX8 VARCHAR2(240) 
, USRX9 VARCHAR2(240) 
, USRX10 VARCHAR2(240) 
, USRX11 VARCHAR2(240) 
, USRX12 VARCHAR2(240) 
, USRX13 VARCHAR2(240) 
, USRX14 VARCHAR2(240) 
, USRX15 VARCHAR2(240) 
, USRX16 VARCHAR2(240) 
, USRX17 VARCHAR2(240) 
, USRX18 VARCHAR2(240) 
, USRX19 VARCHAR2(240) 
)
/

create table SDD_DIAGRAM_SEGMENTS_409 (irid number not null, ivid number not null
, pac_ref number, parent_ivid number 
, TYPES NUMBER(38) 
, DIAGRAM_REF NUMBER(38) NOT NULL
, GRAPHICAL_DATA RAW(240) 
, SEQUENCE NUMBER(38) 
, ELEMENT_TYPE_NAME VARCHAR2(10) 
, DATE_CREATED DATE default SYSDATE 
, DATE_CHANGED DATE 
, CREATED_BY VARCHAR2(30) default USER 
, CHANGED_BY VARCHAR2(30) 
, NOTM NUMBER(38) default 0 
)
/

create table RM_TEXT_LINES_409 (irid number not null, ivid number not null
, pac_ref number, parent_ivid number
, TXT_REF NUMBER(38) NOT NULL
, TXT_SEQ NUMBER(6) NOT NULL
, TXT_TYPE VARCHAR2(10) NOT NULL
, ELEMENT_TYPE_FOR VARCHAR2(6) NOT NULL
, TXT_NOTM NUMBER(38) 
, TXT_TEXT VARCHAR2(2000) 
)
/
