APPS.BIM_CAMPAIGN_FACTS dependencies on ALL_INDEXES

Line 508: FROM all_indexes a, all_ind_columns b

504: CURSOR get_index_params (l_schema VARCHAR2) IS
505: SELECT a.owner,a.index_name,b.table_name,b.column_name,pct_free,ini_trans,max_trans
506: ,initial_extent,next_extent,min_extents,
507: max_extents, pct_increase
508: FROM all_indexes a, all_ind_columns b
509: WHERE a.index_name = b.index_name
510: AND a.owner = l_schema
511: AND a.owner = b.index_owner
512: AND a.index_name like 'BIM_R_CAMP_%FACTS%';

Line 2704: FROM all_indexes a, all_ind_columns b

2700: CURSOR get_index_params (l_schema VARCHAR2) IS
2701: SELECT a.owner,a.index_name,b.table_name,b.column_name,pct_free,ini_trans,max_trans
2702: ,initial_extent,next_extent,min_extents,
2703: max_extents, pct_increase
2704: FROM all_indexes a, all_ind_columns b
2705: WHERE a.index_name = b.index_name
2706: AND a.owner = l_schema
2707: AND a.owner = b.index_owner
2708: AND a.index_name like 'BIM_R_CAMP_%FACTS%';