SELECT A.APPLICATION_ID ECAPPID , A.APPLICATION_SHORT_NAME , T.APPLICATION_NAME NAME FROM FND_APPLICATION A , FND_APPLICATION_TL T WHERE A.APPLICATION_ID = T.APPLICATION_ID AND LANGUAGE= USERENV('LANG') UNION SELECT ECAPPID , APPLICATION_SHORT_NAME , NAME FROM IBY_ECAPP