SELECT ASDK_PROJECTS.FL_STR_PROJECT_NAME PROYECTO
  , ASDK_SERVICE_CALL.serv_id_by_project NUMERO_DEL_CASO
  , ASDK_SERVICE_CALL.serv_id ID_interno_del_caso
  , 'LLAMADA DE SERVICIO' TIPO_DE_CASO
  , ASDK_CATEGORY.CTG_CAPTION CATEGORIA
  , ASDK_CATEGORY.FL_STR_HIERARCHY JERARQUIA
  , ASDK_SERVICE_CALL.serv_description_nohtml DESCRIPCION
  , UsuAutor.UNAME NOMBRE_AUTOR
  , UsuReceptor.UNAME NOMBRE_RECEPTOR
  , UsuEspecialista.UNAME ESPECIALISTA
  , GROUPHD.GRP_NAME GRUPO_ESPECIALISTA
  , Afw_status.stat_name ESTADO
  , ASDK_REASON.reas_description RAZON
  , VENDOR.COMPANY COMPANIA
  , COUNTRYVendor.description PAIS_COMPANIA
  , USUARIOS.UNAME USUARIO
  , USUARIOS.USERNAME USUARIO_Alias
  , COUNTRY.description PAIS_USUARIO
  , DEPARTAMENTOS.nomdepto DEPARTAMENTO_USUARIO
  , COMPANY.description SUCURSAL_USUARIO
  , SITE.description SEDE_USUARIO
  , BUILDING.description EDIFICIO_USUARIO
  , ASDK_SERVICE_CALL.Serv_opened_date FECHA_REGISTRO
  , REGISTRY_TYPE.ret_description TIPO_REGISTRO
  , ASDK_SERVICE_CALL.Serv_colsed_date FECHA_CIERRE
  , ASDK_SERVICE_CALL.Serv_sdb_last_shot ULTIMO_PASO_DEL_DBManager
  , ASDK_SERVICE_CALL.Serv_attention_real_date FECHA_ATENCION
  , ASDK_SERVICE_CALL.Serv_solution_real_date FECHA_SOLUCION
  , ASDK_IMPACT.impa_description IMPACTO
  , ASDK_URGENCY.urge_description URGENCIA
  , ASDK_PRIORITY.prio_description PRIORIDAD
  , ASDK_SERVICE.NAME SERVICIO
  , ASDK_SLA.NAME SLA_Nombre
  , ASDK_SERVICE_CALL.Serv_expired_date FECHA_MAX_SOLUCION
  , ASDK_SERVICE_CALL.Serv_attention_esti_date FECHA_MAX_ATENCION
  , nvl(ASDK_SERVICE_CALL.Serv_current_time, 0) TIEMPO_DEL_CASO
  , nvl(ASDK_SERVICE_CALL.Serv_current_progress, 0) PROGRESO_DEL_CASO
  , nvl(ASDK_SERVICE_CALL.Serv_attention_time, 0) TIEMPO_DE_ATENCION_ESTIMADO
  , nvl(ASDK_SERVICE_CALL.Serv_attention_real_time, 0) TIEMPO_DE_ATENCION_REAL
  , nvl(ASDK_SERVICE_CALL.Serv_solution_time, 0) TIEMPO_DE_SOLUCION_ESTIMADO
  , nvl(ASDK_SERVICE_CALL.Serv_solution_real_time, 0) TIEMPO_DE_SOLUCION_REAL
  , (Select max(SERV.serv_id_by_project) UltimaServAsociada
     From ASDK_SERVICE_CALL_SELF inner join ASDK_SERVICE_CALL SERV on ASDK_SERVICE_CALL_SELF.inse_serv_child_id = SERV.serv_id
     Where ASDK_SERVICE_CALL_SELF.inse_serv_parent_id = ASDK_SERVICE_CALL.Serv_id) ULTIMA_LLAMADA_ASOCIADA
  , (Select max(INCI.inci_id_by_project) UltimoInciAsociado
     From ASDK_INCIDENT_SERVICE_CALL inner join ASDK_INCIDENT INCI on ASDK_INCIDENT_SERVICE_CALL.inch_inci_id = INCI.inci_id
     Where ASDK_INCIDENT_SERVICE_CALL.inch_serv_id = ASDK_SERVICE_CALL.serv_id) ULTIMO_INCIDENTE_ASOCIADO
  , (Select max(PROB.prob_id_by_project) UltimoProbAsociado
     From ASDK_SERVICE_CALL_PROBLEM inner join ASDK_PROBLEM PROB on ASDK_SERVICE_CALL_PROBLEM.inpr_prob_id = PROB.prob_id
     Where ASDK_SERVICE_CALL_PROBLEM.inpr_serv_id = ASDK_SERVICE_CALL.serv_id) ULTIMO_PROBLEMA_ASOCIADO
  , (Select max(CHAN.chan_id_by_project) UltimoCambioAsociado
     From ASDK_SERVICE_CALL_CHANGE inner join ASDK_CHANGE CHAN on ASDK_SERVICE_CALL_CHANGE.inch_chan_id = CHAN.chan_id
     Where ASDK_SERVICE_CALL_CHANGE.inch_Serv_id = ASDK_SERVICE_CALL.Serv_id) ULTIMO_CAMBIO_ASOCIADO
  , DESC_CASOS(ASDK_SERVICE_CALL.serv_commentary) COMENTARIO_DE_LA_SOLUCION
  , (Select CI_CONFIGURATION_ITEM.FL_STR_CI_NAME From CI_CONFIGURATION_ITEM 
     Where CI_CONFIGURATION_ITEM.FL_INT_CI_ID = ASDK_SERVICE_CALL.serv_associated_ci) CI_ASOCIADO
  , '' Causa
FROM ASDK_SERVICE_CALL INNER JOIN ASDK_PROJECTS ON ASDK_SERVICE_CALL.Serv_fl_int_project_id = ASDK_PROJECTS.fl_int_id 
  left outer join ASDK_CATEGORY on ASDK_CATEGORY.CTG_INDEX = ASDK_SERVICE_CALL.Serv_category_id
  left outer join USUARIOS UsuAutor on UsuAutor.CODUSUARIO = ASDK_SERVICE_CALL.Serv_author
  left outer join USUARIOS UsuReceptor on UsuReceptor.CODUSUARIO = ASDK_SERVICE_CALL.Serv_codreceptor
  left outer join USUARIOS UsuEspecialista on UsuEspecialista.CODUSUARIO = ASDK_SERVICE_CALL.Serv_responsible_id
  left outer join GROUPHD on GROUPHD.GRP_ID = ASDK_SERVICE_CALL.Serv_responsible_group_id
  left outer join AFW_STATUS on AFW_STATUS.stat_id  = ASDK_SERVICE_CALL.Serv_status_id
  left outer join ASDK_REASON on ASDK_REASON.reas_id = ASDK_SERVICE_CALL.Serv_reason_id
  left outer join REGISTRY_TYPE on REGISTRY_TYPE.ret_id = ASDK_SERVICE_CALL.Serv_registry_type_id
  left outer join Asdk_priority on Asdk_priority.prio_id = ASDK_SERVICE_CALL.Serv_priority_id
  left outer join ASDK_IMPACT on ASDK_IMPACT.impa_id = ASDK_SERVICE_CALL.Serv_impact_id
  left outer join ASDK_URGENCY on ASDK_URGENCY.urge_id = ASDK_SERVICE_CALL.Serv_urgency_id
  LEFT OUTER JOIN USUARIOS ON USUARIOS.CODUSUARIO = ASDK_SERVICE_CALL.Serv_customer_id 
  left outer join COUNTRY on COUNTRY.countryid = USUARIOS.COUNTRYID
  left outer join DEPARTAMENTOS on DEPARTAMENTOS.coddepto = USUARIOS.CODDEPTO
  left outer join COMPANY on COMPANY.companyid = USUARIOS.COMPANYID
  left outer join SITE on SITE.siteid = USUARIOS.SITEID
  left outer join BUILDING on BUILDING.buildingid = USUARIOS.BUILDINGID
  left outer join VENDOR on VENDOR.VENDORID = ASDK_SERVICE_CALL.Serv_vendor_id
  left outer join COUNTRY CountryVendor on CountryVendor.countryid = VENDOR.COUNTRYID
  left outer join ASDK_SERVICE on ASDK_SERVICE.FL_INT_SERVICE_ID = ASDK_SERVICE_CALL.Serv_service_id
  left outer join ASDK_SLA on ASDK_SLA.SLA_ID = ASDK_SERVICE_CALL.Serv_service_sla_id
WHERE ASDK_PROJECTS.FL_INT_ID = :PROYECTO and ASDK_SERVICE_CALL.Serv_opened_date between :FECHAINI AND :FECHAFIN

UNION ALL
SELECT ASDK_PROJECTS.FL_STR_PROJECT_NAME PROYECTO
  , Asdk_incident.inci_id_by_project NUMERO_DEL_CASO
  , ASDK_INCIDENT.inci_id ID_interno_del_caso
  , 'INCIDENTE' TIPO_DE_CASO
  , ASDK_CATEGORY.CTG_CAPTION CATEGORIA
  , ASDK_CATEGORY.FL_STR_HIERARCHY JERARQUIA
  , Asdk_incident.inci_description_nohtml DESCRIPCION
  , UsuAutor.UNAME NOMBRE_AUTOR
  , UsuReceptor.UNAME NOMBRE_RECEPTOR
  , UsuEspecialista.UNAME ESPECIALISTA
  , GROUPHD.GRP_NAME GRUPO_ESPECIALISTA
  , Afw_status.stat_name ESTADO
  , ASDK_REASON.reas_description RAZON
  , VENDOR.COMPANY COMPANIA
  , COUNTRYVendor.description PAIS_COMPANIA
  , USUARIOS.UNAME USUARIO
  , USUARIOS.USERNAME USUARIO_Alias
  , COUNTRY.description PAIS_USUARIO
  , DEPARTAMENTOS.nomdepto DEPARTAMENTO_USUARIO
  , COMPANY.description SUCURSAL_USUARIO
  , SITE.description SEDE_USUARIO
  , BUILDING.description EDIFICIO_USUARIO
  , ASDK_INCIDENT.inci_opened_date FECHA_REGISTRO
  , REGISTRY_TYPE.ret_description TIPO_REGISTRO
  , Asdk_incident.inci_colsed_date FECHA_CIERRE
  , ASDK_INCIDENT.inci_sdb_last_shot ULTIMO_PASO_DEL_DBManager
  , Asdk_incident.inci_attention_real_date FECHA_ATENCION
  , Asdk_incident.inci_solution_real_date FECHA_SOLUCION
  , ASDK_IMPACT.impa_description IMPACTO
  , ASDK_URGENCY.urge_description URGENCIA
  , ASDK_PRIORITY.prio_description PRIORIDAD
  , ASDK_SERVICE.NAME SERVICIO
  , ASDK_SLA.NAME SLA_Nombre
  , Asdk_incident.inci_expired_date FECHA_MAX_SOLUCION
  , Asdk_incident.inci_attention_esti_date FECHA_MAX_ATENCION
  , nvl(ASDK_INCIDENT.inci_current_time, 0) TIEMPO_DEL_CASO
  , nvl(ASDK_INCIDENT.inci_current_progress, 0) PROGRESO_DEL_CASO
  , nvl(ASDK_INCIDENT.inci_attention_time, 0) TIEMPO_DE_ATENCION_ESTIMADO
  , nvl(ASDK_INCIDENT.inci_attention_real_time, 0) TIEMPO_DE_ATENCION_REAL
  , nvl(ASDK_INCIDENT.inci_solution_time, 0) TIEMPO_DE_SOLUCION_ESTIMADO
  , nvl(ASDK_INCIDENT.inci_solution_real_time, 0) TIEMPO_DE_SOLUCION_REAL
  , (Select max(SERV.serv_id_by_project) UltimoServAsociado
     From ASDK_INCIDENT_SERVICE_CALL inner join ASDK_SERVICE_CALL SERV on ASDK_INCIDENT_SERVICE_CALL.inch_serv_id = SERV.serv_id
     Where ASDK_INCIDENT_SERVICE_CALL.inch_inci_id = ASDK_INCIDENT.inci_id) ULTIMA_LLAMADA_ASOCIADA
  , (Select max(INCI.Inci_id_by_project) UltimoInciAsociado
     From ASDK_INCIDENT_SELF inner join ASDK_INCIDENT INCI on ASDK_INCIDENT_SELF.inse_inci_child_id = INCI.inci_id
     Where ASDK_INCIDENT_SELF.inse_inci_parent_id = ASDK_INCIDENT.inci_id) ULTIMO_INCIDENTE_ASOCIADO
  , (Select max(PROB.prob_id_by_project) UltimoProbAsociado
     From ASDK_INCIDENT_PROBLEM inner join ASDK_PROBLEM PROB on ASDK_INCIDENT_PROBLEM.inpr_prob_id = PROB.prob_id
     Where ASDK_INCIDENT_PROBLEM.inpr_inci_id = ASDK_INCIDENT.inci_id) ULTIMO_PROBLEMA_ASOCIADO
  , (Select max(CHAN.chan_id_by_project) UltimoProbAsociado
     From ASDK_INCIDENT_CHANGE inner join ASDK_CHANGE CHAN on ASDK_INCIDENT_CHANGE.inch_chan_id = CHAN.chan_id
     Where ASDK_INCIDENT_CHANGE.inch_inci_id = ASDK_INCIDENT.inci_id) ULTIMO_CAMBIO_ASOCIADO
  , DESC_CASOS(Asdk_incident.inci_commentary) COMENTARIO_DE_LA_SOLUCION
  , (Select CI_CONFIGURATION_ITEM.FL_STR_CI_NAME From CI_CONFIGURATION_ITEM 
     Where CI_CONFIGURATION_ITEM.FL_INT_CI_ID = ASDK_INCIDENT.inci_associated_ci) CI_ASOCIADO
  , '' Causa
FROM ASDK_INCIDENT INNER JOIN ASDK_PROJECTS ON ASDK_INCIDENT.inci_fl_int_project_id = ASDK_PROJECTS.fl_int_id 
  left outer join ASDK_CATEGORY on ASDK_CATEGORY.CTG_INDEX = Asdk_incident.inci_category_id
  left outer join USUARIOS UsuAutor on UsuAutor.CODUSUARIO = ASDK_INCIDENT.inci_author
  left outer join USUARIOS UsuReceptor on UsuReceptor.CODUSUARIO = Asdk_incident.inci_codreceptor
  left outer join USUARIOS UsuEspecialista on UsuEspecialista.CODUSUARIO = Asdk_incident.inci_responsible_id
  left outer join GROUPHD on GROUPHD.GRP_ID = ASDK_INCIDENT.inci_responsible_group_id
  left outer join AFW_STATUS on AFW_STATUS.stat_id  = ASDK_INCIDENT.inci_status_id
  left outer join ASDK_REASON on ASDK_REASON.reas_id = ASDK_INCIDENT.inci_reason_id
  left outer join REGISTRY_TYPE on REGISTRY_TYPE.ret_id = Asdk_incident.inci_registry_type_id
  left outer join Asdk_priority on Asdk_priority.prio_id = Asdk_incident.inci_priority_id
  left outer join ASDK_IMPACT on ASDK_IMPACT.impa_id = Asdk_incident.inci_impact_id
  left outer join ASDK_URGENCY on ASDK_URGENCY.urge_id = Asdk_incident.inci_urgency_id
  LEFT OUTER JOIN USUARIOS ON USUARIOS.CODUSUARIO = ASDK_INCIDENT.inci_customer_id 
  left outer join COUNTRY on COUNTRY.countryid = USUARIOS.COUNTRYID
  left outer join DEPARTAMENTOS on DEPARTAMENTOS.coddepto = USUARIOS.CODDEPTO
  left outer join COMPANY on COMPANY.companyid = USUARIOS.COMPANYID
  left outer join SITE on SITE.siteid = USUARIOS.SITEID
  left outer join BUILDING on BUILDING.buildingid = USUARIOS.BUILDINGID
  left outer join VENDOR on VENDOR.VENDORID = Asdk_incident.inci_vendor_id
  left outer join COUNTRY CountryVendor on CountryVendor.countryid = VENDOR.COUNTRYID
  left outer join ASDK_SERVICE on ASDK_SERVICE.FL_INT_SERVICE_ID = ASDK_INCIDENT.inci_service_id
  left outer join ASDK_SLA on ASDK_SLA.SLA_ID = ASDK_INCIDENT.inci_service_sla_id
WHERE ASDK_PROJECTS.FL_INT_ID = :PROYECTO and ASDK_INCIDENT.Inci_opened_date between :FECHAINI AND :FECHAFIN

UNION ALL
SELECT ASDK_PROJECTS.FL_STR_PROJECT_NAME PROYECTO
  , ASDK_PROBLEM.Prob_id_by_project NUMERO_DEL_CASO
  , ASDK_PROBLEM.Prob_id ID_interno_del_caso
  , 'PROBLEMA' TIPO_DE_CASO
  , ASDK_CATEGORY.CTG_CAPTION CATEGORIA
  , ASDK_CATEGORY.FL_STR_HIERARCHY JERARQUIA
  , ASDK_PROBLEM.prob_description_nohtml DESCRIPCION
  , UsuAutor.UNAME NOMBRE_AUTOR
  , UsuReceptor.UNAME NOMBRE_RECEPTOR
  , UsuEspecialista.UNAME ESPECIALISTA
  , GROUPHD.GRP_NAME GRUPO_ESPECIALISTA
  , Afw_status.stat_name ESTADO
  , ASDK_REASON.reas_description RAZON
  , '' COMPANIA
  , '' PAIS_COMPANIA
  , '' USUARIO
  , '' USUARIO_Alias
  , '' PAIS_USUARIO
  , '' DEPARTAMENTO_USUARIO
  , '' SUCURSAL_USUARIO
  , '' SEDE_USUARIO
  , '' EDIFICIO_USUARIO
  , ASDK_PROBLEM.Prob_opened_date FECHA_REGISTRO
  , REGISTRY_TYPE.ret_description TIPO_REGISTRO
  , ASDK_PROBLEM.Prob_colsed_date FECHA_CIERRE
  , ASDK_PROBLEM.Prob_sdb_last_shot ULTIMO_PASO_DEL_DBManager
  , ASDK_PROBLEM.Prob_attention_real_date FECHA_ATENCION
  , ASDK_PROBLEM.Prob_solution_real_date FECHA_SOLUCION
  , ASDK_IMPACT.impa_description IMPACTO
  , ASDK_URGENCY.urge_description URGENCIA
  , ASDK_PRIORITY.prio_description PRIORIDAD
  , ASDK_SERVICE.NAME SERVICIO
  , ASDK_SLA.NAME SLA_Nombre
  , ASDK_PROBLEM.Prob_expired_date FECHA_MAX_SOLUCION
  , ASDK_PROBLEM.Prob_attention_esti_date FECHA_MAX_ATENCION
  , nvl(ASDK_PROBLEM.Prob_current_time, 0) TIEMPO_DEL_CASO
  , nvl(ASDK_PROBLEM.Prob_current_progress, 0) PROGRESO_DEL_CASO
  , nvl(ASDK_PROBLEM.Prob_attention_time, 0) TIEMPO_DE_ATENCION_ESTIMADO
  , nvl(ASDK_PROBLEM.Prob_attention_real_time, 0) TIEMPO_DE_ATENCION_REAL
  , nvl(ASDK_PROBLEM.Prob_solution_time, 0) TIEMPO_DE_SOLUCION_ESTIMADO
  , nvl(ASDK_PROBLEM.Prob_solution_real_time, 0) TIEMPO_DE_SOLUCION_REAL
  , (Select max(SERV.serv_id_by_project) UltimaLlamadaAsociada
     From ASDK_SERVICE_CALL_PROBLEM inner join ASDK_SERVICE_CALL SERV on ASDK_SERVICE_CALL_PROBLEM.inpr_serv_id = SERV.serv_id
     Where ASDK_SERVICE_CALL_PROBLEM.inpr_prob_id = ASDK_PROBLEM.Prob_id) ULTIMA_LLAMADA_ASOCIADA
  , (Select max(INCI.inci_id_by_project) UltimoInciAsociado
     From ASDK_INCIDENT_PROBLEM inner join ASDK_INCIDENT INCI on ASDK_INCIDENT_PROBLEM.inpr_inci_id = INCI.inci_id
     Where ASDK_INCIDENT_PROBLEM.inpr_prob_id = ASDK_PROBLEM.Prob_id) ULTIMA_INCIDENTE_ASOCIADO
  , (Select max(PROB.prob_id_by_project) UltimoProbAsociado
     From ASDK_PROBLEM_SELF inner join ASDK_PROBLEM PROB on ASDK_PROBLEM_SELF.prse_prob_child_id = PROB.prob_id
     Where ASDK_PROBLEM_SELF.prse_prob_parent_id = ASDK_PROBLEM.Prob_id) ULTIMO_PROBLEMA_ASOCIADO
  , (Select max(CHAN.chan_id_by_project) UltimoCambioAsociado
     From ASDK_PROBLEM_CHANGE inner join ASDK_CHANGE CHAN on ASDK_PROBLEM_CHANGE.prch_chan_id = CHAN.chan_id
     Where ASDK_PROBLEM_CHANGE.prch_prob_id = ASDK_PROBLEM.Prob_id) ULTIMO_CAMBIO_ASOCIADO
  , DESC_CASOS(ASDK_PROBLEM.Prob_commentary) COMENTARIO_DE_LA_SOLUCION
  , (Select CI_CONFIGURATION_ITEM.FL_STR_CI_NAME From CI_CONFIGURATION_ITEM 
     Where CI_CONFIGURATION_ITEM.FL_INT_CI_ID = ASDK_PROBLEM.Prob_associated_ci) CI_ASOCIADO
  , ASDK_CAUSE.caus_title CAUSA
FROM ASDK_PROBLEM INNER JOIN ASDK_PROJECTS ON ASDK_PROBLEM.Prob_fl_int_project_id = ASDK_PROJECTS.fl_int_id 
  left outer join ASDK_CATEGORY on ASDK_CATEGORY.CTG_INDEX = ASDK_PROBLEM.Prob_category_id
  left outer join USUARIOS UsuAutor on UsuAutor.CODUSUARIO = ASDK_PROBLEM.Prob_author
  left outer join USUARIOS UsuReceptor on UsuReceptor.CODUSUARIO = ASDK_PROBLEM.Prob_codreceptor
  left outer join USUARIOS UsuEspecialista on UsuEspecialista.CODUSUARIO = ASDK_PROBLEM.Prob_responsible_id
  left outer join GROUPHD on GROUPHD.GRP_ID = ASDK_PROBLEM.Prob_responsible_group_id
  left outer join AFW_STATUS on AFW_STATUS.stat_id  = ASDK_PROBLEM.Prob_status_id
  left outer join ASDK_REASON on ASDK_REASON.reas_id = ASDK_PROBLEM.Prob_reason_id
  left outer join REGISTRY_TYPE on REGISTRY_TYPE.ret_id = ASDK_PROBLEM.Prob_registry_type_id
  left outer join Asdk_priority on Asdk_priority.prio_id = ASDK_PROBLEM.Prob_priority_id
  left outer join ASDK_IMPACT on ASDK_IMPACT.impa_id = ASDK_PROBLEM.Prob_impact_id
  left outer join ASDK_URGENCY on ASDK_URGENCY.urge_id = ASDK_PROBLEM.Prob_urgency_id
  left outer join ASDK_SERVICE on ASDK_SERVICE.FL_INT_SERVICE_ID = ASDK_PROBLEM.Prob_service_id
  left outer join ASDK_SLA on ASDK_SLA.SLA_ID = ASDK_PROBLEM.Prob_service_sla_id
  left outer join ASDK_CAUSE on ASDK_CAUSE.caus_id = ASDK_PROBLEM.prob_cause_id
WHERE ASDK_PROJECTS.FL_INT_ID = :PROYECTO and ASDK_PROBLEM.Prob_opened_date between :FECHAINI AND :FECHAFIN

UNION ALL
SELECT ASDK_PROJECTS.FL_STR_PROJECT_NAME PROYECTO
  , ASDK_CHANGE.Chan_id_by_project NUMERO_DEL_CASO
  , ASDK_CHANGE.Chan_id ID_interno_del_caso
  , 'CAMBIO' TIPO_DE_CASO
  , ASDK_CATEGORY.CTG_CAPTION CATEGORIA
  , ASDK_CATEGORY.FL_STR_HIERARCHY JERARQUIA
  , ASDK_CHANGE.chan_description_nohtml DESCRIPCION
  , UsuAutor.UNAME NOMBRE_AUTOR
  , UsuReceptor.UNAME NOMBRE_RECEPTOR
  , UsuEspecialista.UNAME ESPECIALISTA
  , GROUPHD.GRP_NAME GRUPO_ESPECIALISTA
  , Afw_status.stat_name ESTADO
  , ASDK_REASON.reas_description RAZON
  , VENDOR.COMPANY COMPANIA
  , COUNTRYVendor.description PAIS_COMPANIA
  , USUARIOS.UNAME USUARIO
  , USUARIOS.USERNAME USUARIO_Alias
  , COUNTRY.description PAIS_USUARIO
  , DEPARTAMENTOS.nomdepto DEPARTAMENTO_USUARIO
  , COMPANY.description SUCURSAL_USUARIO
  , SITE.description SEDE_USUARIO
  , BUILDING.description EDIFICIO_USUARIO
  , ASDK_CHANGE.Chan_opened_date FECHA_REGISTRO
  , REGISTRY_TYPE.ret_description TIPO_REGISTRO
  , ASDK_CHANGE.Chan_colsed_date FECHA_CIERRE
  , ASDK_CHANGE.Chan_sdb_last_shot ULTIMO_PASO_DEL_DBManager
  , ASDK_CHANGE.chan_real_attention FECHA_ATENCION
  , ASDK_CHANGE.chan_real_solution FECHA_SOLUCION
  , ASDK_IMPACT.impa_description IMPACTO
  , ASDK_URGENCY.urge_description URGENCIA
  , ASDK_PRIORITY.prio_description PRIORIDAD
  , ASDK_SERVICE.NAME SERVICIO
  , ASDK_SLA.NAME SLA_Nombre
  , ASDK_CHANGE.chan_clo_sol_date FECHA_MAX_SOLUCION
  , ASDK_CHANGE.chan_rfc_att_date FECHA_MAX_ATENCION
  , nvl(ASDK_CHANGE.Chan_current_time, 0) TIEMPO_DEL_CASO
  , nvl(ASDK_CHANGE.Chan_current_progress, 0) PROGRESO_DEL_CASO
  , (nvl(ASDK_CHANGE.chan_rfc_att_time, 0) + nvl(ASDK_CHANGE.chan_cab_att_time, 0) + nvl(ASDK_CHANGE.chan_bui_att_time, 0) + nvl(ASDK_CHANGE.chan_tes_att_time, 0)
     + nvl(ASDK_CHANGE.chan_bop_att_time, 0) + nvl(ASDK_CHANGE.chan_rev_att_time, 0) + nvl(ASDK_CHANGE.chan_clo_att_time, 0)) TIEMPO_DE_ATENCION_ESTIMADO
  , null TIEMPO_DE_ATENCION_REAL
  , (nvl(ASDK_CHANGE.chan_rfc_sol_time, 0) + nvl(ASDK_CHANGE.chan_cab_sol_time, 0) + nvl(ASDK_CHANGE.chan_bui_sol_time, 0) + nvl(ASDK_CHANGE.chan_tes_sol_time, 0)
     + nvl(ASDK_CHANGE.chan_bop_sol_time, 0) + nvl(ASDK_CHANGE.chan_rev_sol_time, 0) + nvl(ASDK_CHANGE.chan_clo_sol_time, 0)) TIEMPO_DE_SOLUCION_ESTIMADO
  , null TIEMPO_DE_SOLUCION_REAL
  , (Select max(SERV.serv_id_by_project) UltimoServAsociada
     From ASDK_SERVICE_CALL_CHANGE inner join ASDK_SERVICE_CALL SERV on ASDK_SERVICE_CALL_CHANGE.inch_serv_id = SERV.serv_id
     Where ASDK_SERVICE_CALL_CHANGE.inch_chan_id = ASDK_CHANGE.Chan_id) ULTIMA_LLAMADA_ASOCIADA
  , (Select max(INCI.inci_id_by_project) UltimoServAsociado
     From ASDK_INCIDENT_CHANGE inner join ASDK_INCIDENT INCI on ASDK_INCIDENT_CHANGE.inch_inci_id = INCI.inci_id
     Where ASDK_INCIDENT_CHANGE.inch_chan_id = ASDK_CHANGE.Chan_id) ULTIMA_INCIDENTE_ASOCIADO
  , (Select max(PROB.prob_id_by_project) UltimoProbAsociado
     From ASDK_PROBLEM_CHANGE inner join ASDK_PROBLEM PROB on ASDK_PROBLEM_CHANGE.prch_prob_id = PROB.prob_id
     Where ASDK_PROBLEM_CHANGE.prch_chan_id = ASDK_CHANGE.Chan_id) ULTIMO_PROBLEMA_ASOCIADO
  , (Select max(CHAN.chan_id_by_project) UltimoProbAsociado
     From ASDK_CHANGE_SELF inner join ASDK_CHANGE CHAN on ASDK_CHANGE_SELF.prch_chan_child_id = CHAN.chan_id
     Where ASDK_CHANGE_SELF.prch_chan_parent_id = ASDK_CHANGE.Chan_id) ULTIMO_CAMBIO_ASOCIADO
  , DESC_CASOS(ASDK_CHANGE.Chan_commentary) COMENTARIO_DE_LA_SOLUCION
  , (Select CI_CONFIGURATION_ITEM.FL_STR_CI_NAME From CI_CONFIGURATION_ITEM 
     Where CI_CONFIGURATION_ITEM.FL_INT_CI_ID = ASDK_CHANGE.Chan_associated_ci) CI_ASOCIADO
  , '' Causa
FROM ASDK_CHANGE INNER JOIN ASDK_PROJECTS ON ASDK_CHANGE.Chan_fl_int_project_id = ASDK_PROJECTS.fl_int_id 
  left outer join ASDK_CATEGORY on ASDK_CATEGORY.CTG_INDEX = ASDK_CHANGE.Chan_category_id
  left outer join USUARIOS UsuAutor on UsuAutor.CODUSUARIO = ASDK_CHANGE.Chan_author
  left outer join USUARIOS UsuReceptor on UsuReceptor.CODUSUARIO = ASDK_CHANGE.Chan_codreceptor
  left outer join USUARIOS UsuEspecialista on UsuEspecialista.CODUSUARIO = ASDK_CHANGE.Chan_responsible_id
  left outer join GROUPHD on GROUPHD.GRP_ID = ASDK_CHANGE.Chan_responsible_group_id
  left outer join AFW_STATUS on AFW_STATUS.stat_id  = ASDK_CHANGE.Chan_status_id
  left outer join ASDK_REASON on ASDK_REASON.reas_id = ASDK_CHANGE.Chan_reason_id
  left outer join REGISTRY_TYPE on REGISTRY_TYPE.ret_id = ASDK_CHANGE.Chan_registry_type_id
  left outer join Asdk_priority on Asdk_priority.prio_id = ASDK_CHANGE.Chan_priority_id
  left outer join ASDK_IMPACT on ASDK_IMPACT.impa_id = ASDK_CHANGE.Chan_impact_id
  left outer join ASDK_URGENCY on ASDK_URGENCY.urge_id = ASDK_CHANGE.Chan_urgency_id
  LEFT OUTER JOIN USUARIOS ON USUARIOS.CODUSUARIO = ASDK_CHANGE.Chan_customer_id 
  left outer join COUNTRY on COUNTRY.countryid = USUARIOS.COUNTRYID
  left outer join DEPARTAMENTOS on DEPARTAMENTOS.coddepto = USUARIOS.CODDEPTO
  left outer join COMPANY on COMPANY.companyid = USUARIOS.COMPANYID
  left outer join SITE on SITE.siteid = USUARIOS.SITEID
  left outer join BUILDING on BUILDING.buildingid = USUARIOS.BUILDINGID
  left outer join VENDOR on VENDOR.VENDORID = ASDK_CHANGE.Chan_vendor_id
  left outer join COUNTRY CountryVendor on CountryVendor.countryid = VENDOR.COUNTRYID
  left outer join ASDK_SERVICE on ASDK_SERVICE.FL_INT_SERVICE_ID = ASDK_CHANGE.Chan_service_id
  left outer join ASDK_SLA on ASDK_SLA.SLA_ID = ASDK_CHANGE.Chan_service_sla_id
WHERE ASDK_PROJECTS.FL_INT_ID = :PROYECTO and ASDK_CHANGE.Chan_opened_date between :FECHAINI AND :FECHAFIN
ORDER BY TIPO_DE_CASO, NUMERO_DEL_CASO</CommandText>
				<DataSourceName>ARANDA</DataSourceName>
				<QueryParameters>
					<QueryParameter Name="Proyecto">
						<Value>=Parameters!Proyecto.Value</Value>
					</QueryParameter>
					<QueryParameter Name="FechaIni">
						<Value>=Parameters!FechaIni.Value</Value>
					</QueryParameter>
					<QueryParameter Name="FechaFin">
						<Value>=Parameters!FechaFin.Value</Value>
					</QueryParameter>
				</QueryParameters>
			</Query>
		</DataSet>
		<DataSet Name="dsProyecto">
			<Fields>
				<Field Name="FL_INT_ID">
					<DataField>FL_INT_ID</DataField>
				</Field>
				<Field Name="Proyecto">
					<DataField>Proyecto</DataField>
				</Field>
			</Fields>
			<Query>
				<CommandText>Select FL_INT_ID, Fl_str_project_name Proyecto
From ASDK_PROJECTS
Order by FL_INT_PROJECTSTATE desc, Proyecto