[Home] [Help] [Dependency Information]
Object Name: | AK_FOREIGN_KEYS |
---|---|
Object Type: | TABLE |
Owner: | AK |
FND Design Data: | AK.AK_FOREIGN_KEYS |
Subobject Name: | |
Status: | VALID |
AK_FOREIGN_KEYS defines the foreign keys that belong to an object. You
must create one row for each foreign key you wish to associate to an
object.
For each foreign key, you must specify the database object name,
unique (primary) key name and the application owner of the foreign
key.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AK_FOREIGN_KEYS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | FOREIGN_KEY_NAME |
AK_FOREIGN_KEYS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
UNIQUE_KEY_NAME
DATABASE_OBJECT_NAME |
AK_FOREIGN_KEYS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DATABASE_OBJECT_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FOREIGN_KEY_NAME | VARCHAR2 | (30) | Yes | Unique identifier for a foreign key relationship. |
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Yes | Identifier of database object which contains the foreign key. |
UNIQUE_KEY_NAME | VARCHAR2 | (30) | Yes | Identifier of primary key of the database object that has been specified in DATABASE_OBJECT_NAME. |
APPLICATION_ID | NUMBER | (15) | Yes | Application Id of product team who defined this foreign key relationship. |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT FOREIGN_KEY_NAME
, DATABASE_OBJECT_NAME
, UNIQUE_KEY_NAME
, APPLICATION_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM AK.AK_FOREIGN_KEYS;
AK.AK_FOREIGN_KEYS does not reference any database object
AK.AK_FOREIGN_KEYS is referenced by following:
|
|
|