FND_PRIMARY_KEYS
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.
| 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 |
Usage:
cursor cur_primary_key(n_tabid in number
, n_appid in number)
-- List the primary key
is SELECT PRIMARY_KEY_ID
, PRIMARY_KEY_NAME
, PRIMARY_KEY_TYPE
, ENABLED_FLAG
FROM APPLSYS.FND_PRIMARY_KEYS
where table_id = n_tabid
and application_id = n_appid
order by primary_key_name;