CMK_EXTERNAL_MSG_TYPES_VL
Details
-
Schema: FUSION
-
Object owner: CMK
-
Object type: VIEW
Columns
Name |
---|
EXT_MESSAGE_TYPE_ID EXT_MESSAGE_TYPE_NAME MESSAGE_TYPE VERSION STANDARD DOCUMENT_SUBTYPE DOCUMENT_TYPE VALIDATION_PAYLOAD CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER MODULE_ID DESCRIPTION CONFIGURABLE_FLAG IN_IDENTIFICATION_XPATH MESSAGE_IDENTIFIER_XPATH TP_IDENTIFIER_XPATH TP_TYPE_IDENTIFIER_XPATH OBJECT_XPATH OBN_DOC_TYPE_MAP PO_LINE_XPATH REFERENCE_OBJECT_KEY_XPATH |
Query
SQL_Statement |
---|
SELECT CMK_EXTERNAL_MSG_TYPES_B.EXT_MESSAGE_TYPE_ID EXT_MESSAGE_TYPE_ID, CMK_EXTERNAL_MSG_TYPES_B.EXT_MESSAGE_TYPE_NAME EXT_MESSAGE_TYPE_NAME, CMK_EXTERNAL_MSG_TYPES_B.MESSAGE_TYPE MESSAGE_TYPE, CMK_EXTERNAL_MSG_TYPES_B.VERSION VERSION, CMK_EXTERNAL_MSG_TYPES_B.STANDARD STANDARD, CMK_EXTERNAL_MSG_TYPES_B.DOCUMENT_SUBTYPE DOCUMENT_SUBTYPE, CMK_EXTERNAL_MSG_TYPES_B.DOCUMENT_TYPE DOCUMENT_TYPE, CMK_EXTERNAL_MSG_TYPES_B.VALIDATION_PAYLOAD VALIDATION_PAYLOAD, CMK_EXTERNAL_MSG_TYPES_B.CREATED_BY CREATED_BY, CMK_EXTERNAL_MSG_TYPES_B.CREATION_DATE CREATION_DATE, CMK_EXTERNAL_MSG_TYPES_B.LAST_UPDATED_BY LAST_UPDATED_BY, CMK_EXTERNAL_MSG_TYPES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, CMK_EXTERNAL_MSG_TYPES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CMK_EXTERNAL_MSG_TYPES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CMK_EXTERNAL_MSG_TYPES_B.MODULE_ID MODULE_ID, CMK_EXTERNAL_MSG_TYPES_TL.DESCRIPTION DESCRIPTION, CMK_EXTERNAL_MSG_TYPES_B.CONFIGURABLE_FLAG CONFIGURABLE_FLAG, CMK_EXTERNAL_MSG_TYPES_B.IN_IDENTIFICATION_XPATH IN_IDENTIFICATION_XPATH, CMK_EXTERNAL_MSG_TYPES_B.MESSAGE_IDENTIFIER_XPATH MESSAGE_IDENTIFIER_XPATH, CMK_EXTERNAL_MSG_TYPES_B.TP_IDENTIFIER_XPATH TP_IDENTIFIER_XPATH, CMK_EXTERNAL_MSG_TYPES_B.TP_TYPE_IDENTIFIER_XPATH TP_TYPE_IDENTIFIER_XPATH, CMK_EXTERNAL_MSG_TYPES_B.OBJECT_XPATH OBJECT_XPATH, CMK_EXTERNAL_MSG_TYPES_B.OBN_DOC_TYPE_MAP OBN_DOC_TYPE_MAP, CMK_EXTERNAL_MSG_TYPES_B.PO_LINE_XPATH, CMK_EXTERNAL_MSG_TYPES_B.REFERENCE_OBJECT_KEY_XPATH FROM CMK_EXTERNAL_MSG_TYPES_B, CMK_EXTERNAL_MSG_TYPES_TL WHERE CMK_EXTERNAL_MSG_TYPES_B.EXT_MESSAGE_TYPE_ID = CMK_EXTERNAL_MSG_TYPES_TL.EXT_MESSAGE_TYPE_ID AND CMK_EXTERNAL_MSG_TYPES_TL.LANGUAGE = USERENV('LANG') |