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

TABLE: HR.HR_ITEM_CONTEXTS

Object Details
Object Name: HR_ITEM_CONTEXTS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.HR_ITEM_CONTEXTS
Subobject Name:
Status: VALID


Combinations table for the item context key flexfield ICX


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: HR_ITEM_CONTEXTS_PK
  1. ColumnITEM_CONTEXT_ID
Indexes
Index Type Uniqueness Tablespace Column
HR_ITEM_CONTEXTS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnITEM_CONTEXT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
TableHR_TEMPLATE_ITEM_CONTEXTS_B HR_TIC_B_FK2 HR_ITEM_CONTEXTS HR_TEMPLATE_ITEM_CONTEXTS_B ITEM_CONTEXT_ID
Columns
Name Datatype Length Mandatory Comments
ITEM_CONTEXT_ID NUMBER (15) Yes System-generated primary key using sequence HR_ITEM_CONTEXTS_S
ID_FLEX_NUM NUMBER (15) Yes Key flexfield structure identifier
SUMMARY_FLAG VARCHAR2 (1) Yes Key flexfield summary flag
ENABLED_FLAG VARCHAR2 (1) Yes Key flexfield enabled flag
START_DATE_ACTIVE DATE

Start date
END_DATE_ACTIVE DATE

End date
SEGMENT1 VARCHAR2 (150)
Key flexfield column.
SEGMENT2 VARCHAR2 (150)
Key flexfield column.
SEGMENT3 VARCHAR2 (150)
Key flexfield column.
SEGMENT4 VARCHAR2 (150)
Key flexfield column.
SEGMENT5 VARCHAR2 (150)
Key flexfield column.
SEGMENT6 VARCHAR2 (150)
Key flexfield column.
SEGMENT7 VARCHAR2 (150)
Key flexfield column.
SEGMENT8 VARCHAR2 (150)
Key flexfield column.
SEGMENT9 VARCHAR2 (150)
Key flexfield column.
SEGMENT10 VARCHAR2 (150)
Key flexfield column.
SEGMENT11 VARCHAR2 (150)
Key flexfield column.
SEGMENT12 VARCHAR2 (150)
Key flexfield column.
SEGMENT13 VARCHAR2 (150)
Key flexfield column.
SEGMENT14 VARCHAR2 (150)
Key flexfield column.
SEGMENT15 VARCHAR2 (150)
Key flexfield column.
SEGMENT16 VARCHAR2 (150)
Key flexfield column.
SEGMENT17 VARCHAR2 (150)
Key flexfield column.
SEGMENT18 VARCHAR2 (150)
Key flexfield column.
SEGMENT19 VARCHAR2 (150)
Key flexfield column.
SEGMENT20 VARCHAR2 (150)
Key flexfield column.
SEGMENT21 VARCHAR2 (150)
Key flexfield column.
SEGMENT22 VARCHAR2 (150)
Key flexfield column.
SEGMENT23 VARCHAR2 (150)
Key flexfield column.
SEGMENT24 VARCHAR2 (150)
Key flexfield column.
SEGMENT25 VARCHAR2 (150)
Key flexfield column.
SEGMENT26 VARCHAR2 (150)
Key flexfield column.
SEGMENT27 VARCHAR2 (150)
Key flexfield column.
SEGMENT28 VARCHAR2 (150)
Key flexfield column.
SEGMENT29 VARCHAR2 (150)
Key flexfield column.
SEGMENT30 VARCHAR2 (150)
Key flexfield column.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
OBJECT_VERSION_NUMBER NUMBER

System-generated version of row. Increments by one with each update.
Query Text

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


SELECT ITEM_CONTEXT_ID
,      ID_FLEX_NUM
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
FROM HR.HR_ITEM_CONTEXTS;

Dependencies

[top of page]

HR.HR_ITEM_CONTEXTS does not reference any database object

HR.HR_ITEM_CONTEXTS is referenced by following:

SchemaAPPS
SynonymHR_ITEM_CONTEXTS
TriggerHR_ITEM_CONTEXTS_WHO
SchemaPUBLIC
SynonymHR_ITEM_CONTEXTS