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: EC.ECE_LEVEL_MATRICES

Object Details

Object Name:	ECE_LEVEL_MATRICES
Object Type:	TABLE
Owner:	EC
FND Design Data:	EC.ECE_LEVEL_MATRICES
Subobject Name:
Status:	VALID

The ECE_LEVEL_MATRICES table is used as an intersection
table between the internal levels, represented in
ECE_INTERFACE_TABLES, and the external levels, represented
in ECE_EXTERNAL_LEVELS.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
MATRIX_LEVEL_ID	NUMBER	(15)	Yes	Matrix Level ID
EXTERNAL_LEVEL_ID	NUMBER	(15)	Yes	External Level ID
INTERFACE_TABLE_ID	NUMBER	(15)	Yes	Interface Table ID

Query Text

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


SELECT MATRIX_LEVEL_ID
,      EXTERNAL_LEVEL_ID
,      INTERFACE_TABLE_ID
FROM EC.ECE_LEVEL_MATRICES;

Dependencies

[top of page]

EC.ECE_LEVEL_MATRICES does not reference any database object

EC.ECE_LEVEL_MATRICES is referenced by following:

APPS: ECE_LEVEL_MATRICES