View HLPDTEST.STATEGPS.V_PA_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
PROJECT_TASK_ID number 22  √  null
T_PROJECT_TASK.PROJECT_TASK_ID Implied Constraint R
HOURS_SPENT number 22  √  null

Analyzed at Mon Sep 20 01:06 IST 2021

View Definition:
select pa.project_task_id,nvl(sum(pa.non_billable_hours),0)+ nvl(sum(pa.billable_hours),0) HOURS_SPENT from t_project_activity pa group by pa.project_task_id
 
Possibly Referenced Tables/Views:
T_PROJECT_ACTIVITY 


Close relationships: