1. Tables and Views for SCM
  2. CMK_EXTERNAL_PTNR_MSGS_VL

CMK_EXTERNAL_PTNR_MSGS_VL

Details

  • Schema: FUSION

  • Object owner: CMK

  • Object type: VIEW

Columns

Name

PARTNER_MESSAGE_ID

PARTNER_MESSAGE_STATUS

PARTNER_MESSAGE_STATUS_DATE

OVERLAY_XSLT_FILE_NAME

MESSAGE_ID

EXTERNAL_PARTNER_ID

SERVICE_PROVIDER_ID

DOCUMENT_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

PARTNER_MESSAGE_NAME

MODULE_ID

DESCRIPTION

ACKNOWLEDGEMENT_CODE

DELIVERY_METHOD_ID

PROCESSING_ACTION

FROM_PARTNER_ID_XPATH

FROM_PARTNER_ID_TYPE_XPATH

APPL_PTNR_CODE_XPATH

OBJECT_KEY1_XPATH

OBJECT_KEY2_XPATH

OBJECT_KEY3_XPATH

OBJECT_KEY4_XPATH

OBJECT_KEY5_XPATH

OBJECT_KEY6_XPATH

CONFIRM_EXT_PTNR_MSG_ID

PRIMARY_FLAG

B2B_ACCOUNT_NUM_XPATH

Query

SQL_Statement

SELECT

CMK_EXTERNAL_PTNR_MSGS_B.PARTNER_MESSAGE_ID PARTNER_MESSAGE_ID,

CMK_EXTERNAL_PTNR_MSGS_B.PARTNER_MESSAGE_STATUS PARTNER_MESSAGE_STATUS,

CMK_EXTERNAL_PTNR_MSGS_B.PARTNER_MESSAGE_STATUS_DATE PARTNER_MESSAGE_STATUS_DATE,

CMK_EXTERNAL_PTNR_MSGS_B.OVERLAY_XSLT_FILE_NAME OVERLAY_XSLT_FILE_NAME,

CMK_EXTERNAL_PTNR_MSGS_B.MESSAGE_ID MESSAGE_ID,

CMK_EXTERNAL_PTNR_MSGS_B.EXTERNAL_PARTNER_ID EXTERNAL_PARTNER_ID,

CMK_EXTERNAL_PTNR_MSGS_B.SERVICE_PROVIDER_ID SERVICE_PROVIDER_ID,

CMK_EXTERNAL_PTNR_MSGS_B.DOCUMENT_ID DOCUMENT_ID,

CMK_EXTERNAL_PTNR_MSGS_B.CREATED_BY CREATED_BY,

CMK_EXTERNAL_PTNR_MSGS_B.CREATION_DATE CREATION_DATE,

CMK_EXTERNAL_PTNR_MSGS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

CMK_EXTERNAL_PTNR_MSGS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

CMK_EXTERNAL_PTNR_MSGS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

CMK_EXTERNAL_PTNR_MSGS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

CMK_EXTERNAL_PTNR_MSGS_B.PARTNER_MESSAGE_NAME PARTNER_MESSAGE_NAME,

CMK_EXTERNAL_PTNR_MSGS_B.MODULE_ID MODULE_ID,

CMK_EXTERNAL_PTNR_MSGS_TL.DESCRIPTION DESCRIPTION,

CMK_EXTERNAL_PTNR_MSGS_B.ACKNOWLEDGEMENT_CODE,

CMK_EXTERNAL_PTNR_MSGS_B.DELIVERY_METHOD_ID,

CMK_EXTERNAL_PTNR_MSGS_B.PROCESSING_ACTION,

CMK_EXTERNAL_PTNR_MSGS_B.FROM_PARTNER_ID_XPATH,

CMK_EXTERNAL_PTNR_MSGS_B.FROM_PARTNER_ID_TYPE_XPATH,

CMK_EXTERNAL_PTNR_MSGS_B.APPL_PTNR_CODE_XPATH,

CMK_EXTERNAL_PTNR_MSGS_B.OBJECT_KEY1_XPATH,

CMK_EXTERNAL_PTNR_MSGS_B.OBJECT_KEY2_XPATH,

CMK_EXTERNAL_PTNR_MSGS_B.OBJECT_KEY3_XPATH,

CMK_EXTERNAL_PTNR_MSGS_B.OBJECT_KEY4_XPATH,

CMK_EXTERNAL_PTNR_MSGS_B.OBJECT_KEY5_XPATH,

CMK_EXTERNAL_PTNR_MSGS_B.OBJECT_KEY6_XPATH,

CMK_EXTERNAL_PTNR_MSGS_B.CONFIRM_EXT_PTNR_MSG_ID,

CMK_EXTERNAL_PTNR_MSGS_B.PRIMARY_FLAG,

CMK_EXTERNAL_PTNR_MSGS_B.B2B_ACCOUNT_NUM_XPATH

FROM

CMK_EXTERNAL_PTNR_MSGS_B,

CMK_EXTERNAL_PTNR_MSGS_TL

WHERE

CMK_EXTERNAL_PTNR_MSGS_B.PARTNER_MESSAGE_ID = CMK_EXTERNAL_PTNR_MSGS_TL.PARTNER_MESSAGE_ID AND CMK_EXTERNAL_PTNR_MSGS_TL.LANGUAGE = USERENV('LANG')