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_ESTABLISHMENT_DETAILS

Object Details

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

This table stores safety Establishment details.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EAM_ESTABLISHMENT_DETAILS_U01	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ESTABLISHMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ESTABLISHMENT_ID	NUMBER		Yes	Establishment Unique Identifier
ESTABLISHMENT_SOURCE	NUMBER		Yes	Source of the Establishment - 1- isolation ; 2- Clearance
ESTABLISHMENT_SOURCE_ID	NUMBER		Yes	Isolation Id or Work clearance Id
SEQUENCE_TYPE	NUMBER		Yes	Establishment Sequnce Type : 1- Establishment; 2- Re-Establishment
SEQUENCE_NUMBER	NUMBER		Yes	Establishment Sequence Number
DESCRIPTION	VARCHAR2	(240)		Description of the Establishment Step
ORGANIZATION_ID	NUMBER		Yes	organization Id
MAINTENANCE_OBJECT_ID	NUMBER		Yes	Maintenance Object Identifier- Instance Id of the Positional Asset
RESOURCE_ID	NUMBER			Resource Identifier
DEPT_ID	NUMBER			Department Id
RES_INSTANCE_ID	NUMBER			Resource Instance Id
COMPLETION_DATE	DATE			Completion Date
SAFETY_TAG	NUMBER			Safety Tag
TAG_POSITION	NUMBER			Safety Tag Position
LOCKOUT_DEVICE	NUMBER			Lock Out Device
LOCK_NUMBER	NUMBER			Lock Number
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute Category
ATTRIBUTE1	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE2	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE3	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE4	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE5	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE6	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE7	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE8	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE9	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE10	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE11	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE12	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE13	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE14	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE15	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE16	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE17	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE18	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE19	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE20	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE21	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE22	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE23	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE24	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE25	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE26	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE27	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE28	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE29	VARCHAR2	(240)		Flex Field Attribute
ATTRIBUTE30	VARCHAR2	(240)		Flex Field Attribute
LAST_UPDATE_DATE	DATE		Yes	Last Updated Date
LAST_UPDATED_BY	NUMBER		Yes	Last Updated By
CREATION_DATE	DATE		Yes	Record Creation Date
CREATED_BY	NUMBER		Yes	Establishment Created By
LAST_UPDATE_LOGIN	NUMBER			Last Update Login

Query Text

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


SELECT ESTABLISHMENT_ID
,      ESTABLISHMENT_SOURCE
,      ESTABLISHMENT_SOURCE_ID
,      SEQUENCE_TYPE
,      SEQUENCE_NUMBER
,      DESCRIPTION
,      ORGANIZATION_ID
,      MAINTENANCE_OBJECT_ID
,      RESOURCE_ID
,      DEPT_ID
,      RES_INSTANCE_ID
,      COMPLETION_DATE
,      SAFETY_TAG
,      TAG_POSITION
,      LOCKOUT_DEVICE
,      LOCK_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM EAM.EAM_ESTABLISHMENT_DETAILS;

Dependencies

[top of page]

EAM.EAM_ESTABLISHMENT_DETAILS does not reference any database object

EAM.EAM_ESTABLISHMENT_DETAILS is referenced by following:

EAM: EAM_ESTABLISHMENT_DETAILS#