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_ACCOUNTS_V

Object Details

Object Name:	BIX_DM_EMAIL_ACCOUNTS_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 accounts from the table iem_email_accounts . 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 .
EMAIL_ACCOUNT_ID	VARCHAR2	(40)	Unique identifier for the email account .
EMAIL_ACCOUNT_NAME	VARCHAR2	(120)	Name of the email account .

Query Text

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


SELECT SORT_COL
,      EMAIL_ACCOUNT_ID
,      EMAIL_ACCOUNT_NAME
FROM APPS.BIX_DM_EMAIL_ACCOUNTS_V;

Dependencies

[top of page]

APPS.BIX_DM_EMAIL_ACCOUNTS_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; IEM_MSTEMAIL_ACCOUNTS

APPS.BIX_DM_EMAIL_ACCOUNTS_V is not referenced by any database object