View: FND_APPLICATION_ALL_VIEW

Product:	FND - Application Object Library
Description:	Union of all rows in the table FND_APPLICATION and the row "All" indicating all applications
Implementation/DBA Data:	APPS.FND_APPLICATION_ALL_VIEW

View Text

SELECT B.APPLICATION_ID
, B.APPLICATION_SHORT_NAME
, B.BASEPATH
, T.APPLICATION_NAME
, T.DESCRIPTION
, 2 ORDER_BY
FROM FND_APPLICATION B
, FND_APPLICATION_TL T
WHERE B.APPLICATION_ID = T.APPLICATION_ID
AND T.LANGUAGE = USERENV('LANG') UNION ALL SELECT -2
, L.LOOKUP_CODE
, NULL
, L.MEANING
, L.DESCRIPTION
, 1 ORDER_BY
FROM FND_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'FND_APPLICATION_ALL_VIEW'

Columns