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: CZ.CZ_SERVERS

Object Details

Object Name:	CZ_SERVERS
Object Type:	TABLE
Owner:	CZ
FND Design Data:	CZ.CZ_SERVERS
Subobject Name:
Status:	VALID

This table is used to identify database servers that are active in the Oracle Applications/Oracle Configurator network. It contains entries for the local server, and remote servers associated with Import or Publication processes.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_SERVERS_PK

SERVER_LOCAL_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_SERVERS_PK	NORMAL	UNIQUE	APPS_TS_SEED	SERVER_LOCAL_ID
CZ_SERVERS_U1	NORMAL	UNIQUE	APPS_TS_SEED	LOCAL_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
LOCAL_NAME	VARCHAR2	(40)	Yes	Assigns a local name or alias for the remote server defined in this record
HOSTNAME	VARCHAR2	(255)		Numeric or aliased IP address for the server
DB_LISTENER_PORT	NUMBER	(9)		Number of the TCP port on which the database server listener is running
INSTANCE_NAME	VARCHAR2	(40)		Name under which this database server (instance) is available on the server IP port
SERVER_DB_VERSION	VARCHAR2	(40)		Records the DBMS software version of this remote database server
CZ_OWNER	VARCHAR2	(40)		Identifies the name of the owner of the remote CZ schema
FNDNAM	VARCHAR2	(40)		Name of the Oracle Applications main schema owner, often referred to as "FNDNAM"
SERVER_LOCAL_ID	NUMBER	(9)	Yes	PK. Numeric identity for this remote-server definition
GLOBAL_IDENTITY	VARCHAR2	(255)		Provides alternate mechanism for identifying servers.
NOTES	VARCHAR2	(2000)		Note text
CZ_LINK_NAME	VARCHAR2	(40)		Specifies a name for the database link under the remote CZ-schema owner
FNDNAM_LINK_NAME	VARCHAR2	(40)		Name of the database link to the remote Oracle Applications main schema
IMPORT_ENABLED	VARCHAR2	(1)	Yes	'1' indicates that this server is configured to allow Import. Itis not required that multiple remote servers be supported for import at the same time. '0' indicates import is disabled for this server
SOURCE_SERVER_FLAG	VARCHAR2	(1)		Value will be '1' within a publication target server if the entry contains the source server information. (BOM Sync.)
CONVERTED_TARGET_FLAG	VARCHAR2	(1)		This flag is set on the local server entry on the publication target instance and on the corresponding remote server entry on the publication source instance. Value of '1' indicates that the corresponding server has been converted from remote publication target to Development.

Query Text

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


SELECT LOCAL_NAME
,      HOSTNAME
,      DB_LISTENER_PORT
,      INSTANCE_NAME
,      SERVER_DB_VERSION
,      CZ_OWNER
,      FNDNAM
,      SERVER_LOCAL_ID
,      GLOBAL_IDENTITY
,      NOTES
,      CZ_LINK_NAME
,      FNDNAM_LINK_NAME
,      IMPORT_ENABLED
,      SOURCE_SERVER_FLAG
,      CONVERTED_TARGET_FLAG
FROM CZ.CZ_SERVERS;

Dependencies

[top of page]

CZ.CZ_SERVERS does not reference any database object

CZ.CZ_SERVERS is referenced by following:

APPS: CZ_SERVERS