WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR  EXIT FAILURE ROLLBACK;

spool FND_REGION_CODE_VL.log

prompt
prompt Creating view FND_REGION_CODE_VL
prompt ================================
prompt
CREATE OR REPLACE FORCE VIEW fnd_region_code_vl as
select t.country_code,
			 c.description country_description,
			 t.region_code,
			 b.description_text description,
			 t.created_by,
			 t.creation_date,
			 t.last_updated_by,
			 t.last_update_date
	from fnd_region_code t, fnd_descriptions b, fnd_country_code_vl c
 where t.country_code = c.country_code
	 and t.description_id = b.description_id
	 and b.ref_table = 'FND_REGION_CODE'
	 and b.ref_field = 'DESCRIPTION_ID'
	 and b.language = userenv('LANG')
/


spool off

exit
