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_SITE_PARAM_V

Object Details

Object Name:	BIX_DM_SITE_PARAM_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 sites from the table ieo_svr_groups . 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 .
SITE_ID	VARCHAR2	(40)	Unique identifier for the site .
SITE_NAME	VARCHAR2	(256)	Name of the site .

Query Text

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


SELECT SORT_COL
,      SITE_ID
,      SITE_NAME
FROM APPS.BIX_DM_SITE_PARAM_V;

Dependencies

[top of page]

APPS.BIX_DM_SITE_PARAM_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; IEO_SVR_GROUPS

APPS.BIX_DM_SITE_PARAM_V is not referenced by any database object