APPS.EGO_ITEM_TEXT_PVT dependencies on ALL_INDEXES

Line 314: FROM all_indexes

310:
311: SELECT 'tablespace ' || tablespace_name ||
312: ' storage (initial 1M next 1M minextents 1 maxextents unlimited pctincrease 0)'
313: INTO tspace_idx_param
314: FROM all_indexes
315: WHERE owner = g_Prod_Schema
316: AND index_name = 'EGO_ITEM_TEXT_TL_U1'
317: AND table_name = 'EGO_ITEM_TEXT_TL';
318:

Line 653: FROM all_indexes

649:
650: -- Check for existing indexes in the EGO product, APPS Universal, and interMedia schemas.
651: --
652: FOR index_rec IN ( SELECT owner, index_name, status, domidx_status, domidx_opstatus
653: FROM all_indexes
654: WHERE ( owner = g_Prod_Schema OR owner = USER OR owner = g_Ctx_Schema )
655: AND table_name = 'EGO_ITEM_TEXT_TL'
656: AND index_name = p_Index_Name )
657: LOOP

Line 1074: FROM all_indexes

1070:
1071: Log_Line (l_api_name || ': loop through DOMAIN type indexes');
1072:
1073: FOR index_rec IN ( SELECT owner, index_name, index_type, status, domidx_opstatus
1074: FROM all_indexes
1075: WHERE ( owner = g_Prod_Schema OR owner = USER OR owner = g_Ctx_Schema )
1076: AND table_name = 'EGO_ITEM_TEXT_TL'
1077: AND ( index_type = 'DOMAIN'
1078: OR index_name LIKE 'EGO_ITEM_TEXT_TL_CTX%' )