CREATE OR REPLACE VIEW CI_ACTION_ITEMS(                                                             
ACTION_ITEM_FOR                                                                                     
, ACTION_ITEM_TYPE                                                                                  
, BUTTON_HEIGHT                                                                                     
, BUTTON_WIDTH                                                                                      
, CHANGED_BY                                                                                        
, CREATED_BY                                                                                        
, CREATE_BUTTON_FLAG                                                                                
, CREATE_MENU_ITEM_FLAG                                                                             
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DEFAULT_FLAG                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, ENABLE_ON_DB_RECORD_FLAG                                                                          
, GENERATOR_ITEM_TYPE                                                                               
, HINT_TEXT                                                                                         
, ICON_NAME                                                                                         
, ID                                                                                                
, IMPLEMENTATION_ITEM                                                                               
, IRID                                                                                              
, IVID                                                                                              
, MCN_REFERENCE                                                                                     
, MCN_REFERENCE_TO                                                                                  
, MODULE_NETWORK_REFERENCE                                                                          
, NAME                                                                                              
, NAVIGATION_TO                                                                                     
, NUMBER_OF_TIMES_MODIFIED                                                                          
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, PROMPT                                                                                            
, TYPES                                                                                             
, USAGE_SEQUENCE                                                                                    
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
, WINDOW_REFERENCE                                                                                  
)                                                                                                   
AS SELECT                                                                                           
ACTION_ITEM_FOR                                                                                     
, ACTION_ITEM_TYPE                                                                                  
, BUTTON_HEIGHT                                                                                     
, BUTTON_WIDTH                                                                                      
, CHANGED_BY                                                                                        
, CREATED_BY                                                                                        
, CREATE_BUTTON_FLAG                                                                                
, CREATE_MENU_ITEM_FLAG                                                                             
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DEFAULT_FLAG                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, ENABLE_ON_DB_RECORD_FLAG                                                                          
, GENERATOR_ITEM_TYPE                                                                               
, HINT_TEXT                                                                                         
, ICON_NAME                                                                                         
, IRID                                                                                              
, IMPLEMENTATION_ITEM                                                                               
, IRID                                                                                              
, IVID                                                                                              
, MCN_REF                                                                                           
, MCN_REF_TO                                                                                        
, MODULE_NETWORK_REF                                                                                
, NAME                                                                                              
, NAVIGATION_TO                                                                                     
, NOTM                                                                                              
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, PROMPT                                                                                            
, TYPES                                                                                             
, USAGE_SEQUENCE                                                                                    
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
, WINDOW_REF                                                                                        
FROM  SDD_ACI                                                                                       
WHERE TYPES IN (                                                                                    
4915                                                                                                
, 4911                                                                                              
, 4912                                                                                              
, 4913                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_CLASSIFIER_ATTRIBUTES(                                                    
ATTRIBUTE_DOMAIN_REFERENCE                                                                          
, CHANGED_BY                                                                                        
, CHANGE_RESTRICTION                                                                                
, CLASSIFIER_ATTRIBUTE_SUBTYPE                                                                      
, CLASSIFIER_REFERENCE                                                                              
, COLLECT_CLASSSIFIER_REFERENCE                                                                     
, CREATABLE_FLAG                                                                                    
, CREATED_BY                                                                                        
, DATATYPE_FORMAT                                                                                   
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DB_COLLECTION_AS_REFS_FLAG                                                                        
, DECIMAL_PLACES                                                                                    
, DEFAULT_COLUMN_DATATYPE                                                                           
, DEFAULT_COLUMN_NAME                                                                               
, DEFAULT_DB_COLLECTION_NAME                                                                        
, DEFAULT_VALUE                                                                                     
, DELETABLE_FLAG                                                                                    
, DISPLAY_FLAG                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, ENTITY_OBJECT_REFERENCE                                                                           
, ENTITY_OBJECT_USAGE_REFERENCE                                                                     
, EO_ATTRIBUTE_REFERENCE                                                                            
, EVENT_CLASSIFIER_REFERENCE                                                                        
, GENERAL_ATTRIBUTE_FOR                                                                             
, GENERATE_CLASS_MEMBER_FLAG                                                                        
, GENERIC_CLASS_REFERENCE                                                                           
, ID                                                                                                
, INTERFACE_CLASSIFIER_REFERENCE                                                                    
, IRID                                                                                              
, IVID                                                                                              
, JDBC_TYPE                                                                                         
, MAXIMUM_LENGTH                                                                                    
, MAXIMUM_MULTIPLICITY                                                                              
, MINIMUM_MULTIPLICITY                                                                              
, MODIFICATION_FLAG                                                                                 
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, PERSISTENT_FLAG                                                                                   
, PROGRAMMED_UPDATE_FLAG                                                                            
, PROMPT                                                                                            
, PSEUDOCOLUMN_FLAG                                                                                 
, RETRIEVABLE_FLAG                                                                                  
, SCALAR_DATATYPE                                                                                   
, SEQUENCE                                                                                          
, SERIALIZABLE_FLAG                                                                                 
, SORT_ORDER_DIRECTION                                                                              
, SORT_ORDER_SEQUENCE                                                                               
, SQL_ALIAS                                                                                         
, STATIC_FLAG                                                                                       
, TYPES                                                                                             
, UPDATABLE_FLAG                                                                                    
, VIEW_OBJECT_REFERENCE                                                                             
, VISIBILITY                                                                                        
, VOLATILE_FLAG                                                                                     
)                                                                                                   
AS SELECT                                                                                           
ATTRIBUTE_DOMAIN_REF                                                                                
, CHANGED_BY                                                                                        
, CHANGE_RESTRICTION                                                                                
, CLASSIFIER_ATTRIBUTE_SUBTYPE                                                                      
, CLASSIFIER_REF                                                                                    
, COLLECT_CLASSSIFIER_REF                                                                           
, CREATABLE_FLAG                                                                                    
, CREATED_BY                                                                                        
, DATATYPE_FORMAT                                                                                   
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DB_COLLECTION_AS_REFS_FLAG                                                                        
, DECIMAL_PLACES                                                                                    
, DEFAULT_COLUMN_DATATYPE                                                                           
, DEFAULT_COLUMN_NAME                                                                               
, DEFAULT_DB_COLLECTION_NAME                                                                        
, DEFAULT_VALUE                                                                                     
, DELETABLE_FLAG                                                                                    
, DISPLAY_FLAG                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, ENTITY_OBJECT_REF                                                                                 
, ENTITY_OBJECT_USAGE_REF                                                                           
, EO_ATTRIBUTE_REF                                                                                  
, EVENT_CLASSIFIER_REF                                                                              
, GENERAL_ATTRIBUTE_FOR                                                                             
, GENERATE_CLASS_MEMBER_FLAG                                                                        
, GENERIC_CLASS_REF                                                                                 
, IRID                                                                                              
, INTERFACE_CLASSIFIER_REF                                                                          
, IRID                                                                                              
, IVID                                                                                              
, JDBC_TYPE                                                                                         
, MAXIMUM_LENGTH                                                                                    
, MAXIMUM_MULTIPLICITY                                                                              
, MINIMUM_MULTIPLICITY                                                                              
, MODIFICATION_FLAG                                                                                 
, NAME                                                                                              
, NOTM                                                                                              
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, PERSISTENT_FLAG                                                                                   
, PROGRAMMED_UPDATE_FLAG                                                                            
, PROMPT                                                                                            
, PSEUDOCOLUMN_FLAG                                                                                 
, RETRIEVABLE_FLAG                                                                                  
, SCALAR_DATATYPE                                                                                   
, SEQUENCE                                                                                          
, SERIALIZABLE_FLAG                                                                                 
, SORT_ORDER_DIRECTION                                                                              
, SORT_ORDER_SEQUENCE                                                                               
, SQL_ALIAS                                                                                         
, STATIC_FLAG                                                                                       
, TYPES                                                                                             
, UPDATABLE_FLAG                                                                                    
, VIEW_OBJECT_REF                                                                                   
, VISIBILITY                                                                                        
, VOLATILE_FLAG                                                                                     
FROM  SDD_CAT                                                                                       
WHERE TYPES IN (                                                                                    
5066                                                                                                
, 5067                                                                                              
, 5068                                                                                              
, 5120                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_CLASSIFIERS(                                                              
ABSTRACT_FLAG                                                                                       
, ACTIVE_FLAG                                                                                       
, ACTOR_REFERENCE                                                                                   
, ANALYSIS_TYPE_FLAG                                                                                
, AUTHOR                                                                                            
, BASE_SCALAR_DATATYPE                                                                              
, BUSINESS_OBJECT_REFERENCE                                                                         
, CALL_MODE                                                                                         
, CHANGED_BY                                                                                        
, CLASSIFIER_REFERENCE                                                                              
, CLASSIFIER_SUBTYPE                                                                                
, CLASS_NAME                                                                                        
, COR_DEPTH_LEVEL                                                                                   
, CREATED_BY                                                                                        
, CREATE_SERVER_MAPPING_FLAG                                                                        
, DATATYPE_FORMAT                                                                                   
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DECIMAL_PLACES                                                                                    
, DEFAULT_COLUMN_DATATYPE                                                                           
, DEFAULT_DB_OBJECT_NAME                                                                            
, DEFAULT_DB_OBJECT_TYPE                                                                            
, DEFAULT_VALUE                                                                                     
, DURATION                                                                                          
, DURATION_UNIT                                                                                     
, EJB_TARGET_FLAG                                                                                   
, ELEMENT_TYPE_NAME                                                                                 
, EMBEDABLE_VALIDATOR                                                                               
, EXTERNAL_FLAG                                                                                     
, FETCH_MODE                                                                                        
, FETCH_SIZE                                                                                        
, FILE_SCOPE                                                                                        
, FREQUENCY                                                                                         
, FREQUENCY_UNIT                                                                                    
, GENERATE_ACCESSORS_FLAG                                                                           
, GENERIC_CLASS_REFERENCE                                                                           
, ICON_FILE_REFERENCE                                                                               
, ID                                                                                                
, IMPLEMENTATION_TARGET                                                                             
, INTERFACE_CLASSIFIER_REFERENCE                                                                    
, IRID                                                                                              
, IVID                                                                                              
, LARGE_OBJECT_FLAG                                                                                 
, LEAF_FLAG                                                                                         
, MANDATORY_FLAG                                                                                    
, MAXIMUM_LENGTH                                                                                    
, MAX_FETCH_SIZE                                                                                    
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, O8I_TARGET_FLAG                                                                                   
, OBJECT_STATE_REFERENCE                                                                            
, PERSISTENT_FLAG                                                                                   
, PRIMITIVE_FLAG                                                                                    
, QUERYABLE_FLAG                                                                                    
, REALIZATION_OF                                                                                    
, RICH_INTERFACE_FLAG                                                                               
, ROOT_FLAG                                                                                         
, SIGNAL_MODE                                                                                       
, SQL_ALIAS                                                                                         
, SYSTEM_ELEMENT_FLAG                                                                               
, TIME_OUT_LIMIT                                                                                    
, TIME_OUT_LIMIT_UNIT                                                                               
, TYPE                                                                                              
, TYPES                                                                                             
, UPDATABLE_FLAG                                                                                    
, USE_CASE_REFERENCE                                                                                
, VISIBROKER_TARGET_FLAG                                                                            
, WHEN_OCCURS                                                                                       
)                                                                                                   
AS SELECT                                                                                           
ABSTRACT_FLAG                                                                                       
, ACTIVE_FLAG                                                                                       
, ACTOR_REF                                                                                         
, ANALYSIS_TYPE_FLAG                                                                                
, AUTHOR                                                                                            
, BASE_SCALAR_DATATYPE                                                                              
, BUSINESS_OBJECT_REF                                                                               
, CALL_MODE                                                                                         
, CHANGED_BY                                                                                        
, CLASSIFIER_REF                                                                                    
, CLASSIFIER_SUBTYPE                                                                                
, CLASS_NAME                                                                                        
, COR_DEPTH_LEVEL                                                                                   
, CREATED_BY                                                                                        
, CREATE_SERVER_MAPPING_FLAG                                                                        
, DATATYPE_FORMAT                                                                                   
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DECIMAL_PLACES                                                                                    
, DEFAULT_COLUMN_DATATYPE                                                                           
, DEFAULT_DB_OBJECT_NAME                                                                            
, DEFAULT_DB_OBJECT_TYPE                                                                            
, DEFAULT_VALUE                                                                                     
, DURATION                                                                                          
, DURATION_UNIT                                                                                     
, EJB_TARGET_FLAG                                                                                   
, ELEMENT_TYPE_NAME                                                                                 
, EMBEDABLE_VALIDATOR                                                                               
, EXTERNAL_FLAG                                                                                     
, FETCH_MODE                                                                                        
, FETCH_SIZE                                                                                        
, FILE_SCOPE                                                                                        
, FREQUENCY                                                                                         
, FREQUENCY_UNIT                                                                                    
, GENERATE_ACCESSORS_FLAG                                                                           
, GENERIC_CLASS_REF                                                                                 
, ICON_FILE_REF                                                                                     
, IRID                                                                                              
, IMPLEMENTATION_TARGET                                                                             
, INTERFACE_CLASSIFIER_REF                                                                          
, IRID                                                                                              
, IVID                                                                                              
, LARGE_OBJECT_FLAG                                                                                 
, LEAF_FLAG                                                                                         
, MANDATORY_FLAG                                                                                    
, MAXIMUM_LENGTH                                                                                    
, MAX_FETCH_SIZE                                                                                    
, NAME                                                                                              
, NOTM                                                                                              
, O8I_TARGET_FLAG                                                                                   
, OBJECT_STATE_REF                                                                                  
, PERSISTENT_FLAG                                                                                   
, PRIMITIVE_FLAG                                                                                    
, QUERYABLE_FLAG                                                                                    
, REALIZATION_OF                                                                                    
, RICH_INTERFACE_FLAG                                                                               
, ROOT_FLAG                                                                                         
, SIGNAL_MODE                                                                                       
, SQL_ALIAS                                                                                         
, SYSTEM_ELEMENT_FLAG                                                                               
, TIME_OUT_LIMIT                                                                                    
, TIME_OUT_LIMIT_UNIT                                                                               
, TYPE                                                                                              
, TYPES                                                                                             
, UPDATABLE_FLAG                                                                                    
, USE_CASE_REF                                                                                      
, VISIBROKER_TARGET_FLAG                                                                            
, WHEN_OCCURS                                                                                       
FROM  SDD_CLA                                                                                       
WHERE TYPES IN (                                                                                    
4841                                                                                                
, 4838                                                                                              
, 4839                                                                                              
, 5064                                                                                              
, 5078                                                                                              
, 5085                                                                                              
, 5116                                                                                              
, 5118                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_CLASSIFIER_RULES(                                                         
CHANGED_BY                                                                                          
, CLASSIFIER_ATTRIBUTE_REFERENCE                                                                    
, CLASSIFIER_RULE_FOR                                                                               
, CLASSIFIER_RULE_SUBTYPE                                                                           
, CONTEXT                                                                                           
, CREATED_BY                                                                                        
, DATABASE_CHECK_CONSTRAINT_FLAG                                                                    
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DESIGNATED_PRIMARY_KEY_FLAG                                                                       
, ELEMENT_TYPE_NAME                                                                                 
, ENTITY_OBJECT_REFERENCE                                                                           
, GENERIC_CLASS_REFERENCE                                                                           
, ID                                                                                                
, INTERFACE_CLASSIFIER_REFERENCE                                                                    
, IRID                                                                                              
, IVID                                                                                              
, LANGUAGE_REFERENCE                                                                                
, METHOD_REFERENCE                                                                                  
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, SEQUENCE                                                                                          
, SHORT_DESCRIPTION                                                                                 
, TYPES                                                                                             
, VALIDATOR_OPERATOR                                                                                
, VIEW_OBJECT_REFERENCE                                                                             
)                                                                                                   
AS SELECT                                                                                           
CHANGED_BY                                                                                          
, CLASSIFIER_ATTRIBUTE_REF                                                                          
, CLASSIFIER_RULE_FOR                                                                               
, CLASSIFIER_RULE_SUBTYPE                                                                           
, CONTEXT                                                                                           
, CREATED_BY                                                                                        
, DATABASE_CHECK_CONSTRAINT_FLAG                                                                    
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DESIGNATED_PRIMARY_KEY_FLAG                                                                       
, ELEMENT_TYPE_NAME                                                                                 
, ENTITY_OBJECT_REF                                                                                 
, GENERIC_CLASS_REF                                                                                 
, IRID                                                                                              
, INTERFACE_CLASSIFIER_REF                                                                          
, IRID                                                                                              
, IVID                                                                                              
, LANGUAGE_REF                                                                                      
, METHOD_REF                                                                                        
, NAME                                                                                              
, NOTM                                                                                              
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, SEQUENCE                                                                                          
, SHORT_DESCRIPTION                                                                                 
, TYPES                                                                                             
, VALIDATOR_OPERATOR                                                                                
, VIEW_OBJECT_REF                                                                                   
FROM  SDD_CRU                                                                                       
WHERE TYPES IN (                                                                                    
5087                                                                                                
, 5092                                                                                              
, 5093                                                                                              
, 5094                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_COLUMN_STORAGES(                                                          
CHANGED_BY                                                                                          
, COLUMN_REFERENCE                                                                                  
, COLUMN_STORAGE_FOR                                                                                
, COLUMN_STORAGE_TYPE                                                                               
, CQA_REFERENCE                                                                                     
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, ID                                                                                                
, IRID                                                                                              
, IVID                                                                                              
, LOB_INDEX_NAME                                                                                    
, LOB_SEGMENT_NAME                                                                                  
, LOB_STORAGE_REFERENCE                                                                             
, NUMBER_OF_TIMES_MODIFIED                                                                          
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, STORAGE_DEFINITION_REFERENCE                                                                      
, STORAGE_TABLE_NAME                                                                                
, TABLESPACE_REFERENCE                                                                              
, TABLE_IMPLEMENTATION_REFERENCE                                                                    
, TYPES                                                                                             
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
)                                                                                                   
AS SELECT                                                                                           
CHANGED_BY                                                                                          
, COLUMN_REF                                                                                        
, COLUMN_STORAGE_FOR                                                                                
, COLUMN_STORAGE_TYPE                                                                               
, CQA_REF                                                                                           
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, IRID                                                                                              
, IRID                                                                                              
, IVID                                                                                              
, LOB_INDEX_NAME                                                                                    
, LOB_SEGMENT_NAME                                                                                  
, LOB_STORAGE_REF                                                                                   
, NOTM                                                                                              
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, STORAGE_DEFINITION_REF                                                                            
, STORAGE_TABLE_NAME                                                                                
, TABLESPACE_REF                                                                                    
, TABLE_IMPLEMENTATION_REF                                                                          
, TYPES                                                                                             
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
FROM  SDD_CST                                                                                       
WHERE TYPES IN (                                                                                    
4854                                                                                                
, 4851                                                                                              
, 4852                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_DATABASE_FILES(                                                           
AUTOEXTEND_FLAG                                                                                     
, CHANGED_BY                                                                                        
, CREATED_BY                                                                                        
, DATABASE_FILE_TYPE                                                                                
, DATAFILE_FOR                                                                                      
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, FILE_SIZE                                                                                         
, FILE_SIZE_UNIT                                                                                    
, FULL_PATHNAME                                                                                     
, GROUP_NUMBER                                                                                      
, ID                                                                                                
, IRID                                                                                              
, IVID                                                                                              
, MAXIMUM_SIZE                                                                                      
, MAXIMUM_SIZE_UNITS                                                                                
, NAME                                                                                              
, NEXT_AUTOEXTEND_AMOUNT                                                                            
, NEXT_AUTOEXTEND_UNITS                                                                             
, NUMBER_OF_TIMES_MODIFIED                                                                          
, ORACLE_DATABASE_REFERENCE                                                                         
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, REMARK                                                                                            
, REUSE_FLAG                                                                                        
, TABLESPACE_REFERENCE                                                                              
, TYPES                                                                                             
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
)                                                                                                   
AS SELECT                                                                                           
AUTOEXTEND_FLAG                                                                                     
, CHANGED_BY                                                                                        
, CREATED_BY                                                                                        
, DATABASE_FILE_TYPE                                                                                
, DATAFILE_FOR                                                                                      
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, FILE_SIZE                                                                                         
, FILE_SIZE_UNIT                                                                                    
, FULL_PATHNAME                                                                                     
, GROUP_NUMBER                                                                                      
, IRID                                                                                              
, IRID                                                                                              
, IVID                                                                                              
, MAXIMUM_SIZE                                                                                      
, MAXIMUM_SIZE_UNITS                                                                                
, NAME                                                                                              
, NEXT_AUTOEXTEND_AMOUNT                                                                            
, NEXT_AUTOEXTEND_UNITS                                                                             
, NOTM                                                                                              
, ORACLE_DATABASE_REF                                                                               
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, REMARK                                                                                            
, REUSE_FLAG                                                                                        
, TABLESPACE_REF                                                                                    
, TYPES                                                                                             
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
FROM  SDD_DFI                                                                                       
WHERE TYPES IN (                                                                                    
4925                                                                                                
, 4892                                                                                              
, 4893                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_DB_OBJECT_IMPLEMENTATIONS(                                                
BUILD_TYPE                                                                                          
, CACHED                                                                                            
, CACHE_VALUE                                                                                       
, CHANGED_BY                                                                                        
, CLASS_SOURCE_LOCATION                                                                             
, CLUSTER_REFERENCE                                                                                 
, COMPLETE_FLAG                                                                                     
, CREATED_BY                                                                                        
, CREATE_CLASS_FROM                                                                                 
, CYCLE                                                                                             
, DATABASE_USER_REFERENCE                                                                           
, DATABASE_USER_REFERENCE2                                                                          
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DEGREE                                                                                            
, DIRECTORY_REFERENCE                                                                               
, ELEMENT_TYPE_NAME                                                                                 
, FILENAME                                                                                          
, FORCE_FLAG                                                                                        
, GLOBAL_SYNONYM_NAME                                                                               
, ID                                                                                                
, INCREMENT_VALUE                                                                                   
, INITIAL_TRANSACTION                                                                               
, INSTANCES                                                                                         
, IRID                                                                                              
, IVID                                                                                              
, JAVA_MODULE_REFERENCE                                                                             
, LOCKING_SEQUENCE                                                                                  
, MAXIMUM_TRANSACTION                                                                               
, MAXIMUM_VALUE                                                                                     
, MINIMUM_VALUE                                                                                     
, NUMBER_OF_TIMES_MODIFIED                                                                          
, OBJECT_IMPLEMENTATION_TYPE                                                                        
, ORACLE_TYPE_DBU_REFERENCE                                                                         
, OVERFLOW_TABLESPACE_REFERENCE                                                                     
, PAC_REFERENCE                                                                                     
, PARALLEL                                                                                          
, PARENT_IVID                                                                                       
, PCTTHRESHOLD                                                                                      
, PERCENT_FREE                                                                                      
, PERCENT_USED                                                                                      
, PLSQL_MODULE_REFERENCE                                                                            
, QUERY_REWRITE_INDICATOR                                                                           
, QUEUE_TABLE_DEF_REFERENCE                                                                         
, REFRESH_NEXT                                                                                      
, REFRESH_START                                                                                     
, REFRESH_TYPE                                                                                      
, REPLICATION_GROUP_REFERENCE                                                                       
, RESOLVE_FLAG                                                                                      
, SCOPE                                                                                             
, SEQUENCE_REFERENCE                                                                                
, SNAPSHOT_DEFINITION_REFERENCE                                                                     
, SNAPSHOT_GROUP_REFERENCE                                                                          
, SNAPSHOT_LOG_FLAG                                                                                 
, SNAPSHOT_LOG_INIT_TRANS                                                                           
, SNAPSHOT_LOG_MAX_TRANS                                                                            
, SNAPSHOT_LOG_PERCENT_FREE                                                                         
, SNAPSHOT_LOG_PERCENT_USED                                                                         
, SNAP_LOG_STORAGE_REFERENCE                                                                        
, SNAP_LOG_TABLESPACE_REFERENCE                                                                     
, SORTING_ORDER                                                                                     
, START_VALUE                                                                                       
, STORAGE_DEFINITION_REFERENCE                                                                      
, TABLESPACE_REFERENCE                                                                              
, TABLE_DEFINITION_REFERENCE                                                                        
, TYPES                                                                                             
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
, USE_BLOB                                                                                          
, VIEW_DEFINITION_REFERENCE                                                                         
)                                                                                                   
AS SELECT                                                                                           
BUILD_TYPE                                                                                          
, CACHED                                                                                            
, CACHE_VALUE                                                                                       
, CHANGED_BY                                                                                        
, CLASS_SOURCE_LOCATION                                                                             
, CLUSTER_REF                                                                                       
, COMPLETE_FLAG                                                                                     
, CREATED_BY                                                                                        
, CREATE_CLASS_FROM                                                                                 
, CYCLE                                                                                             
, DATABASE_USER_REF                                                                                 
, DATABASE_USER_REF2                                                                                
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DEGREE                                                                                            
, DIRECTORY_REF                                                                                     
, ELEMENT_TYPE_NAME                                                                                 
, FILENAME                                                                                          
, FORCE_FLAG                                                                                        
, GLOBAL_SYNONYM_NAME                                                                               
, IRID                                                                                              
, INCREMENT_VALUE                                                                                   
, INITIAL_TRANSACTION                                                                               
, INSTANCES                                                                                         
, IRID                                                                                              
, IVID                                                                                              
, JAVA_MODULE_REF                                                                                   
, LOCKING_SEQUENCE                                                                                  
, MAXIMUM_TRANSACTION                                                                               
, MAXIMUM_VALUE                                                                                     
, MINIMUM_VALUE                                                                                     
, NOTM                                                                                              
, OBJECT_IMPLEMENTATION_TYPE                                                                        
, ORACLE_TYPE_DBU_REF                                                                               
, OVERFLOW_TABLESPACE_REF                                                                           
, PAC_REF                                                                                           
, PARALLEL                                                                                          
, PARENT_IVID                                                                                       
, PCTTHRESHOLD                                                                                      
, PERCENT_FREE                                                                                      
, PERCENT_USED                                                                                      
, PLSQL_MODULE_REF                                                                                  
, QUERY_REWRITE_INDICATOR                                                                           
, QUEUE_TABLE_DEF_REF                                                                               
, REFRESH_NEXT                                                                                      
, REFRESH_START                                                                                     
, REFRESH_TYPE                                                                                      
, REPLICATION_GROUP_REF                                                                             
, RESOLVE_FLAG                                                                                      
, SCOPE                                                                                             
, SEQUENCE_REF                                                                                      
, SNAPSHOT_DEFINITION_REF                                                                           
, SNAPSHOT_GROUP_REF                                                                                
, SNAPSHOT_LOG_FLAG                                                                                 
, SNAPSHOT_LOG_INIT_TRANS                                                                           
, SNAPSHOT_LOG_MAX_TRANS                                                                            
, SNAPSHOT_LOG_PERCENT_FREE                                                                         
, SNAPSHOT_LOG_PERCENT_USED                                                                         
, SNAP_LOG_STORAGE_REF                                                                              
, SNAP_LOG_TABLESPACE_REF                                                                           
, SORTING_ORDER                                                                                     
, START_VALUE                                                                                       
, STORAGE_DEFINITION_REF                                                                            
, TABLESPACE_REF                                                                                    
, TABLE_DEFINITION_REF                                                                              
, TYPES                                                                                             
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
, USE_BLOB                                                                                          
, VIEW_DEFINITION_REF                                                                               
FROM  SDD_DOI                                                                                       
WHERE TYPES IN (                                                                                    
4899                                                                                                
, 4901                                                                                              
, 4902                                                                                              
, 4903                                                                                              
, 4904                                                                                              
, 4905                                                                                              
, 4906                                                                                              
, 5063                                                                                              
, 5138                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_OS_FILES(                                                                 
ACCESS_METHOD                                                                                       
, BLOCK_SIZE                                                                                        
, CHANGED_BY                                                                                        
, CLUSTER_SIZE                                                                                      
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, FILE_SIZE                                                                                         
, FILE_TYPE                                                                                         
, FULL_PATHNAME                                                                                     
, ID                                                                                                
, IRID                                                                                              
, IVID                                                                                              
, LANGUAGE_REFERENCE                                                                                
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, ORGANIZATION                                                                                      
, OS_FILE_TYPE                                                                                      
, REMARK                                                                                            
, STORAGE_MEDIA                                                                                     
, TYPES                                                                                             
, UNIT                                                                                              
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
)                                                                                                   
AS SELECT                                                                                           
ACCESS_METHOD                                                                                       
, BLOCK_SIZE                                                                                        
, CHANGED_BY                                                                                        
, CLUSTER_SIZE                                                                                      
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, FILE_SIZE                                                                                         
, FILE_TYPE                                                                                         
, FULL_PATHNAME                                                                                     
, IRID                                                                                              
, IRID                                                                                              
, IVID                                                                                              
, LANGUAGE_REF                                                                                      
, NAME                                                                                              
, NOTM                                                                                              
, ORGANIZATION                                                                                      
, OS_FILE_TYPE                                                                                      
, REMARK                                                                                            
, STORAGE_MEDIA                                                                                     
, TYPES                                                                                             
, UNIT                                                                                              
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
FROM  SDD_FIL                                                                                       
WHERE TYPES IN (                                                                                    
5023                                                                                                
, 4923                                                                                              
, 4924                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_CONTAINER_ELEMENTS(                                                       
APPLICATION_TYPE                                                                                    
, AUTHOR                                                                                            
, AUTHORITY                                                                                         
, CHANGED_BY                                                                                        
, CLASSIFIER_REFERENCE                                                                              
, CODING_STANDARD_REFERENCE                                                                         
, "CONSTRAINTS"                                                                                      
, CONTAINER_SUBTYPE                                                                                 
, CREATED_BY                                                                                        
, DATAWAREHOUSE_FLAG                                                                                
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DEVELOPMENT_LEVEL                                                                                 
, DISPLAY_TITLE                                                                                     
, EJB_TARGET_FLAG                                                                                   
, ELEMENT_TYPE_NAME                                                                                 
, EXTERNAL_FLAG                                                                                     
, GENERATE_CLASSES_FLAG                                                                             
, GENERATE_IDL_FLAG                                                                                 
, GENERATE_METADATA_FLAG                                                                            
, ICON_FILE_REFERENCE                                                                               
, ID                                                                                                
, IMPLEMENTATION_TARGET                                                                             
, INSTANTIABLE_FLAG                                                                                 
, IRID                                                                                              
, IVID                                                                                              
, LANGUAGE_REFERENCE                                                                                
, METADATA_CLASS_NAME                                                                               
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, O8I_TARGET_FLAG                                                                                   
, OS_TIMESTAMP                                                                                      
, OWNING_USER                                                                                       
, PRIORITIES                                                                                        
, REMARK                                                                                            
, ROOT_FLAG                                                                                         
, SYSTEM_ELEMENT_FLAG                                                                               
, TRANSFORMER_STANDARD_REFERENCE                                                                    
, TYPE                                                                                              
, TYPES                                                                                             
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
, VISIBROKER_TARGET_FLAG                                                                            
)                                                                                                   
AS SELECT                                                                                           
APPLICATION_TYPE                                                                                    
, AUTHOR                                                                                            
, AUTHORITY                                                                                         
, CHANGED_BY                                                                                        
, CLASSIFIER_REF                                                                                    
, CODING_STANDARD_REF                                                                               
, CONSTRAINTS                                                                                       
, CONTAINER_SUBTYPE                                                                                 
, CREATED_BY                                                                                        
, DATAWAREHOUSE_FLAG                                                                                
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DEVELOPMENT_LEVEL                                                                                 
, DISPLAY_TITLE                                                                                     
, EJB_TARGET_FLAG                                                                                   
, ELEMENT_TYPE_NAME                                                                                 
, EXTERNAL_FLAG                                                                                     
, GENERATE_CLASSES_FLAG                                                                             
, GENERATE_IDL_FLAG                                                                                 
, GENERATE_METADATA_FLAG                                                                            
, ICON_FILE_REF                                                                                     
, IRID                                                                                              
, IMPLEMENTATION_TARGET                                                                             
, INSTANTIABLE_FLAG                                                                                 
, IRID                                                                                              
, IVID                                                                                              
, LANGUAGE_REF                                                                                      
, METADATA_CLASS_NAME                                                                               
, NAME                                                                                              
, NOTM                                                                                              
, O8I_TARGET_FLAG                                                                                   
, OS_TIMESTAMP                                                                                      
, OWNING_USER                                                                                       
, PRIORITIES                                                                                        
, REMARK                                                                                            
, ROOT_FLAG                                                                                         
, SYSTEM_ELEMENT_FLAG                                                                               
, TRANSFORMER_STANDARD_REF                                                                          
, TYPE                                                                                              
, TYPES                                                                                             
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
, VISIBROKER_TARGET_FLAG                                                                            
FROM  SDD_FOLDERS                                                                                   
WHERE TYPES IN (                                                                                    
4845                                                                                                
, 4842                                                                                              
, 4844                                                                                              
, 5009                                                                                              
, 5127                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_INDEXES(                                                                  
CHANGED_BY                                                                                          
, CLUSTER_REFERENCE                                                                                 
, COMPLETE_FLAG                                                                                     
, COMPUTE_STATISTICS_FLAG                                                                           
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, FOREIGN_KEY_REFERENCE                                                                             
, ID                                                                                                
, INDEX_TYPE                                                                                        
, IRID                                                                                              
, IVID                                                                                              
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, RELATION_INDEX_FOR                                                                                
, RELATION_INDEX_TYPE                                                                               
, REMARK                                                                                            
, SNAPSHOT_DEFINITION_REFERENCE                                                                     
, TABLE_DEFINITION_REFERENCE                                                                        
, TYPES                                                                                             
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
)                                                                                                   
AS SELECT                                                                                           
CHANGED_BY                                                                                          
, CLUSTER_REF                                                                                       
, COMPLETE_FLAG                                                                                     
, COMPUTE_STATISTICS_FLAG                                                                           
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, FOREIGN_KEY_REF                                                                                   
, IRID                                                                                              
, INDEX_TYPE                                                                                        
, IRID                                                                                              
, IVID                                                                                              
, NAME                                                                                              
, NOTM                                                                                              
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, RELATION_INDEX_FOR                                                                                
, RELATION_INDEX_TYPE                                                                               
, REMARK                                                                                            
, SNAPSHOT_DEFINITION_REF                                                                           
, TABLE_DEFINITION_REF                                                                              
, TYPES                                                                                             
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
FROM  SDD_IND                                                                                       
WHERE TYPES IN (                                                                                    
5029                                                                                                
, 4897                                                                                              
, 4898                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_INDEX_PARTITIONS(                                                         
CHANGED_BY                                                                                          
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, ID                                                                                                
, INDEX_PARTITION_TYPE                                                                              
, INDEX_STORAGE_REFERENCE                                                                           
, INITIAL_TRANSACTION                                                                               
, IRID                                                                                              
, IVID                                                                                              
, MAXIMUM_TRANSACTION                                                                               
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, PERCENT_FREE                                                                                      
, SEQUENCE_NUMBER                                                                                   
, STORAGE_DEFINITION_REFERENCE                                                                      
, TABLESPACE_REFERENCE                                                                              
, TABLE_PARTITION_REFERENCE                                                                         
, TYPES                                                                                             
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
, VALUE_LESS_THAN                                                                                   
)                                                                                                   
AS SELECT                                                                                           
CHANGED_BY                                                                                          
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, IRID                                                                                              
, INDEX_PARTITION_TYPE                                                                              
, INDEX_STORAGE_REF                                                                                 
, INITIAL_TRANSACTION                                                                               
, IRID                                                                                              
, IVID                                                                                              
, MAXIMUM_TRANSACTION                                                                               
, NAME                                                                                              
, NOTM                                                                                              
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, PERCENT_FREE                                                                                      
, SEQUENCE_NUMBER                                                                                   
, STORAGE_DEFINITION_REF                                                                            
, TABLESPACE_REF                                                                                    
, TABLE_PARTITION_REF                                                                               
, TYPES                                                                                             
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
, VALUE_LESS_THAN                                                                                   
FROM  SDD_INP                                                                                       
WHERE TYPES IN (                                                                                    
4888                                                                                                
, 4884                                                                                              
, 4886                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_INDEX_STORAGES(                                                           
CHANGED_BY                                                                                          
, CLUSTER_REFERENCE                                                                                 
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DEGREE                                                                                            
, ELEMENT_TYPE_NAME                                                                                 
, ID                                                                                                
, IMPLICIT_INDEX_TYPE                                                                               
, INDEX_REFERENCE                                                                                   
, INDEX_STORAGE_IMPLEMENTING                                                                        
, INDEX_STORAGE_ON                                                                                  
, INDEX_STORAGE_SUBTYPE                                                                             
, INDEX_STORAGE_TYPE                                                                                
, INITIAL_TRANSACTION                                                                               
, INSTANCES                                                                                         
, IRID                                                                                              
, IVID                                                                                              
, MAXIMUM_TRANSACTION                                                                               
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, PAC_REFERENCE                                                                                     
, PARALLEL                                                                                          
, PARENT_IVID                                                                                       
, PERCENT_FREE                                                                                      
, PRIMARY_KEY_REFERENCE                                                                             
, REVERSE_OR_NOSORT                                                                                 
, SNAPSHOT_REFERENCE                                                                                
, STORAGE_DEFINITION_REFERENCE                                                                      
, TABLESPACE_REFERENCE                                                                              
, TABLE_IMPLEMENTATION_REFERENCE                                                                    
, TYPES                                                                                             
, UNIQUE_KEY_REFERENCE                                                                              
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
)                                                                                                   
AS SELECT                                                                                           
CHANGED_BY                                                                                          
, CLUSTER_REF                                                                                       
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DEGREE                                                                                            
, ELEMENT_TYPE_NAME                                                                                 
, IRID                                                                                              
, IMPLICIT_INDEX_TYPE                                                                               
, INDEX_REF                                                                                         
, INDEX_STORAGE_IMPLEMENTING                                                                        
, INDEX_STORAGE_ON                                                                                  
, INDEX_STORAGE_SUBTYPE                                                                             
, INDEX_STORAGE_TYPE                                                                                
, INITIAL_TRANSACTION                                                                               
, INSTANCES                                                                                         
, IRID                                                                                              
, IVID                                                                                              
, MAXIMUM_TRANSACTION                                                                               
, NAME                                                                                              
, NOTM                                                                                              
, PAC_REF                                                                                           
, PARALLEL                                                                                          
, PARENT_IVID                                                                                       
, PERCENT_FREE                                                                                      
, PRIMARY_KEY_REF                                                                                   
, REVERSE_OR_NOSORT                                                                                 
, SNAPSHOT_REF                                                                                      
, STORAGE_DEFINITION_REF                                                                            
, TABLESPACE_REF                                                                                    
, TABLE_IMPLEMENTATION_REF                                                                          
, TYPES                                                                                             
, UNIQUE_KEY_REF                                                                                    
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
FROM  SDD_INS                                                                                       
WHERE TYPES IN (                                                                                    
4900                                                                                                
, 4849                                                                                              
, 4850                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_ITEMS(                                                                    
ALIGN_PROMPT_FLAG                                                                                   
, CHANGED_BY                                                                                        
, COLUMN_REFERENCE                                                                                  
, CONTEXT_FLAG                                                                                      
, CONTEXT_OPTION_QUERY_FLAG                                                                         
, CREATED_BY                                                                                        
, DATATYPE                                                                                          
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DEFAULT_VALUE                                                                                     
, DEFAULT_VALUE_TYPE                                                                                
, DETAIL_TABLE_USAGE_REFERENCE                                                                      
, DISPLAY_FLAG                                                                                      
, DISPLAY_FORMAT                                                                                    
, DISPLAY_HEIGHT                                                                                    
, DISPLAY_TYPE                                                                                      
, DISPLAY_WIDTH                                                                                     
, DOMAIN_REFERENCE                                                                                  
, ELEMENT_TYPE_NAME                                                                                 
, END_TAB                                                                                           
, HELP_CONTEXT_ID_SUFFIX                                                                            
, HIGHLIGHTING                                                                                      
, HINT_TEXT                                                                                         
, ID                                                                                                
, IMPLEMENTATION_ITEM                                                                               
, INSERT_FLAG                                                                                       
, IRID                                                                                              
, ITEM_FOR                                                                                          
, ITEM_GROUP_REFERENCE                                                                              
, ITEM_TYPE                                                                                         
, IVID                                                                                              
, JUSTIFICATION                                                                                     
, MAXIMUM_LENGTH                                                                                    
, MODULE_UNIT_REFERENCE                                                                             
, NAME                                                                                              
, NULLIFY_FLAG                                                                                      
, NUMBER_OF_TIMES_MODIFIED                                                                          
, ORDER_SEQUENCE                                                                                    
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, PROMPT                                                                                            
, RANGE_SEARCH_FLAG                                                                                 
, REMARK                                                                                            
, RESET_GROUP                                                                                       
, RESET_LEVEL                                                                                       
, SELECT_FLAG                                                                                       
, SHOW_MEANING                                                                                      
, SOFT_LOV                                                                                          
, SORTING_ORDER                                                                                     
, SQL_QUERY_SET_REFERENCE                                                                           
, START_TAB                                                                                         
, TRUNCATE_FLAG                                                                                     
, TYPES                                                                                             
, UNBOUND_TYPE                                                                                      
, UPDATE_FLAG                                                                                       
, USAGE_SEQUENCE                                                                                    
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
)                                                                                                   
AS SELECT                                                                                           
ALIGN_PROMPT_FLAG                                                                                   
, CHANGED_BY                                                                                        
, COLUMN_REF                                                                                        
, CONTEXT_FLAG                                                                                      
, CONTEXT_OPTION_QUERY_FLAG                                                                         
, CREATED_BY                                                                                        
, DATATYPE                                                                                          
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DEFAULT_VALUE                                                                                     
, DEFAULT_VALUE_TYPE                                                                                
, DETAIL_TABLE_USAGE_REF                                                                            
, DISPLAY_FLAG                                                                                      
, DISPLAY_FORMAT                                                                                    
, DISPLAY_HEIGHT                                                                                    
, DISPLAY_TYPE                                                                                      
, DISPLAY_WIDTH                                                                                     
, DOMAIN_REF                                                                                        
, ELEMENT_TYPE_NAME                                                                                 
, END_TAB                                                                                           
, HELP_CONTEXT_ID_SUFFIX                                                                            
, HIGHLIGHTING                                                                                      
, HINT_TEXT                                                                                         
, IRID                                                                                              
, IMPLEMENTATION_ITEM                                                                               
, INSERT_FLAG                                                                                       
, IRID                                                                                              
, ITEM_FOR                                                                                          
, ITEM_GROUP_REF                                                                                    
, ITEM_TYPE                                                                                         
, IVID                                                                                              
, JUSTIFICATION                                                                                     
, MAXIMUM_LENGTH                                                                                    
, MODULE_UNIT_REF                                                                                   
, NAME                                                                                              
, NULLIFY_FLAG                                                                                      
, NOTM                                                                                              
, ORDER_SEQUENCE                                                                                    
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, PROMPT                                                                                            
, RANGE_SEARCH_FLAG                                                                                 
, REMARK                                                                                            
, RESET_GROUP                                                                                       
, RESET_LEVEL                                                                                       
, SELECT_FLAG                                                                                       
, SHOW_MEANING                                                                                      
, SOFT_LOV                                                                                          
, SORTING_ORDER                                                                                     
, SQL_QUERY_SET_REF                                                                                 
, START_TAB                                                                                         
, TRUNCATE_FLAG                                                                                     
, TYPES                                                                                             
, UNBOUND_TYPE                                                                                      
, UPDATE_FLAG                                                                                       
, USAGE_SEQUENCE                                                                                    
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
FROM  SDD_ITE                                                                                       
WHERE TYPES IN (                                                                                    
4997                                                                                                
, 4916                                                                                              
, 4917                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_MODULE_COMPONENT_LINKS(                                                   
CHANGED_BY                                                                                          
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, FK_ON_FROM_COMPONENT_FLAG                                                                         
, ID                                                                                                
, IRID                                                                                              
, IVID                                                                                              
, JOIN_CONSTRAINT_REFERENCE                                                                         
, KEY_BASED_LINK_VIA                                                                                
, MCN_REFERENCE_FROM                                                                                
, MCN_REFERENCE_TO                                                                                  
, MODULE_COMPONENT_LINK_TYPE                                                                        
, MODULE_REFERENCE_FROM                                                                             
, MODULE_REFERENCE_TO                                                                               
, NUMBER_OF_TIMES_MODIFIED                                                                          
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, PRIMARY_KEY_REFERENCE                                                                             
, SQL_QUERY_CLAUSE                                                                                  
, TABLE_USAGE_REFERENCE_FROM                                                                        
, TABLE_USAGE_REFERENCE_TO                                                                          
, TYPES                                                                                             
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
)                                                                                                   
AS SELECT                                                                                           
CHANGED_BY                                                                                          
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, FK_ON_FROM_COMPONENT_FLAG                                                                         
, IRID                                                                                              
, IRID                                                                                              
, IVID                                                                                              
, JOIN_CONSTRAINT_REF                                                                               
, KEY_BASED_LINK_VIA                                                                                
, MCN_REF_FROM                                                                                      
, MCN_REF_TO                                                                                        
, MODULE_COMPONENT_LINK_TYPE                                                                        
, MODULE_REF_FROM                                                                                   
, MODULE_REF_TO                                                                                     
, NOTM                                                                                              
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, PRIMARY_KEY_REF                                                                                   
, SQL_QUERY_CLAUSE                                                                                  
, TABLE_USAGE_REF_FROM                                                                              
, TABLE_USAGE_REF_TO                                                                                
, TYPES                                                                                             
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
FROM  SDD_MCL                                                                                       
WHERE TYPES IN (                                                                                    
4909                                                                                                
, 4910                                                                                              
, 5059                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_MODULES(                                                                  
ACTIVITY_CODE                                                                                       
, BOTTOM_TITLE                                                                                      
, CANDIDATE_FLAG                                                                                    
, CHANGED_BY                                                                                        
, COMMAND_LINE                                                                                      
, COMPLETION_STATUS                                                                                 
, COMPLEXITY                                                                                        
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, ESTIMATE                                                                                          
, ESTIMATE_UNITS                                                                                    
, FORMAT                                                                                            
, FREE_FORMAT_TEXT_FLAG                                                                             
, GENERAL_MODULE_TYPE                                                                               
, HELP_CONTEXT_ID_PREFIX                                                                            
, HELP_FILE_NAME                                                                                    
, HELP_GRAPHIC_FILE_NAME                                                                            
, ID                                                                                                
, IMPLEMENTATION_NAME                                                                               
, IRID                                                                                              
, IVID                                                                                              
, JAVA_METHOD                                                                                       
, JAVA_MODULE_REFERENCE                                                                             
, JAVA_MODULE_TYPE                                                                                  
, JAVA_PARAMETER_LIST                                                                               
, JAVA_RETURN_TYPE                                                                                  
, LANGUAGE_REFERENCE                                                                                
, MODULE_TYPE                                                                                       
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, ORACLE_OBJECT_TYPE_REFERENCE                                                                      
, ORACLE_TYPE_REFERENCE                                                                             
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, PLSQL_MODULE_TYPE                                                                                 
, PREVENT_GENERATION_FLAG                                                                           
, PROJECT_CODE                                                                                      
, PURPOSE                                                                                           
, REPEATABLE_FLAG                                                                                   
, RETURN_TYPE                                                                                       
, RNDS_FLAG                                                                                         
, RNPS_FLAG                                                                                         
, RUNTIME_PATHNAME                                                                                  
, SCOPE                                                                                             
, SHORT_NAME                                                                                        
, SHORT_TITLE                                                                                       
, SIZE_OF_MODULE                                                                                    
, SOURCE_PATHNAME                                                                                   
, TASK_CODE                                                                                         
, TOP_LEVEL_FLAG                                                                                    
, TOP_TITLE                                                                                         
, TYPES                                                                                             
, TYPE_MEMBER_ORDERING                                                                              
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
, WNDS_FLAG                                                                                         
, WNPS_FLAG                                                                                         
)                                                                                                   
AS SELECT                                                                                           
ACTIVITY_CODE                                                                                       
, BOTTOM_TITLE                                                                                      
, CANDIDATE_FLAG                                                                                    
, CHANGED_BY                                                                                        
, COMMAND_LINE                                                                                      
, COMPLETION_STATUS                                                                                 
, COMPLEXITY                                                                                        
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, ESTIMATE                                                                                          
, ESTIMATE_UNITS                                                                                    
, FORMAT                                                                                            
, FREE_FORMAT_TEXT_FLAG                                                                             
, GENERAL_MODULE_TYPE                                                                               
, HELP_CONTEXT_ID_PREFIX                                                                            
, HELP_FILE_NAME                                                                                    
, HELP_GRAPHIC_FILE_NAME                                                                            
, IRID                                                                                              
, IMPLEMENTATION_NAME                                                                               
, IRID                                                                                              
, IVID                                                                                              
, JAVA_METHOD                                                                                       
, JAVA_MODULE_REF                                                                                   
, JAVA_MODULE_TYPE                                                                                  
, JAVA_PARAMETER_LIST                                                                               
, JAVA_RETURN_TYPE                                                                                  
, LANGUAGE_REF                                                                                      
, MODULE_TYPE                                                                                       
, NAME                                                                                              
, NOTM                                                                                              
, ORACLE_OBJECT_TYPE_REF                                                                            
, ORACLE_TYPE_REF                                                                                   
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, PLSQL_MODULE_TYPE                                                                                 
, PREVENT_GENERATION_FLAG                                                                           
, PROJECT_CODE                                                                                      
, PURPOSE                                                                                           
, REPEATABLE_FLAG                                                                                   
, RETURN_TYPE                                                                                       
, RNDS_FLAG                                                                                         
, RNPS_FLAG                                                                                         
, RUNTIME_PATHNAME                                                                                  
, SCOPE                                                                                             
, SHORT_NAME                                                                                        
, SHORT_TITLE                                                                                       
, SIZE_OF_MODULE                                                                                    
, SOURCE_PATHNAME                                                                                   
, TASK_CODE                                                                                         
, TOP_LEVEL_FLAG                                                                                    
, TOP_TITLE                                                                                         
, TYPES                                                                                             
, TYPE_MEMBER_ORDERING                                                                              
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
, WNDS_FLAG                                                                                         
, WNPS_FLAG                                                                                         
FROM  SDD_MOD                                                                                       
WHERE TYPES IN (                                                                                    
5022                                                                                                
, 4907                                                                                              
, 4908                                                                                              
, 5062                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_LISTS_OF_VALUES(                                                          
CHANGED_BY                                                                                          
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DISPLAY_TITLE                                                                                     
, ELEMENT_TYPE_NAME                                                                                 
, GENERAL_MODULE_REFERENCE                                                                          
, HELP_CONTEXT_ID_PREFIX                                                                            
, ID                                                                                                
, IMPLEMENTATION_ITEM                                                                               
, IRID                                                                                              
, IVID                                                                                              
, LAYOUT_STYLE                                                                                      
, MODULE_UNIT_SUBTYPE                                                                               
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, REQ_PAGE_HEIGHT                                                                                   
, REQ_PAGE_WIDTH                                                                                    
, ROWS_DISPLAYED                                                                                    
, SHORT_DESCRIPTION                                                                                 
, TYPES                                                                                             
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
)                                                                                                   
AS SELECT                                                                                           
CHANGED_BY                                                                                          
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DISPLAY_TITLE                                                                                     
, ELEMENT_TYPE_NAME                                                                                 
, GENERAL_MODULE_REF                                                                                
, HELP_CONTEXT_ID_PREFIX                                                                            
, IRID                                                                                              
, IMPLEMENTATION_ITEM                                                                               
, IRID                                                                                              
, IVID                                                                                              
, LAYOUT_STYLE                                                                                      
, MODULE_UNIT_SUBTYPE                                                                               
, NAME                                                                                              
, NOTM                                                                                              
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, REQ_PAGE_HEIGHT                                                                                   
, REQ_PAGE_WIDTH                                                                                    
, ROWS_DISPLAYED                                                                                    
, SHORT_DESCRIPTION                                                                                 
, TYPES                                                                                             
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
FROM  SDD_MUN                                                                                       
WHERE TYPES IN (                                                                                    
5054                                                                                                
, 5055                                                                                              
, 5056                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_MODULE_UNITS(                                                             
AUTOQUERY_FLAG                                                                                      
, CHANGED_BY                                                                                        
, CREATED_BY                                                                                        
, DATASOURCE_TYPE                                                                                   
, DATATARGET_TYPE                                                                                   
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DELETE_FLAG                                                                                       
, DISPLAY_TITLE                                                                                     
, ELEMENT_TYPE_NAME                                                                                 
, GENERAL_MODULE_REFERENCE                                                                          
, HELP_CONTEXT_ID_PREFIX                                                                            
, HELP_CONTEXT_ID_SUFFIX                                                                            
, ID                                                                                                
, IMPLEMENTATION_ITEM                                                                               
, INSERT_FLAG                                                                                       
, IRID                                                                                              
, IVID                                                                                              
, LANGUAGE_REFERENCE                                                                                
, LAYOUT_STYLE                                                                                      
, MODULE_COMPONENT_REFERENCE                                                                        
, MODULE_LEVEL_FLAG                                                                                 
, MODULE_UNIT_SUBTYPE                                                                               
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, REQ_OVERFLOW                                                                                      
, REQ_PAGE_HEIGHT                                                                                   
, REQ_PAGE_WIDTH                                                                                    
, REQ_VIEW_HEIGHT                                                                                   
, REQ_VIEW_WIDTH                                                                                    
, ROWS_DISPLAYED                                                                                    
, RUNTIME_PATHNAME                                                                                  
, SELECT_FLAG                                                                                       
, SHORT_DESCRIPTION                                                                                 
, TYPES                                                                                             
, UPDATE_FLAG                                                                                       
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
)                                                                                                   
AS SELECT                                                                                           
AUTOQUERY_FLAG                                                                                      
, CHANGED_BY                                                                                        
, CREATED_BY                                                                                        
, DATASOURCE_TYPE                                                                                   
, DATATARGET_TYPE                                                                                   
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DELETE_FLAG                                                                                       
, DISPLAY_TITLE                                                                                     
, ELEMENT_TYPE_NAME                                                                                 
, GENERAL_MODULE_REF                                                                                
, HELP_CONTEXT_ID_PREFIX                                                                            
, HELP_CONTEXT_ID_SUFFIX                                                                            
, IRID                                                                                              
, IMPLEMENTATION_ITEM                                                                               
, INSERT_FLAG                                                                                       
, IRID                                                                                              
, IVID                                                                                              
, LANGUAGE_REF                                                                                      
, LAYOUT_STYLE                                                                                      
, MODULE_COMPONENT_REF                                                                              
, MODULE_LEVEL_FLAG                                                                                 
, MODULE_UNIT_SUBTYPE                                                                               
, NAME                                                                                              
, NOTM                                                                                              
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, REQ_OVERFLOW                                                                                      
, REQ_PAGE_HEIGHT                                                                                   
, REQ_PAGE_WIDTH                                                                                    
, REQ_VIEW_HEIGHT                                                                                   
, REQ_VIEW_WIDTH                                                                                    
, ROWS_DISPLAYED                                                                                    
, RUNTIME_PATHNAME                                                                                  
, SELECT_FLAG                                                                                       
, SHORT_DESCRIPTION                                                                                 
, TYPES                                                                                             
, UPDATE_FLAG                                                                                       
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
FROM  SDD_MUN                                                                                       
WHERE TYPES IN (                                                                                    
5051                                                                                                
, 4920                                                                                              
, 5052                                                                                              
, 5053                                                                                              
, 5054                                                                                              
, 5055                                                                                              
, 5056                                                                                              
, 5057                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_MODULE_COMPONENTS(                                                        
AUTOQUERY_FLAG                                                                                      
, CHANGED_BY                                                                                        
, CREATED_BY                                                                                        
, DATASOURCE_TYPE                                                                                   
, DATATARGET_TYPE                                                                                   
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DELETE_FLAG                                                                                       
, DISPLAY_TITLE                                                                                     
, ELEMENT_TYPE_NAME                                                                                 
, GENERAL_MODULE_REFERENCE                                                                          
, HELP_CONTEXT_ID_PREFIX                                                                            
, HELP_CONTEXT_ID_SUFFIX                                                                            
, ID                                                                                                
, IMPLEMENTATION_ITEM                                                                               
, INSERT_FLAG                                                                                       
, IRID                                                                                              
, IVID                                                                                              
, LANGUAGE_REFERENCE                                                                                
, LAYOUT_STYLE                                                                                      
, MODULE_LEVEL_FLAG                                                                                 
, MODULE_UNIT_SUBTYPE                                                                               
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, REQ_OVERFLOW                                                                                      
, REQ_PAGE_HEIGHT                                                                                   
, REQ_PAGE_WIDTH                                                                                    
, REQ_VIEW_HEIGHT                                                                                   
, REQ_VIEW_WIDTH                                                                                    
, ROWS_DISPLAYED                                                                                    
, RUNTIME_PATHNAME                                                                                  
, SELECT_FLAG                                                                                       
, SHORT_DESCRIPTION                                                                                 
, TYPES                                                                                             
, UPDATE_FLAG                                                                                       
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
)                                                                                                   
AS SELECT                                                                                           
AUTOQUERY_FLAG                                                                                      
, CHANGED_BY                                                                                        
, CREATED_BY                                                                                        
, DATASOURCE_TYPE                                                                                   
, DATATARGET_TYPE                                                                                   
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DELETE_FLAG                                                                                       
, DISPLAY_TITLE                                                                                     
, ELEMENT_TYPE_NAME                                                                                 
, GENERAL_MODULE_REF                                                                                
, HELP_CONTEXT_ID_PREFIX                                                                            
, HELP_CONTEXT_ID_SUFFIX                                                                            
, IRID                                                                                              
, IMPLEMENTATION_ITEM                                                                               
, INSERT_FLAG                                                                                       
, IRID                                                                                              
, IVID                                                                                              
, LANGUAGE_REF                                                                                      
, LAYOUT_STYLE                                                                                      
, MODULE_LEVEL_FLAG                                                                                 
, MODULE_UNIT_SUBTYPE                                                                               
, NAME                                                                                              
, NOTM                                                                                              
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, REQ_OVERFLOW                                                                                      
, REQ_PAGE_HEIGHT                                                                                   
, REQ_PAGE_WIDTH                                                                                    
, REQ_VIEW_HEIGHT                                                                                   
, REQ_VIEW_WIDTH                                                                                    
, ROWS_DISPLAYED                                                                                    
, RUNTIME_PATHNAME                                                                                  
, SELECT_FLAG                                                                                       
, SHORT_DESCRIPTION                                                                                 
, TYPES                                                                                             
, UPDATE_FLAG                                                                                       
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
FROM  SDD_MUN                                                                                       
WHERE TYPES IN (                                                                                    
4920                                                                                                
, 5052                                                                                              
, 5053                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_CONSTRAINTS(                                                              
ARC_MANDATORY                                                                                       
, ARC_NUMBER                                                                                        
, CHANGED_BY                                                                                        
, CHECK_CONSTRAINT_TYPE                                                                             
, CLIENT_ENFORCE_WHEN_NULL_FLAG                                                                     
, COMPLETE_FLAG                                                                                     
, CONSTRAINT_TYPE                                                                                   
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DEFER_STATUS                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, ENABLED_FLAG                                                                                      
, ERROR_MESSAGE                                                                                     
, EXCEPTION_TABLE                                                                                   
, FK_CASCADE_DELETE                                                                                 
, FK_CASCADE_UPDATE                                                                                 
, FK_TRANSFERABLE                                                                                   
, FOREIGN_TABLE_REFERENCE                                                                           
, FOR_JOINING_TO                                                                                    
, ID                                                                                                
, IMPLEMENTATION_LEVEL                                                                              
, IRID                                                                                              
, IVID                                                                                              
, KEY_UPDATEABLE                                                                                    
, MANDATORY_FLAG                                                                                    
, NAME                                                                                              
, NULL_IS_DISCRETE_VALUE_FLAG                                                                       
, NUMBER_OF_TIMES_MODIFIED                                                                          
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, PRIMARY_KEY_REFERENCE                                                                             
, RELATIONSHIP_END_REFERENCE                                                                        
, REMARK                                                                                            
, TABLE_REFERENCE                                                                                   
, TYPES                                                                                             
, UNIQUE_IDENTIFIER_REFERENCE                                                                       
, UNIQUE_KEY_REFERENCE                                                                              
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
)                                                                                                   
AS SELECT                                                                                           
ARC_MANDATORY                                                                                       
, ARC_NUMBER                                                                                        
, CHANGED_BY                                                                                        
, CHECK_CONSTRAINT_TYPE                                                                             
, CLIENT_ENFORCE_WHEN_NULL_FLAG                                                                     
, COMPLETE_FLAG                                                                                     
, CONSTRAINT_TYPE                                                                                   
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DEFER_STATUS                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, ENABLED_FLAG                                                                                      
, ERROR_MESSAGE                                                                                     
, EXCEPTION_TABLE                                                                                   
, FK_CASCADE_DELETE                                                                                 
, FK_CASCADE_UPDATE                                                                                 
, FK_TRANSFERABLE                                                                                   
, FOREIGN_TABLE_REF                                                                                 
, FOR_JOINING_TO                                                                                    
, IRID                                                                                              
, IMPLEMENTATION_LEVEL                                                                              
, IRID                                                                                              
, IVID                                                                                              
, KEY_UPDATEABLE                                                                                    
, MANDATORY_FLAG                                                                                    
, NAME                                                                                              
, NULL_IS_DISCRETE_VALUE_FLAG                                                                       
, NOTM                                                                                              
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, PRIMARY_KEY_REF                                                                                   
, RELATIONSHIP_END_REF                                                                              
, REMARK                                                                                            
, TABLE_REF                                                                                         
, TYPES                                                                                             
, UNIQUE_IDENTIFIER_REF                                                                             
, UNIQUE_KEY_REF                                                                                    
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
FROM  SDD_OCO                                                                                       
WHERE TYPES IN (                                                                                    
5027                                                                                                
, 4970                                                                                              
, 4971                                                                                              
, 4972                                                                                              
, 4973                                                                                              
, 5060                                                                                              
, 5061                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_JOIN_CONSTRAINTS(                                                         
ARC_MANDATORY                                                                                       
, ARC_NUMBER                                                                                        
, CHANGED_BY                                                                                        
, COMPLETE_FLAG                                                                                     
, CONSTRAINT_TYPE                                                                                   
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DEFER_STATUS                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, ENABLED_FLAG                                                                                      
, ERROR_MESSAGE                                                                                     
, EXCEPTION_TABLE                                                                                   
, FK_CASCADE_DELETE                                                                                 
, FK_CASCADE_UPDATE                                                                                 
, FK_TRANSFERABLE                                                                                   
, FOREIGN_TABLE_REFERENCE                                                                           
, FOR_JOINING_TO                                                                                    
, ID                                                                                                
, IMPLEMENTATION_LEVEL                                                                              
, IRID                                                                                              
, IVID                                                                                              
, MANDATORY_FLAG                                                                                    
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, PRIMARY_KEY_REFERENCE                                                                             
, RELATIONSHIP_END_REFERENCE                                                                        
, TABLE_REFERENCE                                                                                   
, TYPES                                                                                             
, UNIQUE_KEY_REFERENCE                                                                              
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
)                                                                                                   
AS SELECT                                                                                           
ARC_MANDATORY                                                                                       
, ARC_NUMBER                                                                                        
, CHANGED_BY                                                                                        
, COMPLETE_FLAG                                                                                     
, CONSTRAINT_TYPE                                                                                   
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DEFER_STATUS                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, ENABLED_FLAG                                                                                      
, ERROR_MESSAGE                                                                                     
, EXCEPTION_TABLE                                                                                   
, FK_CASCADE_DELETE                                                                                 
, FK_CASCADE_UPDATE                                                                                 
, FK_TRANSFERABLE                                                                                   
, FOREIGN_TABLE_REF                                                                                 
, FOR_JOINING_TO                                                                                    
, IRID                                                                                              
, IMPLEMENTATION_LEVEL                                                                              
, IRID                                                                                              
, IVID                                                                                              
, MANDATORY_FLAG                                                                                    
, NAME                                                                                              
, NOTM                                                                                              
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, PRIMARY_KEY_REF                                                                                   
, RELATIONSHIP_END_REF                                                                              
, TABLE_REF                                                                                         
, TYPES                                                                                             
, UNIQUE_KEY_REF                                                                                    
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
FROM  SDD_OCO                                                                                       
WHERE TYPES IN (                                                                                    
4971                                                                                                
, 5060                                                                                              
, 5061                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_DATABASES(                                                                
ARCHIVE_REDO_LOG_FILES                                                                              
, CHANGED_BY                                                                                        
, CHARACTER_SET                                                                                     
, COMPLETE_FLAG                                                                                     
, CONNECT_STRING                                                                                    
, CREATED_BY                                                                                        
, DATABASE_TYPE                                                                                     
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DB_VERSION                                                                                        
, ELEMENT_TYPE_NAME                                                                                 
, ID                                                                                                
, IRID                                                                                              
, IVID                                                                                              
, LOCAL_NAME                                                                                        
, MAX_DATABASE_INSTANCES                                                                            
, MAX_DATA_FILES                                                                                    
, MAX_LOG_FILES                                                                                     
, MAX_LOG_HISTORY                                                                                   
, MAX_LOG_MEMBERS                                                                                   
, NAME                                                                                              
, NODE_REFERENCE                                                                                    
, NON_ORACLE_DATABASE_TYPE                                                                          
, NUMBER_OF_TIMES_MODIFIED                                                                          
, REMARK                                                                                            
, REUSE_CONTROL_FILE                                                                                
, SHARED_FLAG                                                                                       
, TNS_ALIAS                                                                                         
, TYPES                                                                                             
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
)                                                                                                   
AS SELECT                                                                                           
ARCHIVE_REDO_LOG_FILES                                                                              
, CHANGED_BY                                                                                        
, CHARACTER_SET                                                                                     
, COMPLETE_FLAG                                                                                     
, CONNECT_STRING                                                                                    
, CREATED_BY                                                                                        
, DATABASE_TYPE                                                                                     
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DB_VERSION                                                                                        
, ELEMENT_TYPE_NAME                                                                                 
, IRID                                                                                              
, IRID                                                                                              
, IVID                                                                                              
, LOCAL_NAME                                                                                        
, MAX_DATABASE_INSTANCES                                                                            
, MAX_DATA_FILES                                                                                    
, MAX_LOG_FILES                                                                                     
, MAX_LOG_HISTORY                                                                                   
, MAX_LOG_MEMBERS                                                                                   
, NAME                                                                                              
, NODE_REF                                                                                          
, NON_ORACLE_DATABASE_TYPE                                                                          
, NOTM                                                                                              
, REMARK                                                                                            
, REUSE_CONTROL_FILE                                                                                
, SHARED_FLAG                                                                                       
, TNS_ALIAS                                                                                         
, TYPES                                                                                             
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
FROM  SDD_ODB                                                                                       
WHERE TYPES IN (                                                                                    
4927                                                                                                
, 4926                                                                                              
, 4993                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_ORACLE_TYPES(                                                             
CHANGED_BY                                                                                          
, COLLECTION_OF                                                                                     
, COLLECTION_TYPE                                                                                   
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, ID                                                                                                
, IRID                                                                                              
, IVID                                                                                              
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, OBJECT_REF_FLAG                                                                                   
, ORACLE_OBJECT_TYPE_REFERENCE                                                                      
, ORT_TYPE                                                                                          
, REMARK                                                                                            
, SCALAR_DATATYPE                                                                                   
, SCALAR_DECIMAL_PLACES                                                                             
, SCALAR_MAXIMUM_LENGTH                                                                             
, TYPES                                                                                             
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
, VARRAY_LIMIT                                                                                      
)                                                                                                   
AS SELECT                                                                                           
CHANGED_BY                                                                                          
, COLLECTION_OF                                                                                     
, COLLECTION_TYPE                                                                                   
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, IRID                                                                                              
, IRID                                                                                              
, IVID                                                                                              
, NAME                                                                                              
, NOTM                                                                                              
, OBJECT_REF_FLAG                                                                                   
, ORACLE_OBJECT_TYPE_REF                                                                            
, ORT_TYPE                                                                                          
, REMARK                                                                                            
, SCALAR_DATATYPE                                                                                   
, SCALAR_DECIMAL_PLACES                                                                             
, SCALAR_MAXIMUM_LENGTH                                                                             
, TYPES                                                                                             
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
, VARRAY_LIMIT                                                                                      
FROM  SDD_ORT                                                                                       
WHERE TYPES IN (                                                                                    
4858                                                                                                
, 4853                                                                                              
, 4855                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_PROJECT_STANDARDS(                                                        
ASSOCIATION_NAME_PREFIX                                                                             
, ASSOCIATION_NAME_SUFFIX                                                                           
, CHANGED_BY                                                                                        
, CLASS_NAME_PREFIX                                                                                 
, CLASS_NAME_SUFFIX                                                                                 
, COLUMN_PREFIX                                                                                     
, CREATED_BY                                                                                        
, CREATE_RTL_PK_COLS_FLAG                                                                           
, DATA_MEMBER_NAME_PREFIX                                                                           
, DATA_MEMBER_NAME_SUFFIX                                                                           
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DISCRIMINATOR_COLUMN_SUFFIX                                                                       
, ELEMENT_TYPE_NAME                                                                                 
, FK_CONSTRAINT_SUFFIX                                                                              
, GENERATE_ACCESSORS_FLAG                                                                           
, GENERATE_COMMENTS_FLAG                                                                            
, GENERATE_CREATE_METHOD_FLAG                                                                       
, GENERATE_DML_METHODS_FLAG                                                                         
, GENERATE_JAVA_IMP_STMTS_FLAG                                                                      
, GENERATE_REMOVE_METHOD_FLAG                                                                       
, GENERATE_TS_COLL_CLASS_FLAG                                                                       
, ID                                                                                                
, IMPLEMENTATION_TARGET                                                                             
, IRID                                                                                              
, IVID                                                                                              
, MM_ASSOC_IMPLEMENTATION                                                                           
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, ORACLE_ATT_PREFIX_FOR_ASS_ENDS                                                                    
, ORACLE_COLLECTION_TYPE_PREFIX                                                                     
, ORACLE_TYPE_SUFFIX                                                                                
, PK_CONSTRAINT_SUFFIX                                                                              
, PROJECT_STANDARD_SUBTYPE                                                                          
, SEQUENCE_SUFFIX                                                                                   
, SURROGATE_PK_COLUMN_SUFFIX                                                                        
, TABLE_PREFIX                                                                                      
, TYPES                                                                                             
, UK_CONSTRAINT_SUFFIX                                                                              
, UPDATE_SERVER_MODEL_FLAG                                                                          
)                                                                                                   
AS SELECT                                                                                           
ASSOCIATION_NAME_PREFIX                                                                             
, ASSOCIATION_NAME_SUFFIX                                                                           
, CHANGED_BY                                                                                        
, CLASS_NAME_PREFIX                                                                                 
, CLASS_NAME_SUFFIX                                                                                 
, COLUMN_PREFIX                                                                                     
, CREATED_BY                                                                                        
, CREATE_RTL_PK_COLS_FLAG                                                                           
, DATA_MEMBER_NAME_PREFIX                                                                           
, DATA_MEMBER_NAME_SUFFIX                                                                           
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DISCRIMINATOR_COLUMN_SUFFIX                                                                       
, ELEMENT_TYPE_NAME                                                                                 
, FK_CONSTRAINT_SUFFIX                                                                              
, GENERATE_ACCESSORS_FLAG                                                                           
, GENERATE_COMMENTS_FLAG                                                                            
, GENERATE_CREATE_METHOD_FLAG                                                                       
, GENERATE_DML_METHODS_FLAG                                                                         
, GENERATE_JAVA_IMP_STMTS_FLAG                                                                      
, GENERATE_REMOVE_METHOD_FLAG                                                                       
, GENERATE_TS_COLL_CLASS_FLAG                                                                       
, IRID                                                                                              
, IMPLEMENTATION_TARGET                                                                             
, IRID                                                                                              
, IVID                                                                                              
, MM_ASSOC_IMPLEMENTATION                                                                           
, NAME                                                                                              
, NOTM                                                                                              
, ORACLE_ATT_PREFIX_FOR_ASS_ENDS                                                                    
, ORACLE_COLLECTION_TYPE_PREFIX                                                                     
, ORACLE_TYPE_SUFFIX                                                                                
, PK_CONSTRAINT_SUFFIX                                                                              
, PROJECT_STANDARD_SUBTYPE                                                                          
, SEQUENCE_SUFFIX                                                                                   
, SURROGATE_PK_COLUMN_SUFFIX                                                                        
, TABLE_PREFIX                                                                                      
, TYPES                                                                                             
, UK_CONSTRAINT_SUFFIX                                                                              
, UPDATE_SERVER_MODEL_FLAG                                                                          
FROM  SDD_PST                                                                                       
WHERE TYPES IN (                                                                                    
5155                                                                                                
, 5156                                                                                              
, 5157                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_PASSED_VALUES(                                                            
CALLED_ARGUMENT_REFERENCE                                                                           
, CALLED_ARGUMENT_VALUE_FROM                                                                        
, CHANGED_BY                                                                                        
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, ID                                                                                                
, IRID                                                                                              
, ITEM_REFERENCE                                                                                    
, IVID                                                                                              
, MODULE_ARGUMENT_REFERENCE                                                                         
, MODULE_NETWORK_REFERENCE                                                                          
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, PASSED_VALUE_TYPE                                                                                 
, TYPES                                                                                             
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
, VALUE                                                                                             
)                                                                                                   
AS SELECT                                                                                           
CALLED_ARGUMENT_REF                                                                                 
, CALLED_ARGUMENT_VALUE_FROM                                                                        
, CHANGED_BY                                                                                        
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, IRID                                                                                              
, IRID                                                                                              
, ITEM_REF                                                                                          
, IVID                                                                                              
, MODULE_ARGUMENT_REF                                                                               
, MODULE_NETWORK_REF                                                                                
, NAME                                                                                              
, NOTM                                                                                              
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, PASSED_VALUE_TYPE                                                                                 
, TYPES                                                                                             
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
, VALUE                                                                                             
FROM  SDD_PVL                                                                                       
WHERE TYPES IN (                                                                                    
4880                                                                                                
, 4879                                                                                              
, 4883                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_QUEUES(                                                                   
AUTO_COMMIT_FLAG                                                                                    
, CHANGED_BY                                                                                        
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, ID                                                                                                
, INFINITE_FLAG                                                                                     
, IRID                                                                                              
, IVID                                                                                              
, MAX_RETRIES                                                                                       
, MULTIPLE_CONSUMERS_FLAG                                                                           
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, QUEUE_SUBTYPE                                                                                     
, QUEUE_TABLE_DEF_REFERENCE                                                                         
, QUEUE_TYPE                                                                                        
, REMARK                                                                                            
, RETENTION_TIME                                                                                    
, RETRY_DELAY                                                                                       
, TYPES                                                                                             
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
)                                                                                                   
AS SELECT                                                                                           
AUTO_COMMIT_FLAG                                                                                    
, CHANGED_BY                                                                                        
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, IRID                                                                                              
, INFINITE_FLAG                                                                                     
, IRID                                                                                              
, IVID                                                                                              
, MAX_RETRIES                                                                                       
, MULTIPLE_CONSUMERS_FLAG                                                                           
, NAME                                                                                              
, NOTM                                                                                              
, QUEUE_SUBTYPE                                                                                     
, QUEUE_TABLE_DEF_REF                                                                               
, QUEUE_TYPE                                                                                        
, REMARK                                                                                            
, RETENTION_TIME                                                                                    
, RETRY_DELAY                                                                                       
, TYPES                                                                                             
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
FROM  SDD_QUE                                                                                       
WHERE TYPES IN (                                                                                    
5139                                                                                                
, 5140                                                                                              
, 5141                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_QUEUE_IMPLEMENTATIONS(                                                    
CHANGED_BY                                                                                          
, COMPLETE_FLAG                                                                                     
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, ID                                                                                                
, INFINITE_FLAG                                                                                     
, IRID                                                                                              
, IVID                                                                                              
, MAX_RETRIES                                                                                       
, NON_PERSISTENT_QUEUE_REFERENCE                                                                    
, NUMBER_OF_TIMES_MODIFIED                                                                          
, ORACLE_DATABASE_REFERENCE                                                                         
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, PERSISTENT_QUEUE_REFERENCE                                                                        
, QUEUE_IMPLEMENTATION_SUBTYPE                                                                      
, QUEUE_TABLE_DBU_REFERENCE                                                                         
, RETENTION_TIME                                                                                    
, RETRY_DELAY                                                                                       
, TYPES                                                                                             
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
)                                                                                                   
AS SELECT                                                                                           
CHANGED_BY                                                                                          
, COMPLETE_FLAG                                                                                     
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, IRID                                                                                              
, INFINITE_FLAG                                                                                     
, IRID                                                                                              
, IVID                                                                                              
, MAX_RETRIES                                                                                       
, NON_PERSISTENT_QUEUE_REF                                                                          
, NOTM                                                                                              
, ORACLE_DATABASE_REF                                                                               
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, PERSISTENT_QUEUE_REF                                                                              
, QUEUE_IMPLEMENTATION_SUBTYPE                                                                      
, QUEUE_TABLE_DBU_REF                                                                               
, RETENTION_TIME                                                                                    
, RETRY_DELAY                                                                                       
, TYPES                                                                                             
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
FROM  SDD_QUI                                                                                       
WHERE TYPES IN (                                                                                    
5142                                                                                                
, 5143                                                                                              
, 5144                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_RELATION_DEFINITIONS(                                                     
ALIAS                                                                                               
, CHANGED_BY                                                                                        
, CLUSTER_REFERENCE                                                                                 
, COLUMN_PREFIX                                                                                     
, CREATED_BY                                                                                        
, DATAWAREHOUSE_TYPE                                                                                
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DISPLAY_TITLE                                                                                     
, ELEMENT_TYPE_NAME                                                                                 
, ID                                                                                                
, INDEX_ONLY_FLAG                                                                                   
, INITIAL_NUMBER_OF_ROWS                                                                            
, IRID                                                                                              
, IVID                                                                                              
, JOURNAL_LOCATION                                                                                  
, MAXIMUM_NUMBER_OF_ROWS                                                                            
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, OID_ATTRIBUTE_LIST                                                                                
, ORACLE_OBJECT_TYPE_REFERENCE                                                                      
, OVERRIDE_SELECT_TEXT_FLAG                                                                         
, RECORD_FILE_REFERENCE                                                                             
, RECORD_FORMAT                                                                                     
, RECORD_SIZE                                                                                       
, REMARK                                                                                            
, SAMPLE_PERCENT                                                                                    
, SAMPLE_TYPE                                                                                       
, TABLE_TYPE                                                                                        
, TYPES                                                                                             
, UPDATABLE_FLAG                                                                                    
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
, DATA_PERSISTENCE
)                                                                                                   
AS SELECT                                                                                           
ALIAS                                                                                               
, CHANGED_BY                                                                                        
, CLUSTER_REF                                                                                       
, COLUMN_PREFIX                                                                                     
, CREATED_BY                                                                                        
, DATAWAREHOUSE_TYPE                                                                                
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DISPLAY_TITLE                                                                                     
, ELEMENT_TYPE_NAME                                                                                 
, IRID                                                                                              
, INDEX_ONLY_FLAG                                                                                   
, INITIAL_NUMBER_OF_ROWS                                                                            
, IRID                                                                                              
, IVID                                                                                              
, JOURNAL_LOCATION                                                                                  
, MAXIMUM_NUMBER_OF_ROWS                                                                            
, NAME                                                                                              
, NOTM                                                                                              
, OID_ATTRIBUTE_LIST                                                                                
, ORACLE_OBJECT_TYPE_REF                                                                            
, OVERRIDE_SELECT_TEXT_FLAG                                                                         
, RECORD_FILE_REF                                                                                   
, RECORD_FORMAT                                                                                     
, RECORD_SIZE                                                                                       
, REMARK                                                                                            
, SAMPLE_PERCENT                                                                                    
, SAMPLE_TYPE                                                                                       
, TABLE_TYPE                                                                                        
, TYPES                                                                                             
, UPDATABLE_FLAG                                                                                    
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
, DATA_PERSISTENCE
FROM  SDD_TAB                                                                                       
WHERE TYPES IN (                                                                                    
4982                                                                                                
, 4974                                                                                              
, 4975                                                                                              
, 4976                                                                                              
, 4977                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_USE_CASE_ACTIONS(                                                         
CHANGED_BY                                                                                          
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, GENERAL_ACTION_REFERENCE                                                                          
, ID                                                                                                
, IRID                                                                                              
, IVID                                                                                              
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, SEQUENCE_IN_PARENT                                                                                
, TYPE                                                                                              
, TYPES                                                                                             
, USE_CASE_ACTION_SUBTYPE                                                                           
, USE_CASE_EVENT_OUT_REFERENCE                                                                      
, USE_CASE_INVOKED_REFERENCE                                                                        
, USE_CASE_REFERENCE                                                                                
)                                                                                                   
AS SELECT                                                                                           
CHANGED_BY                                                                                          
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, GENERAL_ACTION_REF                                                                                
, IRID                                                                                              
, IRID                                                                                              
, IVID                                                                                              
, NAME                                                                                              
, NOTM                                                                                              
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, SEQUENCE_IN_PARENT                                                                                
, TYPE                                                                                              
, TYPES                                                                                             
, USE_CASE_ACTION_SUBTYPE                                                                           
, USE_CASE_EVENT_OUT_REF                                                                            
, USE_CASE_INVOKED_REF                                                                              
, USE_CASE_REF                                                                                      
FROM  SDD_UCA                                                                                       
WHERE TYPES IN (                                                                                    
5111                                                                                                
, 5112                                                                                              
, 5113                                                                                              
, 5114                                                                                              
, 5115                                                                                              
);                                                                                                  
CREATE OR REPLACE VIEW CI_EXTENDED_ELEMENTS(                                                        
CHANGED_BY                                                                                          
, COMMENTS                                                                                          
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, ID                                                                                                
, IRID                                                                                              
, IVID                                                                                              
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, TYPES                                                                                             
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
)                                                                                                   
AS SELECT                                                                                           
CHANGED_BY                                                                                          
, COMMENTS                                                                                          
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_NAME                                                                                 
, IRID                                                                                              
, IRID                                                                                              
, IVID                                                                                              
, NAME                                                                                              
, NOTM                                                                                              
, TYPES                                                                                             
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
FROM  SDD_UEE                                                                                       
WHERE TYPES IN (                                                                                    
4945                                                                                                
);                                                                                                  
CREATE OR REPLACE VIEW CI_EXTENDED_STRUCTURE_ELEMENTS(                                              
CHANGED_BY                                                                                          
, COMMENTS                                                                                          
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_FOR                                                                                  
, ELEMENT_TYPE_NAME                                                                                 
, ID                                                                                                
, IRID                                                                                              
, IVID                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, PART_OF_REFERENCE                                                                                 
, TYPES                                                                                             
, USER_DEFINED_PROPERTY_0                                                                           
, USER_DEFINED_PROPERTY_1                                                                           
, USER_DEFINED_PROPERTY_10                                                                          
, USER_DEFINED_PROPERTY_11                                                                          
, USER_DEFINED_PROPERTY_12                                                                          
, USER_DEFINED_PROPERTY_13                                                                          
, USER_DEFINED_PROPERTY_14                                                                          
, USER_DEFINED_PROPERTY_15                                                                          
, USER_DEFINED_PROPERTY_16                                                                          
, USER_DEFINED_PROPERTY_17                                                                          
, USER_DEFINED_PROPERTY_18                                                                          
, USER_DEFINED_PROPERTY_19                                                                          
, USER_DEFINED_PROPERTY_2                                                                           
, USER_DEFINED_PROPERTY_3                                                                           
, USER_DEFINED_PROPERTY_4                                                                           
, USER_DEFINED_PROPERTY_5                                                                           
, USER_DEFINED_PROPERTY_6                                                                           
, USER_DEFINED_PROPERTY_7                                                                           
, USER_DEFINED_PROPERTY_8                                                                           
, USER_DEFINED_PROPERTY_9                                                                           
, USE_OF_REFERENCE                                                                                  
)                                                                                                   
AS SELECT                                                                                           
CHANGED_BY                                                                                          
, COMMENTS                                                                                          
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, ELEMENT_TYPE_FOR                                                                                  
, ELEMENT_TYPE_NAME                                                                                 
, IRID                                                                                              
, IRID                                                                                              
, IVID                                                                                              
, NOTM                                                                                              
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, PART_OF_REF                                                                                       
, TYPES                                                                                             
, USRX0                                                                                             
, USRX1                                                                                             
, USRX10                                                                                            
, USRX11                                                                                            
, USRX12                                                                                            
, USRX13                                                                                            
, USRX14                                                                                            
, USRX15                                                                                            
, USRX16                                                                                            
, USRX17                                                                                            
, USRX18                                                                                            
, USRX19                                                                                            
, USRX2                                                                                             
, USRX3                                                                                             
, USRX4                                                                                             
, USRX5                                                                                             
, USRX6                                                                                             
, USRX7                                                                                             
, USRX8                                                                                             
, USRX9                                                                                             
, USE_OF_REF                                                                                        
FROM  SDD_UES                                                                                       
WHERE TYPES IN (                                                                                    
4944                                                                                                
);                                                                                                  
CREATE OR REPLACE VIEW CI_WORKFLOW_ATTRIBUTES(                                                      
ATTRIBUTE_DOMAIN_REFERENCE                                                                          
, CHANGED_BY                                                                                        
, CLASSIFIER_ATTRIBUTE_REFERENCE                                                                    
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DEFAULT_VALUE                                                                                     
, ELEMENT_TYPE_NAME                                                                                 
, ID                                                                                                
, IMPLEMENTATION_NAME                                                                               
, IRID                                                                                              
, IVID                                                                                              
, NAME                                                                                              
, NUMBER_OF_TIMES_MODIFIED                                                                          
, PAC_REFERENCE                                                                                     
, PARENT_IVID                                                                                       
, SECURITY_LEVEL                                                                                    
, SEQUENCE                                                                                          
, TYPE                                                                                              
, TYPES                                                                                             
, WORKFLOW_ATTRIBUTE_SUBTYPE                                                                        
, WORKFLOW_ITEM_TYPE_REFERENCE                                                                      
, WORKFLOW_MESS_TYPE_REFERENCE                                                                      
, WORKFLOW_SUBTYPE                                                                                  
)                                                                                                   
AS SELECT                                                                                           
ATTRIBUTE_DOMAIN_REF                                                                                
, CHANGED_BY                                                                                        
, CLASSIFIER_ATTRIBUTE_REF                                                                          
, CREATED_BY                                                                                        
, DATE_CHANGED                                                                                      
, DATE_CREATED                                                                                      
, DEFAULT_VALUE                                                                                     
, ELEMENT_TYPE_NAME                                                                                 
, IRID                                                                                              
, IMPLEMENTATION_NAME                                                                               
, IRID                                                                                              
, IVID                                                                                              
, NAME                                                                                              
, NOTM                                                                                              
, PAC_REF                                                                                           
, PARENT_IVID                                                                                       
, SECURITY_LEVEL                                                                                    
, SEQUENCE                                                                                          
, TYPE                                                                                              
, TYPES                                                                                             
, WORKFLOW_ATTRIBUTE_SUBTYPE                                                                        
, WORKFLOW_ITEM_TYPE_REF                                                                            
, WORKFLOW_MESS_TYPE_REF                                                                            
, WORKFLOW_SUBTYPE                                                                                  
FROM  SDD_WAT                                                                                       
WHERE TYPES IN (                                                                                    
5152                                                                                                
, 5153                                                                                              
, 5154                                                                                              
);                                                                                                  
