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_LINEAR_LOCATIONS

Object Details

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

This table stores linear location ids pushed into EAM from external sources. An internal EAM id is generated for an external linear id and that id will be used across EAM codes.
This table stores the association between the external linear location id and the internal EAM masking id generated.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
EXTERNAL_LINEAR_ID	NUMBER		Yes	External linear location id
EXTERNAL_LINEAR_NAME	VARCHAR2	(240)		External linear location name
EAM_LINEAR_ID	NUMBER		Yes	EAM internal masking id
EXTERNAL_SOURCE_NAME	VARCHAR2	(240)		External source name
EXTERNAL_LINEAR_TYPE	VARCHAR2	(240)		External Linear Type

Query Text

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


SELECT EXTERNAL_LINEAR_ID
,      EXTERNAL_LINEAR_NAME
,      EAM_LINEAR_ID
,      EXTERNAL_SOURCE_NAME
,      EXTERNAL_LINEAR_TYPE
FROM EAM.EAM_LINEAR_LOCATIONS;

Dependencies

[top of page]

EAM.EAM_LINEAR_LOCATIONS does not reference any database object

EAM.EAM_LINEAR_LOCATIONS is referenced by following:

EAM: EAM_LINEAR_LOCATIONS#