[Home] [Help] [Dependency Information]

TABLE: OKC.OKC_K_ENTITY_LOCKS

Object Details

Object Name:	OKC_K_ENTITY_LOCKS
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_K_ENTITY_LOCKS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_K_ENTITY_LOCKS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	K_ENTITY_LOCK_ID
OKC_K_ENTITY_LOCKS_NU1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENTITY_NAME ENTITY_PK1
OKC_K_ENTITY_LOCKS_NU2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENTITY_NAME ENTITY_PK1 ENTITY_PK2
OKC_K_ENTITY_LOCKS_NU3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCK_BY_DOCUMENT_ID LOCK_BY_DOCUMENT_TYPE
OKC_K_ENTITY_LOCKS_NU4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENTITY_NAME ENTITY_PK1 ENTITY_PK2 LOCK_BY_DOCUMENT_ID LOCK_BY_DOCUMENT_TYPE

Columns

Query Text

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

SELECT K_ENTITY_LOCK_ID
,      ENTITY_NAME
,      ENTITY_PK1
,      ENTITY_PK2
,      ENTITY_PK3
,      ENTITY_PK4
,      ENTITY_PK5
,      LOCK_BY_ENTITY_ID
,      LOCK_BY_DOCUMENT_TYPE
,      LOCK_BY_DOCUMENT_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM OKC.OKC_K_ENTITY_LOCKS;

Dependencies

[top of page]

OKC.OKC_K_ENTITY_LOCKS does not reference any database object

OKC.OKC_K_ENTITY_LOCKS is referenced by following:

OKC

OKC_K_ENTITY_LOCKS#