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: DDD.DDD_AMC_CATALOG

Object Details

Object Name:	DDD_AMC_CATALOG
Object Type:	TABLE
Owner:	DDD
FND Design Data:	DDD.DDD_AMC_CATALOG
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
DDD_AMC_CATALOG_N	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FOLDER_NAME AMC_FILE_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
AMC_ID	NUMBER			AMC Id
FOLDER_NAME	VARCHAR2	(1000)	Yes	Folder name
AMC_FILE_NAME	VARCHAR2	(255)	Yes	AMC file name
FILENAME	VARCHAR2	(255)	Yes	File name
CREATEDATE	DATE		Yes	Create date
MODELGUID	VARCHAR2	(38)	Yes	Model GUID
MODELNAME	VARCHAR2	(255)	Yes	Model name
MODELDESCRIPTION	VARCHAR2	(1000)		Model description
COLLABORATIONDBNAME	VARCHAR2	(255)		Collaboration database name
COLLABORATIONDBHOST	VARCHAR2	(255)		Collaboration database host
COLLABORATIONDBASSID	VARCHAR2	(20)		Collaboration database SID
WEBLINKAMI	VARCHAR2	(1000)		Weblink AMI
REPLICATIONTIMESTAMP	VARCHAR2	(38)		Replication time stamp

Query Text

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


SELECT AMC_ID
,      FOLDER_NAME
,      AMC_FILE_NAME
,      FILENAME
,      CREATEDATE
,      MODELGUID
,      MODELNAME
,      MODELDESCRIPTION
,      COLLABORATIONDBNAME
,      COLLABORATIONDBHOST
,      COLLABORATIONDBASSID
,      WEBLINKAMI
,      REPLICATIONTIMESTAMP
FROM DDD.DDD_AMC_CATALOG;

Dependencies

[top of page]

DDD.DDD_AMC_CATALOG does not reference any database object

DDD.DDD_AMC_CATALOG is referenced by following:

APPS: DDD_AMC_CATALOG