View HLPDTEST.STATEGPS.T_ORA_CLOUD_IMPL_ATTRIBUTES_VL Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
APPLICATION_ID number 22  √  null
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R
PKG_TASK_ID number 22  √  null
TASK_ID number 22
T_REPORTING_PLAN_TASKS.TASK_ID Implied Constraint R
BUSINESS_OBJ_ID number 22  √  null
ATTRIBUTE_SET_ID number 22  √  null
ATTRIBUTE_ID number 22
T_GPS_MODEL_SEARCH_ATTRIBUTES.ATTRIBUTE_ID Implied Constraint R
ATTRIBUTE_NAME varchar2 150
ATTRIBUTE_VALUE varchar2 150  √  null
ATTRIBUTE_DESCRIPTION varchar2 500  √  null
IS_ATTRIBUTE_MANDATORY varchar2 150
CREATED_DATE timestamp(6) 11,6  √  null
CREATED_BY varchar2 50
LAST_UPDATED_DATE timestamp(6) 11,6  √  null
LAST_UPDATED_BY varchar2 50
IMPL_BO_ATTR_ID number 22
DETAIL_IMPL_ID number 22  √  null
CONFIG_IMPL_ID number 22  √  null
CONFIG_PKG_ID number 22  √  null
BUSINESS_OBJ_NAME varchar2 150
BUSINESS_OBJ_CODE varchar2 150
BUSINESS_OBJ_DESC varchar2 2000
TASK_NAME varchar2 150
TASK_DESCRIPTION varchar2 500
TASK_CODE varchar2 150
IS_TASK_MANDATORY varchar2 150
INSTANCE_NAME varchar2 240  √  null
INSTANCE_ID number 22  √  null
T_INSTANCES.INSTANCE_ID Implied Constraint R
ORA_BUSINESS_OBJ_ID number 22
APPLICATION_NAME varchar2 150
BO_CREATED_BY varchar2 50
BO_CREATED_DATE timestamp(6) 11,6
BO_LAST_UPDATED_BY varchar2 50
BO_LAST_UPDATED_DATE timestamp(6) 11,6

Analyzed at Fri Oct 16 01:05 IST 2020

View Definition:
SELECT t_ora_cloud_setup_tasks.APPLICATION_ID, t_ora_cloud_bo_attributes.PKG_TASK_ID, t_ora_cloud_setup_tasks.TASK_ID, t_ora_cloud_bo_attributes.BUSINESS_OBJ_ID, t_ora_cloud_impl_bo_attributes.ATTRIBUTE_SET_ID, t_ora_cloud_bo_attributes.ATTRIBUTE_ID, t_ora_cloud_bo_attributes.ATTRIBUTE_NAME, t_ora_cloud_impl_bo_attributes.ATTRIBUTE_VALUE, t_ora_cloud_bo_attributes.ATTRIBUTE_DESCRIPTION, t_ora_cloud_bo_attributes.IS_MANDATORY as is_attribute_mandatory, t_ora_cloud_impl_bo_attributes.CREATED_DATE, t_ora_cloud_impl_bo_attributes.CREATED_BY, t_ora_cloud_impl_bo_attributes.LAST_UPDATED_DATE, t_ora_cloud_impl_bo_attributes.LAST_UPDATED_BY, t_ora_cloud_impl_bo_attributes.IMPL_BO_ATTR_ID, t_ora_cloud_impl_bo_attributes.DETAIL_IMPL_ID, t_ora_config_impl_details.CONFIG_IMPL_ID, t_ora_cloud_config_pkg_tasks.CONFIG_PKG_ID, t_ora_cloud_setup_business_obj.BUSINESS_OBJ_NAME, t_ora_cloud_setup_business_obj.BUSINESS_OBJ_CODE, t_ora_cloud_setup_business_obj.BUSINESS_OBJ_DESC, t_ora_cloud_setup_tasks.TASK_NAME, t_ora_cloud_setup_tasks.TASK_DESCRIPTION, t_ora_cloud_setup_tasks.TASK_CODE, t_ora_cloud_setup_tasks.IS_MANDATORY as is_task_mandatory, (select INSTANCE_SHORT_NAME from tri2gps_dev.t_mig_instance_details where instance_id = t_ora_cloud_impl_bo_attributes.INSTANCE_ID) AS INSTANCE_NAME, t_ora_cloud_impl_bo_attributes.INSTANCE_ID, t_ora_cloud_setup_business_obj.ora_business_obj_id, t_ora_cloud_applications.application_name, t_ora_cloud_setup_business_obj.CREATED_BY as bo_created_by, t_ora_cloud_setup_business_obj.created_date as bo_created_date, t_ora_cloud_setup_business_obj.LAST_UPDATED_BY as bo_last_updated_by, t_ora_cloud_setup_business_obj.LAST_UPDATED_DATE as bo_last_updated_date FROM ocsr.t_ora_cloud_bo_attributes t_ora_cloud_bo_attributes, ocsr.t_ora_cloud_impl_bo_attributes t_ora_cloud_impl_bo_attributes, ocsr.t_ora_config_impl_details t_ora_config_impl_details, ocsr.t_ora_cloud_config_pkg_tasks t_ora_cloud_config_pkg_tasks, ocsr.t_ora_cloud_setup_business_obj t_ora_cloud_setup_business_obj, ocsr.t_ora_cloud_setup_tasks t_ora_cloud_setup_tasks, ocsr.t_ora_cloud_config_impl t_ora_cloud_config_impl, ocsr.t_ora_cloud_applications t_ora_cloud_applications WHERE t_ora_cloud_bo_attributes.ATTRIBUTE_ID = t_ora_cloud_impl_bo_attributes.ATTRIBUTE_ID AND t_ora_cloud_bo_attributes.PKG_TASK_ID = t_ora_cloud_config_pkg_tasks.PKG_TASK_ID AND t_ora_cloud_bo_attributes.BUSINESS_OBJ_ID = t_ora_cloud_setup_business_obj.BUSINESS_OBJ_ID AND t_ora_cloud_impl_bo_attributes.DETAIL_IMPL_ID = t_ora_config_impl_details.DETAIL_IMPL_ID AND t_ora_cloud_applications.app_id = t_ora_cloud_setup_tasks.application_id AND t_ora_cloud_setup_business_obj.TASK_ID = t_ora_cloud_setup_tasks.TASK_ID AND t_ora_cloud_config_pkg_tasks.TASK_ID = t_ora_cloud_setup_tasks.TASK_ID AND t_ora_config_impl_details.CONFIG_IMPL_ID = t_ora_cloud_config_impl.CONFIG_IMPL_ID AND t_ora_cloud_config_pkg_tasks.CONFIG_PKG_ID = t_ora_config_impl_details.CONFIG_PKG_ID
 

Close relationships: