[Home] [Help] [Dependency Information]
Object Name: | FND_PRIMARY_KEYS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_PRIMARY_KEYS |
Subobject Name: | |
Status: | VALID |
FND_PRIMARY_KEYS stores information about the registered primary
and unique keys in your applications. Each row includes the name
and a description of the primary or unique key. Each row also
includes the table the key references, the type of the key (Primary
or Unique), and whether the key is the Developer (DataMerge) key.
You need one row for each primary or unique key in each application.
Oracle Applications uses this information for AuditTrail and when
installing and upgrading the database.
.
.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_PRIMARY_KEYS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
APPLICATION_ID
TABLE_ID PRIMARY_KEY_ID ZD_EDITION_NAME |
FND_PRIMARY_KEYS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
PRIMARY_KEY_NAME
APPLICATION_ID TABLE_ID ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Yes | Application identifier |
TABLE_ID | NUMBER | (15) | Yes | Table identifier |
PRIMARY_KEY_ID | NUMBER | (15) | Yes | Primary key identifier |
PRIMARY_KEY_NAME | VARCHAR2 | (30) | Yes | Primary 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_TYPE | VARCHAR2 | (1) | Yes | Primary key type (Developer or Alternate) |
AUDIT_KEY_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if this key is the primary key |
DESCRIPTION | VARCHAR2 | (240) | Description | |
ENABLED_FLAG | VARCHAR2 | (1) | Determines whether this key will be created as an enabled or disabled constraint | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, TABLE_ID
, PRIMARY_KEY_ID
, PRIMARY_KEY_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, PRIMARY_KEY_TYPE
, AUDIT_KEY_FLAG
, DESCRIPTION
, ENABLED_FLAG
, ZD_EDITION_NAME
FROM APPLSYS.FND_PRIMARY_KEYS;
APPLSYS.FND_PRIMARY_KEYS does not reference any database object
APPLSYS.FND_PRIMARY_KEYS is referenced by following:
|
|
|