View HLPDTEST.STATEGPS.T_PROJECT_PLAN_REMOVED_TASKS_V | Generated by SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon May 23 01:05 IST 2022 |
View Definition:
select tp.project_task_id,
tp.start_date,
tp.finish_date,
coalesce(tws.description, tws.state_name),
i.application_module,
tgw.workflow_type_name,
tga.application_name,
tp.duration,
tp.daysremaining,
tp.user_id,
tws.state_id,
tgw.workflow_type_id,
tga.application_id,
tgw.workflow_order
from t_gps_applications tga,
t_gps_workflow_types tgw,
t_gps_workflow_states tws,
t_instances tgi,
tri2gps_dev.issues i,
t_project_task tp,
t_project_task_history pph
where tga.application_id = tgw.application_id
and tgw.workflow_type_id = tws.workflow_type_id
and tga.visible_flag = 'true'
and tgw.visible_flag = 'true'
and tgi.application_id = tga.application_id
and tgw.workflow_type_id = tgi.workflow_type_id
and tgi.instance_id = i.instance_id
and tp.state_id = tws.state_id
and tp.instance_id = i.instance_id
and tgi.active = 0
and pph.project_task_id = tp.project_task_id
and pph.execution_id = get_previous_history_id(tga.application_id)
Possibly Referenced Tables/Views:
![]() ![]() |