SVC_SR_MSG_THREADS_V

Details

• Schema: FUSION

• Object owner: SVC

• Object type: VIEW

Columns

Name
MAX_LAST_UPDATE_DATE MAX_MESSAGE_LAST_UPDATE_DATE THREAD_ID SR_ID

Query

SQL_Statement
SELECT MAX(LAST_UPDATE_DATE) MAX_LAST_UPDATE_DATE, MAX(MESSAGE_LAST_UPDATE_DATE) MAX_MESSAGE_LAST_UPDATE_DATE, NVL(PARENT_MESSAGE_ID,MESSAGE_ID) THREAD_ID, SR_ID FROM svc_sr_messages GROUP BY NVL(PARENT_MESSAGE_ID,MESSAGE_ID), SR_ID