View HLPDTEST.STATEGPS.V_RESOURCE_TASK_SUMMARY 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
SEQ number 22  √  null
USER_NAME varchar2 2000  √  null
APPLICATION_NAME varchar2 255  √  null
PROPERTY varchar2 24  √  null
VALUE number 22  √  null

Analyzed at Mon May 23 01:05 IST 2022

View Definition:
select 1 seq, user_name, application_name,'1.STARTED Est. Days' PROPERTY, sum(duration) VALUE from t_project_task_v where --user_name = 'lchinta' user_name is not null and status = 'STARTED' group by user_name, application_name, status union select 2 seq, user_name, application_name,'2.STARTED Days Remaining' PROPERTY, sum(nvl(daysremaining,duration)) VALUE from t_project_task_v where --user_name = 'lchinta' user_name is not null and status = 'STARTED' group by user_name, application_name,status union select 3 seq, user_name, application_name, '3.PENDING Est. Days' PROPERTY, sum(duration) VALUE from t_project_task_v where --user_name = 'lchinta' AND user_name is not null and status = 'PENDING' group by user_name, application_name, status union select 4 seq, user_name, application_name, '4.PENDING Days Remaining' PROPERTY, sum(nvl(daysremaining,duration)) VALUE from t_project_task_v where --user_name = 'lchinta' user_name is not null and status = 'PENDING' group by user_name, application_name, status union select 5 seq, user_name, application_name,'5.NOT STARTED Est. Days' PROPERTY, sum(duration) VALUE from t_project_task_v where --user_name = 'lchinta' user_name is not null and status = 'NOT STARTED' group by user_name, application_name,status
 
Possibly Referenced Tables/Views: