View HLPDTEST.STATEGPS.V_TASKS_WHITEBOARD | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon May 23 01:05 IST 2022 |
View Definition:
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
Possibly Referenced Tables/Views:
![]() ![]() |