ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 178BC86E4D88AC81E0630100007F2BDF select dic.table_owner, dic.table_name, dic.index_owner, decode(di.index_type,'NORMAL',null,di.index_type) index_type, dic.index_name, xxen_util.meaning(decode(di.uniqueness,'UNIQUE','Y'),'YES_NO',0) unique_, dic.column_name, dic.column_position, do.created from dba_indexes di, dba_ind_columns dic, dba_objects do where 1=1 and di.owner=dic.index_owner and di.index_name=dic.index_name and di.owner=do.owner(+) and di.index_name=do.object_name(+) and do.object_type(+)='INDEX' order by dic.table_name, dic.index_name, dic.column_position Y US DBA Index Columns Enginatics 1=1 1 10 1=1 lower(dic.table_name) like lower(:table_name)||'%' LOV custom Y select distinct dt.table_name value, dt.owner description from dba_tables dt where dt.owner in (select fou.oracle_username from fnd_oracle_userid fou) order by dt.table_name US Table Name starts with