eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.BIX_DM_EMAIL_AGENT_GROUPS_V

Object Details

Object Name:	BIX_DM_EMAIL_AGENT_GROUPS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view lists all the email center agent groups from jtf_rs_groups_b table . It is used in the definition of list of values for the parameters of reports and bins .

[View Source]

Columns

Name	Datatype	Length	Comments
SORT_COL	NUMBER		Used to sort the rows in the views while displaying in the list of values of the parameters .
GROUP_ID	VARCHAR2	(40)	Unique identifier for the agent group .
GROUP_NAME	VARCHAR2	(80)	Name of the agent group .

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SORT_COL
,      GROUP_ID
,      GROUP_NAME
FROM APPS.BIX_DM_EMAIL_AGENT_GROUPS_V;

Dependencies

[top of page]

APPS.BIX_DM_EMAIL_AGENT_GROUPS_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; JTF_RS_GROUPS_TL; JTF_RS_GROUP_MEMBERS; JTF_RS_RESOURCE_VALUES

APPS.BIX_DM_EMAIL_AGENT_GROUPS_V is not referenced by any database object