SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW [dbo].[vw___ris_risks_situations_without_rowver_and_computed]
 AS 
 select 
	  [riss_risk_situation_id] 
	, [riss_risk_id] 
	, [riss_policy_id] 
	, [riss_policy_situation_id] 
	, [riss_number] 
	, [riss_movement_code] 
	, [riss_movement_date] 
	, [riss_entrance_date] 
	, [riss_modify_date] 
	, [riss_retire_date] 
	, [riss_formula_code] 
	, [riss_nature_code] 
	, [riss_operation_utc_date] 
	, [riss_lot_acc_id] 
	, [riss_risk_situation_id_old] 
	, [riss_obsolete] 
	, [riss_bonus_value] 
	, [riss_bonus50_years] 
	, [riss_address1__1] 
	, [riss_address2__1] 
	, [riss_address3__1] 
	, [riss_country_code__1] 
	, [riss_dpi_code__1] 
	, [riss_postcode_code__1] 
	, [riss_city__1] 
	, [riss_address1__2] 
	, [riss_address2__2] 
	, [riss_address3__2] 
	, [riss_country_code__2] 
	, [riss_dpi_code__2] 
	, [riss_postcode_code__2] 
	, [riss_city__2] 
	, [riss_address1__3] 
	, [riss_address2__3] 
	, [riss_address3__3] 
	, [riss_country_code__3] 
	, [riss_dpi_code__3] 
	, [riss_postcode_code__3] 
	, [riss_city__3] 
	, [riss_perception_invoice_start_date] 
	, [riss_perception_invoice_end_date] 
	, [riss_reimboursement_invoice_start_date] 
	, [riss_reimboursement_invoice_end_date] 
 from [dbo].[ris_risks_situations]
GO
