CMK_EXTERNAL_MSG_TYPES

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

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

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