APPS.EGO_ITEM_TEXT_PVT dependencies on ALL_INDEXES

Line 271: FROM all_indexes

267:
268: SELECT 'tablespace ' || tablespace_name ||
269: ' storage (initial 1M next 1M minextents 1 maxextents unlimited pctincrease 0)'
270: INTO tspace_idx_param
271: FROM all_indexes
272: WHERE owner = g_Prod_Schema
273: AND index_name = 'EGO_ITEM_TEXT_TL_U1'
274: AND table_name = 'EGO_ITEM_TEXT_TL';
275:

Line 609: FROM all_indexes

605:
606: -- Check for existing indexes in the EGO product, APPS Universal, and interMedia schemas.
607: --
608: FOR index_rec IN ( SELECT owner, index_name, status, domidx_status, domidx_opstatus
609: FROM all_indexes
610: WHERE ( owner = g_Prod_Schema OR owner = USER OR owner = g_Ctx_Schema )
611: AND table_name = 'EGO_ITEM_TEXT_TL'
612: AND index_name = p_Index_Name )
613: LOOP

Line 1028: FROM all_indexes

1024:
1025: Log_Line (l_api_name || ': loop through DOMAIN type indexes');
1026:
1027: FOR index_rec IN ( SELECT owner, index_name, index_type, status, domidx_opstatus
1028: FROM all_indexes
1029: WHERE ( owner = g_Prod_Schema OR owner = USER OR owner = g_Ctx_Schema )
1030: AND table_name = 'EGO_ITEM_TEXT_TL'
1031: AND ( index_type = 'DOMAIN'
1032: OR index_name LIKE 'EGO_ITEM_TEXT_TL_CTX%' )