View HLPDTEST.STATEGPS.T_DUE_TASKS_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_ORDER number 22  √  null
APPLICATION_ID number 22  √  null
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R
APPLICATION_NAME varchar2 255  √  null
WORKFLOW_TYPE_ID number 22  √  null
T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Implied Constraint R
WORKFLOW_TYPE_NAME varchar2 255  √  null
INSTANCE_ID number 22  √  null
T_INSTANCES.INSTANCE_ID Implied Constraint R
IA_ISSUE_NUMBER varchar2 4000  √  null
IA_ISSUE_TITLE varchar2 4000  √  null
PRIORITY number 22  √  null
PROJECT_TASK_ID number 22  √  null
T_PROJECT_TASK.PROJECT_TASK_ID Implied Constraint R
STATE_NAME varchar2 255  √  null
USER_NAME varchar2 2000  √  null
DURATION number 22  √  null
DAYSREMAINING number 22  √  null
PROMISED_DUE_DATE date 7  √  null

Analyzed at Thu Sep 24 01:05 IST 2020

View Definition:
select ws.state_order,a.application_id,a.application_name, wt.workflow_type_id,wt.workflow_type_name,i.instance_id,ip.IA_ISSUE_NUMBER, ip.IA_ISSUE_TITLE, ip.priority,pt.project_task_id,ws.state_name,pt.user_name,pt.duration,pt.daysremaining,pt.promised_due_date from t_project_task pt, t_instances i, t_gps_applications a, v_instance_props ip, t_gps_workflow_states ws, t_gps_workflow_types wt, t_gps_instances gi where pt.instance_id = i.instance_id and i.instance_id = ip.instance_id and i.instance_id = gi.instance_id and gi.active = 1 and gi.instance_present = 1 and pt.state_id = ws.state_id and ws.workflow_type_id = wt.workflow_type_id and pt.promised_due_date < SYSDATE and (pt.daysremaining > 0 or (pt.duration > 0 and pt.daysremaining is null) or (pt.duration is null and pt.daysremaining is null)) and i.application_id = a.application_id and a.visible_flag = 'true' and wt.visible_flag = 'true' union select ws.state_order,a.application_id,a.application_name,wt.workflow_type_id,wt.workflow_type_name,NULL,NULL, NULL, NULL,pt.project_task_id,ws.state_name,pt.user_name,pt.duration,pt.daysremaining,pt.promised_due_date from t_project_task pt, t_gps_applications a, t_gps_workflow_states ws, t_gps_workflow_types wt where pt.state_id = ws.state_id and pt.promised_due_date < SYSDATE and (pt.daysremaining > 0 or (pt.duration > 0 and pt.daysremaining is null) or (pt.duration is null and pt.daysremaining is null)) and wt.application_id = a.application_id and ws.workflow_type_id = wt.workflow_type_id and a.visible_flag = 'true' and wt.visible_flag = 'true' and not exists (select * from t_workflow_state_task_v x where x.state_id = pt.state_id) order by 1
 
Possibly Referenced Tables/Views:


Close relationships: