CMK_COLLAB_MESSAGES

Details

Schema: FUSION
Object owner: CMK
Object type: VIEW

Columns

Name
MESSAGE_ID MESSAGE_NAME GENERIC_XSLT_FILENAME EXT_MESSAGE_TYPE_ID DOC_OPERATION_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER MODULE_ID DESCRIPTION APPL_PTNR_CODE_XPATH OBJECT_KEY1_XPATH OBJECT_KEY2_XPATH OBJECT_KEY3_XPATH OBJECT_KEY4_XPATH OBJECT_KEY5_XPATH OBJECT_KEY6_XPATH XSLT_FILE RECIPIENT_EMAIL_XPATH VALIDATION_PAYLOAD DEF_EMAIL_SUBJECT SERVICE_PROVIDER_ID B2B_ACCOUNT_NUM_XPATH

Name

MESSAGE_ID

MESSAGE_NAME

GENERIC_XSLT_FILENAME

EXT_MESSAGE_TYPE_ID

DOC_OPERATION_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

MODULE_ID

DESCRIPTION

APPL_PTNR_CODE_XPATH

OBJECT_KEY1_XPATH

OBJECT_KEY2_XPATH

OBJECT_KEY3_XPATH

OBJECT_KEY4_XPATH

OBJECT_KEY5_XPATH

OBJECT_KEY6_XPATH

XSLT_FILE

RECIPIENT_EMAIL_XPATH

VALIDATION_PAYLOAD

DEF_EMAIL_SUBJECT

SERVICE_PROVIDER_ID

B2B_ACCOUNT_NUM_XPATH

Query

SQL_Statement
SELECT CMK_COLLAB_MESSAGES_B.MESSAGE_ID MESSAGE_ID, CMK_COLLAB_MESSAGES_B.MESSAGE_NAME MESSAGE_NAME, CMK_COLLAB_MESSAGES_B.GENERIC_XSLT_FILENAME GENERIC_XSLT_FILENAME, CMK_COLLAB_MESSAGES_B.EXT_MESSAGE_TYPE_ID EXT_MESSAGE_TYPE_ID, CMK_COLLAB_MESSAGES_B.DOC_OPERATION_ID DOC_OPERATION_ID, CMK_COLLAB_MESSAGES_B.CREATED_BY CREATED_BY, CMK_COLLAB_MESSAGES_B.CREATION_DATE CREATION_DATE, CMK_COLLAB_MESSAGES_B.LAST_UPDATED_BY LAST_UPDATED_BY, CMK_COLLAB_MESSAGES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, CMK_COLLAB_MESSAGES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CMK_COLLAB_MESSAGES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CMK_COLLAB_MESSAGES_B.MODULE_ID MODULE_ID, CMK_COLLAB_MESSAGES_TL.DESCRIPTION DESCRIPTION, CMK_COLLAB_MESSAGES_B.APPL_PTNR_CODE_XPATH, CMK_COLLAB_MESSAGES_B.OBJECT_KEY1_XPATH, CMK_COLLAB_MESSAGES_B.OBJECT_KEY2_XPATH, CMK_COLLAB_MESSAGES_B.OBJECT_KEY3_XPATH, CMK_COLLAB_MESSAGES_B.OBJECT_KEY4_XPATH, CMK_COLLAB_MESSAGES_B.OBJECT_KEY5_XPATH, CMK_COLLAB_MESSAGES_B.OBJECT_KEY6_XPATH, CMK_COLLAB_MESSAGES_B.XSLT_FILE, CMK_COLLAB_MESSAGES_B.RECIPIENT_EMAIL_XPATH, CMK_COLLAB_MESSAGES_B.VALIDATION_PAYLOAD, CMK_COLLAB_MESSAGES_TL.DEF_EMAIL_SUBJECT, CMK_COLLAB_MESSAGES_B.SERVICE_PROVIDER_ID, CMK_COLLAB_MESSAGES_B.B2B_ACCOUNT_NUM_XPATH FROM CMK_COLLAB_MESSAGES_B, CMK_COLLAB_MESSAGES_TL WHERE CMK_COLLAB_MESSAGES_B.MESSAGE_ID = CMK_COLLAB_MESSAGES_TL.MESSAGE_ID AND CMK_COLLAB_MESSAGES_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

CMK_COLLAB_MESSAGES_B.MESSAGE_ID MESSAGE_ID,

CMK_COLLAB_MESSAGES_B.MESSAGE_NAME MESSAGE_NAME,

CMK_COLLAB_MESSAGES_B.GENERIC_XSLT_FILENAME GENERIC_XSLT_FILENAME,

CMK_COLLAB_MESSAGES_B.EXT_MESSAGE_TYPE_ID EXT_MESSAGE_TYPE_ID,

CMK_COLLAB_MESSAGES_B.DOC_OPERATION_ID DOC_OPERATION_ID,

CMK_COLLAB_MESSAGES_B.CREATED_BY CREATED_BY,

CMK_COLLAB_MESSAGES_B.CREATION_DATE CREATION_DATE,

CMK_COLLAB_MESSAGES_B.LAST_UPDATED_BY LAST_UPDATED_BY,

CMK_COLLAB_MESSAGES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

CMK_COLLAB_MESSAGES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

CMK_COLLAB_MESSAGES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

CMK_COLLAB_MESSAGES_B.MODULE_ID MODULE_ID,

CMK_COLLAB_MESSAGES_TL.DESCRIPTION DESCRIPTION,

CMK_COLLAB_MESSAGES_B.APPL_PTNR_CODE_XPATH,

CMK_COLLAB_MESSAGES_B.OBJECT_KEY1_XPATH,

CMK_COLLAB_MESSAGES_B.OBJECT_KEY2_XPATH,

CMK_COLLAB_MESSAGES_B.OBJECT_KEY3_XPATH,

CMK_COLLAB_MESSAGES_B.OBJECT_KEY4_XPATH,

CMK_COLLAB_MESSAGES_B.OBJECT_KEY5_XPATH,

CMK_COLLAB_MESSAGES_B.OBJECT_KEY6_XPATH,

CMK_COLLAB_MESSAGES_B.XSLT_FILE,

CMK_COLLAB_MESSAGES_B.RECIPIENT_EMAIL_XPATH,

CMK_COLLAB_MESSAGES_B.VALIDATION_PAYLOAD,

CMK_COLLAB_MESSAGES_TL.DEF_EMAIL_SUBJECT,

CMK_COLLAB_MESSAGES_B.SERVICE_PROVIDER_ID,

CMK_COLLAB_MESSAGES_B.B2B_ACCOUNT_NUM_XPATH

FROM

CMK_COLLAB_MESSAGES_B,

CMK_COLLAB_MESSAGES_TL

WHERE

CMK_COLLAB_MESSAGES_B.MESSAGE_ID = CMK_COLLAB_MESSAGES_TL.MESSAGE_ID AND CMK_COLLAB_MESSAGES_TL.LANGUAGE = USERENV('LANG')