DOS_MESSAGES_ALL

Details

Schema: FUSION
Object owner: DOS
Object type: VIEW

Columns

Name
MESSAGE_ID MESSAGE_NAME MESSAGE_TEXT MESSAGE_SEVERITY ACTIVE_FLAG FUNCTIONAL_MODULE PROCESSING_ENTITY_TYPE PROCESSING_ENTITY_ID MESSAGE_APPLICATION_CODE EXCEPTION_TYPE RECOVERY_STATUS TOKEN_NAME_A TOKEN_VALUE_A TOKEN_NAME_B TOKEN_VALUE_B TOKEN_NAME_C TOKEN_VALUE_C TOKEN_NAME_D TOKEN_VALUE_D TOKEN_NAME_E TOKEN_VALUE_E CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER MSG_REQUEST_ID

Name

MESSAGE_ID

MESSAGE_NAME

MESSAGE_TEXT

MESSAGE_SEVERITY

ACTIVE_FLAG

FUNCTIONAL_MODULE

PROCESSING_ENTITY_TYPE

PROCESSING_ENTITY_ID

MESSAGE_APPLICATION_CODE

EXCEPTION_TYPE

RECOVERY_STATUS

TOKEN_NAME_A

TOKEN_VALUE_A

TOKEN_NAME_B

TOKEN_VALUE_B

TOKEN_NAME_C

TOKEN_VALUE_C

TOKEN_NAME_D

TOKEN_VALUE_D

TOKEN_NAME_E

TOKEN_VALUE_E

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

MSG_REQUEST_ID

Query

SQL_Statement
select v.MESSAGE_ID,v.MESSAGE_NAME, nvl2(v.MESSAGE_NAME, REGEXP_REPLACE( replace(replace(replace(replace( replace(m.message_text,v.TOKEN_NAME_E,v.token_value_E),v.TOKEN_NAME_D,v.TOKEN_VALUE_D),v.TOKEN_NAME_c,v.token_value_c),v.TOKEN_NAME_b,v.token_value_b),v.TOKEN_NAME_a,v.token_value_a) ,'[},{]+') ,v.MESSAGE_TEXT) message_text, v.MESSAGE_SEVERITY, v.ACTIVE_FLAG,v.FUNCTIONAL_MODULE,v.PROCESSING_ENTITY_TYPE,v.PROCESSING_ENTITY_ID, v.MESSAGE_APPLICATION_CODE,v.EXCEPTION_TYPE,v.RECOVERY_STATUS,v.TOKEN_NAME_A, v.TOKEN_VALUE_A,v.TOKEN_NAME_B,v.TOKEN_VALUE_B,v.TOKEN_NAME_C,v.TOKEN_VALUE_C, v.TOKEN_NAME_D,v.TOKEN_VALUE_D,v.TOKEN_NAME_E,v.TOKEN_VALUE_E,v.CREATED_BY, v.CREATION_DATE,v.LAST_UPDATED_BY,v.LAST_UPDATE_DATE,v.LAST_UPDATE_LOGIN,v.OBJECT_VERSION_NUMBER,v.MSG_REQUEST_ID from fnd_new_messages m, DOS_MESSAGES_V v where m.message_name=v.message_name and v.active_flag=1 and v.message_name IS NOT NULL and v.message_application_code='DOS' and m.language_code= USERENV('LANG') UNION select v.MESSAGE_ID,v.MESSAGE_NAME, v.message_text, v.MESSAGE_SEVERITY, v.ACTIVE_FLAG,v.FUNCTIONAL_MODULE,v.PROCESSING_ENTITY_TYPE,v.PROCESSING_ENTITY_ID, v.MESSAGE_APPLICATION_CODE,v.EXCEPTION_TYPE,v.RECOVERY_STATUS,v.TOKEN_NAME_A, v.TOKEN_VALUE_A,v.TOKEN_NAME_B,v.TOKEN_VALUE_B,v.TOKEN_NAME_C,v.TOKEN_VALUE_C, v.TOKEN_NAME_D,v.TOKEN_VALUE_D,v.TOKEN_NAME_E,v.TOKEN_VALUE_E,v.CREATED_BY, v.CREATION_DATE,v.LAST_UPDATED_BY,v.LAST_UPDATE_DATE,v.LAST_UPDATE_LOGIN,v.OBJECT_VERSION_NUMBER,v.MSG_REQUEST_ID from DOS_MESSAGES_V v where v.active_flag=1 and v.message_name IS NULL and v.message_application_code='DOS'

SQL_Statement

select

v.MESSAGE_ID,v.MESSAGE_NAME,

nvl2(v.MESSAGE_NAME,

REGEXP_REPLACE(

replace(replace(replace(replace(

replace(m.message_text,v.TOKEN_NAME_E,v.token_value_E),v.TOKEN_NAME_D,v.TOKEN_VALUE_D),v.TOKEN_NAME_c,v.token_value_c),v.TOKEN_NAME_b,v.token_value_b),v.TOKEN_NAME_a,v.token_value_a) ,'[},{]+')

,v.MESSAGE_TEXT) message_text,

v.MESSAGE_SEVERITY,

v.ACTIVE_FLAG,v.FUNCTIONAL_MODULE,v.PROCESSING_ENTITY_TYPE,v.PROCESSING_ENTITY_ID,

v.MESSAGE_APPLICATION_CODE,v.EXCEPTION_TYPE,v.RECOVERY_STATUS,v.TOKEN_NAME_A,

v.TOKEN_VALUE_A,v.TOKEN_NAME_B,v.TOKEN_VALUE_B,v.TOKEN_NAME_C,v.TOKEN_VALUE_C,

v.TOKEN_NAME_D,v.TOKEN_VALUE_D,v.TOKEN_NAME_E,v.TOKEN_VALUE_E,v.CREATED_BY,

v.CREATION_DATE,v.LAST_UPDATED_BY,v.LAST_UPDATE_DATE,v.LAST_UPDATE_LOGIN,v.OBJECT_VERSION_NUMBER,v.MSG_REQUEST_ID

from fnd_new_messages m, DOS_MESSAGES_V v

where m.message_name=v.message_name

and v.active_flag=1

and v.message_name IS NOT NULL

and v.message_application_code='DOS'

and m.language_code= USERENV('LANG')

UNION