View HLPDTEST.STATEGPS.T_PROJECT_HOURS_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  √  null
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R
TOTAL_ESTIMATED_HOURS number 22  √  null
TOTAL_ACTUAL_HOURS number 22  √  null
HOURS_DIFF number 22  √  null

Analyzed at Thu Aug 13 01:05 IST 2020

View Definition:
select application_id, nvl(sum(duration) * 8, 0) total_estimated_hours, nvl(sum(total_actual_hours), 0) total_actual_hours, (nvl(sum(duration) * 8, 0))-(nvl(sum(total_actual_hours), 0))hours_diff from (select wt.application_id, sum(duration)duration, (select nvl(sum(billable_hours), 0) + nvl(sum(non_billable_hours), 0) + nvl(sum(extra_billable_hours), 0) test1 from t_project_activity b where b.project_task_id = pt.project_task_id) total_actual_hours --, /* select(nvl(sum(duration) * 8, 0) - nvl(nvl(sum(billable_hours),0) + nvl(sum(non_billable_hours),0) + nvl(sum(extra_billable_hours),0), 0)) hours_diff*/ from t_gps_workflow_types wt, t_gps_workflow_states ws, t_project_task pt --, --t_project_activity pa where wt.workflow_type_id = ws.workflow_type_id and ws.state_id = pt.state_id --and pa.project_task_id = pt.project_task_id(+) group by application_id,project_task_id) hrs group by application_id
 
Possibly Referenced Tables/Views:


Close relationships: