SELECT t_project_task_v.property3 instance_id, t_project_task_v.start_date Task_Start_Date, t_project_task_v.user_name, t_project_task_v.duration, t_project_task_v.daysremaining, v_instance_props.ia_issue_number, v_instance_props.ia_issue_title, t_gps_workflow_states.state_name, t_gps_workflow_states.state_id, t_gps_workflow_types.workflow_type_name, t_gps_workflow_types.workflow_type_id, t_gps_applications.application_id, t_gps_applications.application_name, --t_project_task_history.update_date Task_last_updated_date, T_PROJECT_ACTIVITY.Created_date Task_last_updated_date, T_PROJECT_ACTIVITY.activity, ((Nvl(BILLABLE_HOURS, 0) + Nvl(NON_BILLABLE_HOURS, 0) + Nvl(EXTRA_BILLABLE_HOURS, 0))) spent_activity_hours, t_instances.predecessor, t_project_task_v.status, Nvl(t_project_task_v.duration, 0) * 8 ESTIMATED_HOURS, NVL(Activity_hours.SPENT_HOURS, 0) SPENT_HOURS, (Nvl(t_project_task_v.duration, 0) * 8 - NVL(Activity_hours.SPENT_HOURS, 0)) LEFT_HOURS, Decode(t_project_task_v.daysremaining, 0, 'Closed', 'OPEN') SUB_TASK_STATUS, issues.application_module, t_project_task_v.project_task_id FROM stategps.t_project_task_v T_PROJECT_TASK_V, stategps.v_instance_props V_INSTANCE_PROPS, stategps.t_gps_workflow_states T_GPS_WORKFLOW_STATES, stategps.t_gps_workflow_types T_GPS_WORKFLOW_TYPES, stategps.t_gps_applications T_GPS_APPLICATIONS, stategps.t_project_task_history T_PROJECT_TASK_HISTORY, stategps.t_instances T_INSTANCES, stategps.t_project_activity T_PROJECT_ACTIVITY, tri2gps_dev.issues ISSUES, (SELECT a.PROJECT_TASK_ID, SUM(Nvl(BILLABLE_HOURS, 0) + Nvl(NON_BILLABLE_HOURS, 0) + Nvl(EXTRA_BILLABLE_HOURS, 0)) SPENT_HOURS FROM T_PROJECT_ACTIVITY a GROUP BY a.PROJECT_TASK_ID) Activity_hours WHERE t_project_task_v.project_task_id = t_project_task_history.project_task_id( + ) AND T_PROJECT_TASK_V.PROJECT_TASK_ID = Activity_hours.PROJECT_TASK_ID (+) AND t_project_task_v.property3 = t_instances.instance_id (+) AND t_project_task_v.project_task_id = t_project_activity.project_task_id ( + ) AND t_project_task_v.property3 = v_instance_props.instance_id(+) AND t_project_task_v.ia_issue_number IS NOT NULL AND t_project_task_v.state_id = t_gps_workflow_states.state_id AND t_project_task_v.ia_issue_number = issues.issue_number (+) AND t_gps_workflow_types.application_id = t_gps_applications.application_id AND t_gps_workflow_states.workflow_type_id = t_gps_workflow_types.workflow_type_id AND ( t_project_task_history.history_id IS NULL OR t_project_task_history.history_id = (SELECT Max( T_PROJECT_TASK_HISTORY$1.history_id) FROM stategps.t_project_task_history T_PROJECT_TASK_HISTORY$1 WHERE T_PROJECT_TASK_HISTORY$1.project_task_id = t_project_task_v.project_task_id) ) -- AND t_project_task_v.project_task_id = 27537 --AND t_project_task_v.ia_issue_number = 'IS065517' ORDER BY t_project_task_v.project_task_id