APPS.ENG_CHANGE_TEXT_PVT dependencies on ALL_INDEXES

Line 275: FROM all_indexes

271:
272: SELECT 'tablespace ' || tablespace_name ||
273: ' storage (initial 1M next 1M minextents 1 maxextents unlimited pctincrease 0)'
274: INTO tspace_idx_param
275: FROM all_indexes
276: WHERE owner = g_Prod_Schema
277: AND index_name = 'ENG_CHANGE_IMTEXT_TL_U1'
278: AND table_name = 'ENG_CHANGE_IMTEXT_TL';
279:

Line 602: FROM all_indexes

598:
599: -- Check for existing indexes in the ENG product, APPS Universal, and interMedia schemas.
600: --
601: FOR index_rec IN ( SELECT owner, index_name, status, domidx_status, domidx_opstatus
602: FROM all_indexes
603: WHERE ( owner = g_Prod_Schema OR owner = USER OR owner = g_Ctx_Schema )
604: AND table_name = 'ENG_CHANGE_IMTEXT_TL'
605: AND index_name = p_Index_Name )
606: LOOP