View HLPDTEST.STATEGPS.T_PROJECT_DUE_DATES_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_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
STATE_DESCRIPTOR varchar2 100  √  null
INSTANCE_ID number 22  √  null
T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Implied Constraint R
PROMISED_DUE_DATE date 7  √  null
MOVED_OUT_DATE date 7  √  null
APPLICATION_NAME varchar2 255  √  null
ISSUE_NUMBER varchar2 4000  √  null
ISSUE_TITLE varchar2 4000  √  null
STATUS varchar2 7  √  null
COUNT number 22  √  null

Analyzed at Sat Dec 05 01:06 IST 2020

View Definition:
SELECT T_GPS_APPLICATIONS.APPLICATION_ID, T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_NAME, T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID, T_GPS_WORKFLOW_STATES.STATE_DESCRIPTOR, T_GPS_INSTANCES.INSTANCE_ID, T_INSTANCES.PROMISED_DUE_DATE, T_GPS_INSTANCES.MOVED_OUT_DATE, T_GPS_APPLICATIONS.APPLICATION_NAME, (SELECT T_GPS_INSTANCE_PROPERTIES.PROPERTY_VALUE FROM T_GPS_INSTANCE_PROPERTIES WHERE INSTANCE_ID = T_GPS_INSTANCES.INSTANCE_ID AND T_GPS_INSTANCE_PROPERTIES.PROPERTY_NAME = 'tri2.SG_TRI2_ENTITY.IA_ISSUE_NUMBER') AS ISSUE_NUMBER, (SELECT T_GPS_INSTANCE_PROPERTIES.PROPERTY_VALUE FROM T_GPS_INSTANCE_PROPERTIES WHERE INSTANCE_ID = T_GPS_INSTANCES.INSTANCE_ID AND T_GPS_INSTANCE_PROPERTIES.PROPERTY_NAME = 'tri2.SG_TRI2_ENTITY.IA_ISSUE_TITLE') AS ISSUE_TITLE, (CASE WHEN TRUNC(T_INSTANCES.PROMISED_DUE_DATE) < TRUNC(T_GPS_INSTANCES.MOVED_OUT_DATE) THEN 'After' WHEN TRUNC(T_INSTANCES.PROMISED_DUE_DATE) > TRUNC(T_GPS_INSTANCES.MOVED_OUT_DATE) THEN 'Before' WHEN TRUNC(T_INSTANCES.PROMISED_DUE_DATE) = TRUNC(T_GPS_INSTANCES.MOVED_OUT_DATE) THEN 'On' ELSE 'Without' END) STATUS, 1 AS COUNT FROM STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS, STATEGPS.T_GPS_WORKFLOW_TYPES T_GPS_WORKFLOW_TYPES, STATEGPS.T_GPS_WORKFLOW_STATES T_GPS_WORKFLOW_STATES, STATEGPS.T_GPS_INSTANCES T_GPS_INSTANCES, STATEGPS.T_GPS_INSTANCE_PROPERTIES T_GPS_INSTANCE_PROPERTIES, STATEGPS.T_INSTANCES T_INSTANCES WHERE T_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_WORKFLOW_TYPES.APPLICATION_ID AND T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID = T_GPS_WORKFLOW_STATES.WORKFLOW_TYPE_ID AND T_GPS_WORKFLOW_STATES.STATE_ID = T_GPS_INSTANCES.CURRENT_STATE_ID AND T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID = T_GPS_INSTANCES.WORKFLOW_TYPE_ID AND T_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_INSTANCES.APPLICATION_ID AND T_GPS_INSTANCES.INSTANCE_ID = T_INSTANCES.INSTANCE_ID AND T_INSTANCES.INSTANCE_ID = T_GPS_INSTANCE_PROPERTIES.INSTANCE_ID AND T_GPS_INSTANCES.MOVED_OUT_DATE IS NOT NULL AND T_GPS_WORKFLOW_STATES.STATE_DESCRIPTOR = 'Workflow End' AND T_GPS_INSTANCE_PROPERTIES.PROPERTY_NAME = 'tri2.SG_TRI2_ENTITY.IA_ISSUE_NUMBER'
 
Possibly Referenced Tables/Views:


Close relationships: