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

spool FND_LANGUAGE_CODE_VL.log

prompt
prompt Creating view FND_LANGUAGE_CODE_VL
prompt ==================================
prompt
CREATE OR REPLACE FORCE VIEW FND_LANGUAGE_CODE_VL as
select a.language_code,
			 a.installed_flag,
			 b.description_text description,
			 a.created_by,
			 a.creation_date,
			 a.last_updated_by,
			 a. last_update_date
	from fnd_language_code a, fnd_descriptions b
 where b.language = userenv('lang')
	 and a.description_id = b.description_id
	 and b.ref_table = 'FND_LANGUAGE_CODE'
	 and b.ref_field = 'DESCRIPTION_ID'
/


spool off

exit
