CMK_MSGS_EMAIL_BODY_VL

Details

• Schema: FUSION

• Object owner: CMK

• Object type: VIEW

Columns

Name
NAME EMAIL_BODY_ID BODY_NUMBER TYPE MESSAGE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN MODULE_ID OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT CMK_MSGS_EMAIL_BODY_TL.NAME NAME, CMK_MSGS_EMAIL_BODY_B.EMAIL_BODY_ID EMAIL_BODY_ID, CMK_MSGS_EMAIL_BODY_B.BODY_NUMBER BODY_NUMBER, CMK_MSGS_EMAIL_BODY_B.TYPE TYPE, CMK_MSGS_EMAIL_BODY_B.MESSAGE_ID MESSAGE_ID, CMK_MSGS_EMAIL_BODY_B.CREATED_BY CREATED_BY, CMK_MSGS_EMAIL_BODY_B.CREATION_DATE CREATION_DATE, CMK_MSGS_EMAIL_BODY_B.LAST_UPDATED_BY LAST_UPDATED_BY, CMK_MSGS_EMAIL_BODY_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, CMK_MSGS_EMAIL_BODY_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CMK_MSGS_EMAIL_BODY_B.MODULE_ID MODULE_ID, CMK_MSGS_EMAIL_BODY_B.OBJECT_VERSION_NUMBER FROM CMK_MSGS_EMAIL_BODY_B, CMK_MSGS_EMAIL_BODY_TL WHERE CMK_MSGS_EMAIL_BODY_B.EMAIL_BODY_ID = CMK_MSGS_EMAIL_BODY_TL.EMAIL_BODY_ID AND CMK_MSGS_EMAIL_BODY_TL.LANGUAGE = USERENV('LANG')