FND_NEW_MESSAGES

Details

• Schema: MESSAGE

• Object owner: FND

• Object type: VIEW

Columns

Name
APPLICATION_ID LANGUAGE_CODE MESSAGE_NUMBER MESSAGE_NAME MESSAGE_TEXT CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN DESCRIPTION TYPE MAX_LENGTH CATEGORY SEVERITY FND_LOG_SEVERITY

Query

SQL_Statement
select B.APPLICATION_ID, T.LANGUAGE, B.MESSAGE_NUMBER, B.MESSAGE_NAME, T.MESSAGE_TEXT, B.CREATION_DATE,B.CREATED_BY,B.LAST_UPDATE_DATE,B.LAST_UPDATED_BY,B.LAST_UPDATE_LOGIN,'', B.TYPE,2000,B.MESSAGE_CATEGORY,B.MESSAGE_SEVERITY,'' from fnd_messages_b b, fnd_messages_tl t where t.application_id = b.application_id and t.message_name = b.message_name