View: FUN_RICH_MESSAGES_VL

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.FUN_RICH_MESSAGES_VL

View Text

SELECT B.ROWID ROW_ID
, B.APPLICATION_ID
, B.MESSAGE_NAME
, B.OBJECT_VERSION_NUMBER
, B.CREATED_BY_MODULE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, T.MESSAGE_TEXT
FROM FUN_RICH_MESSAGES_B B
, FUN_RICH_MESSAGES_TL T
WHERE B.APPLICATION_ID = T.APPLICATION_ID
AND B.MESSAGE_NAME = T.MESSAGE_NAME
AND T.LANGUAGE = USERENV('LANG')