DOO_MESSAGES_VL

Details

• Schema: FUSION

• Object owner: DOO

• Object type: VIEW

Columns

Name
MESSAGE_ID MESSAGE_TYPE MSG_REQUEST_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN MSG_ENTITY_TYPE MSG_ENTITY_ID1 MSG_ENTITY_ID2 MSG_ENTITY_ID3 MSG_ENTITY_ID4 MSG_ENTITY_ID5 MESSAGE_NAME MESSAGE_TEXT OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT B.MESSAGE_ID MESSAGE_ID, B.MESSAGE_TYPE MESSAGE_TYPE, B.MSG_REQUEST_ID MSG_REQUEST_ID, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.MSG_ENTITY_TYPE MSG_ENTITY_TYPE, B.MSG_ENTITY_ID1 MSG_ENTITY_ID1, B.MSG_ENTITY_ID2 MSG_ENTITY_ID2, B.MSG_ENTITY_ID3 MSG_ENTITY_ID3, B.MSG_ENTITY_ID4 MSG_ENTITY_ID4, B.MSG_ENTITY_ID5 MSG_ENTITY_ID5, B.MESSAGE_NAME MESSAGE_NAME, T.MESSAGE_TEXT MESSAGE_TEXT, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM DOO_MESSAGES_B B, DOO_MESSAGES_TL T WHERE B.MESSAGE_ID = T.MESSAGE_ID AND T.LANGUAGE = USERENV('LANG')