SELECT i.dscript_id, i.dscript_name, f.nls_language, i.dscript_lang_id FROM Ies_deployed_scripts i, Fnd_languages f WHERE i.dscript_lang_id = f.language_id AND i.active_status = 1
View Text - HTML Formatted
SELECT I.DSCRIPT_ID , I.DSCRIPT_NAME , F.NLS_LANGUAGE , I.DSCRIPT_LANG_ID FROM IES_DEPLOYED_SCRIPTS I , FND_LANGUAGES F WHERE I.DSCRIPT_LANG_ID = F.LANGUAGE_ID AND I.ACTIVE_STATUS = 1