1. Tables and Views for SCM
  2. CMK_APPL_PARTNERS_SETUP_VL

CMK_APPL_PARTNERS_SETUP_VL

Details

  • Schema: FUSION

  • Object owner: CMK

  • Object type: VIEW

Columns

Name

APPL_PARTNER_ID

PARTNER_KEY_TYPE

PARTNER_KEY1

PARTNER_KEY2

PARTNER_KEY3

PARTNER_KEY4

PARTNER_KEY5

PROC_ACTION_CODE

EXTERNAL_PARTNER_ID

SERVICE_PROVIDER_ID

APPL_PARTNER_DOC_ID

APPL_PARTNER_DOC_STATUS

PRIMARY_RECIPIENT_FLAG

DOCUMENT_ID

DELIVERY_METHOD_ID

DELIVERY_METHOD_TYPE

RECIPIENT_EMAIL_ID

PARTNER_MESSAGE_ID

PARTNER_MESSAGE_NAME

OVERRIDE_STATUS

Query

SQL_Statement

SELECT

CMK_APPLICATION_PARTNERS.APPL_PARTNER_ID APPL_PARTNER_ID,

CMK_APPLICATION_PARTNERS.PARTNER_KEY_TYPE PARTNER_KEY_TYPE,

CMK_APPLICATION_PARTNERS.PARTNER_KEY1 PARTNER_KEY1,

CMK_APPLICATION_PARTNERS.PARTNER_KEY2 PARTNER_KEY2,

CMK_APPLICATION_PARTNERS.PARTNER_KEY3 PARTNER_KEY3,

CMK_APPLICATION_PARTNERS.PARTNER_KEY4 PARTNER_KEY4,

CMK_APPLICATION_PARTNERS.PARTNER_KEY5 PARTNER_KEY5,

CMK_APPLICATION_PARTNERS.PROC_ACTION_CODE PROC_ACTION_CODE,

CMK_APPLICATION_PARTNERS.EXTERNAL_PARTNER_ID EXTERNAL_PARTNER_ID,

CMK_APPLICATION_PARTNERS.SERVICE_PROVIDER_ID SERVICE_PROVIDER_ID,

CMK_APPL_PARTNER_DOCS.APPL_PARTNER_DOC_ID APPL_PARTNER_DOC_ID,

CMK_APPL_PARTNER_DOCS.APPL_PARTNER_DOC_STATUS APPL_PARTNER_DOC_STATUS,

CMK_APPL_PARTNER_DOCS.PRIMARY_RECIPIENT_FLAG PRIMARY_RECIPIENT_FLAG,

CMK_APPL_PARTNER_DOCS.DOCUMENT_ID DOCUMENT_ID,

CMK_DELIVERY_METHODS.DELIVERY_METHOD_ID DELIVERY_METHOD_ID,

CMK_DELIVERY_METHODS.DELIVERY_METHOD_TYPE DELIVERY_METHOD_TYPE,

CMK_DELIVERY_METHODS.RECIPIENT_EMAIL_ID RECIPIENT_EMAIL_ID,

CMK_EXTERNAL_PTNR_MSGS_B.PARTNER_MESSAGE_ID PARTNER_MESSAGE_ID,

CMK_EXTERNAL_PTNR_MSGS_B.PARTNER_MESSAGE_NAME PARTNER_MESSAGE_NAME,

CMK_EXT_PTNR_MSGS_CUST.OVERRIDE_STATUS OVERRIDE_STATUS

FROM

CMK_APPLICATION_PARTNERS,

CMK_APPL_PARTNER_DOCS,

CMK_EXTERNAL_PTNR_MSGS_B,

CMK_EXT_PTNR_MSGS_CUST,

CMK_DELIVERY_METHODS

WHERE

CMK_APPLICATION_PARTNERS.APPL_PARTNER_ID = CMK_APPL_PARTNER_DOCS.APPL_PARTNER_ID

AND CMK_APPL_PARTNER_DOCS.DOCUMENT_ID = CMK_EXTERNAL_PTNR_MSGS_B.DOCUMENT_ID

AND CMK_EXTERNAL_PTNR_MSGS_B.PARTNER_MESSAGE_ID = CMK_EXT_PTNR_MSGS_CUST.PARTNER_MESSAGE_CUST_ID

AND CMK_EXT_PTNR_MSGS_CUST.DELIVERY_METHOD_ID = CMK_DELIVERY_METHODS.DELIVERY_METHOD_ID

AND (CMK_APPLICATION_PARTNERS.EXTERNAL_PARTNER_ID = CMK_EXTERNAL_PTNR_MSGS_B.EXTERNAL_PARTNER_ID

OR (CMK_APPLICATION_PARTNERS.SERVICE_PROVIDER_ID = CMK_EXTERNAL_PTNR_MSGS_B.SERVICE_PROVIDER_ID

AND CMK_EXTERNAL_PTNR_MSGS_B.EXTERNAL_PARTNER_ID IS NULL

AND NOT EXISTS (SELECT 1 FROM CMK_EXTERNAL_PTNR_MSGS_B CMKEXTERNALPTNRMSGS

WHERE CMKEXTERNALPTNRMSGS.EXTERNAL_PARTNER_ID = CMK_APPLICATION_PARTNERS.EXTERNAL_PARTNER_ID

AND CMKEXTERNALPTNRMSGS.DOCUMENT_ID = CMK_EXTERNAL_PTNR_MSGS_B.DOCUMENT_ID)))