Declare @i_user_id int, @o_grp int, @i_project_id int
select @i_user_id = especialista, --se puede obtener por la consulta(select codusuario from usuarios where username='usuario_de_red')
       @o_grp  = grupo_especialista, --se puede obtener por la consulta(select GRP_ID from GROUPHD where GRP_NAME='grupo_desasociar')
       @i_project_id = proyecto	--se puede obtener por la consulta(select FL_INT_ID from ASDK_PROJECTS where FL_STR_PROJECT_NAME='Proyecto')

SELECT   inci_id, 'INCIDENTE'
FROM     ASDK_INCIDENT
WHERE    inci_responsible_id = @i_user_id AND inci_responsible_group_id = @o_grp 
AND      inci_final_status = 1 AND inci_fl_int_project_id = @i_project_id
UNION ALL
SELECT   chan_id, 'CAMBIOS'
FROM     ASDK_CHANGE
WHERE    chan_responsible_id = @i_user_id  AND chan_responsible_group_id = @o_grp      
AND      chan_final_status = 1 AND chan_fl_int_project_id = @i_project_id 
UNION ALL
SELECT   prob_id, 'PROBLEMAS'
FROM     ASDK_PROBLEM
WHERE    prob_responsible_id = @i_user_id  AND prob_responsible_group_id = @o_grp        
AND      prob_final_status = 1 AND prob_fl_int_project_id = @i_project_id 
UNION ALL
SELECT   serv_id,'SERVICE CALL'
FROM     ASDK_SERVICE_CALL
WHERE    serv_responsible_id = @i_user_id  AND serv_responsible_group_id = @o_grp       
AND      serv_final_status = 1 AND serv_fl_int_project_id = @i_project_id 
UNION ALL
SELECT   ASDK_TASK.id_task, 'TAREA CAMBIOS'
FROM     ASDK_TASK
LEFT JOIN ASDK_CHANGE_TASK ON ASDK_TASK.id_task =  ASDK_CHANGE_TASK.id_task
LEFT JOIN ASDK_CHANGE   ON    ASDK_CHANGE_TASK.codcambio = ASDK_CHANGE.chan_id
WHERE    RESPONSABLEID = @i_user_id  AND GRP_ID = @o_grp 
AND      dbo.FUN_ASDK_STATUS_CHILD(TASK_STATUS) > 0 
AND chan_fl_int_project_id = @i_project_id                             -- Tareas para cambios
UNION ALL
SELECT   ASDK_TASK.id_task, 'TAREA SERVICE CALL'
FROM     ASDK_TASK
LEFT JOIN ASDK_SERVICECALL_TASK ON ASDK_TASK.id_task = ASDK_SERVICECALL_TASK.seta_task_id
LEFT JOIN ASDK_SERVICE_CALL  ON ASDK_SERVICECALL_TASK.seta_serv_id = ASDK_SERVICE_CALL.serv_id
WHERE    RESPONSABLEID = @i_user_id  AND GRP_ID = @o_grp 
AND      dbo.FUN_ASDK_STATUS_CHILD(TASK_STATUS) > 0 
AND ASDK_SERVICE_CALL.serv_fl_int_project_id = @i_project_id -- Tareas para requerimientos
UNION ALL
SELECT   voti_item_id, 'PROCESO VOTACION'
FROM     ASDK_VOTING
WHERE    voti_user_id = @i_user_id  AND voti_group_id = @o_grp
UNION ALL
SELECT   fl_int_solution_id,'ARTICULOS'
FROM     ASS_ARTICLE
LEFT JOIN   ASS_PROJECT_ARTICLE ON ASS_ARTICLE.fl_int_solution_id = ASS_PROJECT_ARTICLE.prar_solution_id
WHERE    fl_int_responsible_id = @i_user_id  AND fl_int_group_responsible_id = @o_grp
AND      dbo.FUN_ASDK_STATUS_CHILD(FL_INT_SOLUTION_STATE) > 0 AND prar_project_id = @i_project_id