DBA Data[Home] [Help] [Dependency Information]

TABLE: EAM.EAM_ISOLATIONS

Object Details
Object Name: EAM_ISOLATIONS
Object Type: TABLE
Owner: EAM
FND Design Data: TableEAM.EAM_ISOLATIONS
Subobject Name:
Status: VALID


This table stores safety Isolation Definition.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EAM_ISOLATIONS_U01 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnISOLATION_ID
Columns
Name Datatype Length Mandatory Comments
ISOLATION_ID NUMBER
Yes Unique Identifier for Isolation
ISOLATION_NAME VARCHAR2 (240) Yes Isolation Name
ISOLATION_TYPE NUMBER
Yes Isolation Type
DESCRIPTION VARCHAR2 (240)
Description for Isolation
ORGANIZATION_ID NUMBER
Yes Organization Id
PENDING_FLAG VARCHAR2 (1)
Release Pending Flag
EFFECTIVE_START_DATE DATE

Effective Start Date
EFFECTIVE_END_DATE DATE

Effective End Date
APPROVED_BY NUMBER

Approved By
USER_DEFINED_STATUS_ID NUMBER
Yes User Defined Status
STATUS_TYPE NUMBER
Yes Status Type
PERMIT_REQUIRED_FLAG VARCHAR2 (1)
Permit Required Flag
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 Update Date
LAST_UPDATED_BY NUMBER
Yes Last Updated By
CREATION_DATE DATE
Yes Creation Date
CREATED_BY NUMBER
Yes Created By
LAST_UPDATE_LOGIN NUMBER

Last Update Login
Query Text

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


SELECT ISOLATION_ID
,      ISOLATION_NAME
,      ISOLATION_TYPE
,      DESCRIPTION
,      ORGANIZATION_ID
,      PENDING_FLAG
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      APPROVED_BY
,      USER_DEFINED_STATUS_ID
,      STATUS_TYPE
,      PERMIT_REQUIRED_FLAG
,      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_ISOLATIONS;

Dependencies

[top of page]

EAM.EAM_ISOLATIONS does not reference any database object

EAM.EAM_ISOLATIONS is referenced by following:

SchemaEAM
ViewEAM_ISOLATIONS#