TO FIND INDEX COLUMNS

SELECT application_id,
table_id,
index_id,
column_sequence,
column_id
FROM fnd_index_columns WHERE table_id =
(SELECT table_id
FROM fnd_tables
WHERE table_name = UPPER('&table_name'));

Note: Enter the table_name for which you want to find out index columns. If
you are aware of index_id from query no. 9 above then specify that in the where
clause instead of table_name.