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: ASG.ASG_SYNCH_SERVER

Object Details

Object Name:	ASG_SYNCH_SERVER
Object Type:	TABLE
Owner:	ASG
FND Design Data:	ASG.ASG_SYNCH_SERVER
Subobject Name:
Status:	VALID

Informating about all the Mobile Device Gateway

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ASG_SYNCH_SERVER_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	SERVER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SERVER_ID	NUMBER		Yes	Gateway server identifier.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
SNAP_DATABASE	VARCHAR2	(240)	Yes	Snapshot database name
NETWORK_PROTOCOL	VARCHAR2	(60)		Network protocol
HOST_NAME	VARCHAR2	(60)		Machine host name or IP address.
PORT_NUMBER	VARCHAR2	(60)		Port number
ORACLE_SID	VARCHAR2	(60)		Oracle SID.
WIRELESS_FLAG	VARCHAR2	(1)		Flag to indicate if the server supports wireless synchronization.
VERSION_ID	VARCHAR2	(30)		Version ID for this Gateway Server
CONS_PASSWORD	VARCHAR2	(60)		CONSOLIDATOR password of the gateway server
ADMIN_PASSWORD	VARCHAR2	(60)		ADMIN password of the gateway server.
ENABLED	VARCHAR2	(1)		Flag to indicates whether the gateway server is built-up.
DESCRIPTION	VARCHAR2	(2000)		Description of the gateway server.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
LANGUAGE	VARCHAR2	(4)		Language used.
MOBILE_SERVER_URL	VARCHAR2	(2000)		Mobile Server URL.

Query Text

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


SELECT SERVER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      SNAP_DATABASE
,      NETWORK_PROTOCOL
,      HOST_NAME
,      PORT_NUMBER
,      ORACLE_SID
,      WIRELESS_FLAG
,      VERSION_ID
,      CONS_PASSWORD
,      ADMIN_PASSWORD
,      ENABLED
,      DESCRIPTION
,      SECURITY_GROUP_ID
,      LANGUAGE
,      MOBILE_SERVER_URL
FROM ASG.ASG_SYNCH_SERVER;

Dependencies

[top of page]

ASG.ASG_SYNCH_SERVER does not reference any database object

ASG.ASG_SYNCH_SERVER is referenced by following:

APPS: ASG_SYNCH_SERVER