VIEW: APPS.IEM_REFINBEMAIL_ACCOUNTS_V

Source

View Text - Preformatted

SELECT ' ' IEU_OBJECT_FUNCTION, ' ' IEU_OBJECT_PARAMETERS, '6010DA40B6F511D3A05000C04F53FBA6' IEU_MEDIA_TYPE_UUID, 'EMAIL_ACCOUNT_ID' IEU_PARAM_PK_COL, a.email_account_id IEU_PARAM_PK_VALUE, a.email_account_id, count(*) Total, 'RS_INDIVIDUAL' RESOURCE_TYPE, c.resource_id RESOURCE_ID from IEM_MSTEMAIL_ACCOUNTS a, iem_rt_proc_emails b, iem_agents c where a.email_account_id=b.email_account_id and a.email_account_id=c.email_account_id and b.resource_id=0 and ((b.group_id,c.resource_id) in (select group_id,resource_id from jtf_rs_group_members_vl where delete_flag<>'Y') OR b.group_id=0) and b.message_id not in ( select message_id from iem_reroute_hists where agent_id=c.resource_id ) group by a.email_account_id,c.resource_id

View Text - HTML Formatted

SELECT ' ' IEU_OBJECT_FUNCTION
, ' ' IEU_OBJECT_PARAMETERS
, '6010DA40B6F511D3A05000C04F53FBA6' IEU_MEDIA_TYPE_UUID
, 'EMAIL_ACCOUNT_ID' IEU_PARAM_PK_COL
, A.EMAIL_ACCOUNT_ID IEU_PARAM_PK_VALUE
, A.EMAIL_ACCOUNT_ID
, COUNT(*) TOTAL
, 'RS_INDIVIDUAL' RESOURCE_TYPE
, C.RESOURCE_ID RESOURCE_ID
FROM IEM_MSTEMAIL_ACCOUNTS A
, IEM_RT_PROC_EMAILS B
, IEM_AGENTS C
WHERE A.EMAIL_ACCOUNT_ID=B.EMAIL_ACCOUNT_ID
AND A.EMAIL_ACCOUNT_ID=C.EMAIL_ACCOUNT_ID
AND B.RESOURCE_ID=0
AND ((B.GROUP_ID
, C.RESOURCE_ID) IN (SELECT GROUP_ID
, RESOURCE_ID
FROM JTF_RS_GROUP_MEMBERS_VL
WHERE DELETE_FLAG<>'Y') OR B.GROUP_ID=0)
AND B.MESSAGE_ID NOT IN ( SELECT MESSAGE_ID
FROM IEM_REROUTE_HISTS
WHERE AGENT_ID=C.RESOURCE_ID ) GROUP BY A.EMAIL_ACCOUNT_ID
, C.RESOURCE_ID