[Home] [Help] [Dependency Information]
Object Name: | AK_UNIQUE_KEYS |
---|---|
Object Type: | TABLE |
Owner: | AK |
FND Design Data: | AK.AK_UNIQUE_KEYS |
Subobject Name: | |
Status: | VALID |
AK_UNIQUE_KEYS defines the unique keys that belong to an object. You
must create one row for each unique key you wish to associate to an
object. Generally the unique key is the primary key of a view, though
some views may have additional unique keys.
For each unique key, you must specify the database object name,
unique key name and the application owner of the unique key.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AK_UNIQUE_KEYS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | UNIQUE_KEY_NAME |
AK_UNIQUE_KEYS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DATABASE_OBJECT_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIQUE_KEY_NAME | VARCHAR2 | (30) | Yes | Unique identifier of unique key relationship |
DATABASE_OBJECT_NAME | VARCHAR2 | (30) | Yes | Identifier of database object which contains the unique key |
APPLICATION_ID | NUMBER | (15) | Yes | Application Id of product team who defined this unique 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 UNIQUE_KEY_NAME
, DATABASE_OBJECT_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_UNIQUE_KEYS;
AK.AK_UNIQUE_KEYS does not reference any database object
AK.AK_UNIQUE_KEYS is referenced by following:
|
|
|