CREATE OR REPLACE FORCE VIEW "V_ASDK_INCIDENT_RULES" ("INCI_ID", "INCI_CATEGORY_ID", "INCI_CUSTOMER_ID", "INCI_PRIORITY_ID", "INCI_IMPACT_ID", "INCI_URGENCY_ID", "INCI_STATUS_ID", "INCI_CURRENT_PROGRESS", "INCI_RESPONSIBLE_GROUP_ID", "INCI_CURRENT_TIME", "INCI_EXPIRED_DATE", "INCI_REGISTRY_TYPE_ID", "OPENED_DATE", "INCI_COLSED_DATE", "INCI_SERVICE_ID", "INCI_ATTENTION_TIME", "INCI_ATTENTION_REAL_DATE", "INCI_SOLUTION_TIME", "INCI_INVOLVED_USER", "INCI_INVOLVED_CI", "INCI_VENDOR_ID", "INCI_ASSOCIATED_CI", "INCI_DESCRIPTION", "INCI_RESPONSIBLE_ID", "INCI_SERVICE_SLA_ID", "INCI_ID_BY_PROJECT", "INCI_SOLUTION_REAL_TIME", "INCI_ATTENTION_REAL_TIME", "INCI_SOLUTION_REAL_DATE", "EXPR1", "INCI_REASON_ID", "INCI_AUTHOR", "INCI_ATTENTION_ESTI_DATE", "CUMPLE_ATENCION", "CUMPLE_SOLUCION", "FL_STR_CI_NAME", "INCI_LAST_TRANSITION", "INCI_FLAG_NOTE", "INCI_FLAG_NOTE_PRIV", "SITEID", "CITYID", "COUNTRYID", "BUILDINGID", "CODDEPTO", "CHA_ID", "FLOORID", "NUMBERDEPID", "COMPANYID", "FL_INT_PROJECT_ID", "INCI_FLAG_CATEGORY", "INCI_FLAG_PRIORITY", "INCI_FLAG_IMPACT", "INCI_FLAG_URGENCY", "INCI_FLAG_STATUS", "INCI_FLAG_REASON", "INCI_FLAG_SERVICE", "INCI_FLAG_SLA", "INCI_FLAG_RESP_USER", "INCI_FLAG_RESP_GROUP", "ADD_STR_1", "ADD_STR_2", "ADD_STR_3", "ADD_STR_4", "ADD_STR_5", "ADD_STR_6", "ADD_STR_7", "ADD_STR_8", "ADD_STR_9", "ADD_STR_10", "ADD_STR_11", "ADD_STR_12", "ADD_STR_13", "ADD_STR_14", "ADD_STR_15", "ADD_STR_16", "ADD_STR_17", "ADD_STR_18", "ADD_STR_19", "ADD_STR_20", "ADD_STR_21", "ADD_STR_22", "ADD_STR_23", "ADD_STR_24", "ADD_STR_25", "ADD_STR_26", "ADD_STR_27", "ADD_STR_28", "ADD_STR_29", "ADD_STR_30", "inci_attention_add_days_date", "inci_opened_add_days_date", "INCI_SOLUTION_ADD_DAYS_DATE", "INCI_STATUS_TIME", "TIME_STAMP", "FILES", "SURVEY_SUCCEEDED", "INCI_FLAG_PROCEDURE") AS 
  SELECT
	inci_id,
	inci_category_id,
	inci_customer_id,
	inci_priority_id,
	inci_impact_id,
	inci_urgency_id,
	inci_status_id,
	inci_current_progress,
	inci_responsible_group_id,
	inci_current_time,
	inci_expired_date,
	inci_registry_type_id,
	inci_opened_date opened_date,
	inci_colsed_date,
	inci_service_id,
	inci_attention_time,
	inci_attention_real_date,
	inci_solution_time + inci_attention_time inci_solution_time,
	inci_involved_user,
	inci_involved_ci,
	inci_vendor_id,
	inci_associated_ci,
	inci_description,
	inci_responsible_id,
	inci_service_sla_id,
	inci_id_by_project,
	inci_solution_real_time,
	inci_attention_real_time,
	inci_solution_real_date,
	inci_solution_time expr1,
	inci_reason_id,
	inci_author,
	inci_attention_esti_date,
	CASE WHEN CASE WHEN inci_attention_real_time IS NULL THEN SIGN (inci_attention_time - inci_current_time) ELSE SIGN (inci_attention_time - inci_attention_real_time) END >= 0 THEN 1 ELSE 0 END cumple_atencion,
	CASE WHEN CASE WHEN inci_solution_real_time IS NULL THEN SIGN (inci_solution_time + inci_attention_time - inci_current_time) ELSE SIGN (inci_solution_time + inci_attention_time - inci_solution_real_time) END >= 0 THEN 1 ELSE 0 END cumple_solucion,
	ci.fl_str_ci_name,
	FUN_GET_LAST_TRANSITION (1, inci_id, ir.time_stamp) inci_last_transition,
	inci_flag_note,
	inci_flag_note_priv,
	u.siteid,
	u.cityid,
	u.countryid,
	u.buildingid,
	u.coddepto,
	u.cha_id,
	u.floorid,
	u.numberdepid,
	u.companyid,
	inci_fl_int_project_id fl_int_project_id,
	inci_flag_category,
	inci_flag_priority,
	inci_flag_impact,
	inci_flag_urgency,
	inci_flag_status,
	inci_flag_reason,
	inci_flag_service,
	inci_flag_sla,
	inci_flag_resp_user,
	inci_flag_resp_group,
	ir.add_str_1,
	ir.add_str_2,
	ir.add_str_3,
	ir.add_str_4,
	ir.add_str_5,
	ir.add_str_6,
	ir.add_str_7,
	ir.add_str_8,
	ir.add_str_9,
	ir.add_str_10,
	ir.add_str_11,
	ir.add_str_12,
	ir.add_str_13,
	ir.add_str_14,
	ir.add_str_15,
	ir.add_str_16,
	ir.add_str_17,
	ir.add_str_18,
	ir.add_str_19,
	ir.add_str_20,
	ir.add_str_21,
	ir.add_str_22,
	ir.add_str_23,
	ir.add_str_24,
	ir.add_str_25,
	ir.add_str_26,
	ir.add_str_27,
	ir.add_str_28,
	ir.add_str_29,
	ir.add_str_30,
	date_attention_calculated inci_attention_add_days_date ,
	date_registry_calculated  inci_opened_add_days_date,
	date_solution_calculated  INCI_SOLUTION_ADD_DAYS_DATE,
	inci_status_time,
	ir.time_stamp,
	NVL (FUN_ASDK_TEXT_FILES (inci_id, 8, 13), '') AS files,
	survey_succeeded,
	CASE WHEN inci_procedure_id IS NULL THEN 0 ELSE 1 END inci_flag_procedure
FROM ASDK_INCIDENT_RULES ir
LEFT OUTER JOIN USUARIOS u ON ir.inci_customer_id = u.codusuario
LEFT OUTER JOIN CI_CONFIGURATION_ITEM ci ON ci.fl_int_ci_id = ir.inci_associated_ci
LEFT OUTER JOIN ASDK_DATES_CASE dc ON ir.inci_id = dc.case_id
	AND type_case_id = 1;