View HLPDTEST.STATEGPS.T_PROJECT_CURRENT_PLAN_V | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Tue May 24 01:05 IST 2022 |
View Definition:
select min(start_date) start_date,
max(end_date) finish_date,
round(coalesce(decode(sum(decode(daysremaining, 0, duration)),
null,
0,
sum(decode(daysremaining, 0, duration))) /
sum(decode(daysremaining,
0,
duration,
coalesce(daysremaining, duration))) * 100,
0),
2) percent_completed,
task,
module,
workflow,
project,
project_id,
workflow_order,
workflow_id,
count(task_id) total_tasks,
sum(case when daysremaining = 0 and task is not null then 1 else 0 end) tasks_completed,
trunc(max(end_date)) - trunc(min(start_date)) duration
from t_project_plan_tasks_v
--where project_id = 8522
group by task,
module,
workflow,
project,
project_id,
workflow_order,
workflow_id
Possibly Referenced Tables/Views:
![]() ![]() |