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]

TABLE: IEB.IEB_MMS_SERVERS

Object Details

Object Name:	IEB_MMS_SERVERS
Object Type:	TABLE
Owner:	IEB
FND Design Data:	IEB.IEB_MMS_SERVERS
Subobject Name:
Status:	VALID

Summary of media server information. This is an obsolete table, replaced by IEO server location schema.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
MMSSVR_ID	NUMBER	(15)	Yes	Unique ID generated by system as primary key
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
MMS_SERVER_NAME	VARCHAR2	(80)	Yes	MMS Server Name
ACTIVE_Y_N	VARCHAR2	(1)	Yes	Yes or No
DESCRIPTION	VARCHAR2	(240)		A brief desciption of the Media Manager Server.
COMMUNICATION_METHOD	VARCHAR2	(32)	Yes	Communication type, such as RMI, TCP/IP, etc.
COM_OBJECT_NAME	VARCHAR2	(80)		RMI or other Object Name
COM_DNS_NAME	VARCHAR2	(80)		DNS Name
COM_IP_ADDRESS	VARCHAR2	(15)		TCP/IP port number
COM_PORT_NUMBER	NUMBER	(15)		TCP/IP port number
COM_PARAM1	VARCHAR2	(80)		Future Use
COM_PARAM2	VARCHAR2	(80)		Future Use
COM_PARAM3	VARCHAR2	(80)		Future Use
COM_PARAM4	VARCHAR2	(80)		Future Use
SECURITY_GROUP_ID	NUMBER	(15)		This column is the subscriber?s unique ID that enables secure and exclusive data access for Application Hosting Support.

Query Text

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


SELECT MMSSVR_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      MMS_SERVER_NAME
,      ACTIVE_Y_N
,      DESCRIPTION
,      COMMUNICATION_METHOD
,      COM_OBJECT_NAME
,      COM_DNS_NAME
,      COM_IP_ADDRESS
,      COM_PORT_NUMBER
,      COM_PARAM1
,      COM_PARAM2
,      COM_PARAM3
,      COM_PARAM4
,      SECURITY_GROUP_ID
FROM IEB.IEB_MMS_SERVERS;

Dependencies

[top of page]

IEB.IEB_MMS_SERVERS does not reference any database object

IEB.IEB_MMS_SERVERS is referenced by following:

APPS: IEB_MMS_SERVERS