View HLPDTEST.STATEGPS.T_MONTHLY_OPEN_CLOSED_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
PROJECT varchar2 255  √  null
WORKFLOW_TYPE_NAME varchar2 255  √  null
STATE_NAME varchar2 255  √  null
USER_NAME varchar2 2000  √  null
TASK_DATE date 7  √  null
STATUS varchar2 6  √  null
INSTANCE_ID number 22  √  null
T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Implied Constraint R
STATE_ORDER number 22  √  null

Analyzed at Thu Aug 13 01:05 IST 2020

View Definition:
select a.application_name PROJECT, wt.workflow_type_name, ws.state_name,pt.user_name, trunc(gi.created_date,'MM') TASK_DATE, decode(gi.instance_present,0,'CLOSED') STATUS, gi.instance_id, ws.state_order from t_gps_instances gi, t_project_task pt, t_gps_applications a, t_gps_workflow_types wt, t_gps_workflow_states ws where gi.workflow_type_id = wt.workflow_type_id and a.application_id = gi.application_id and a.visible_flag = 'true' and pt.instance_id = gi.instance_id and pt.state_id = gi.current_state_id and pt.state_id = ws.state_id and gi.active = 1 and decode(gi.instance_present,0,'CLOSED') is not null union select a.application_name PROJECT, wt.workflow_type_name, ws.state_name,pt.user_name, trunc(gi.created_date,'MM') TASK_DATE, 'OPEN' STATUS, gi.instance_id, ws.state_order from t_gps_instances gi, t_project_task pt, t_gps_applications a, t_gps_workflow_types wt, t_gps_workflow_states ws where gi.workflow_type_id = wt.workflow_type_id and a.application_id = gi.application_id and a.visible_flag = 'true' and pt.instance_id = gi.instance_id and gi.active = 1 and pt.state_id = gi.current_state_id and pt.state_id = ws.state_id
 
Possibly Referenced Tables/Views:


Close relationships: