VIEW: APPS.BIX_DM_EMAIL_AGENT_GROUPS_V

Source

View Text - Preformatted

SELECT 1 sort_col, lookup_code group_id, meaning group_name FROM fnd_lookups WHERE lookup_type = 'BIX_DM_ALL_LOOKUP' UNION SELECT DISTINCT 2 sort_col, TO_CHAR(g.group_id) group_id, g.group_name group_name FROM jtf_rs_group_members r, jtf_rs_groups_tl g WHERE EXISTS ( SELECT 'DUMMY' FROM jtf_rs_resource_values resource_values WHERE r.resource_id = resource_values.resource_id AND resource_values.value = 'IEM_DEFAULT_VALUE' ) AND r.group_id = g.group_id

View Text - HTML Formatted

SELECT 1 SORT_COL
, LOOKUP_CODE GROUP_ID
, MEANING GROUP_NAME
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIX_DM_ALL_LOOKUP' UNION SELECT DISTINCT 2 SORT_COL
, TO_CHAR(G.GROUP_ID) GROUP_ID
, G.GROUP_NAME GROUP_NAME
FROM JTF_RS_GROUP_MEMBERS R
, JTF_RS_GROUPS_TL G
WHERE EXISTS ( SELECT 'DUMMY'
FROM JTF_RS_RESOURCE_VALUES RESOURCE_VALUES
WHERE R.RESOURCE_ID = RESOURCE_VALUES.RESOURCE_ID
AND RESOURCE_VALUES.VALUE = 'IEM_DEFAULT_VALUE' )
AND R.GROUP_ID = G.GROUP_ID