FND_MESSAGES

Details

Schema: MESSAGE
Object owner: FND
Object type: VIEW

Columns

Name
MODULE_ID APPLICATION_ID MESSAGE_NUMBER MESSAGE_NAME MESSAGE_TEXT MESSAGE_USER_DETAILS MESSAGE_ADMIN_DETAILS MESSAGE_CAUSE MESSAGE_USER_ACTION MESSAGE_ADMIN_ACTION CONTEXT CHANGE_SINCE_LAST_REFRESH LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN TYPE MESSAGE_CATEGORY MESSAGE_SEVERITY LOGGABLE_ALERTABLE ROW_ID

Name

MODULE_ID

APPLICATION_ID

MESSAGE_NUMBER

MESSAGE_NAME

MESSAGE_TEXT

MESSAGE_USER_DETAILS

MESSAGE_ADMIN_DETAILS

MESSAGE_CAUSE

MESSAGE_USER_ACTION

MESSAGE_ADMIN_ACTION

CONTEXT

CHANGE_SINCE_LAST_REFRESH

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

TYPE

MESSAGE_CATEGORY

MESSAGE_SEVERITY

LOGGABLE_ALERTABLE

ROW_ID

Query

SQL_Statement
SELECT B.MODULE_ID, B.APPLICATION_ID, B.MESSAGE_NUMBER, B.MESSAGE_NAME, T.MESSAGE_TEXT, T.MESSAGE_USER_DETAILS, T.MESSAGE_ADMIN_DETAILS, T.MESSAGE_CAUSE, T.MESSAGE_USER_ACTION, T.MESSAGE_ADMIN_ACTION, B.CONTEXT, B.CHANGE_SINCE_LAST_REFRESH, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.TYPE, B.MESSAGE_CATEGORY, B.MESSAGE_SEVERITY, B.LOGGABLE_ALERTABLE, B.ROWID ROW_ID FROM FND_MESSAGES_TL T, FND_MESSAGES_B B WHERE B.MESSAGE_NAME = T.MESSAGE_NAME AND B.APPLICATION_ID = T.APPLICATION_ID AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.MODULE_ID,

B.APPLICATION_ID,

B.MESSAGE_NUMBER,

B.MESSAGE_NAME,

T.MESSAGE_TEXT,

T.MESSAGE_USER_DETAILS,

T.MESSAGE_ADMIN_DETAILS,

T.MESSAGE_CAUSE,

T.MESSAGE_USER_ACTION,

T.MESSAGE_ADMIN_ACTION,

B.CONTEXT,

B.CHANGE_SINCE_LAST_REFRESH,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.CREATION_DATE,

B.CREATED_BY,

B.LAST_UPDATE_LOGIN,

B.TYPE,

B.MESSAGE_CATEGORY,

B.MESSAGE_SEVERITY,

B.LOGGABLE_ALERTABLE,

B.ROWID ROW_ID

FROM

FND_MESSAGES_TL T,

FND_MESSAGES_B B

WHERE

B.MESSAGE_NAME = T.MESSAGE_NAME AND B.APPLICATION_ID = T.APPLICATION_ID AND T.LANGUAGE = USERENV('LANG')