PJT_RES_WEEKLY_ASSGN_HRS_V

Details

• Schema: FUSION

• Object owner: PJT

• Object type: VIEW

Columns

Name
SCHEDULE_ID RESOURCE_ID PERSON_ID EMAIL PROJECT_ID PROJ_ELEMENT_ID WEEK_START_DATE REMAINING_HOURS TASK_ALLOCATED_HOURS

Query

SQL_Statement

SELECT null schedule_id , a.resource_id , null person_id , null email , a.project_id , a.task_id proj_element_id , TRUNC(a.daily_date, 'D') week_start_date , ROUND(SUM(a.remaining_quantity_d), 2) remaining_hours , ROUND(SUM(a.quantity_d), 2) task_allocated_hours FROM PJT_SUM_MPP_LINEAR_SPREAD a where a.remaining_quantity >0 GROUP BY a.resource_id , a.project_id , a.task_id, TRUNC(a.daily_date, 'D')