APPS.INV_ITEM_PVT dependencies on ALL_INDEXES

Line 6305: FROM all_indexes

6301:
6302: /* Check if index exists before dropping it*/
6303: BEGIN
6304: SELECT index_name into l_index_name
6305: FROM all_indexes
6306: WHERE table_name = 'EGO_ITEM_TEXT_TL'
6307: AND index_name = 'EGO_ITEM_TEXT_TL_CTX1'
6308: AND owner = l_prod_schema;
6309: EXCEPTION