View HLPDTEST.STATEGPS.V_PA_SUMMARY | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||
Analyzed at Mon May 23 01:05 IST 2022 |
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:
![]() ![]() |