select (SELECT APPLICATION_NAME FROM T_GPS_APPLICATIONS tga WHERE tga.APPLICATION_ID = i.PROJECT_ID) APPLICATION_NAME, tga.application_id, tgwt.workflow_type_name, tgwt.workflow_type_id, ti.instance_id, tgws.state_id, ATTRIBUTE22 region, ATTRIBUTE23 country, ATTRIBUTE24 entity, i.application_module, i.issue_number, i.issue_title, tpcp.priority, ti.priority priority_number, ATTRIBUTE6 ticket_type, ATTRIBUTE7 change_type, ATTRIBUTE2 migration_type, tpt.user_name, (SELECT k.first_name || ' ' || k.middle_name || ' ' || k.last_name from tas.t_users k where k.user_name = tpt.user_name) user_full_name, tgws.state_name, i.created_date, (SELECT k.first_name || ' ' || k.middle_name || ' ' || k.last_name from tas.t_users k where k.user_id = i.created_by) created_by, i.parent_issue_number, tpt.project_task_id, i.Attribute1 incident_number,'STARTED' status,tgws.state_order,tpt.resource_name,i.attribute3, i.attribute4,i.attribute5,i.due_date from t_gps_applications tga, t_gps_app_properties tgap, t_gps_workflow_types tgwt, t_gps_workflow_states tgws, t_project_task tpt, t_instances ti, t_gps_instances tgi, tri2gps_dev.issues i, t_project_custom_priority tpcp where tga.application_id = tgwt.application_id and tga.application_id = tgap.application_id and tgwt.workflow_type_id = tgws.workflow_type_id and tpt.instance_id = ti.instance_id and ti.instance_id = i.instance_id and tgi.instance_id = i.instance_id and tgws.state_id = tpt.state_id and tgws.state_id = tgi.current_state_id and tpt.state_id = tgi.current_state_id and ti.application_id = tga.application_id and ti.workflow_type_id = tgwt.workflow_type_id and ti.priority = tpcp.start_range and tga.visible_flag = 'true' and tgwt.visible_flag = 'true' and ti.active = 1 and tgi.instance_present = 1 --and issue_number='IS000142' and tgap.property_name = 'TICKET_MANAGEMENT_APPLICATION' and tgap.property_value = 'TRUE' union select (SELECT APPLICATION_NAME FROM T_GPS_APPLICATIONS tga WHERE tga.APPLICATION_ID = i.PROJECT_ID) APPLICATION_NAME, tga.application_id, tgwt.workflow_type_name, tgwt.workflow_type_id, ti.instance_id, tgws.state_id, ATTRIBUTE22 region, ATTRIBUTE23 country, ATTRIBUTE24 entity, i.application_module, i.issue_number, i.issue_title, tpcp.priority, ti.priority priority_number, ATTRIBUTE6 ticket_type, ATTRIBUTE7 change_type, ATTRIBUTE2 migration_type, tpt.user_name, (SELECT k.first_name || ' ' || k.middle_name || ' ' || k.last_name from tas.t_users k where k.user_name = tpt.user_name) user_full_name, tgws.state_name, i.created_date, (SELECT k.first_name || ' ' || k.middle_name || ' ' || k.last_name from tas.t_users k where k.user_id = i.created_by) created_by, i.parent_issue_number, tpt.project_task_id, i.Attribute1 incident_number,'NOT STARTED' status,tgws.state_order,tpt.resource_name,i.attribute3, i.attribute4,i.attribute5,i.due_date from t_gps_applications tga, t_gps_app_properties tgap, t_gps_workflow_types tgwt, t_gps_workflow_states tgws, t_project_task tpt, t_instances ti, tri2gps_dev.issues i, t_project_custom_priority tpcp where tga.application_id = tgwt.application_id and tga.application_id = tgap.application_id and tgwt.workflow_type_id = tgws.workflow_type_id and tpt.instance_id = ti.instance_id and ti.instance_id = i.instance_id and tgws.state_id = tpt.state_id and ti.application_id = tga.application_id and ti.workflow_type_id = tgwt.workflow_type_id and ti.priority = tpcp.start_range and tga.visible_flag = 'true' and tgwt.visible_flag = 'true' and ti.active = 1 and tgap.property_name = 'TICKET_MANAGEMENT_APPLICATION' --and issue_number='IS000142' and (tpt.daysremaining is null or tpt.daysremaining <> 0) and not exists(select 1 from t_gps_instances tgi where tgi.instance_id=ti.instance_id and tgi.current_state_id=tpt.state_id and instance_present=1) and tgap.property_value = 'TRUE'