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: HR.HR_KI_CONTEXTS

Object Details

Object Name:	HR_KI_CONTEXTS
Object Type:	TABLE
Owner:	HR
Subobject Name:
Status:	VALID

This table holds the contextual data assembled for a transaction, which will be used by the message map to build the XML document.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_KI_CONTEXT_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONTEXT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CONTEXT_ID	NUMBER	(15)	Yes	KI Context identifier
VIEW_NAME	VARCHAR2	(30)	Yes	Name of view
PARAM_1	VARCHAR2	(2000)		Context Data column 1
PARAM_2	VARCHAR2	(2000)		Context Data column 2
PARAM_3	VARCHAR2	(2000)		Context Data column 3
PARAM_4	VARCHAR2	(2000)		Context Data column 4
PARAM_5	VARCHAR2	(2000)		Context Data column 5
PARAM_6	VARCHAR2	(2000)		Context Data column 6
PARAM_7	VARCHAR2	(2000)		Context Data column 7
PARAM_8	VARCHAR2	(2000)		Context Data column 8
PARAM_9	VARCHAR2	(2000)		Context Data column 9
PARAM_10	VARCHAR2	(2000)		Context Data column 10
PARAM_11	VARCHAR2	(2000)		Context Data column 11
PARAM_12	VARCHAR2	(2000)		Context Data column 12
PARAM_13	VARCHAR2	(2000)		Context Data column 13
PARAM_14	VARCHAR2	(2000)		Context Data column 14
PARAM_15	VARCHAR2	(2000)		Context Data column 15
PARAM_16	VARCHAR2	(2000)		Context Data column 16
PARAM_17	VARCHAR2	(2000)		Context Data column 17
PARAM_18	VARCHAR2	(2000)		Context Data column 18
PARAM_19	VARCHAR2	(2000)		Context Data column 19
PARAM_20	VARCHAR2	(2000)		Context Data column 20
PARAM_21	VARCHAR2	(2000)		Context Data column 21
PARAM_22	VARCHAR2	(2000)		Context Data column 22
PARAM_23	VARCHAR2	(2000)		Context Data column 23
PARAM_24	VARCHAR2	(2000)		Context Data column 24
PARAM_25	VARCHAR2	(2000)		Context Data column 25
PARAM_26	VARCHAR2	(2000)		Context Data column 26
PARAM_27	VARCHAR2	(2000)		Context Data column 27
PARAM_28	VARCHAR2	(2000)		Context Data column 28
PARAM_29	VARCHAR2	(2000)		Context Data column 29
PARAM_30	VARCHAR2	(2000)		Context Data column 30
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	This column is used for locking purposes. A way to implement Optimistic Locking

Query Text

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


SELECT CONTEXT_ID
,      VIEW_NAME
,      PARAM_1
,      PARAM_2
,      PARAM_3
,      PARAM_4
,      PARAM_5
,      PARAM_6
,      PARAM_7
,      PARAM_8
,      PARAM_9
,      PARAM_10
,      PARAM_11
,      PARAM_12
,      PARAM_13
,      PARAM_14
,      PARAM_15
,      PARAM_16
,      PARAM_17
,      PARAM_18
,      PARAM_19
,      PARAM_20
,      PARAM_21
,      PARAM_22
,      PARAM_23
,      PARAM_24
,      PARAM_25
,      PARAM_26
,      PARAM_27
,      PARAM_28
,      PARAM_29
,      PARAM_30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
FROM HR.HR_KI_CONTEXTS;

Dependencies

[top of page]

HR.HR_KI_CONTEXTS does not reference any database object

HR.HR_KI_CONTEXTS is referenced by following:

APPS: HR_KI_CONTEXTS; HR_KI_CONTEXTS_WHO
PUBLIC: HR_KI_CONTEXTS