CMK_COLLAB_MESSAGES_VL
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 |
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') |