FA Database Index Listing - draft
Description
Categories: BI Publisher
Application: Assets
Source: Database Index Listing (XML) - Not Supported: Reserved For Future Use
Short Name: FASINDX_XML
DB package: FA_FASINDX_XMLP_PKG
Source: Database Index Listing (XML) - Not Supported: Reserved For Future Use
Short Name: FASINDX_XML
DB package: FA_FASINDX_XMLP_PKG
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
select ind.table_name, ind.index_name, obj.created, obj.last_ddl_time, lu.meaning unique_flag, col.column_name from all_indexes ind, all_ind_columns col, all_objects obj, fa_lookups lu where ind.table_name like 'FA%' and col.table_name = ind.table_name and col.index_name = ind.index_name and obj.object_name = ind.index_name and obj.object_type = 'INDEX' and lu.lookup_type = 'YESNO' and lu.lookup_code = decode (ind.uniqueness, 'UNIQUE', 'YES', 'NO') order by ind.table_name, ind.index_name, col.column_position |