[Home] [Help] [Dependency Information]
Object Name: | FND_FOREIGN_KEYS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_FOREIGN_KEYS |
Subobject Name: | |
Status: | VALID |
FND_FOREIGN_KEYS stores information about the registered foreign
keys in your applications. Each row includes the name and a
description of the foreign key, the primary key it references, the
cascade behavior, the relation, and any special condition. You
need one row for each foreign key in each application. Oracle
Applications uses this information when installing and upgrading
the database.
.
.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_FOREIGN_KEYS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
APPLICATION_ID
TABLE_ID FOREIGN_KEY_ID |
FND_FOREIGN_KEYS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
FOREIGN_KEY_NAME
APPLICATION_ID TABLE_ID |
FND_FOREIGN_KEYS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
PRIMARY_KEY_APPLICATION_ID
PRIMARY_KEY_TABLE_ID PRIMARY_KEY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Yes | Application identifier |
TABLE_ID | NUMBER | (15) | Yes | Table identifier |
FOREIGN_KEY_ID | NUMBER | (15) | Yes | Foreign key identifier |
FOREIGN_KEY_NAME | VARCHAR2 | (30) | Yes | Foreign key name |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
PRIMARY_KEY_APPLICATION_ID | NUMBER | (15) | Yes | Primary key application identifier |
PRIMARY_KEY_TABLE_ID | NUMBER | (15) | Yes | Primary key table identifier |
PRIMARY_KEY_ID | NUMBER | (15) | Yes | Primary key identifier |
CASCADE_BEHAVIOR | VARCHAR2 | (1) | Yes | Cascade behavior |
FOREIGN_KEY_RELATION | VARCHAR2 | (1) | Yes | Foreign key relation |
DESCRIPTION | VARCHAR2 | (240) | Description | |
CONDITION | VARCHAR2 | (2000) | Condition statement for conditional foreign keys (arc relationships) | |
ENABLED_FLAG | VARCHAR2 | (1) | Determines whether this key will be created as an enabled or disabled constraint |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, TABLE_ID
, FOREIGN_KEY_ID
, FOREIGN_KEY_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, PRIMARY_KEY_APPLICATION_ID
, PRIMARY_KEY_TABLE_ID
, PRIMARY_KEY_ID
, CASCADE_BEHAVIOR
, FOREIGN_KEY_RELATION
, DESCRIPTION
, CONDITION
, ENABLED_FLAG
FROM APPLSYS.FND_FOREIGN_KEYS;
APPLSYS.FND_FOREIGN_KEYS does not reference any database object
APPLSYS.FND_FOREIGN_KEYS is referenced by following:
|
|
|