DBA Data[Home] [Help]

APPS.BIM_EVENT_FACTS dependencies on ALL_INDEXES

Line 380: FROM all_indexes A, all_ind_columns B

376:
377: CURSOR get_index_params (l_schema VARCHAR2) IS
378: SELECT a.owner,a.index_name,b.table_name,b.column_name, a.pct_free, a.ini_trans,a.max_trans
379: ,a.initial_extent,a.next_extent,a.min_extents,a.max_extents, a.pct_increase
380: FROM all_indexes A, all_ind_columns B
381: WHERE a.index_name = b.index_name
382: AND a.owner = l_schema
383: AND a.owner = b.index_owner
384: AND a.index_name like 'BIM_R_EVEN%_FACTS%';