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: OKE.OKE_K_USER_ATTRIBUTES_H

Object Details

Object Name:	OKE_K_USER_ATTRIBUTES_H
Object Type:	TABLE
Owner:	OKE
FND Design Data:	OKE.OKE_K_USER_ATTRIBUTES_H
Subobject Name:
Status:	VALID

OKE_K_USER_ATTRIBUTES stores user defined attributes in addition to descriptive flexfields. OKE_K_USER_ATTRIBUTES_H is the history table that stores the data associated with each version.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKE_K_USER_ATTR_H_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	K_USER_ATTRIBUTE_ID MAJOR_VERSION
OKE_K_USER_ATTR_H_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	K_HEADER_ID MAJOR_VERSION
OKE_K_USER_ATTR_H_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	K_LINE_ID MAJOR_VERSION

Columns

Name	Datatype	Length	Mandatory	Comments
K_USER_ATTRIBUTE_ID	NUMBER		Yes	Unique identifier for extensive contract attribute record
MAJOR_VERSION	NUMBER		Yes	Major version number of contract document
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
RECORD_VERSION_NUMBER	NUMBER			Locking sequence number for the record
K_HEADER_ID	NUMBER		Yes	Contract document unique identifier
K_LINE_ID	NUMBER			Contract document line item unique identifier
USER_ATTRIBUTE_CONTEXT	VARCHAR2	(40)	Yes	Extensible contract attribute group
USER_ATTRIBUTE01	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE02	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE03	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE04	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE05	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE06	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE07	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE08	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE09	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE10	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE11	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE12	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE13	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE14	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE15	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE16	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE17	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE18	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE19	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE20	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE21	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE22	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE23	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE24	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE25	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE26	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE27	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE28	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE29	VARCHAR2	(150)		Extensible contract attribute
USER_ATTRIBUTE30	VARCHAR2	(150)		Extensible contract attribute

Query Text

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


SELECT K_USER_ATTRIBUTE_ID
,      MAJOR_VERSION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      RECORD_VERSION_NUMBER
,      K_HEADER_ID
,      K_LINE_ID
,      USER_ATTRIBUTE_CONTEXT
,      USER_ATTRIBUTE01
,      USER_ATTRIBUTE02
,      USER_ATTRIBUTE03
,      USER_ATTRIBUTE04
,      USER_ATTRIBUTE05
,      USER_ATTRIBUTE06
,      USER_ATTRIBUTE07
,      USER_ATTRIBUTE08
,      USER_ATTRIBUTE09
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE16
,      USER_ATTRIBUTE17
,      USER_ATTRIBUTE18
,      USER_ATTRIBUTE19
,      USER_ATTRIBUTE20
,      USER_ATTRIBUTE21
,      USER_ATTRIBUTE22
,      USER_ATTRIBUTE23
,      USER_ATTRIBUTE24
,      USER_ATTRIBUTE25
,      USER_ATTRIBUTE26
,      USER_ATTRIBUTE27
,      USER_ATTRIBUTE28
,      USER_ATTRIBUTE29
,      USER_ATTRIBUTE30
FROM OKE.OKE_K_USER_ATTRIBUTES_H;

Dependencies

[top of page]

OKE.OKE_K_USER_ATTRIBUTES_H does not reference any database object

OKE.OKE_K_USER_ATTRIBUTES_H is referenced by following:

APPS: OKE_K_USER_ATTRIBUTES_H