VIEW: APPS.IEM_INBEMAIL_COUNTS_V

Source

View Text - Preformatted

SELECT ' ' IEU_OBJECT_FUNCTION, ' ' IEU_OBJECT_PARAMETERS, '6010DA40B6F511D3A05000C04F53FBA6' IEU_MEDIA_TYPE_UUID, 'ACCOUNT_ROUTE_CLASS_ID' IEU_PARAM_PK_COL, TO_CHAR(a.ACCOUNT_ROUTE_CLASS_ID) IEU_PARAM_PK_VALUE, 'RS_INDIVIDUAL' RESOURCE_TYPE, c.email_account_id, b.name, 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_account_route_class a, iem_route_classifications b, 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 c.rt_classification_id=b.route_classification_id and e.email_account_id=d.email_account_id and e.email_account_id=a.email_account_id and a.route_classification_id=b.route_classification_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 a.account_route_class_id,c.email_account_id,b.name,d.resource_id,e.from_name order by b.name

View Text - HTML Formatted

SELECT ' ' IEU_OBJECT_FUNCTION
, ' ' IEU_OBJECT_PARAMETERS
, '6010DA40B6F511D3A05000C04F53FBA6' IEU_MEDIA_TYPE_UUID
, 'ACCOUNT_ROUTE_CLASS_ID' IEU_PARAM_PK_COL
, TO_CHAR(A.ACCOUNT_ROUTE_CLASS_ID) IEU_PARAM_PK_VALUE
, 'RS_INDIVIDUAL' RESOURCE_TYPE
, C.EMAIL_ACCOUNT_ID
, B.NAME
, 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_ACCOUNT_ROUTE_CLASS A
, IEM_ROUTE_CLASSIFICATIONS B
, 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 C.RT_CLASSIFICATION_ID=B.ROUTE_CLASSIFICATION_ID
AND E.EMAIL_ACCOUNT_ID=D.EMAIL_ACCOUNT_ID
AND E.EMAIL_ACCOUNT_ID=A.EMAIL_ACCOUNT_ID
AND A.ROUTE_CLASSIFICATION_ID=B.ROUTE_CLASSIFICATION_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 A.ACCOUNT_ROUTE_CLASS_ID
, C.EMAIL_ACCOUNT_ID
, B.NAME
, D.RESOURCE_ID
, E.FROM_NAME ORDER BY B.NAME