Product: | CS - Service |
---|---|
Description: | All messages and their corresponding attributes |
Implementation/DBA Data: | APPS.CS_MESSAGES_V |
SELECT MSG.ROWID ROW_ID
, MSG.MESSAGE_ID
, MSG.SOURCE_OBJECT_TYPE_CODE
, MSG.SENDER
, MSG.RECEIVER
, MSG.DATE_SENT
, MSG.LAST_UPDATE_DATE
, MSG.LAST_UPDATED_BY
, MSG.CREATION_DATE
, MSG.CREATED_BY
, MSG.LAST_UPDATE_LOGIN
, MSG.SOURCE_OBJECT_EXT_ID OBJECT_EXT_ID
, MSG.SOURCE_OBJECT_INT_ID OBJECT_ID
, MSG.SOURCE_OBJECT_TYPE_CODE OBJECT_TYPE_CODE
, CSLK2.MEANING PRIORITY
, MSG.EXPAND_ROLES
, MSG.CONFIRMATION
, MSG.MESSAGE
, MSG.RESPONDER
, MSG.RESPONSE_DATE
, CSLK3.MEANING RESPONSE
, MSG.RESPONDER_COMMENT
, CSLK1.MEANING ACTION_TYPE
, CSLK4.MEANING SOURCE_OBJECT
, USR.USER_NAME ENTERED_BY
FROM CS_MESSAGES MSG
, CS_LOOKUPS CSLK1
, CS_LOOKUPS CSLK2
, CS_LOOKUPS CSLK3
, CS_LOOKUPS CSLK4
, FND_USER USR
WHERE MSG.ACTION_CODE = CSLK1.LOOKUP_CODE(+)
AND CSLK1.LOOKUP_TYPE(+) = 'MESSAGE_ACTION_REQUEST'
AND MSG.PRIORITY = CSLK2.LOOKUP_CODE(+)
AND CSLK2.LOOKUP_TYPE(+) = 'MESSAGE_PRIORITY'
AND MSG.RESPONSE = CSLK3.LOOKUP_CODE(+)
AND CSLK3.LOOKUP_TYPE(+) = 'MESSAGE_RESPONSE'
AND MSG.SOURCE_OBJECT_TYPE_CODE = CSLK4.LOOKUP_CODE(+)
AND CSLK4.LOOKUP_TYPE(+) = 'CS_OBJECT_SOURCE_TYPE'
AND MSG.CREATED_BY = USR.USER_ID