DBA Data[Home] [Help]

APPS.MSC_UTIL dependencies on ALL_INDEXES

Line 381: FROM all_indexes

377:
378: BEGIN
379: SELECT partitioned
380: INTO l_partitioned
381: FROM all_indexes
382: WHERE owner=v_msc_schema
383: AND table_name = p_table_name
384: AND index_name = p_index_name;
385:

Line 544: FROM ALL_INDEXES

540: AND alt.tablespace_name = dt.tablespace_name ;
541: BEGIN
542: SELECT TABLESPACE_NAME
543: INTO v_index_space
544: FROM ALL_INDEXES
545: WHERE table_name = upper(p_table_name)
546: and owner = upper(p_schema)
547: and rownum = 1;
548: EXCEPTION