View HLPDTEST.STATEGPS.T_TICKET_DETAILS_V 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_NAME varchar2 255  √  null
APPLICATION_ID number 22
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R
WORKFLOW_TYPE_NAME varchar2 255
WORKFLOW_TYPE_ID number 22
T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Implied Constraint R
INSTANCE_ID number 22
T_INSTANCES.INSTANCE_ID Implied Constraint R
STATE_ID number 22
T_GPS_WORKFLOW_STATES.STATE_ID Implied Constraint R
REGION varchar2 2000  √  null
COUNTRY varchar2 2000  √  null
ENTITY varchar2 2000  √  null
APPLICATION_MODULE varchar2 50  √  null
ISSUE_NUMBER varchar2 100  √  null
ISSUE_TITLE varchar2 4000  √  null
PRIORITY varchar2 255
T_PROJECT_CUSTOM_PRIORITY.PRIORITY Implied Constraint R
PRIORITY_NUMBER number 22  √  null
TICKET_TYPE varchar2 2000  √  null
CHANGE_TYPE varchar2 2000  √  null
MIGRATION_TYPE varchar2 2000  √  null
USER_NAME varchar2 2000  √  null
USER_FULL_NAME varchar2 302  √  null
STATE_NAME varchar2 255  √  null
CREATED_DATE date 7  √  null
CREATED_BY varchar2 302  √  null
PARENT_ISSUE_NUMBER varchar2 100  √  null
PROJECT_TASK_ID number 22
T_PROJECT_TASK.PROJECT_TASK_ID Implied Constraint R

Analyzed at Fri Sep 25 01:05 IST 2020

View Definition:
select (SELECT APPLICATION_NAME FROM T_GPS_APPLICATIONS tga WHERE tga.APPLICATION_ID = i.PROJECT_ID) APPLICATION_NAME, tga.application_id, tgwt.workflow_type_name, tgwt.workflow_type_id, ti.instance_id, tgws.state_id, ATTRIBUTE22 region, ATTRIBUTE23 country, ATTRIBUTE24 entity, i.application_module, i.issue_number, i.issue_title, tpcp.priority, ti.priority priority_number, ATTRIBUTE6 ticket_type, ATTRIBUTE7 change_type, ATTRIBUTE2 migration_type, tpt.user_name, (SELECT k.first_name || ' ' || k.middle_name || ' ' || k.last_name from tas.t_users k where k.user_name = tpt.user_name) user_full_name, tgws.state_name, i.created_date, (SELECT k.first_name || ' ' || k.middle_name || ' ' || k.last_name from tas.t_users k where k.user_id = i.created_by) created_by, i.parent_issue_number, tpt.project_task_id from t_gps_applications tga, t_gps_app_properties tgap, t_gps_workflow_types tgwt, t_gps_workflow_states tgws, t_project_task tpt, t_instances ti, t_gps_instances tgi, tri2gps_dev.issues i, t_project_custom_priority tpcp where tga.application_id = tgwt.application_id and tga.application_id = tgap.application_id and tgwt.workflow_type_id = tgws.workflow_type_id and tpt.instance_id = ti.instance_id and ti.instance_id = i.instance_id and tgi.instance_id = i.instance_id and tgws.state_id = tpt.state_id and tgws.state_id = tgi.current_state_id and tpt.state_id = tgi.current_state_id and ti.application_id = tga.application_id and ti.workflow_type_id = tgwt.workflow_type_id and ti.priority = tpcp.start_range and tga.visible_flag = 'true' and tgwt.visible_flag = 'true' and ti.active = 1 and tgi.instance_present = 1 and tgap.property_name = 'TICKET_MANAGEMENT_APPLICATION' and tgap.property_value = 'TRUE' --and tga.application_name='ORACLE ERP India' /*and i.issue_number='IS094337'*/
 
Possibly Referenced Tables/Views:


Close relationships: