VIEW: APPS.IEM_INBEMAIL_SUMM_V

Source

View Text - Preformatted

SELECT ' ' IEU_OBJECT_FUNCTION, ' ' IEU_OBJECT_PARAMETERS, '6010DA40B6F511D3A05000C04F53FBA6' IEU_MEDIA_TYPE_UUID, 'EMAIL_ACCOUNT_ID' IEU_PARAM_PK_COL, TO_CHAR(c.email_account_id) IEU_PARAM_PK_VALUE, 'RS_INDIVIDUAL' RESOURCE_TYPE, c.email_account_id, d.resource_id RESOURCE_ID, count(*) total, e.FROM_NAME, trunc(nvl(max(sysdate-c.received_date)*24*60,0)/1440)||':'||trunc(mod(nvl(max(sysdate-c.received_date)*24*60 ,0),1440)/60)||':'|| trunc(mod((mod(nvl(max(sysdate-c.received_date)*24*60,0),1440)),60)) waittime, 'B9539E58E3EA11d3AEB400C04F601AB2' IEU_ACTION_OBJECT_CODE from iem_rt_proc_emails c, iem_agents d, iem_mstemail_accounts e where c.resource_id=0 and c.email_account_id=e.email_account_id and e.email_account_id=d.email_account_id and ((c.group_id,d.resource_id) in ( select group_id, resource_id from jtf_rs_group_members_vl where delete_flag<>'Y') OR c.group_id=0) and c.message_id not in ( select message_id from iem_reroute_hists where agent_id=d.resource_id ) group by c.email_account_id,d.resource_id,e.from_name order by e.from_name

View Text - HTML Formatted

SELECT ' ' IEU_OBJECT_FUNCTION
, ' ' IEU_OBJECT_PARAMETERS
, '6010DA40B6F511D3A05000C04F53FBA6' IEU_MEDIA_TYPE_UUID
, 'EMAIL_ACCOUNT_ID' IEU_PARAM_PK_COL
, TO_CHAR(C.EMAIL_ACCOUNT_ID) IEU_PARAM_PK_VALUE
, 'RS_INDIVIDUAL' RESOURCE_TYPE
, C.EMAIL_ACCOUNT_ID
, D.RESOURCE_ID RESOURCE_ID
, COUNT(*) TOTAL
, E.FROM_NAME
, TRUNC(NVL(MAX(SYSDATE-C.RECEIVED_DATE)*24*60
, 0)/1440)||':'||TRUNC(MOD(NVL(MAX(SYSDATE-C.RECEIVED_DATE)*24*60
, 0)
, 1440)/60)||':'|| TRUNC(MOD((MOD(NVL(MAX(SYSDATE-C.RECEIVED_DATE)*24*60
, 0)
, 1440))
, 60)) WAITTIME
, 'B9539E58E3EA11D3AEB400C04F601AB2' IEU_ACTION_OBJECT_CODE
FROM IEM_RT_PROC_EMAILS C
, IEM_AGENTS D
, IEM_MSTEMAIL_ACCOUNTS E
WHERE C.RESOURCE_ID=0
AND C.EMAIL_ACCOUNT_ID=E.EMAIL_ACCOUNT_ID
AND E.EMAIL_ACCOUNT_ID=D.EMAIL_ACCOUNT_ID
AND ((C.GROUP_ID
, D.RESOURCE_ID) IN ( SELECT GROUP_ID
, RESOURCE_ID
FROM JTF_RS_GROUP_MEMBERS_VL
WHERE DELETE_FLAG<>'Y') OR C.GROUP_ID=0)
AND C.MESSAGE_ID NOT IN ( SELECT MESSAGE_ID
FROM IEM_REROUTE_HISTS
WHERE AGENT_ID=D.RESOURCE_ID ) GROUP BY C.EMAIL_ACCOUNT_ID
, D.RESOURCE_ID
, E.FROM_NAME ORDER BY E.FROM_NAME