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_WORK_CLEARANCES

Object Details

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

This table stores Safety Work Clearance definition. It would be attached to Establishment & Re-Establishment sequences, Work Orders and Work Permits

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EAM_WORK_CLEARANCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WORK_CLEARANCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
WORK_CLEARANCE_ID	NUMBER		Yes	Unique Identifier for Work Clearance
WORK_CLEARANCE_NAME	VARCHAR2	(240)	Yes	Work Clearance Name
LAST_ISOLATION_ID	NUMBER			Last Isolation Id
DESCRIPTION	VARCHAR2	(240)		Work Clearance Description
ORGANIZATION_ID	NUMBER		Yes	Organization Id
PENDING_FLAG	VARCHAR2	(1)		Pending Flag
SCHEDULED_ESTAB_START_DATE	DATE			Scheduled Establishment Start Date
SCHEDULED_ESTAB_END_DATE	DATE			Scheduled Establishment End Date
SCHEDULED_REESTAB_START_DATE	DATE			Scheduled Re-Establishment Start Date
SCHEDULED_REESTAB_END_DATE	DATE			Scheduled Re-Establishment End Date
COMPLETION_DATE	DATE			Work Clearance Completion Date
USER_DEFINED_STATUS_ID	NUMBER		Yes	User Defined Status Id
STATUS_TYPE	NUMBER		Yes	System Status Id
PERMIT_REQUIRED_FLAG	VARCHAR2	(1)		Permit required Flag
APPROVED_BY	NUMBER			Approved By
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	Creation Date
CREATED_BY	NUMBER		Yes	Created By
LAST_UPDATE_LOGIN	NUMBER			Last Updated Login

Query Text

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


SELECT WORK_CLEARANCE_ID
,      WORK_CLEARANCE_NAME
,      LAST_ISOLATION_ID
,      DESCRIPTION
,      ORGANIZATION_ID
,      PENDING_FLAG
,      SCHEDULED_ESTAB_START_DATE
,      SCHEDULED_ESTAB_END_DATE
,      SCHEDULED_REESTAB_START_DATE
,      SCHEDULED_REESTAB_END_DATE
,      COMPLETION_DATE
,      USER_DEFINED_STATUS_ID
,      STATUS_TYPE
,      PERMIT_REQUIRED_FLAG
,      APPROVED_BY
,      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_WORK_CLEARANCES;

Dependencies

[top of page]

EAM.EAM_WORK_CLEARANCES does not reference any database object

EAM.EAM_WORK_CLEARANCES is referenced by following:

EAM: EAM_WORK_CLEARANCES#