PJT_RES_PRJ_WEEKLY_SUMM_V

Details

• Schema: FUSION

• Object owner: PJT

• Object type: VIEW

Columns

Name
SCHEDULE_ID RESOURCE_ID PERSON_ID EMAIL PROJECT_ID PROJECT_ROLE_ID WEEK_START_DATE ALLOCATED_HOURS REMAINING_HOURS TASK_ALLOCATED_HOURS

Query

SQL_Statement

select null schedule_id , resource_id , null person_id , null email , project_id , project_role_id , week_start_date , sum(allocated_hours) allocated_hours , sum(remaining_hours) remaining_hours , sum(task_allocated_hours) task_allocated_hours from ( SELECT alloc.resource_id , alloc.project_id , alloc.project_role_id , alloc.week_start_date , alloc.allocated_hours , 0 remaining_hours , 0 task_allocated_hours FROM pjt_res_weekly_alloc_hrs_v alloc UNION ALL SELECT prs.resource_id , prs.project_id , prs.project_role_id , assgn.week_start_date , 0 allocated_hours , assgn.remaining_hours , assgn.task_allocated_hours FROM pjt_project_resource prs , pjt_res_weekly_assgn_hrs_v assgn where prs.project_id = assgn.project_id and prs.resource_id = assgn.resource_id ) group by resource_id , project_id , project_role_id , week_start_date