DBA Data[Home] [Help]

APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on ALL_IND_COLUMNS

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

Line 1942: FROM ALL_IND_COLUMNS b

1938: ELSE
1939: SELECT b.column_name
1940: BULK COLLECT
1941: INTO lv_indColList
1942: FROM ALL_IND_COLUMNS b
1943: WHERE b.index_owner = v_msc_schema AND
1944: b.table_owner = v_msc_schema AND
1945: b.index_name = lv_index_name AND
1946: b.table_name = p_part_table