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