DBA Data[Home] [Help]

APPS.BIM_FUND_FACTS dependencies on ALL_IND_COLUMNS

Line 895: FROM all_indexes a, all_ind_columns b

891: CURSOR get_index_params (l_schema VARCHAR2) IS
892: SELECT a.owner,a.index_name,b.table_name,b.column_name,pct_free,ini_trans,max_trans
893: ,initial_extent,next_extent,min_extents,
894: max_extents, pct_increase
895: FROM all_indexes a, all_ind_columns b
896: WHERE a.index_name = b.index_name
897: AND a.owner = l_schema
898: AND a.owner = b.index_owner
899: AND (a.index_name like 'BIM_R_FUND%_FACTS%'