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: EAM.EAM_ASSET_EXPLOSION_TEMP

Object Details

Object Name:	EAM_ASSET_EXPLOSION_TEMP
Object Type:	TABLE
Owner:	EAM
FND Design Data:	EAM.EAM_ASSET_EXPLOSION_TEMP
Subobject Name:
Status:	VALID

This is a temporary table used to explode asset hierarchy information.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EAM_ASSET_EXPLOSION_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	GROUP_ID ASSET_GROUP_ID ASSET_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_ID	NUMBER			Exploder Process Group Identifier
ASSET_GROUP_ID	NUMBER			Asset Group Identifier
ASSET_NUMBER	VARCHAR2	(30)	Yes	Asset Number Identifier
LOW_LEVEL_CODE	NUMBER			Explosion Level Code

Query Text

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


SELECT GROUP_ID
,      ASSET_GROUP_ID
,      ASSET_NUMBER
,      LOW_LEVEL_CODE
FROM EAM.EAM_ASSET_EXPLOSION_TEMP;

Dependencies

[top of page]

EAM.EAM_ASSET_EXPLOSION_TEMP does not reference any database object

EAM.EAM_ASSET_EXPLOSION_TEMP is referenced by following:

EAM: EAM_ASSET_EXPLOSION_TEMP#