VIEW: APPS.IBY_ECAPP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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