[Home] [Help] [Dependency Information]
Object Name: | FND_PRIMARY_KEY_COLUMNS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_PRIMARY_KEY_COLUMNS |
Subobject Name: | |
Status: | VALID |
FND_PRIMARY_KEY_COLUMNS stores information about individual columns
in primary and unique keys. Each row includes the primary or
unique key the column is a part of and the sequence in the primary
key. You need one row for each primary key column 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_KEY_COLUMNS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
APPLICATION_ID
TABLE_ID PRIMARY_KEY_ID PRIMARY_KEY_SEQUENCE ZD_EDITION_NAME |
FND_PRIMARY_KEY_COLUMNS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
APPLICATION_ID
TABLE_ID PRIMARY_KEY_ID COLUMN_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_SEQUENCE | NUMBER | (15) | Yes | Sequence of the column in the primary key |
COLUMN_ID | NUMBER | (15) | Yes | Column identifier |
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 |
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_SEQUENCE
, COLUMN_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ZD_EDITION_NAME
FROM APPLSYS.FND_PRIMARY_KEY_COLUMNS;
APPLSYS.FND_PRIMARY_KEY_COLUMNS does not reference any database object
APPLSYS.FND_PRIMARY_KEY_COLUMNS is referenced by following:
|
|
|