View HLPDTEST.STATEGPS.CHILD_STATE_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
STATE_NAME varchar2 255  √  null
PARENT_ISSUE_NUMBER varchar2 100  √  null
USER_NAME varchar2 2000  √  null

Analyzed at Mon May 23 01:05 IST 2022

View Definition:
select decode(child_data.state_descriptor, 'Workflow Move', (select M.STATE_NAME from tri2gps_dev.MIG_REQUESTS_V M where M.MIGRATION_REQUEST_NUMBER = issue_number), state_name) state_name,parent_issue_number,user_name from (select ws.state_descriptor, state_name, issue_number, A.INSTANCE_ID,parent_issue_number,d.user_name from tri2gps_dev.issues a, t_gps_instances b, t_gps_workflow_states ws, t_project_task d where a.instance_id = b.instance_id and b.instance_present = 1 and d.instance_id=a.instance_id and d.state_id = b.current_state_id and b.current_state_id = ws.state_id and parent_issue_number is not null and a.issue_number is not null /* and a.parent_issue_number = 'INC00064'*/)child_data
 
Possibly Referenced Tables/Views: