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_AMM_CATALOG

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
DDD_AMM_CATALOG_N	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FOLDER_NAME AMM_FILE_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
FOLDER_NAME	VARCHAR2	(1000)	Yes	Folder name
AMM_FILE_NAME	VARCHAR2	(255)	Yes	AMM File name
CODECTYPE	VARCHAR2	(20)	Yes	Code CType
CREATEDATE	DATE		Yes	Create date
DATA_ID	NUMBER	(18)	Yes	Data Id
SERVER_HOST_NAME	VARCHAR2	(255)		Server host name
TYPE	VARCHAR2	(20)		Type
VALUE1	VARCHAR2	(255)		Value1
VALUE2	VARCHAR2	(255)		Value2
VALUE3	VARCHAR2	(255)		Value3
VALUE4	VARCHAR2	(255)		Value4
VALUE5	VARCHAR2	(255)		Value5
VALUE6	VARCHAR2	(255)		Value6

Query Text

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


SELECT FOLDER_NAME
,      AMM_FILE_NAME
,      CODECTYPE
,      CREATEDATE
,      DATA_ID
,      SERVER_HOST_NAME
,      TYPE
,      VALUE1
,      VALUE2
,      VALUE3
,      VALUE4
,      VALUE5
,      VALUE6
FROM DDD.DDD_AMM_CATALOG;

Dependencies

[top of page]

DDD.DDD_AMM_CATALOG does not reference any database object

DDD.DDD_AMM_CATALOG is referenced by following:

APPS: DDD_AMM_CATALOG