[Home] [Help] [Dependency Information]
Object Name: | FF_ARCHIVE_ITEM_CONTEXTS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | FF.FF_ARCHIVE_ITEM_CONTEXTS |
Subobject Name: | |
Status: | VALID |
FF_ARCHIVE_ITEM_CONTEXTS records any additional context required to
retrieve an archive item e.g. a tax unit.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FF_ARCHIVE_ITEM_CONTEXT_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ARCHIVE_ITEM_ID
CONTEXT_ID |
Table | |
Foreign Table | Foreign Key Column | FF_ARCHIVE_ITEM_CONTEXTS | FF_ARCHIVE_ITEMS | FF_ARCHIVE_ITEM_CONTEXTS ARCHIVE_ITEM_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ARCHIVE_ITEM_ID | NUMBER | (15) | Yes | Foreign key to FF_ARCHIVE_ITEMS |
SEQUENCE_NO | NUMBER | (2) | Yes | Sequence number for the route taken from ff_route_context_usages table. |
CONTEXT | VARCHAR2 | (30) | Yes | Value of the context required to find an archive database item |
CONTEXT_ID | NUMBER | (15) | Yes | Foreign key to FF_CONTEXTS |
Cut, paste (and edit) the following text to query this object:
SELECT ARCHIVE_ITEM_ID
, SEQUENCE_NO
, CONTEXT
, CONTEXT_ID
FROM HR.FF_ARCHIVE_ITEM_CONTEXTS;
HR.FF_ARCHIVE_ITEM_CONTEXTS does not reference any database object
HR.FF_ARCHIVE_ITEM_CONTEXTS is referenced by following:
|
|
|