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)