VIEW: APPS.CS_MESSAGES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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