FND_PRIMARY_KEY_COLUMNS

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

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

Usage:


cursor cur_pk_columns(n_tabid in number
                    , n_appid in number
                    , n_keyid in number) is
  SELECT c.column_name
  from applsys.fnd_columns c
  ,    applsys.fnd_primary_key_columns k
  where k.table_id = c.table_id
  and   k.application_id = c.application_id
  and   k.column_id = c.column_id
  and   k.table_id = n_tabid
  and   k.application_id = n_appid
  and   k.primary_key_id = n_keyid
  order by primary_key_sequence;