Product: | IEU - Universal Work Queue |
---|---|
Description: | View used for UWQ selector SpreadTable. |
Implementation/DBA Data: | Not implemented in this database |
SELECT DISTINCT A.RESOURCE_ID RESOURCE_ID
, '' IEU_OBJECT_FUNCTION
, '' IEU_OBJECT_PARAMETERS
, B.MEDIA_TYPE_UUID IEU_MEDIA_TYPE_UUID
, 'SMTP_MSG_ID' IEU_PARAM_PK_COL
, D.SMTP_MSG_ID IEU_PARAM_PK_VALUE
, 'RS_INDIVIDUAL' RESOURCE_TYPE
, C.MEDIA_TYPE_NAME QUEUE_TYPE
, D.CLASSIFICATION QUEUE_NAME
, 1 QUEUE_COUNT
, D.MSG_ID MSG_ID
, D.SENDER_NAME SENDER_NAME
, D.RECEIVED_DATE RECEIVED_DATE
, D.FROM_STR FROM_FIELD
, D.TO_STR TO_FIELD
, D.PRIORITY PRIORITY
, D.REPLY_TO REPLY_TO
, D.SUBJECT SUBJECT
, D.SCORE SCORE
, D.FOLDER_PATH FOLDER_PATH
, SUBSTR(D.FOLDER_PATH
, INSTR(D.FOLDER_PATH
, '/'
, -1)+1) FOLDER_NAME
, D.USER_PARAM1 USER_PARAM1
, D.USER_PARAM2 USER_PARAM2
FROM IEU_UWQ_SEL_MRT_DATA A
, IEU_UWQ_MEDIA_TYPES_B B
, IEU_UWQ_MEDIA_TYPES_TL C
, TABLE( CAST( IEU_ACQ_EMAIL_FUNC_PVT.GET_EMAIL_HEADERS(A.RESOURCE_ID
, 'ALL'
, 0
, 0) AS "SYSTEM".IEU_UWQ_MSG_HEADER_TABLE ) ) D
WHERE (B.MEDIA_TYPE_UUID = 'D2325ED0421D11D484CD00C04F53F265')
AND (C.MEDIA_TYPE_ID = B.MEDIA_TYPE_ID)
AND (C.LANGUAGE = USERENV('LANG'))
AND (A.MEDIA_TYPE_ID = 10001)
AND NVL(A.NOT_VALID
, 'N') = 'N'