DBA Data[Home] [Help]

APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on ALL_IND_COLUMNS

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

1537: p_index_name IN VARCHAR2,
1538: p_table_name IN VARCHAR2)
1539: IS
1540: select ai.INDEX_TYPE, aic.column_name, aie.column_expression, aic.column_position
1541: from all_indexes ai, all_ind_columns aic, all_ind_expressions aie
1542: where ai.index_name = aic.index_name
1543: and ai.owner = aic.index_owner
1544: and ai.table_name = aic.table_name
1545: and ai.table_owner = aic.table_owner

Line 1673: FROM ALL_IND_COLUMNS b

1669: ELSE
1670: SELECT b.column_name
1671: BULK COLLECT
1672: INTO lv_indColList
1673: FROM ALL_IND_COLUMNS b
1674: WHERE b.index_owner = v_msc_schema AND
1675: b.table_owner = v_msc_schema AND
1676: b.index_name = lv_index_name AND
1677: b.table_name = p_part_table