1. Tables and Views for SCM
  2. DOS_MESSAGES_V

DOS_MESSAGES_V

Details

  • Schema: FUSION

  • Object owner: DOS

  • Object type: VIEW

Columns

Name

MESSAGE_ID

MESSAGE_NAME

MESSAGE_TEXT

MESSAGE_SEVERITY

ACTIVE_FLAG

FUNCTIONAL_MODULE

PROCESSING_ENTITY_TYPE

PROCESSING_ENTITY_ID

MESSAGE_APPLICATION_CODE

EXCEPTION_TYPE

RECOVERY_STATUS

TOKEN_NAME_A

TOKEN_VALUE_A

TOKEN_NAME_B

TOKEN_VALUE_B

TOKEN_NAME_C

TOKEN_VALUE_C

TOKEN_NAME_D

TOKEN_VALUE_D

TOKEN_NAME_E

TOKEN_VALUE_E

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

MSG_REQUEST_ID

Query

SQL_Statement

SELECT MESSAGE_ID, MESSAGE_NAME, MESSAGE_TEXT, MESSAGE_SEVERITY, ACTIVE_FLAG, FUNCTIONAL_MODULE,

PROCESSING_ENTITY_TYPE, PROCESSING_ENTITY_ID, MESSAGE_APPLICATION_CODE, EXCEPTION_TYPE, RECOVERY_STATUS,

TOKEN_NAME_A, TOKEN_VALUE_A, TOKEN_NAME_B, TOKEN_VALUE_B, TOKEN_NAME_C, TOKEN_VALUE_C, TOKEN_NAME_D, TOKEN_VALUE_D,

TOKEN_NAME_E, TOKEN_VALUE_E, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,

OBJECT_VERSION_NUMBER, MSG_REQUEST_ID

FROM

(SELECT DOS_MESSAGES.MESSAGE_ID MESSAGE_ID, DOS_MESSAGES.MESSAGE_NAME MESSAGE_NAME, DOS_MESSAGES.MESSAGE_TEXT

MESSAGE_TEXT, DOS_MESSAGES.MESSAGE_SEVERITY MESSAGE_SEVERITY, DOS_MESSAGES.ACTIVE_FLAG ACTIVE_FLAG,

DOS_MESSAGES.FUNCTIONAL_MODULE FUNCTIONAL_MODULE, DOS_MESSAGES.PROCESSING_ENTITY_TYPE PROCESSING_ENTITY_TYPE,

DOS_MESSAGES.PROCESSING_ENTITY_ID PROCESSING_ENTITY_ID, DOS_MESSAGES.MESSAGE_APPLICATION_CODE

MESSAGE_APPLICATION_CODE, DOS_MESSAGES.EXCEPTION_TYPE EXCEPTION_TYPE, DOS_MESSAGES.RECOVERY_STATUS

RECOVERY_STATUS, DOS_MESSAGES.TOKEN_NAME_A TOKEN_NAME_A, DOS_MESSAGES.TOKEN_VALUE_A TOKEN_VALUE_A,

DOS_MESSAGES.TOKEN_NAME_B TOKEN_NAME_B, DOS_MESSAGES.TOKEN_VALUE_B TOKEN_VALUE_B, DOS_MESSAGES.TOKEN_NAME_C

TOKEN_NAME_C, DOS_MESSAGES.TOKEN_VALUE_C TOKEN_VALUE_C, DOS_MESSAGES.TOKEN_NAME_D TOKEN_NAME_D,

DOS_MESSAGES.TOKEN_VALUE_D TOKEN_VALUE_D, DOS_MESSAGES.TOKEN_NAME_E TOKEN_NAME_E, DOS_MESSAGES.TOKEN_VALUE_E

TOKEN_VALUE_E, DOS_MESSAGES.CREATED_BY CREATED_BY, DOS_MESSAGES.CREATION_DATE CREATION_DATE,

DOS_MESSAGES.LAST_UPDATED_BY LAST_UPDATED_BY, DOS_MESSAGES.LAST_UPDATE_DATE LAST_UPDATE_DATE,

DOS_MESSAGES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DOS_MESSAGES.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

NULL AS msg_request_id

FROM FUSION.DOS_MESSAGES

UNION ALL

SELECT DM.MESSAGE_ID MESSAGE_ID, DM.MESSAGE_NAME MESSAGE_NAME, DM.MESSAGE_TEXT MESSAGE_TEXT, DM.MESSAGE_SEVERITY

MESSAGE_SEVERITY, DM.ACTIVE_FLAG ACTIVE_FLAG, DM.FUNCTIONAL_MODULE FUNCTIONAL_MODULE, DME.ENTITY_TYPE

PROCESSING_ENTITY_TYPE, DME.ENTITY_ID PROCESSING_ENTITY_ID, DM.MESSAGE_APPLICATION_CODE

MESSAGE_APPLICATION_CODE, DM.EXCEPTION_TYPE EXCEPTION_TYPE, DM.RECOVERY_STATUS RECOVERY_STATUS, DM.TOKEN_NAME_A

TOKEN_NAME_A, DM.TOKEN_VALUE_A TOKEN_VALUE_A, DM.TOKEN_NAME_B TOKEN_NAME_B, DM.TOKEN_VALUE_B TOKEN_VALUE_B,

DM.TOKEN_NAME_C TOKEN_NAME_C, DM.TOKEN_VALUE_C TOKEN_VALUE_C, DM.TOKEN_NAME_D TOKEN_NAME_D, DM.TOKEN_VALUE_D

TOKEN_VALUE_D, DM.TOKEN_NAME_E TOKEN_NAME_E, DM.TOKEN_VALUE_E TOKEN_VALUE_E, DME.CREATED_BY CREATED_BY,

DME.CREATION_DATE CREATION_DATE, DME.LAST_UPDATED_BY LAST_UPDATED_BY, DME.LAST_UPDATE_DATE LAST_UPDATE_DATE,

DME.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DME.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, NULL AS

msg_request_id

FROM FUSION.DOS_MESSAGES DM

INNER JOIN FUSION.DOS_MESSAGE_ENTITIES DME ON DME.MESSAGE_ID = DM.MESSAGE_ID

UNION

SELECT MessagePEO.MESSAGE_ID, MessagePEO.MESSAGE_NAME, MessagePEO.MESSAGE_TEXT, DECODE(

MessageRequestPEO.MESSAGE_TYPE,'ERROR',2,1), DECODE(MESSAGEREQUESTPEO.REQ_ENTITY_TYPE,'TASK',0,DECODE( MessageRequestPEO.ACTIVE_FLAG,'Y',1,0)),

'ORCH_INFRA' AS FUNCTIONAL_MODULE, 'TLINE' AS PROCESSING_ENTITY_TYPE, TO_CHAR(

OrchestrationGroupsPEO.TRANSACTION_ENTITY_ID) AS PROCESSING_ENTITY_ID, 'DOO' AS MESSAGE_APPLICATION_CODE, NULL,

1 AS RECOVERY_STATUS, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, MessageRequestPEO.CREATED_BY,

MessageRequestPEO.CREATION_DATE, MessageRequestPEO.LAST_UPDATED_BY, MessageRequestPEO.LAST_UPDATE_DATE,

MessageRequestPEO.LAST_UPDATE_LOGIN, MessageRequestPEO.OBJECT_VERSION_NUMBER, MessageRequestPEO.msg_request_id

FROM FUSION.DOO_MESSAGE_REQUESTS MessageRequestPEO, FUSION.DOO_MESSAGES_VL MessagePEO,

FUSION.DOO_MESSAGE_ENTITIES MESSAGEENTITYPEO, FUSION.DOO_ORCHESTRATION_GROUPS ORCHESTRATIONGROUPSPEO

WHERE MessagePEO.msg_request_id = MessageRequestPEO.msg_request_id

AND MESSAGEREQUESTPEO.ORCHESTRATION_APPLICATION_ID = 1002

AND ((MESSAGEREQUESTPEO.REQ_ENTITY_TYPE = 'PROCESS'

AND MESSAGEENTITYPEO.ENTITY_TYPE = 'CONTEXT' )

OR (MESSAGEREQUESTPEO.REQ_ENTITY_TYPE = 'TASK'

AND MESSAGEENTITYPEO.ENTITY_TYPE = 'SUMMARY' ) )

AND MessageEntityPEO.ENTITY_NAME = 'PROCESS'

AND MessageEntityPEO.MSG_REQUEST_ID = MessageRequestPEO.MSG_REQUEST_ID

AND MessageEntityPEO.MESSAGE_ID IS NULL

AND OrchestrationGroupsPEO.ORCHESTRATION_APPLICATION_ID = 1002

AND ORCHESTRATIONGROUPSPEO.TRANSACTION_ENTITY_NAME = 'DOS_SUPPLY_TRACKING_LINES_V'

AND MessageEntityPEO.ENTITY_ID = TO_CHAR(OrchestrationGroupsPEO.DOO_PROCESS_INSTANCE_ID)

)