DBA Data[Home] [Help]

APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on ALL_INDEXES

Line 1796: ALL_INDEXES di,

1792: di.index_type,
1793: dt.EXTENT_MANAGEMENT,
1794: dt.ALLOCATION_TYPE
1795: FROM ALL_IND_PARTITIONS ipa,
1796: ALL_INDEXES di,
1797: dba_tablespaces dt
1798: WHERE ipa.index_owner= v_msc_schema
1799: AND di.table_owner= v_msc_schema
1800: AND ipa.partition_name=cp_partname

Line 1812: from all_indexes ai, all_ind_columns aic, all_ind_expressions aie

1808: p_index_name IN VARCHAR2,
1809: p_table_name IN VARCHAR2)
1810: IS
1811: select ai.INDEX_TYPE, aic.column_name, aie.column_expression, aic.column_position
1812: from all_indexes ai, all_ind_columns aic, all_ind_expressions aie
1813: where ai.index_name = aic.index_name
1814: and ai.owner = aic.index_owner
1815: and ai.table_name = aic.table_name
1816: and ai.table_owner = aic.table_owner