DBA Data[Home] [Help]

APPS.BIM_FUND_FACTS dependencies on ALL_INDEXES

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%'

Line 2468: --FND_FILE.put_line(fnd_file.log,'error creating all indexes'||sqlerrm(sqlcode));

2464: END LOOP;
2465: EXCEPTION
2466: WHEN OTHERS THEN
2467: null;
2468: --FND_FILE.put_line(fnd_file.log,'error creating all indexes'||sqlerrm(sqlcode));
2469: -- DBMS_OUTPUT.PUT_LINE(sqlerrm(sqlcode));
2470: END;
2471:
2472: -- For performance reasons.