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

spool FND_COUNTRY_CODE_VL.log

prompt
prompt Creating view FND_COUNTRY_CODE_VL
prompt =================================
prompt
CREATE OR REPLACE FORCE VIEW fnd_country_code_vl as
select a.country_code,
			 b.description_text description,
			 a.created_by,
			 a.creation_date,
			 a.last_updated_by,
			 a.last_update_date
	from fnd_country_code a, fnd_descriptions b
 where b.language = userenv('lang')
	 and a.description_id = b.description_id
	 and b.ref_table = 'FND_COUNTRY_CODE'
	 and b.ref_field = 'DESCRIPTION_ID'
/


spool off

exit
